Description
Workshop Overview & Details
+
Workshop Overview & Details
Date: Saturday, 07 February 2026
Time: 9:00 AM – 5:00 PM
Location: Mercure Hotel, Putrajaya
- FREE Workbook
- FREE Certificate
- FREE Digital Notes
- FREE Mousepad
- FREE Breakfast, Lunch, Tea
- FREE Flow Coffee
Morning Session >>
+
Morning Session >>
1) Introduction to Power BI basics and interface overview.
2) Types of data sources supported by Power BI.
3) Importing data from Excel, CSV files, Databases.
4) Direct Query vs. Import Mode.
5) Hands-on Exercise: Connect to a sample dataset.
6) Introduction to Power Query Editor.
7) Data cleaning techniques: Removing duplicates, handling missing values, splitting and merging columns.
8) Transforming data: Filtering rows, changing data types, creating calculated columns.
9) Hands-on Exercise: Clean and prepare a dataset.
10) What is data modelling & creating relationships between tables.
11) Understanding primary and foreign keys.
12) Introduction to DAX (Data Analysis Expressions).
13) Hands-on Exercise: Build a simple data model.
Afternoon Session >>
+
Afternoon Session >>
14) Overview of visualization types:
- Bar charts, line charts, pie charts, maps, tables, and matrices.
- Customising visuals: Formatting options, adding filters and slicers.
- Hands-on Exercise: Create a dashboard with multiple visuals.
15) Publishing reports to Power BI Service:
- Sharing dashboards with others.
- Setting up automatic data refresh.
- Hands-on Exercise: Publish and share a report.
16) Participants work on a mini-project using a sample dataset:
- Clean the data.
- Create a data model.
- Develop visualizations.
- Publish and share their report.
