Course Details

Data Wrangling, Analysis and Visualisation

Overview

  • Course Date:

    TBA

  • Registration Period:

    TBA

  • Duration/Frequency:

    24 hours / 3 days (9:00am - 6:00pm)

  • Mode of Training:

    Face-to-Face (Classroom Teaching)

What You Will Learn

Data may be in abundance, however making it comprehensible and meaningful to stakeholders require data-driven skillsets.

Through this course, you will gain the skills to clean data, perform simple analysis and create useful and interactive visualizations and dashboards for presentation and recommendations to stakeholders. You will learn how to achieve this using Excel and Tableau / Power BI software.

Key Outcomes

  • Prepare, clean, format and manage data using Excel for analysis
  • Summarise and represent data meaningfully using excel for further analysis and decision making
  • Prepare and manipulate data for visualisation using Tableau / Power BI
  • Visualise data using Tableau / Power BI
  • Apply advanced visualisation using charting capabilities in Tableau / Power BI
  • Build Interactive Dashboards using Tableau / Power BI

Topics to be covered

Part 1: Collecting and Managing Business Data
Part 2: Understanding your Data
  • Data Calculations and Management
  • Decision making using What-If Analysis
Part 3: Prep your Data with Tableau / Power BI
  • Tableau / Power BI Prep Introduction
Part 4: Visualising your Data
  • Tableau / Power BI Basics
  • Advanced Tableau / Power BI Charting
  • Interactive Dashboarding