50%(8)4 out of 8 people found this document helpful
This preview shows page 1 out of 1 page.
The preview shows page 1 - 1 out of 1 page.
Week One: Hands-on MIS Application Software Exercise SolutionStore & Region Sales DatabaseThis exercise helps students understand how a raw file of sales transactions can beanalyzed to produce valuable information for managers.Your challenge is to ask theright questions about the data and then present your case!Import the data into Excel or Access (or compatible spreadsheet/database). Use the datato perform the below analyses:Analyze ALL THREE of the below items:1.Best Performing Regions by Total Revenue2.Best Performing Stores by Total Revenue3.Best Selling Products by Total Revenue