BUSINESS ANALYTICS ASSIGNMENT
Part 1: Write a two-page paper that identifies three companies in the retail business that have been using big data. Explain how big data is helping these companies improve the efficacy of their operations. (Hint: Refer to Chapter 1 and Chapter 3 for information on big data)
The following are guidelines to the required format:
• Should not be in question and answer format, but rather embody and use the question as a guide to forming the analysis
• Use paragraphs to present analyses, providing information to answer the question
• Double spaced; any headings should be bolded ;cite all references using standard MLA or APA writing styles.
Part 2: The XYZ Company sells different merchandise through different salespersons in different states. The sales manager is interested in knowing who sold what, where, and how much. Using the sample data construct a pivot table for each of the items below:
1. Sum of Amount Sold
2. Total sales broken down into three regions
3. Performance of each salesperson in each region
4. Sales broken down by region, then by salesperson, and then by Merchandise
5. Two-dimensional table that shows sales performance by region and type of merchandise
The following are guidelines to the required format:
• A pivot table should be created for each of the items above
• Copy the Pivot Table from Excel into a word document and place the corresponding label at the top of each pivot so I am able to identify which pivot table was constructed.