The following case was developed by the Ernst & Young Academic Resource Center, which is sponsored by the Ernest & Young Foundation.

For this case, you have received a data file, Analytics_mindset_case_studies_ETL_Case4.xlsx (go to the student download page at http://www.pearsonhighered.com/romney to download this file). It includes 789 lines of journal entries for 11 days from a hotel and conference center (on the tab labeled JELineItems), as well as other important accounting-relevant data sets on these other tabs:

BusinessUnits, ChartOfAccounts, PreparerInfo and Source. The following is a select list of data fields from this file noting the field name and field description tabs on which the data field is located.