MIS271 - Business Intelligence and Data Warehousing - Deakin University

Assignment Task

Purpose

This task provides you with opportunities to learn and apply the knowledge (GLO1 & ULO1) and skills (GLO4 & ULO2, ULO3) required in the study and practice of business intelligence. By completing this task, you will develop your skills in researching, understanding, applying, evaluating, and presenting information required of business intelligence professionals/business analysts.

Context/Scenario

For this task, assume you are a graduate business analyst. You must prepare a business intelligence report and associated dashboards for the management team.

Practical sessions in this unit will provide you with an introduction to data analysis and the production of visualisations with the help of Microsoft Excel and Power BI. This assignment is designed to broaden your understanding of BI tools and further develop your analytical skills. This assignment also explores a practicebased approach to assess the capabilities and limitations of BI tools.

You will be provided with a dataset (i.e., super store orders dataset) and will be asked to (1) analyse the dataset; (2) design BI solutions for managerial use and, (2) make a series of justification and recommendations for the company managers (see assignment tasks below).

1. Cleaning and standardising the dataset

The first step is to clean and standardise the dataset using Excel.

• Discuss steps and provide screenshots of your data cleaning and standardising process (i.e., before and after data is cleaned and standardised).
• Justify why these steps need to be done. Note: Please feel free to (1) use reading materials and literature to support your arguments, and (2) make reasonable assumptions or refine the data as needed. 

2. Analysis and reporting 

A. Using ExceL: Analyse the dataset using Microsoft Excel. Key findings should be reported (i.e., screenshots of charts, tables, diagrams, etc. from Excel)

B. Usign Power of BI: Create two (02) reports. Each report must contain a collection of visualisations (i.e., screenshots from Power BI outputs). Explain why you have chosen these visualisations and indicate what they show, why you picked them, and so on.

3. Dashbord Development

• Develop at least two (02) dashboards to be used by the business managers (e.g., you may create one dashboard for the Sales Manager and one for the Customer Relationship Manager, etc.).
• You must produce the actual visuals in the Power BI tool. Screenshots from Power BI should be provided.

4. Justification and Recommendation

• Justify why these reports and dashboards could provide insights and why you have laid out the attributes in the fashion you proposed (feel free to include all other relevant justifications).
• Using the insights gained from your analysis, propose a set of recommendations that would help your managers solve business problems and/or achieve goals.

5. Group Restriction: Groups of 04 (FOUR) members.

Finding Group Members: Students should use the assessment discussion forums or discuss directly with their classmates to find group members to work with. Groups should be formed by the end of week 3, or the system will automatically/randomly assign students to a group of 4 members in week 4

This MIS271 - Statistics has been solved by our PhD Experts at My Uni Paper.