Fundamentals of Data Wrangling, Analysis and Visualisation

Harness the power of data to gain perspectives you never thought available. This course will provide participants with a good foundation to conduct data wrangling, perform data analysis, create effective visualisation charts, build interactive dashboards and compose convincing data-driven stories using Microsoft Excel (Power Query, PivotTables and PivotCharts) and Tableau/Power BI to support data-driven business decisions.  Tableau and Power BI will be used as the visualisation tools on alternate runs.

Learning Objectives

By the end of this course, participants will be able to:

  • Apply data cleansing and data transformation techniques using Power Query, a free function within Microsoft Excel
  • Apply mathematical and statistical functions for deriving insights from data
  • Create PivotTables and PivotCharts to calculate, summarise, analyse, and visualise data
  • Apply visualisation principles for creating effective visualisations
  • Create and interpret visualisation charts
  • Build interactive dashboards for monitoring key metrics
  • Create data-driven stories for communicating key insights

Who should attend?

Managers, professionals, executives and support staff who are interested to conduct data wrangling, perform data analysis, create visualisation charts, dashboards, and data stories using Microsoft Excel and Tableau/Power BI to support data-driven business decisions.

Entry Requirement 

Basic IT literacy, with a keen interest in data analysis and presentation

Certification

Participants will be awarded a certificate of completion upon meeting the 75% course attendance requirement.

For courses with assessment component, participants will be awarded the certification of completion upon passing the assessment. Otherwise, a certification of attendance will be issued instead upon meeting the 75% course attendance requirement.

 

Please click on the "Register" button to view the updated course schedule and fees on the Skills Training & Enhancement Portal (STEP).
 
Please click on the "Register" button to view the updated course schedule and fees on the Skills Training & Enhancement Portal (STEP).
 
Related Courses
Hot Links

Last updated on 28 Feb 2025

Need more help?

If you are still unsure about which course to pursue, please contact our Academy for Continuing Education