Data Analytics Report


Assessment: Assignment 2- Data Analytics Report 2

[email protected] a glance
Task Use the Data Science Road Map, your Power BI and Statistics skills to analyse and visualisea data set from an open data source
Learningoutcomes Present and describe information effectively
Suggest ways to improve decision making processes
Value 15%
Submission Learnline Submit Here
Week 12(see Learnline for details)
Volume&Documentation Two documents are required:

  • A Power BI workbook showing data analysis and a data dashboard
  • A 2- 4-page report in Word of PDF format summarising outcomes and decisions (see required structure in task details)
    Group or Individual Individual
    Criteria See separate document


For this assignment, you are responsible for designing a visual project in Power BI where you explain and examine an open source data set retrieved from either:
• NT Government Open Data Project:
• Darwin City Council:
NOTE: Interstate students may use data from an open data portal. However I need to approve this BEFORE you begin your assessment
This assignment will enable you to synthesise all data analytics skills learned to date as well practice your data visualisation and storytelling skills.
A structure for your response is provided in the details on page 2.


  1. Choose your data set/s. In some circumstances, depending of the data set chosen, you may want to use more than 1.
  2. Ask three (3) relevant questions relating to your data set. Consider:
    a. Who is your audience?
    b. What information does your visualisation intend to convey to your audience?
  3. When developing questions, try to think of yourself as a data analyst, and consider all of the different kinds of analysis tasks that a person might want to perform.
  4. Extract the relevant data to answer each question. For example, you may use nominal and numeric data types to represent data and your data extraction may include mean, maximum, minimum, mode, or more sophisticated analyses.
  5. Visualise your data: Select appropriate representations and interactions of the data for your nominated audience.
  6. Check if your data representations can answer your questions.
  7. Convert your data values to graphical form. Select the most effective visual encoding to convert data values to graphical form, such as colour, area, charts, interactions.
  8. Briefly analyse your data visualisation and discuss the insight it provides. For example, how do your visual displays support answering the questions you asked above? What story are you telling with your data?

Your written report should have at least three (3) questions and answers with the steps you have implemented to visualise the data, along with related screen shots showing the visualisation you used to answer each question. The maximum number of pages for this assignment is 4 (not counting visualisations)
The recommended structure for the report is as follows:

  1. Title page
  2. Problem: outline the problem you are trying to solve based on the data sets you identified. What are the three questions you are going to solve? You may use a scenario here if it helps. The audience should also be explained in this section.
  3. Data Wrangling: outline the steps you took to clean the data initially and the processes you used to understand what was in the data set you chose.
  4. Features extracted: based on your problem, what features did you choose to work with and why?
  5. Ethical considerations: use the factors from the Business Ethics Canvas to write about the ethical aspects you considered
  6. Modelling & Analysis: what visualisation and statistical processes did you employ to find answers to the problem you identified. Why did you choose these?
  7. Present Results: this should include a data dashboard created in POWER BIand contain both visual, numerical and textual data.Choices regarding visualisations should be explained critically.
  8. References (where appropriate)


  1. Data Analysis Skills (Use of the Data Science Road Map, data extraction, creative questions and ethical considerations)
  2. Demonstration of Data Visualisation and Statistical Thinking skills (ability to use the language, concepts and processes, and representations of statistics to address the problem presented to the target audience)
  3. Demonstration of POWER BI skills (the ability to use a data dashboard to answer key questions)
  4. Writing skills – ability to write a coherent report. The report should provide some insight into the data, be easy to read and easy to understand. References should be included where appropriate
  5. Innovation/Originality – for going above and beyond!

Leave a Reply

Your email address will not be published.