Business Intelligence and Data Visualization Core Tasks - BI Analysis Tools Reports Group Assignment PART A: Assignment Information Due Date: 11:59pm Friday 24 April, 2020 (Teams must be finalised by the end of Week 4) Assignment Structure: Written and computed reports for data analysis on John Steed's Online Emporium Assignment Length: Task A (N/A); Task B (N/A); Task C (N/A); Task D (800-1000). Assignment Groups: This assignment will be completed in groups of 3-4 students. If you are looking for a team to join, ask your tutor for assistance. Group Data: Once your team has formed, please inform your Tutor. You will get a team number from your Tutor and use the team number to download the correct database file from Canvas. It is important that you use the correct data for your team, otherwise your analysis results will be considered as incorrect during the marking process. For example, Product Five may be the best performing product for Team One, while Product Five may be the worst performing product for Team Two. Assignment Submission Procedure and Related Information . The first page of your word or PDF submission for the assignment should be a cover sheet (see Canvas), which includes your team members' names and their IDs. · Penalties for late submissions apply. PART B: Case Study Description and Assignment Tasks John Steed's Online Emporium (JSOE) is an online retailer that sells over 50 products to customers mainly based in Australia. Data has been obtained from JSOE's transaction system and placed into a Microsoft Access database file. The database contains: Product, Customer and Sales data. Task A (10%) Answer the following very specific questions by analysing JSOE data using PowerPivot. For this task you only need to submit one word or PDF document. Cut and paste the table below into a word or PDF document, which should be saved under the name: Ass1_TeamNN_TaskA (where NN is your team number). 1. What is your team number? 2. How many orders exist in your orders table? 3. Which product(s) appears in the largest number of sales orders? Page 1
4. Which product(s) has the largest total quantity sold figure? 5. Which product has the largest number of orders made by females? 6. What percentage of total female orders is this? (Up to 2 decimal places)? Page 2 7. Which product(s) have the largest total quantity of sales in 2012? 8. In which month of the year are sales largest for product 21, 22, 23? (Underline the most appropriate) 21: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec All-Same 22: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec All-Same 23: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec All-Same 9. Which customer category generated the largest number of orders? 10. How many orders generated the largest net profit? Net Profit is (selling price - cost price) * quantity sold 11. List the product names of the top 10 products that produce