Analyzing Data with Power BI Hands-On Training on Building Interactive Dashboards, Automating Reports & Unlocking Data Insights

29-30 Oct, 2025, CONCORDE HOTEL KUALA LUMPUR

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

Morgan holds a Degree in IT & Tech Management from UTM, he has 20 years working experience as a trainer in the field of Information Technology. He has obtained ITIL Certification and also PSMB approved trainer (TTT). He has conducted various trainings. His key expertise are:

  • Conducting IT Training in the area of Basic Networking, PC Repairing, PC Troubleshooting & Microsoft Office Training
  • Conducting research on the latest development and requirement for training based on customer request Developing & Maintaining a sound marketing strategy
  •  Ensure KPI and Customer Satisfaction are meet

 

As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia.
As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia. He's also a well sought after consultant and works on several key IT projects each year, with leading brands in the region.

 

Venue Details

CONCORDE HOTEL KUALA LUMPUR
2 Jalan Sultan Ismail, 50250 Kuala Lumpur, Malaysia,
Phone : 03 2144 2200

https://kualalumpur.concorde hotelsresorts.com/

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Jane,
03 2283 6101
Jane@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON
  • Introduction & Basic Concepts
  • Getting Started with Power BI
  • Creating Basic Visualizations
  • Connecting to Data Sources
  • Data Transformation and Modelling
  • Advanced Visualizations and Customization
  • Introduction to DAX (Data Analysis Expressions)
  • Advanced DAX
  • Publishing and Sharing Reports
OBJECTIVES
Power BI is a suite of Business Analytics Tools that empower organizations to transform raw data into meaningful insights. This course provides participants with the skills to leverage Power BI for Data Analysis, Report Generation, and sharing insights across teams.
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Gaining Proficiency in Power BI Desktop to Build Reports and Dashboards.
  2. Learning Techniques for Data Preparation, Transformation and Modelling.
  3. Exploring DAX Functions to Perform Advanced Calculations.
  4. Understanding Power BI Service for Collaboration and Report Distribution.
  5. Accessing Insights on the go with Power BI Mobile.
  6. Having a Strong Understanding of Power BI’s Capabilities.
  7. Being able to Transform Raw Data into Meaningful Reports.
  8. Creating Interactive Dashboards for Real-Time Insights.
  9. Leveraging DAX for Powerful Data Analysis
WHO SHOULD ATTEND

This course is specially designed for Professionals who can benefit from leveraging Power BI for Data Analysis, Visualization, and Reporting.

1. Business Analysts:
• Individuals responsible for analyzing business data to derive insights and make informed decisions.
2. Data Analysts:
• Professionals working with data to extract meaningful information and create reports.
3. IT Professionals:
• IT staff who are looking to improve their skills in data analysis and reporting using Power BI.
4. Financial Analysts:
• Finance professionals who want to leverage Power BI for financial data analysis and reporting.
5. Project Managers:
• Those who want to use Power BI for project reporting, tracking, and analysis.
6. Marketing Professionals:
• Marketing analysts and managers who want to analyze and visualize marketing data.
7. Operations Managers:
• Professionals responsible for optimizing business operations through data-driven insights.
8. Human Resources Professionals:
• HR staff who are looking to analyze workforce
data, employee performance, and other HR metrics.
9. Entrepreneurs and Small Business Owners:
• Individuals who run their own businesses and want to gain insights from their data.
10. Anyone Interested in Data Visualization:
• Individuals with a general interest in data visualization and analysis.
11. Excel Users:
• Individuals familiar with Excel who want to
transition to more advanced and scalable data analysis using Power BI.

METHODOLOGY
Training for Power BI typically involves a combination of theoretical concepts, hands-on exercises, and real-world scenarios to ensure participants gain both knowledge and practical skills
1. Classroom Training:
• Traditional classroom-style training where an instructor leads the session, covers theory, and guides participants through hands-on exercises.
2. Workshops:
• Interactive workshops that focus on practical applications. Participants work on exercises and projects to reinforce their understanding of Power BI concepts.
3. Interactive Dashboards:
• Using Power BI itself as a teaching tool by
creating interactive dashboards that demonstrate
various features and functionalities.
4. Hands-On Labs:
• Practical exercises and labs where participants
can apply what they’ve learned in a controlled environment.
DAY 1
9:00

INTRODUCTION & BASIC CONCEPTS

  • Overview of course objectives and expectations.
  • High-level introduction to Power BI’s components (Desktop, Service, and Mobile).
10.45

GETTING STARTED WITH POWER BI

  • Power BI Ecosystem Overview:
    - Power BI Desktop: The primary tool for creating and designing reports.
    - Power BI Service: The cloud platform for sharing, collaboration, and online access.
    - Power BI Mobile: On-the-go access for viewing and interacting with reports.
  • Interface Walkthrough:
    - Exploring the layout of Power BI Desktop (ribbons, panes, and views).
    - Key functionalities like importing data, creating visuals, and saving work.
12.00

CREATING BASIC VISUALIZATIONS

  • Overview of available chart types (bar, line, pie, etc.) and their use cases.
  • Build a bar chart to represent sales data.
  • Create and format a pie chart to show category-wise distribution.
  • Tips for Effective Presentation
  • Using colours, labels, and themes to enhance visual appeal.


1:00 Lunch
2:00

CONNECTING TO DATA SOURCES

  • Connecting to common data sources like Excel, CSV, and text files.
  • Data Import Basics
  • Overview of import vs. direct query modes.
  • Introduction to Power Query Editor for cleaning and preparing data
  • Removing duplicates, renaming columns, and splitting data fields.
3:45

DATA TRANSFORMATION AND MODELING

  • Advanced transformations like
  • Merging and appending queries.
  • Grouping data and creating calculated columns.
  • Introduction to data modelling concepts
  • Creating relationships between tables (one- to-many, many-to-many)
  • Importance of data normalization and integrity.
  • Data cleaning, merging, and creating simple relationships.
5:00 End of Day 1
DAY 2
9:00

ADVANCED VISUALIZATIONS AND CUSTOMIZATION

  • Exploring advanced visuals
  • Maps (Geospatial Data Representation).
  • Gauge charts (KPIs).
  • Waterfall charts (showing changes over time or categories).
  • Using slicers for filtering data.
  • Applying drill-through for in-depth data exploration.
  • Storytelling with Bookmarks and Selections
  • Techniques to create interactive report narratives.

10.45

INTRODUCTION TO DAX (DATA ANALYSIS EXPRESSIONS)

  • Basics of DAX
  • What is DAX and why is it important?
  • Writing simple DAX formulas for calculated columns and measures.
  • SUM, AVERAGE, COUNT, and IF.
1:00 Lunch
2:00

ADVANCED DAX

  • Time intelligence functions (e.g., YTD, MTD, SAMEPERIODLASTYEAR).
  • Logical functions for complex scenarios.
  • Aggregation functions like CALCULATE and FILTER.
  • Creating a year-over-year comparison.
  • Custom KPIs using calculated measures.
3:45

PUBLISHING AND SHARING REPORTS

  • Publishing Reports to Power BI Service
  • Uploading reports and understanding workspace hierarchy.
  • Data Refresh and Gateways
  • Setting up automatic refresh schedules.
  • Configuring data gateways for on-premises sources.
5:00 End of Course