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: