Microsoft Power BI: Analyze, Visualize, Present
Microsoft Power BI: Analyze, Visualize, Present
Duration: 2 Days
Delivery Mode: Hands-on Workshop
Target Audience: Corporate staff, data analysts, executives, business decision-makers
Course Objectives
By the end of this course, participants will be able to:
- Understand the Power BI ecosystem and its core components
- Connect and prepare data from multiple sources
- Transform raw data using Power Query Editor
- Create compelling data visualizations and dashboards
- Analyze trends, KPIs, and generate interactive reports
- Share insights and collaborate using Power BI Service
Course Content
- Day 1: Power BI Fundamentals & Data Preparation
Module 1: Introduction to Power BI
- Understanding Business Intelligence (BI)
- Overview of Power BI: Desktop, Service, Mobile
- Power BI ecosystem and data pipeline
Module 2: Getting Started with Power BI Desktop
- Interface walkthrough
- Connecting to data sources (Excel, CSV, Web, SQL Server)
- Understanding datasets, reports, and dashboards
Module 3: Data Transformation with Power Query
- Introduction to Power Query Editor
- Cleaning and shaping data
- Merging and appending queries
- Handling missing or erroneous data
Module 4: Data Modeling
- Introduction to relationships and data model
- Creating calculated columns and measures
- Introduction to DAX (Data Analysis Expressions)
- Day 2: Data Visualization, Analysis & Presentation
Module 5: Visualizing Data
- Creating charts, tables, maps, and KPIs
- Customizing visuals with filters, slicers, and drilldowns
- Using themes and formatting tools
Module 6: Data Analysis Techniques
- Time intelligence and trends
- Calculating KPIs and ratios
- Conditional formatting and tooltips
Module 7: Designing Interactive Dashboards
- Best practices for dashboard design
- Interactive elements and user-friendly navigation
- Combining visuals to tell a story
Module 8: Publishing and Sharing Reports
- Introduction to Power BI Service
- Publishing reports to workspace
- Sharing dashboards and setting permissions
- Scheduling data refresh and subscriptions
Details
Start :
28 July 2025 @ 9.00 AM
End :
29 July 2025 @ 5.00 PM
Event Category :
Microsoft Power BI
Organizer
Smart Training Solutions
Phone :
+60 11-6367 5521
Email :
ikmal@smarttraining.my
Venue
Smart Training Center
01-26, Tingkat 1, Kompleks Permaisuri Q, Jalan Sri Permaisuri, Bandar Sri Permaisuri, 56000 Cheras, Wilayah Persekutuan Kuala Lumpur.
Smart training solutions (STS), a company specializing in providing comprehensive training and consultancy services in Information Technology (IT) and Human Leadership Soft Skills.
CONTACT US
- training@smarttraining.my
- +603-91339006
- Cheras Business Centre (Block G) Jalan 3/101C Batu 5, Cheras 56000 Kuala Lumpur