Scenario
You work as a report developer and analyst. Your manager has supplied you with some data related to sales and has requested a number of reports. Your task, with a partner, is to create the required reports to answer each of the questions below.
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). Each screen shot should include the student IDs.
our manager has also asked you to interpret the data and provide an explanation for the results for questions.
Questions:
1. What is the overall Sales revenue?
2. What is the overall profit for 2014?
3. What is the Sales revenue for Paseo in 2013?
4. Which country has the highest selling rate of velo in 2014?
5. For the country in Question 4, which product did they sell the highest profit in 2013?
6. For the product in Question 4, which segment created the highest profit in 2013?
7. Which product has got highest sales in 2014?
8. Which year had the lowest profit?
9. In the year with the lowest profit which segment had the lowest profit and how much is that? assuming all products had at least one sale
10. In the year with the highest profit, which product and segment were most profitable?
11. For the most profitable segment in 2014, what product has got the lowest sold rate?
12. What product has got the highest sold rate, in what month, and what is the unit sold number?
13. Which month has got highest and lowest gross sale? (2 marks)
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more