Advanced Data Visualisation using Power BI
TGS-2024048385
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.
Training Type
Full Time
Who Should Attend
Admin, operational, and managerial staff who use Power BI to perform advanced data analysis and create interactive dashboards for reporting purposes.
Course Duration
3 Days
Total Training Duration (Hour)
24
Course Outline
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
Learning Unit 2: Beyond Basic Charts
- Waterfall charts, funnel charts, gauges, and other advanced visuals
- Formatting and customizing visuals for impact
- Interactive elements and user experience considerations
Learning Unit 3: DAX Advanced Techniques
- 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
Learning Unit 4: Custom Visuals and the Power BI Marketplace
- Identifying and integrating custom visuals for specific needs
- Evaluating and selecting appropriate custom visuals
- Leverage custom visuals for unique data storytelling
Learning Unit 5: Storytelling with Data
- Designing dashboards and reports with a narrative flow
- Engaging users with visuals and data insights
- Best practices for layout, hierarchy, and user interaction
Course Learning Outcome
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.
Pre-requisites
- 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.
Funding Information
19 Aug 2024 To 18 Aug 2026
Course Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $1,500.00 | $1,635.00 |
| Individual Pricing (Fee payable to Training Provider) | Before GST | With GST (9%) |
| Individual (Baseline) | $750.00 | $885.00 |
| Individual (MCES) | $450.00 | $585.00 |
| Corporate Pricing (Fee payable to Training Provider) | ||
| SME | Before GST | With GST (9%) |
| Corporate (SME) | $450.00 | $585.00 |
| Non-SME | Before GST | With GST (9%) |
| Corporate (Non-SME, Baseline) | $750.00 | $885.00 |
| Corporate (Non-SME, MCES) | $450.00 | $585.00 |
Company Sponsored Funding Types
- 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
- 70% of course fee funded
- Non-SME (Baseline)
- Non-SME companies, employee is Singaporean or PR aged below 40
- 50% of course fee funded
- Non-SME (MCES)
- Non-SME companies, employee is Singaporean aged 40 years and above
- 70% of course fee funded
Absentee Payroll Funding for Companies:
- $4.50 per training hour capped at $100,000 per enterprise per calendar year
------------------------------------------------------------------------
Self-sponsored Funding Types
- MCES
- Singaporean aged 40 years and above
- 70% of course fee funded
- Normal
- Singaporean / PR aged 21 years and above
- 50% of course fee funded
