This course is designed to equip participants with essential data transformation and visualisation skills using Microsoft Power Query and Power BI Desktop. Through hands-on training, Participants will explore how to efficiently clean, transform, and prepare data for analysis using Power Query. The course then guides participants through the process of creating compelling data visualisations and interactive dashboards in Power BI Desktop. Emphasising practical application, the course includes real-world exercises to ensure participants gain confidence and competence in using these powerful tools for data analysis and business intelligence.
KEY LEARNING OUTCOMES
By the end of this course, you will be able to use a visualisation software to:
- Importing & Transforming data
- Auditing & Cleaning data
- Filtering & Formatting data
- Pivoting & Unpivoting data
- Appending & Merging data
- Using the Query Editor
- Creating relationships between related data sources
- Building reports with various types of aggregations and filters
- Analysing data with visual analytics
- Creating interactive dashboards
COURSE OUTLINE
- Introducing Query Editor
- Introducing Power BI Desktop
WHO SHOULD ATTEND?
COURSE DETAILS
Duration: 8hrs (1 day)
Language: English
Delivery Mode: Classroom
Location: Classroom
Mode of Assessment: Practical and Written Assessment
Trainer: This course is delivered in collaboration with our training partner. AE to be assigned by training partner. Assigned AE and their credentials will be confirmed before course commencement.
Max. Class Size: 25 pax
Course Schedule: N.A.
In collabration with:
ENTRY REQUIREMENT
CERTIFICATION
Participants who meet at least 75% of the required course attendance and attempt the assessment will be awarded with Certificate of Completion.
Course Fees
| LEARNER CATEGORY | Course Fee |
|---|---|
|
Full Course fee
|
S$545.00 |
|
Singapore Permanent Resident
|
S$163.50 |
|
Long Term Visit Pass + (LTVP+)
|
S$163.50 |
|
Singaporean aged 39 & below
|
S$163.50 |
|
Singaporean aged 40 & above
|
S$63.50 |
|
SME-sponsored (Singapore Permanent Resident)
|
S$63.50 |
|
SME-sponsored (Singaporean aged 39 & below)
|
S$63.50 |
|
SME-sponsored (Singaporean aged 40 & above)
|
S$63.50 |
|
SME-sponsored (LTVP+)
|
S$63.50 |
The course fees payable above are inclusive of 9% GST rate.
Interested in This Course?
Speak with us to learn more about course schedules, funding support,
registration procedures, and corporate training options.