Advanced Power BI

Advanced Power BI

Course Information

2 Days Course 

Fee: $1,280 (before GST)

Course Dates: 

  • 11 & 12 Sep 2025
  • 6 & 7 Oct 2025
  • 3 & 4 Nov 2025
  • 8 & 9 Dec 2025

Time: 9.15am – 5pm

Contact: [email protected] 

Venue: Hotel (near MRT)

Note:

  • Tea breaks and buffet lunch will be served. Car parking coupons are available upon request. 
  • For 3 pax and above, 10% discount across the board
Person reviewing business analytics on laptop, showing performance data. Ideal for corporate training and development.

Course Introduction

This 2-day 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

  • Introduction to Advanced Visualizations
  • Custom Visuals and Third-Party Tools
  • Interactive Reports and Dashboards
  • Advanced Charting Techniques
  • Building Advanced Visuals Exercise
  • Deep Dive into Advanced DAX
  • Advanced Data Modeling
  • Time Intelligence in DAX
  • Analyzing Unstructured Data
  • Advanced DAX Scenarios Exercise
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
– 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

Topic 4: Advanced Charting Techniques

– Advanced chart types and their
applications (e.g., waterfall charts,
funnel charts)
– Customizing visuals with advanced
formatting options

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 data in DAX
(e.g., YTD, QTD calculations)
– 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

Questions regarding to the Course?
Let us help!

Scroll to Top