Powerbi Data analysis

Master of Business Analytics BUS5AP La Trobe Business School

1

BUS5AP – Business Application of Analytics Assignment 03: “Analyse This!” – Bring your user stories to life with Power BI Assignment Type: Individual Marks: 40% Release Date: Wednesday, 05-Oct-2022 Due Date: Saturday, 12 November 2022 23:55 (AEDT) – submission link on LMS

“Analyse This!” – Bring your user stories to life with PowerBI

Having successfully completed your analysis of user stories, you have been requested by HOLISTICO

to deliver a prototype dashboard. You will use your experience gained from Week 05 (Think like a

designer) and the Power BI content from Week 8 to Week 12 to develop a visually compelling

dashboard that encompasses user stories completed in Assignment 02.

You will then pitch this dashboard to HOLISTICO’s team to show them the value of the analytics

exercise they have undertaken with you as you uncover insights about their operation and direction.

A sample dataset for this assessment is provided in the spreadsheet (BUS5AP-HOLISTICO-AS03-

Dataset.xlsx) on the LMS under Assignment 03.

Deliverables:

1. Complete the spreadsheet template, with the first column showing a list of user stories from

Assignment 02 and the second column noting if this user story is prototyped in your

dashboard.

2. A 15-minute (exactly 15 minutes) video recording of you presenting your dashboard and how

this dashboard delivers on the user stories presented in Assignment 02.

o You may use additional material such as a slide deck to present your dashboard

(especially when linking the dashboard to the user stories), and you must be visible in

the recording to deliver the pitch.

o The presentation must cover the following:

▪ How your dashboard delivers on the value drops specific in your business case

and the user stories from assignment 02 (both the Summary and Operational

level dashboard) – it is acceptable to make changes to your value drops and

user stories in the event that it doesn’t align with the dashboards.

▪ A walkthrough of each of the elements of the dashboards (and how it delivers

on a selected user story)

o You may use Zoom screen recording feature to capture you dashboard pitch. For a

step-by-step guide to Zoom screen recording, follow this link.

3. A PowerBI file in PBIX format covering the content above. The PowerBI dashboard must

consist at minimum of the following:

o A strategic level dashboard highlighting organisation trends (ideally aligned to the

Clinic Owner).

o An Operational level dashboard that allows personas such as the Clinic Owner

Practitioner and the Practice Managers’ to gain insights into specific patient trends.

o Each of the dashboards will be located on the same PowerBI PBIX file under multiple

tabs. You can have more than 2 tabs but less than 4 tabs.

Master of Business Analytics BUS5AP La Trobe Business School

2

o Add your own data into the spreadsheet to support your user story where data does

not exist on the spreadsheet you may create some sample data on the excel sheet

that can then be used on the report.

Note: the LMS Assignment will allow 3 attachments – the Video Presentation, the PBIX file and the

Excel sheet with the list of the user stories incorporated in the Power BI dashboard from assignment

02. Try and combine as many user stories into a single dashboard visual.

Master of Business Analytics BUS5AP La Trobe Business School

3

Criteria Pass (P) Credit (C) Distinction (B) High Distinction (A)

Design of the PowerBI Report - Strategic Dashboard 8 marks

Minimal effort towards developing visually compelling dashboards and linking these to the user stories

Decent effort towards developing visually compelling dashboards and linking these to the user stories

Good effort towards developing visually compelling dashboards and linking these to the user stories

Comprehensive effort towards developing visually compelling dashboards and linking these to the user stories

Design of the PowerBI Report - Operational Dashboard 8 marks

Minimal effort towards developing visually compelling dashboards and linking these to the user stories

Decent effort towards developing visually compelling dashboards and linking these to the user stories

Good effort towards developing visually compelling dashboards and linking these to the user stories

Comprehensive effort towards developing visually compelling dashboards and linking these to the user stories

Coverage of user stories in the dashboard 10 marks

At least 30% of the user stories are developed and presented (i.e. included as part of the dashboard)

At least 50% of the user stories are developed and presented (i.e. included as part of the dashboard)

At least 75% of the user stories are developed and presented (i.e. included as part of the dashboard)

At least 90% of the user stories are developed and presented (i.e. included as part of the dashboard)

Presentation of Dashboard 10 marks

Basic effort to communicate the value of the dashboard, how it delivers on the user stories and the insights derived as a result of incorporating it in strategic and operational decision making.

Fair effort to communicate the value of the dashboard, how it delivers on the user stories and the insights derived as a result of incorporating it in strategic and operational decision making.

Good effort to communicate the value of the dashboard, how it delivers on the user stories and the insights derived as a result of incorporating it in strategic and operational decision making.

Excellent effort to communicate the value of the dashboard, how it delivers on the user stories and the insights derived as a result of incorporating it in strategic and operational decision making.

Novelty 4 marks

No element of creativity.

Some elements of creativity.

Strong elements of creativity.

Extensive creativity across entire effort.