This course equips participants with the knowledge and skills to prepare data, conduct data analysis, create effective visualisation and interactive dashboards, and build machine learning services without programming, using Microsoft Excel, Tableau and various code-free tools and platforms.
Learning Objectives
By the end of this course, participants will be able to:
- Get & transform data using Power Query in Excel
- Apply mathematical and statistical functions for deriving insights from data
- Create PivotTables and PivotCharts to calculate, summarise, analyse, and visualise data
- Create PivotTables, PivotCharts and Dashboard for data exploration and analysis
- Apply visualisation principles for creating effective visualisations
- Build interactive dashboards for monitoring key metrics
- Build machine learning services for performing sentiment analysis and solving regression problems
- Evaluate training models for video analysis
Who should attend?
Managers, professionals, executives and support staff involved in data collection, preparation and presentation for analysis with a keen interest in making full use of data to make useful predictions.
Entry Requirement
Participants should have basic IT literacy with a keen interest in data analysis and presentation, and are comfortable with performing basic software setup and configuration.
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).