Group Assessment
Cover Page
Unit
Details Name Fundamental of Business Analytics
Code HI6037
Year, Trimester 2023, Trimester 1
Assessment
Details Name Group Assignment
Due Date and Week 28/05/2023, Week 10
Group
Student
Details Student ID First Name Family Name Work Contribution
Group
Submission
Declaration Integrity Declaration Student ID Full Name Submission Date
We have read and understand academic integrity policies and practices and our assessment does not violate these.
Instructions
Academic
Integrity
Information Holmes Institute is committed to ensuring and upholding academic integrity. All assessment must comply with academic integrity guidelines. Important academic integrity breaches include plagiarism, collusion, copying, impersonation, contract cheating, data fabrication and falsification. Please learn about academic integrity and consult your teachers with any questions. Violating academic integrity is serious and punishable by penalties that range from deduction of marks, failure of the assessment task or unit involved, suspension of course enrolment, or cancellation of course enrolment.
Format
Instructions • Most assessments must be in MS Word format with no spacing, 11-pt Calibri font and at least 2cm margins on all four sides with appropriate section headings and page numbers.
• You must name your file with the Unit Code and Group Number (e.g. “HI5004 Group 4”).
• Check that you submit the correct document as special consideration is not granted if you make a mistake.
• Student IDs need to be indicated on the cover page. Non-contributing students do not receive marks.
Penalties • All work must be submitted on Blackboard by the due date and time along with a completed Assessment Cover Page. Late penalties apply.
• Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using Holmes Institute Adapted Harvard Referencing. Penalties are associated with incorrect citation and referencing.
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:
Screen shoots:
Note:
GET ANSWERS / LIVE CHAT