Analyzing Manager Performance at Home
Station. You are a regional manager for Home Station, a national chain of home renovation stores. You are analyzing the weekly sales data for one of the retail stores located in Austin, Texas. The sales data is reported by department and manager. The Austin store manager wants to rotate the department
managers in each of the store’s departments so each manager becomes more familiar with the entire store’s operations. You have been assigned the task of determining the impact of rotating the managers on store sales. You will import the sales data from a database into Excel and then create a PivotTable report to summarize the quarterly sales by department and by manager.
Complete the following:
You are a regional manager for Home Station, a national chain of home renovation stores. You are analyzing the weekly sales data for one of the retail stores located in Houston, Texas. The sales data is reported by department and manager. The Houston store manager wants to rotate the department
managers in each of the store’s departments so each manager becomes more familiar with the entire store’s operations. You have been assigned the task of determining the impact of rotating the managers on store sales. You will import the sales data from a database into Excel and then create a PivotTable report to summarize the quarterly sales by department and by manager.
Complete the following:
1. Create a new Excel workbook and save it as 7-2-B-Home Station-Houston-YourName.xlsx attached with the data of the assignment. (If the Creation Date of the property file is not the current date, contact the instructor)
2. Import the information from the Sales table in the Sales.accdb database provided into a worksheet named Sales. (If have problem converting the Access Database use the Sales.xlsx File)
3. Create a PivotTable report using the data in the Sales worksheet and place the PivotTable report in a new worksheet named Houston-1 to analyze the sales by department and change the number format of the sales data to currency.
4. Create a new PivotTable named Houston-2 to analyze department sales by quarter. Which department had the highest quarterly sales, and in which quarter did it occur?
(Hint: Use the Date field to summarize the dates by quarter.)
6. Create a new PivotTable named Houston-3 and use the Manager Field to analyze department sales by managers. What is the manager that has more sales?
7. Add your name and date at the end of the exercise
8. Save and close the 7-2-B-Home Station-Houston-YourName.xlsx workbook.