Power Bi Mastery: Essential Skills for Modern Data Analytics
This 2-day intensive course equips professionals with essential Power BI skills to create dynamic reports, perform efficient data transformations, and utilize advanced analytics for strategic decision-making. It empowers participants to translate raw data into impactful business insights.
Programme Overview
With organisations increasingly relying on data-driven strategies, mastering Power BI is no longer optional, it's a necessity. This 2-day intensive course equips professionals with the latest Power BI tools and techniques, empowering them to create dynamic reports, perform efficient data transformations, and utilise advanced analytics. Through expert-led sessions, participants gain hands-on experience in navigating Power BI Desktop and Service, unlocking actionable insights to elevate organisational performance. Designed for those eager to build a robust foundation, this course ensures you'll be confident in utilising Power BI to its full potential.
Learning Outcomes
Develop a deep understanding of Power BI tools and functionalities.
Gain expertise in creating & customizing interactive reports and dashboards.
Learn to publish and share insights effectively using Power BI Service.
Expand your proficiency with custom visuals for impactful presentations.
Acquire skills to implement drill-through and filters for enhanced data analysis.
Who Should Attend?
Professionals new to Power BI
Professionals transitioning to data-centric roles.
Business analysts looking to improve data reporting
Decision-makers looking to leverage data for strategies
Microsoft Excel users looking to apply advanced BI tools
Duration
2 days (14 hours)
Course Outline
Day 1 (9:00 AM to 5:00 PM)
Module 1: Introduction to Power BI & Business Intelligence
Trainer introduction
Ice-breaking session
Understanding Business Intelligence
What is Power BI?
Understanding Power BI Ecosystem
Power BI Service
Power BI Desktop
Module 2: Navigating Power BI Desktop & Exploring Reports
Getting to know Power BI Desktop Interface
Navigating with the application
Exploring a completed Report
Open existing PBIX report
Explore the Report components
Visuals, Fields, Views
Understanding visuals interactions
Module 3: Getting Started with Reports & Data Import
Get Data
Import data into Power BI Desktop
Identifying various data sources
Import Single table
Create Basic Report
Add Visuals, set fields and formatting
Module 4: Data Transformation with Power Query
Connecting to Data Sources
Transforming and Cleaning Data
Applying data cleansing and transformation actions
Utilising Power Query Editor
Reflection & Wrap-Up for Day 1
Day 2 (9:00 AM to 5:00 PM)
Module 5: Working with Data Model
Introduction to Data Model
Designing Data Model
Understanding difference between FACT and DIMENSION tables
Set relationships between tables using the MODEL view
Create reports using data model
Module 6: DAX Calculations
Introduction to DAX
Working with Calculated Columns & Measures
Adding Calculated Column
Understand the difference between Implicit & Explicit measures
Adding Measures
Displaying Measures in Reports
Module 7: Advanced Report Features and Enhancements
Insert & Format logo
Adding Text box for title text
Format report page with background colour, wallpaper
Understanding different filters that are available
Visual, Page, Report and Slicer
Enable/Disable filter interactions between visuals
Setting up Drill through
Adding Custom Visuals
Module 8: Publishing Content to Power BI Service
Sign up to Power BI Service
Exploring Power BI Service Interface
Publishing PBIX report file
Create Dashboard
Your Trainer
Norhayati Isa
- Microsoft Certified Trainer (MCT)
- Power BI Data Analyst (Associate)
- Microsoft Office Specialist Master (2016, 2019 Expert)
- HRD Corp Accredited Trainer
- IBM Domino Trainer & Consultant
- Expertise in Microsoft Office & Power BI data analysis
- Over 25 years in IT training & consulting
Norhayati Isa is a seasoned IT professional with over 25 years of experience in training and consulting. Starting her career in 1990 after an NCC diploma, she has excelled in teaching desktop applications, transitioning to specialize in Lotus Notes in 1998. Her extensive background provides valuable insights and solutions to diverse clients.
An HRDF Certified Trainer and Microsoft Certified Trainer (MCT), Norhayati is an expert in Microsoft Excel and Power BI, offering comprehensive courses. Her proficiency extends across the entire Microsoft Office suite, including Project, Access, and VBA. She is passionate about creating an engaging and enjoyable learning environment, ensuring students unlock their full potential.
Beyond training, Norhayati has undertaken various consulting projects, developing Microsoft Access databases, implementing Project Server, and automating processes with VBA for notable clients. She holds multiple Microsoft Office certifications (Master and Expert levels) and is a Power BI Data Analyst. Her ability to customize classes to clients' specific needs highlights her commitment to impactful learning outcomes.
Pricing
Sign up by 16 May 2026
Sign up by 16 May 2026
Course fee includes 8% SST, refreshments, lunch, handouts & certificate.
Download Brochure16 June 2026