You work as a report developer and analyst. Your manager has supplied you with some data related to the organization and has requested a number of reports. You have been requested to use Microsoft Power BI to analyse the data.

Assignment Description
Scenario
You work as a report developer and analyst. Your manager has supplied you with some data related to the organization and has requested a number of reports. You have been requested to use Microsoft Power BI to analyse the data.
The list of assignment 2 submissions is as below:
A – Report submission
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. You are also required to interpret the data and provide an explanation for the results for questions.
B – Dashboard submission
Once you have answered the questions and provided required information, on the second part, you need to create 4 dashboards for the data sets with the Power BI tool and there should be at least 6 visualization chart and 1 slicer in each dashboard to visualize different aspect of the data analysis. The more creative dashboards’ design the higher mark you get for this section.
You must upload a copy of this word file of the assignment, the actual power BI file with all the designed dashboards, and the assignment cover sheet to the Blackboard.
Marking guide Weighting
Report questions, screenshots, and explanations 15 marks
Dashboard design and creation 15 marks
TOTAL weight for this assignment 30 marks
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)
Answer:
Screen shoots:
Note:

Question: 2. How much is the total gross margin for each state in 2013? (1 marks)
Answer:
Screen shoots:
Note:

Question: 3. How much is the maximum discount and by which store? (1 marks)
Answer:
Screen shoots:
Note:

Question: 4. Which city has the maximum original sales price in 2014? How much? (2 marks)
Answer:
Screen shoots:
Note:

Question: 5. The city in Question 4, which product did they sell the highest sales price in 2014? (1 mark)
Answer:
Screen shoots:
Note:
Question: 6. For the product in Question 5, which year it has the highest original sales price? (1 marks)
Answer:
Screen shoots:
Note:

Question: 7. Which product category has the highest fixed price in 2013? (1 marks)
Answer:
Screen shoots:
Note:

Question: 8. Which month had the lowest gross margin and in which year? (1 marks)
Answer:
Screen shoots:
Note:

Question: 9. In the year with the lowest profit (gross margin) which product had the lowest profit and how much is that? (2 marks)
Answer:
Screen shoots:
Note:

Question: 10. In the year with the highest profit (gross margin) which product had the highest profit and how much is that? (2 marks)
Answer:
Screen shoots:
Note:

Question: 11. For the product with the highest average latitude, had the lowest quantity sold by which store manager (1 marks)
Answer: