Advanced Data Visualisation using Power BI
Funding Validity Period
19 August 2024
-
18 August 2028
Course Overview
This 3-day course is designed for Power BI users who want to take their data visualisation skills to the next level. Participants will delve into advanced techniques for creating compelling and informative dashboards and reports. The course will cover advanced data manipulation, custom visuals, DAX (Data Analysis Expressions), storytelling with data, and best practices for deployment and sharing.
Skills Acquired
By the end of this course, learners will be able to:
- Apply Advanced Data Visualisation via Power Query Editor.
- Analyse Data Patterns, Trends and Correlations in Advanced Data Visualisation.
- Implement DAX Techniques in Dashboard and Scorecard Development Process.
- Develop Custom Visuals in the Form of Tables, Graphs and Dynamic Data Display.
- Determine Storytelling Techniques to Support Presentation of Data Analysis.
Learning Modules
Learning Unit 1: Power Query Editor Deep Dive
-
- Advanced data transformations (pivoting, unpivoting, merging
- M language fundamentals for custom data manipulation
- Appraising error handling and data quality checks
- Waterfall charts, funnel charts, gauges, and other advanced visuals
- Formatting and customizing visuals for impact
- Interactive elements and user experience considerations
- Calculated columns and measures
- DAX syntax and common functions
- Filtering and aggregation with DAX
- Time intelligence functions (DATES, PERIODS, etc.)
- Utilizing advanced filtering and calculated tables
- Creating complex KPIs and performance metrics
- Identifying and integrating custom visuals for specific needs
- Evaluating and selecting appropriate custom visuals
- Leverage custom visuals for unique data storytelling
- Designing dashboards and reports with a narrative flow
- Engaging users with visuals and data insights
- Best practices for layout, hierarchy, and user interaction
Who is this course for
Admin, operational, and managerial staff who use Power BI to perform advanced data analysis and create interactive dashboards for reporting purposes.
Academic prerequisites
- Learners must be able to read, write, speak and listen English at Secondary level.
- Learner should have at least 1 year’s working experience in any industry.
- Learners must have basic knowledge on Power BI.
Course Fees
| Fees | Small Medium Enterprises (SMEs) | Non Small Medium Enterprises | Singaporean Employees aged 40 years and above |
|---|---|---|---|
| Full Fee | $1,500.00 | $1,500.00 | $1,500.00 |
| 9% GST (on full course fee) | $135.00 | $135.00 | $135.00 |
| Funding Amount | $1,050.00 (70% off course fee) | $750.00 (50% off course fee) | $1,050.00 (70% off course fee) |
| Nett Fee Payable (incl. GST) | $585.00 | $885.00 | $585.00 |
- SME: Company registered or incorporated in Singapore AND employment size of not more than 200 or with annual sales turnover of not more than $100 million
- Non-SME (MCES): Employee is Singaporean aged 40 years and above
- Eligible for Absentee Payroll Funding
- Eligible for SkillsFuture Enterprise Credit (SFEC)
| Fees | Singapore Citizens (40 years and above) | Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) |
|---|---|---|
| Full Fee | $1,500.00 | $1,500.00 |
| 9% GST (on full course fee) | $135.00 | $135.00 |
| Funding Amount | $1,050.00 (70% off course fee) | $750.00 (50% off course fee) |
| Nett Fee Payable (incl. GST) | $585.00 | $885.00 |
- MCES: Singaporean aged 40 years and above
- Normal: Singaporean / PR aged 21 years and above
- Eligible for UTAP funding
- Eligible for SkillsFuture Credit
- Eligible for PSEA Funds
Advanced Data Visualisation using Power BI
Course Highlight
Course Duration
24 HRS
Training Time
9am - 6pm
Mode of Training
Classroom
Course Reference Number
TPG-2026116065
Claude Cowork for Business Automation
16 HRS Course
Learn More
Build Apps in a Day with Vibe Coding
8 HRS Course
Learn More
Blockchain & Digital Assets for Business
16 HRS Course
Learn More
Smart with Google Workspace and AI
16 HRS Course
Learn More
Systems Thinking for Professional Growth
16 HRS Course
Learn More
Mastering Excel with AI and CoPilot
8 HRS Course
Learn More
Mastering Data Analysis with Python
16 HRS Course
Learn More
Finance for Non-financial Managers
16 HRS Course
Learn More