Using Power BI
Course Information
2 Days Course
Fee: $1280 (before GST)
Course Dates:
- 4 & 5 Sep 2025
- 13 & 14 Oct 2025
- 11 & 12 Nov 2025
- 18 & 19 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
Course Introduction
This 2-day practical workshop is aimed at equipping participants with the 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
By the end of this workshop, participants will be able to:
- Appreciate the concept of business intelligence and how it is applied in business
- Be equipped with the skills to differentiate between Power Pivot and traditional Pivot Table features
- Learn about Power Query and build Data Models
- Understand data analysis and data visualization concepts
- Learn the features in Power BI Desktop
- Be equipped with required skills to create Power BI dashboard solution
- Learn how to create BI Reports
Who Should Attend
This course would be suitable for any working professionals who are interested to advance their knowledge in using Power BI Desktop and its applications for their businesses.
Course Outlines
Day 1
Topic 1: What is Data Visualisation
- Purpose of data visualization
- Why is data visualization important?
- 4 types of data analytics
- The data analytics cycle
Topic 2: Navigating Through Power BI Desktop and Data Models
- Navigating through Power BI
- Understanding data formats and types
- Data Transformation in Power Query Editor
- Creating Relationships between Tables
- Create Basic Visualization
Topic 3: Setup and Data Visualization Techniques with Visual Filters and Power Query
- Setting up Page Size and Tools
- Using Visual Filters
- Applying Advance Slicer Techniques
- Calculated Column
- Create Measures Table
- Calculated Measure
Topic 4: Creating Scorecards, KPIs and Gauge Charts and DAX Formulas
- Create DAX Formulas
- Aggregation and Iteration Functions
- Using SUM, CALCULATE, FILTER
Functions - SUMX Function
- AVERAGE and AVERAGEX Functions
- Using COUNT and COUNTROWS Functions
- DISTINCTCOUNT Function
- MAX and MIN Functions
- DIVIDE Function
- FILTER Function
- ALL Function
- ALLEXCEPT Function
- Using Score Cards
- Using Key Performance Indicators (KPIs)
- Using Gauge Charts
Topic 5: Publishing Dashboards on Analysis Services
- Power BI Analysis Services
- Using the Publish Feature
- Creating Reports on Workplace
- Creating Dashboards
Topic 6: Techniques to Provide Context and Details to Data and Using Predictive Analytics
- Predictive Analytics
- Using Smart Narrative
- Creating Drill-Throughs
- Creating Hierarchy