In-house: | Face to Face:

POWER BI FOR BUSINESS ANALYTICS & DASHBOARD MANAGEMENT

19-20 Nov, 2026, Concorde Hotel Kuala Lumpur

Register Now PDF Brochure

IPA Training is Registered with

Learn from the Best

FAKHRUL SYAHMI

Data Analytics & Data Science Consultant | Certified Trainer | AI & Automation Specialist

Master’s Degree in Data Science

 

Fakhrul Syahmi is an accomplished data analytics and AI specialist with a proven track record in helping organisations harness technology for smarter decision-making and enhanced productivity. Armed with a Master’s Degree in Data Science, he brings deep expertise in data analytics, business intelligence, automation solutions, and AI-powered workplace tools.

 

His technical proficiencies span Microsoft Excel, Power BI, Power Platform (Power Apps, Power Automate), Looker Studio, AppSheet, AI tools (Microsoft Copilot, ChatGPT), and advanced automation workflows. He has also delivered data science solutions in predictive analytics, machine learning, time series forecasting, and text mining.

 

As a certified trainer, Fakhrul is known for his dynamic, hands-on training style that blends real-world scenarios, case studies, and interactive exercises. His sessions consistently equip participants with immediately applicable skills while driving both individual capability and organisational growth.

 

Fakhrul has designed and delivered customised training programmes, data solutions, and analytics projects for a wide range of industries — including banking, manufacturing, oil & gas, and government linked companies. His holistic approach focuses on knowledge transfer, capability development, and measurable business outcomes.

 

Training & Project Specialties

 

• Data Science: Predictive Analytics, Machine Learning, Time Series, Text Mining

• Advanced Excel & Data Analytics

• Business Intelligence & Dashboard Development (Power BI, Looker Studio)

• Automation Solutions (Power Platform, AppSheet)

• AI-Powered Data Analysis for Decision-Making

• Workplace Productivity with AI Assistants (Copilot, ChatGPT, Notion AI)

 

Notable Clients

Petronas Chemicals Bhd, AgroBank, Bank Simpanan Nasional (BSN), Al-Rajhi Bank, Shell, Teleperformance Malaysia, Berjaya Group, Menteri Besar Incorporated (MBI), Medivest, and more

 

Venue Details

Concorde Hotel Kuala Lumpur
2 Jalan Sultan Ismail, 50250 Kuala Lumpur, Malaysia,

https://kualalumpur.concorde hotelsresorts.com/


Phone : 03 2144 2200

Contact us

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

Jane,

Office: 03 2283 6101

Mobile: +60 129418251

jane@ipa.com.my

Keith,

Office: 03 2283 0000

Mobile: +60 162272735

keith@ipa.com.my

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

FOCUSING ON

Session 1: Power BI Fundamentals & Data Preparation

  • Module 1: Introduction to Power BI
  • Module 2: Data Import and Data Transformation with Power Query
  • Module 3: Data Modeling Fundamentals

 

Session 2: Visualization, DAX & Dashboard Development

  • Module 4: Data Visualization and Interactive Reporting
  • Module 5: Introduction to DAX (Data Analysis Expressions)
  • Module 6: Dashboard Design and Best Practices
TURNING YOUR BUSINESS DATA INTO INSIGHTS THAT DRIVE BETTER DECISIONS

Businesses today generate more data than ever—but data alone does not improve performance. The real advantage comes from knowing how to transform raw information into meaningful insights that management can understand and act on.

 

This intensive 2-day course equips participants with practical, hands-on skills in Microsoft Power BI, one of today’s leading business intelligence and data visualisation platforms.

 

Designed specifically for Business Professionals, Executives, Analysts and Managers, the course takes participants step-by-step from importing and cleaning data to building data models, performing calculations and creating professional, interactive management dashboards.

 

Participants will work with realistic business data and learn how to turn spreadsheets and other data sources into clear, visual and decision-ready reports covering sales, revenue, trends, product performance and management KPIs.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Understanding how Power BI and Business Intelligence can support business reporting and management decision-making.
  2. Connecting and importing data from commonly used business sources such as Excel, CSV files and databases.
  3. Using Power Query to clean, organise, transform and combine raw business data.
  4. Building effective data models and relationships to create reliable and scalable reports.
  5. Transforming data into meaningful KPIs, charts, trends and management insights.
  6. Creating basic DAX measures and calculations for more powerful business analysis.
  7. Analysing performance across time periods, products, departments, regions and other business dimensions.
  8. Building professional, interactive dashboards using filters, slicers, drill-down, drill-through, KPI cards and other Power BI features.
  9. Applying dashboard design and data storytelling principles so that reports are easy for management to understand.
  10. Publishing and sharing Power BI reports for improved collaboration and organisational reporting.
  11. Developing a complete Management KPI Dashboard from raw business data through a practical case study.
WHO SHOULD ATTEND
  • Instructor-Led Presentation
  • Hands-On Exercises
  • Real Business Case Studies
  • Interactive Discussion
  • Practical Dashboard Development Workshop
  • Q&A Session
METHODOLOGY

This course is ideal for Malaysian private-sector organisations, SMEs, MNCs, GLCs, government agencies and professionals who work with business data, prepare reports or use information to support management decisions.

  • Executives & Managers
  • Finance & Accounts Professionals
  • Sales & Marketing Professionals
  • HR & People Management Professionals
  • Operations, Supply Chain & Procurement Teams
  • Business, Data & Reporting Analysts
  • Project Managers & Department Heads
  • Excel Users Ready to Take the Next Step Especially suitable for professionals who currently spend significant time preparing, updating and presenting recurring reports in Microsoft Excel.
  • Anyone responsible for preparing management reports, analysing organisational data or communicating business performance to decision-makers.
DAY 1
 

SESSION 1: POWER BI FUNDAMENTALS & DATA PREPARATION

9:00

MODULE 1: INTRODUCTION TO POWER BI

  • • Overview of Power BI and Business Intelligence
  • • Power BI Desktop vs Power BI Service
  • • Understanding reports, dashboards, and datasets
  • • Power BI interface and navigation
  • • Importing data from Excel, CSV, and databases

Learning Outcomes

  • Understand the Power BI ecosystem
  • Identify the components of Power BI Desktop, Service, and Mobile
  • Recognize the role of business intelligence in decision-making
10.45

MODULE 2: DATA IMPORT AND DATA TRANSFORMATION WITH POWER QUERY

  • Connecting to data sources
  • Data profiling and data quality checks
  • Removing duplicates and blanks
  • Changing data types
  • Splitting and merging columns
  • Replacing values
  • Filtering and sorting data
  • Appending and merging queries
  • Creating calculated columns in Power Query

Learning Outcomes

  • Import data from multiple sources
  • Clean and prepare raw data for reporting
  • Apply transformation techniques using Power Query Editor
1:00 Lunch
2:00

MODULE 3: DATA MODELING FUNDAMENTALS

  • Fact table vs dimension table
  • Creating relationships
  • One-to-many relationships
  • Star schema concept
  • Managing model view
  • Creating date/calendar tables
  • Best practices for data modelling

Learning Outcomes

  • Understand relationships between tables
  • Build a proper data model for reporting
5:00 End of Day 1
DAY 2
 

SESSION 2: VISUALIZATION, DAX & DASHBOARD DEVELOPMENT

9:00

MODULE 4: DATA VISUALIZATION AND INTERACTIVE REPORTING

  • Tables and matrix visuals
  • Bar, column, line, and pie charts
  • KPI cards and scorecards
  • Slicers and filters
  • Drill-through and drill-down
  • Conditional formatting
  • Customizing visual interactions
  • Tooltips and bookmarks

Learning Outcomes

  • Build effective visual reports
  • Select suitable charts for different business scenarios
  • Apply formatting and interactivity features
10.45

MODULE 5: INTRODUCTION TO DAX (DATA ANALYSIS EXPRESSIONS)

  • Introduction to DAX concepts
  • Measures vs calculated columns
  • SUM, AVERAGE, COUNT, DISTINCTCOUNT
  • IF statements
  • DIVIDE function
  • CALCULATE function (basic)
  • Time intelligence basics
  • YTD, MTD, Previous Month comparison

Learning Outcomes

  • Create basic calculations using DAX
  • Understand measures vs calculated columns
1:00 Lunch
2:00

MODULE 6: DASHBOARD DESIGN AND BEST PRACTICES

  • Dashboard layout planning
  • Visual hierarchy and user experience
  • KPI-focused dashboard design
  • Business storytelling with visuals
  • Publishing reports to Power BI Service
  • Sharing reports and collaboration
  • Best practices for executive reporting

Learning Outcomes

  • Design professional dashboards
  • Apply storytelling techniques using data
 

PRACTICAL SESSION: Hands-on Case Study

Participants will work on a real business reporting case involving:

  • Sales Performance Analysis
  • Revenue by Region
  • Monthly Trend Analysis
  • Product Performance Dashboard
  • Management KPI Dashboard
5:00 End of Course