Select a publicly available dataset from the internet. Alternatively, you can use the same dataset used for A1, provided it allows you to apply the below listed advanced analytical methods

/ Uncategorized / By /

Task Instructions

Step 1 : Select a publicly available dataset from the internet. Alternatively, you can use the same dataset used for A1, provided it allows you to apply the below listed advanced analytical methods

Step 2 : Find out the issues that the selected data has and apply suitable steps to handle the issues and errors if any. Also transform the data variables if needed, to make it suitable for subsequent analysis (Note: Use power query editor and DAX expressions)

Step 3 : Analyse selected data using the selected tool and implement the advanced visualisation techniques. Creating meaningful visualisations that give you more visual insight into data.

Step 4 : Based on analysis using visualisation, identify important finding about that data.

Step 5 : Carefully identify your limitations.

Step 6 : Now create a Microsoft PowerPoint presentation having the following sections:

Section1: Selected Dataset

  • Provide a link to data.
  • Provide a rationale for the choice of this data.
  • Explain how you handled data issues.
  • What data transformations did you do to prepare the data?

Section 2: Selected Advanced Data analytics technique/ Visual

  • Provide a list of objectives or investigative questions you are interested to explore in this dataset.
  • For each question, select an analysis method from the list below and apply on the dataset. Explain the rationale for the choice of a methods and also state how the method helped you in answering your investigative questions.
  1. Use of power query and DAX expressions
  2. Forecasting/Prediction, Trendlines, linear regression
  3. Clustering techniques
  4. Decision tree/Python in power BI

Section 3: Visualisations (Diagrams)

  • On every PowerPoint slide, copy a diagram / chart (visualisation created for the advanced analytics) and beneath the visual briefly explain what information/knowledge you obtained from the diagram

Section 4: Findings and Limitations

  • Explain your findings about the selected data as a result of advanced data analysis and visualisation that you have performed.
  • Enlist your limitations.