Highlights
The tasks
You will use Power BI tool for data analysis and visualisation exercises provided in this assessment. These tasks will help to build your knowledge of data formats, storage, retrieval, analysis and visualisation techniques of dashboard design.
You are required to work on the given PBIX file on the Moodle site. Download the file into your local machine and work on the file directly.
For each task, use Power BI tool, generate the output by executing the Power BI functions on the given dataset in the PBIX file, and save the screenshots of the output. Save all output screenshots and analysis on the generated outputs in an MS Word file. This Word file is required to be submitted as a report for marking. Each task should be numbered correctly for marking. Also, your worked PBIX file is needed to be submitted in a zip format
Report and visualisation
1. Create a line chart which can display the average price (Price-End of day) for each year and month.
Write your explanation on the created chart.
2. Create a Line and stacked column chart visualisation, which displays the following information
• Quarterly data from Q12010-Q22017
• Columns which should display the average Price-End of day of the corresponding quarter.
• A line which shows the average percentage change between the Price-End of day and the Price-Start of day for each quarter
Write an explanation on the created chart.
3. Create a Slicer to show the different Weekday-Names.
4. Create a Gauge Chart to display the minimum, the maximum and the average Price-End of day. Write an explanation on the created chart.
5. Create a matrix to show date, Price-Start of day and Price-End of Day.
6. Write a conclusion on your overall analysis and data visualisation.
This Engineering Assignment has been solved by our Engineering Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
© Copyright 2026 My Uni Papers – Student Hustle Made Hassle Free. All rights reserved.