Business Intelligence and Knowledge Management Reporting

Reference no: EM133142019

HS3041 Business Intelligence and Knowledge Management Reporting Assignment - Holmes Institute

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 your team members, is to create the required reports to answer each of the questions below.

You have been requested to use Microsoft PowerBIto analyse the data. Once you have created the required reports you will need to record the answerand insert a screen shot of the report with the answer highlighted, (in the area below). Each screen shot should include thestudent IDs. Your manager has also asked you to interpret the data and provide an explanation for the results for questions.

You need to create a separate report for each question.

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 producthas gothighest 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 productand 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?

14. Which month has got the highest profit in 2014 and how much?

15. What country provided the highest sales revenue for the Amarilla and how much was that?

16. What product has got less discounts rate?

17. Which product had the biggest change in Sales Revenue from 2013 to 2014? Develop an appropriate visualisation.

18. Which country and what month and year was the largest profit and how much?

19. What product has got lowest gross sale and through which segment?

Reference no: EM133142019

Questions Cloud

Differences between state and federal jurisdiction : Identify the differences between state and federal jurisdiction, when it comes to criminal law, and what is meant by due process of law.

Create hypothetical task force in response to threat : Create a hypothetical task force in response to the threat you selected. Explain how each part of the task force is integral to its success.

Research different domestic violence treatment modalities : Research different domestic violence treatment modalities. Look at both victim treatment and perpetrator treatment

BUSN7003 - Industry Research Project Assignment : BUSN7003 - Industry Research Project Assignment Help and Solution - Southern Cross University - Assessment Writing Service - TOPIC - EDUCATION AND EARNINGS

Business Intelligence and Knowledge Management Reporting : HS3041 Business Intelligence and Knowledge Management Reporting Assignment - Holmes Institute - What is the overall Sales revenue

CIS015-3 Social and Professional Project Management : CIS015-3 Social and Professional Project Management Assignment Help and Solution - University of Bedfordshire - Assessment Writing Service

CPCCBS6002 - Research and Evaluate Construction Methods : CPCCBS6002 - Research and Evaluate Construction Methods and Materials for Commercial Buildings to Three Storeys Assignment Help and Solution - TAFE NSW

Designing and implementing a relational database : Overview - The purpose of this task is to develop student's skills in designing and implementing a relational database for a given case study

Examines the opportunities and benefits e-commerce offers : E-commerce Applications - examines the opportunities and benefits e-commerce offers a small business such as the Organic Toy Company

User Account

All Pages