HI6037 Fundamental of Business Analytics Report

Part A template

Read the following requirements (15 marks):

You work as a report developer and analyst. Your manager has supplied you with some data related to organization and has requested a number of reports. Your task, with your group members, is to create the required reports to answer the following questions.

You have been requested to use Microsoft PowerBI to analyse the data. Once you have created the required reports you will need to record the answer and insert a screen shot of the report with the answer highlighted (in the area below). Your manager has also asked you to interpret the data and provide an explanation for the results for questions. You need to provide it in the Note box.

Question:

1. What is the maximum longitude? It belongs to which state?(2 marks)
2. How much is the total gross margin for each state in 2013?(1 marks)
3. How much is the maximum discount and by which store?(1 marks)
4. Which city has the maximum original sales price in 2014?How much ?(2 marks)
5. The city in question 4, which product did they sell the highest sales prices in 2014(1 marks)
6. For the product in question 5, which year it has the highest original sales price?(1 marks)
7. Which product category has the highest fixed price in 2013?(1 marks)
8. Which month had the lowest gross margin and in which year?(1 marks)
9. In the year with the lowest profit(gross margin) which product had the lowest profit and how much is that ?(2 marks)
10. In the year with the highest profit(gross margin) which product had the highest profit and how much is that ?(2 marks)
11. For the product with the highest average latitude, had the lowest quantity sold by which store manager(1 marks)