
2-Day Power BI Desktop Series 3 - Designing Powerful Dashboards Tips and Techniques Course (New & Exclusive Course)
Course Overview
This course is created, owned, and trained by its original creator, Mr. Alaster Leong. Learn from the original creator.
This course is intended for existing Power BI users.
Ready to take your Power BI dashboard design skills to the next level?
This Power BI Desktop course is the third in the series and is a hands-on, project-based course designed for users looking to elevate their dashboard design skills and explore the latest Power BI features and visuals.
You’ll apply advanced techniques to real-world business intelligence scenarios, reinforcing your skills through practical application. You’ll learn how to create dashboards that are not only insightful and visually compelling but also user-friendly — so even end users without Power BI experience can navigate them with ease. Additionally, you’ll learn how to optimize your dashboards to be space-efficient, making the best use of available screen real estate without sacrificing clarity.
In business intelligence, even the most powerful data model can fall short without thoughtful, well-executed design. This course dives into advanced dashboard design strategies, emphasising clarity, usability, and real-world impact — helping you build dashboards that are intuitive, interactive, and make the best use of available space.
This course builds upon the foundational knowledge taught in Power BI Desktop Series 1 – Data Model, DAX & Dashboard Visualization. You’ll continue using the same project database from Series 1, allowing you to dive straight into refining your design approach without time wastage.
This course is the third in our Power BI Desktop series:
- Power BI Desktop Series 1 – Data Model, DAX & Dashboard Visualization
- Power BI Desktop Series 2 – Advanced DAX Formula
- Power BI Desktop Series 3 – Designing Powerful Dashboards Tips & Techniques
Objectives
Upon completion of the course, learners will be able to:
- Utilise advanced dashboard design techniques to create professional, user-friendly reports
- Apply practical tips and techniques to elevate the clarity, usability, and effectiveness of your dashboards
- Work confidently with newly implemented Power BI features and visuals to enhance data presentation and interactivity
Who Should Attend
This course is for:
- Learners who have attended our Power BI Series 1 – Data Model, DAX & Dashboard Visualization course.
- Existing Power BI Desktop users
Methodology
This is a hands-on practical course. Trainer will walk through the topic step-by-step. Learners will be provided with exercise files on every topic to effectively apply what have been taught. A short Q & A session will be available after each topic.
Prerequisites
- Have attended our “Power BI Series 1 – Data Model, DAX & Dashboard Visualization”
- Existing Power BI Desktop users
Things To Bring
- A Windows operating system laptop with Microsoft Power BI Desktop recent version (October 2024 or later) installed or updated (personal laptop is preferred as some company laptops may have security restrictions).
- Laptop power adaptor and a USB mouse.
Course Information
Fee
SGD 910.00 (Nett)
Absentees will be charged the full course fee
Includes lunch and two coffee breaks with light snacks, unless otherwise stated
Time
9:00am to 5:00pm (14 hours)
Mode
Classroom @ Hotel
(The hotel will be confirmed five days before the course start date)
Dates
22-23 Sep 2025
24-25 Nov 2025
ALS reserves the right to reschedule, postpone or cancel any course, change the venue at short notice and at its absolute discretion, due to insufficient enrolment, class size, availability and circumstances outside our control.
If your organisation has a group registration of six or more individuals attending the same course, you may request a closed class in your preferred month, subject to the trainer’s availability.
Why Learn With Us?
Course Outline
1. Project Setting
- Project Path Setup
- Option Settings
- Turn on Preview features
- Pane Manager Setup
2. New Features, Visuals & Advanced Design Techniques
- Organize Measures with Virtual Folders
- Creating Dynamic Format String for Measures
- Canvas Background & Wallpaper
- Using Image as a Button
- Modern Visual Tooltips
- Report Page Tooltips
- The New Drill Through Location
- Creating Drill Through Button
- Conditional Drill Through
- Calculation Group
- Conditional Formatting on Chart
- Locking Objects
- Small Multiples
- Field Parameters – Dynamic Table Columns
- Field Parameters – Dynamic X & Y Axis
- Create Hierarchies in Field Parameters
- Dynamic Slicer Based on Field Parameters
- Create a Reset all Slicers Button
- Search Box & Wildcard in Slicer
- Create an Apply all Slicers Button
- Dynamic Constant Line for Line or Column Chart
- Dynamically Highlight Columns below Target
- Sparkline in Matrix Visual
- Traffic Light KPI in Table Visual
- Display Last Refresh Date and Time
- Selection Pane In-Depth
- Bookmarks In-Depth
- Create Dynamic Titles Based on Slicer Selection
- Create Multiple Page Tabs within a Page
- Slicer Pane
- Q&A Visual
- Conditional Icons in Table or Matrix Visual
- Reference Line in Chart
- The New Card Visual
- The New Button Slicer
- Card (new) Visual Small Multiples
- Text Slicer
- Visual Calculation
- Building Page Navigation Pane
3. Optional Topics
- Creating a Live Analog Clock
- The New List Slicer
- Creating a Data Dictionary
Our Dedicated Lead IT Trainer - Mr. Alaster Leong
This course is created, owned and trained by Mr. Alaster Leong. Learn from the original creator of this course.
Alaster has been training adult learners in IT in both the private and public sectors since 1986. Alaster’s career before training centred around IT for over 12 years, as he held various roles within software development. He has earned himself a Microsoft Office Specialist (MOS) certification and he is an existing Trainer approved by People’s Association (PA). He was also a former Associate Trainer with the Civil Service College.
He specialises on training Microsoft Applications and Adobe Photoshop. Based on his vast experience and keeping abreast with the emerging trends, tools and technologies with the IT industry, especially software, he has extensively involved in developing several course outlines and course materials and conducting training to equip learners with skills in-demand or likely to be most important in the jobs of the future work.
Alaster constantly explore innovative and effective ways in imparting knowledge and engaging his learners at the same time. He also focuses his training on providing practical solutions to real-life problems, especially Excel. He is more than willing to help overcome various problems faced by his learners that arise in their workplace in applying their newly-acquired knowledge and skills any time after the course. He is well-known for his dedication, commitment and passion to training that makes him well-liked and appreciated by his learners.
More Courses By Alaster
Data Analysis using Dynamic and Interactive Excel Dashboard Course
Data Analysis with Excel Power Query, Data Model and Power Pivot Course
Excel 100 Tips and Techniques Course (Exclusive)
Excel 365 Dynamic Arrays Series 1 – Power Functions Course (Exclusive)
Excel Advanced Formulas and Functions Course
Excel Automation with VBA Series 1 – Fundamentals Course
Excel Data Cleansing and Building Techniques Course
Excel Pivot Table In-Depth Course
Excel Power Query Series 1 – Automating Data Preparation (Exclusive)
Excel Power Query Series 2 – Automate Complex Data Transformation (New & Exclusive)
Power BI Desktop Series 1 – Data Model, DAX and Dashboard Visualization Course (Exclusive)
Power BI Desktop Series 2 – Advanced DAX Formulas Course (Exclusive)