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.