Advanced Power BI
Course Information
2 Days Course
Fee: $1280 (before GST)
Course Dates:
- 3 & 4 Nov 2025
- 8 & 9 Dec 2025
- 5 & 6 Jan 2026
- 5 & 6 Mar 2026
Time: 9.15am – 5pm
Contact: [email protected]
Venue: Hotel (near MRT)
Note:
- Tea breaks and buffet lunch will be served. Car park coupons are available upon request.
- For 3 pax and above, 10% discount across the board
Refer A Friend
Get a $15 NTUC voucher for every successful referral! T&Cs apply & while stocks last!
- Rewards are issued only after their referral has completed the course.
- Referred individuals must not have attended our courses in the last 12 months.
- Referrals from the same company or organization as the referrer are not valid.
Course Introduction
This 2-days practical workshop is aimed at equipping participants with the advanced fundamentals of using Power BI Desktop as well as the applied skills required to enable them to communicate insights in the form of BI reports to make the right business decisions.
Learning Outcome
- Master advanced data visualization tools for compelling storytelling and effective communication.
- Understand how to design interactive reports and dashboards with dynamic data updates
- Discover the potential of custom visuals in Power BI and how to integrate third-party visualization tools for enhanced data representation
- Develop skills to effectively present data using advanced charting techniques and formatting options.
- Learn best practices for designing impactful and user-friendly reports and dashboards
- Gain a deep understanding of complex DAX functions and their applications in data analysis.
- Understand how to work with time-based data and custom calendars in DAX.
Who Should Attend
- Executives, Senior Executives and Managers
- Staff seeking to enhance their data analytics skills on the Power BI Desktop platform
Course Outlines
- Topic 1. Introduction to Advanced Visualizations
- Overview of advanced visualizations in Power BI
- Best practices for effective data visualization
- Topic 2. Custom Visuals and Third-Party Tools
- Exploring custom visuals in Power BI (e.g. Sankey diagram, Marimenkko chart)
- Integrating third-party visualization tools
- Topic 3.Interactive Reports and Dashboards
- Designing interactive reports with bookmarks, buttons, tool-tips and drillthroughs
- Creating dynamic dashboards with real-time data slicers and dynamic axis
- Topic 4. Advanced Charting Techniques
- Advanced chart types and their applications (e.g., waterfall charts, funnel charts)
- Customizing visuals with advanced
formatting options - Create role-based dashboards with RLS
- Topic 5. Deep Dive into Advanced DAX
- Understanding complex DAX functions (e.g., CALCULATE, SUMX,
RELATEDTABLE, RANKX, LOOKUPVALUE, SWITCH, FILTER, ALLSELECTED) - Techniques for optimizing DAX performance
- Topic 6. Advanced Data Modeling
- Best practices for data modeling in Power BI
- Creating and managing complex relationships between tables
- Topic 7. Time Intelligence in DAX
- Working with time-based in DAX (eg. YTD, QTD calculators)
- Handling time zones and custom calendars
- Topic 8. Analyzing Unstructured Data
- Techniques for analyzing text data in Power BI
- Using AI and machine learning features in Power BI for advanced analytics
- Topic 9. AI in Power BI
- Using Smart Narratives
- Q&A
- Using Co-Pilot in Power BI
- Methodology
Interactive lectures, demonstrations and hands-on practices