ISYS $2103$: Data Analytics Case Study

Scenario: You are the regional manager of the Q$.$CInn, a nationwide chain of affordable motels for vacationing families & business travelers. You will be preparing year end reports for $24$ Q$.$CInn franchises located in Nebraska$/$South Dakota region.

Open Q$.$C Inn file & save as QCInn$\_$yourfirstnamelastname: Example: QCInn$\_$JohnDoe, Fill out Documentation Sheet with Your Name & Date. Review the data on the Motels & Terms & Definitions Sheets. On the Motels Sheet: Complete the Occupancy Rates, ADR & ReV Par$($Columns K$,$ M & N$).$

Create PivotTables to answer the following questions:

NOTE: Format ALL Value fields accordingly$-$accounting or currenc $\%,$ commas & NO decimals: For an example: $$134,000,5\%,56,000$

When complete: Submit in Blackboard: HW Assignment # $2($PivotTables$)$

Total number of Rooms rented each Year

Total Revenue by Motel Total:

Total Rooms rented by Region & State Region:

State:

Tofal Motel Rooms & Rooms Rented per City Total Motel Rooms:

Rooms rented per city:

Total Revenue & Total Rooms Rented by Month

a$.$ Insert a Slicer for Motel Name

b$.$ Show data for Lexington Inn & Suites

c$.$ Change Sliver Caption to: Click on Motel Name

Total Revenue by City

a$.$ Sort Smallest to Largest

b$.$ Highlight the City with the Lowest Revenue

Total Revenue by Year

a$.$ Create a Clustered Column Chart

b$.$ Chart Title: Q$,$C Inn: Total Revenue by Year

c$.$ Remove the Legend

d$.$ Format: Your choice