Businees Intelligence Discussion

Businees Intelligence
Reporting Assignment 2020
Reporting Assignment

Date Due: Session 8

Assessment Percentage: 35%

Groups: 2 students per group

Data File: Sale Report T2 2020.xlsx

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. Your manager has also asked you to interpret the data and provide an explanation for the results for questions.

The footer must include the group members name and student ID.

You need to create a separate report for each question.

Name your file for assignment 1 in the form Student ID1 Student ID2.pdf. You must upload a copy of this word file of the assignment and the actual power BI file to Blackboard.

Question:

1. What is the overall Sales revenue? (2 marks)

Answer:

Screen shoots:

Note:

Question:

2. What is the overall profit for 2014? (1 mark)

Answer:

Screen shoots:

Note:

Question:

3. What is the Sales revenue for Paseo in 2013? (1 mark)

Answer:

Screen shoots:

Note:

Question:

4. Which country has the highest selling rate of velo in 2014? (2 marks)

Answer:

Screen shoots:

Note:

Question:

5. For the country in Question 4, which product did they sell the highest profit in 2013? (2 marks)

Answer:

Screen shoots:

Note:

Question:

6. For the product in Question 4, which segment created the highest profit in 2013? (2 marks)

Answer:

Screen shoots:

Note:

Question:

7. Which product has got highest sales in 2014? (2 marks)

Answer:

Screen shoots:

Note:

Question:

8. Which year had the lowest profit? (2 marks)

Answer:

Screen shoots:

Note:

Question:

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 (2 marks)

Answer:

Screen shoots:

Note:

Question:

10. In the year with the highest profit, which product and segment were most profitable? (1 mark)

Answer:

Screen shoots:

Note:

· 2015 highest profit,

Question:

11. For the most profitable segment in 2014, what product has got the lowest sold rate? (1 mark)

Answer:

Screen shoots:

Note:

Question:

12. What product has got the highest sold rate, in what month, and what is the unit sold number? (3 marks)

Answer:

Screen shoots:

Note:

Question:

13. Which month has got highest and lowest gross sale? (2 marks)

Answer:

Screen shoots:

Note:

Question:

14. Which month has got the highest profit in 2014 and how much? (2 marks)

Answer:

Screen shoots:

Note:

Question:

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

Answer:

Screen shoots:

Note:

Question:

16. What product has got less discounts rate? (1 marks)

Answer:

Screen shoots:

Note:

Question:

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

Answer:

Screen shoots:

Note:

Question:

18. Which country and what month and year was the largest profit and how much? (3 marks)

Answer:

Screen shoots:

Note:

Question:

19. What product has got lowest gross sale and through which segment? (2 marks)

Answer:

Screen shoots:

Note:

(Id) Name / (Id) Name

Applied Sciences
Architecture and Design
Biology
Business & Finance
Chemistry
Computer Science
Geography
Geology
Education
Engineering
English
Environmental science
Spanish
Government
History
Human Resource Management
Information Systems
Law
Literature
Mathematics
Nursing
Physics
Political Science
Psychology
Reading
Science
Social Science
Home
Homework Answers
Blog
Archive
Tags
Reviews
Contact
google+twitterfacebook
Copyright © 2021 HomeworkMarket.comHOMEWORKMARKET.COM YOUR HOMEWORK ANSWERSHomeworkMarket
chat0
Home.Literature.
Help.
Log in / Sign up
Businees Intelligence
profile
Ahmad571

ReportingAssignmentT22020.docx
Home>Information Systems homework help>Businees Intelligence
Reporting Assignment 2020
Reporting Assignment

Date Due: Session 8

Assessment Percentage: 35%

Groups: 2 students per group

Data File: Sale Report T2 2020.xlsx

Scenario

The footer must include the group members name and student ID.

You need to create a separate report for each question.

Name your file for assignment 1 in the form Student ID1 Student ID2.pdf. You must upload a copy of this word file of the assignment and the actual power BI file to Blackboard.

Question:

1. What is the overall Sales revenue? (2 marks)

Answer:

Screen shoots:

Note:

Question:

2. What is the overall profit for 2014? (1 mark)

Answer:

Screen shoots:

Note:

Question:

3. What is the Sales revenue for Paseo in 2013? (1 mark)

Answer:

Screen shoots:

Note:

Question:

4. Which country has the highest selling rate of velo in 2014? (2 marks)

Answer:

Screen shoots:

Note:

Question:

5. For the country in Question 4, which product did they sell the highest profit in 2013? (2 marks)

Answer:

Screen shoots:

Note:

Question:

6. For the product in Question 4, which segment created the highest profit in 2013? (2 marks)

Answer:

Screen shoots:

Note:

Question:

7. Which product has got highest sales in 2014? (2 marks)

Answer:

Screen shoots:

Note:

Question:

8. Which year had the lowest profit? (2 marks)

Answer:

Screen shoots:

Note:

Question:

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 (2 marks)

Answer:

Screen shoots:

Note:

Question:

10. In the year with the highest profit, which product and segment were most profitable? (1 mark)

Answer:

Screen shoots:

Note:

· 2015 highest profit,

Question:

11. For the most profitable segment in 2014, what product has got the lowest sold rate? (1 mark)

Answer:

Screen shoots:

Note:

Question:

12. What product has got the highest sold rate, in what month, and what is the unit sold number? (3 marks)

Answer:

Screen shoots:

Note:

Question:

13. Which month has got highest and lowest gross sale? (2 marks)

Answer:

Screen shoots:

Note:

Question:

14. Which month has got the highest profit in 2014 and how much? (2 marks)

Answer:

Screen shoots:

Note:

Question:

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

Answer:

Screen shoots:

Note:

Question:

16. What product has got less discounts rate? (1 marks)

Answer:

Screen shoots:

Note:

Question:

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

Answer:

Screen shoots:

Note:

Question:

18. Which country and what month and year was the largest profit and how much? (3 marks)

Answer:

Screen shoots:

Note:

Question:

19. What product has got lowest gross sale and through which segment? (2 marks)

Answer:

Screen shoots:

Note:

(Id) Name / (Id) Name

Our Service Charter

1. Professional & Expert Writers: Blackboard Experts only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Blackboard Experts are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Blackboard Experts is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Blackboard Experts, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.

Businees Intelligence Discussion

Businees Intelligence Discussion

Our Service Charter

Recent Posts

Recent Comments