​

Course Overview

This practical 5-day course provides a comprehensive introduction to Power BI, Microsoft’s powerful business intelligence and data visualization tool. Through hands-on exercises, participants will explore Power BI Desktop and Power BI Service, learning how to load data, build data models, create interactive visualizations, and share meaningful reports and dashboards. The course focuses on helping non-technical professionals become confident in analyzing and presenting data using Power BI.

​

Learning Outcomes

By the end of this course, participants will be able to:

• Understand the purpose and components of Power BI.

• Connect to various data sources such as Excel, CSV, and databases.

• Clean and transform data using Power Query Editor.

• Create relationships and develop a data model.

• Use DAX to build calculated columns, measures, and tables.

• Design interactive visualizations and dashboards.

• Publish and share reports using Power BI Service.

• Set up data refresh schedules and gateways.

​

Daily Modules & Topics

​

Day 1: Introduction to Power BI and Data Preparation

• Introduction to Business Intelligence and Power BI

• Navigating the Power BI Desktop interface

• Loading and exploring data sources (CSV, TXT, Excel)

• Introduction to Power Query Editor

• Basic data transformation techniques

• Adding columns from examples

• Appending and merging queries

• Combining files

• Using parameters and templates

Day 2: Data Modeling Fundamentals

• Introduction to data modeling concepts

• Creating relationships between tables

• Enhancing models with hierarchy and metadata

• Introduction to DAX (Data Analysis Expressions)

• Calculated columns and tables

• Basic DAX functions

• What-If parameters

Day 3: Creating Measures and Using DAX

• Understanding measures vs. calculated columns

• Writing DAX measures

• Aggregation and filter functions

• Time intelligence functions

• Creating reusable KPIs and calculations

• Practice exercises on model enhancements

Day 4: Building Interactive Visualizations

• Overview of visualization options in Power BI

• Creating bar charts, maps, slicers, tables, and trend visuals

• Designing dashboards for storytelling

• Using custom visuals and themes

• Adding interactivity with bookmarks and filters

• Goal tracking and combining visuals effectively

Day 5: Publishing Reports and Managing Data

• Introduction to Power BI Service

• Publishing reports

• Creating and sharing dashboards

• Refreshing data

• Overview of data refresh options

• Installing and using the data gateway

• Scheduling automatic data refresh

• Course review and final Q&A

• Certification of completion

Training Methodology

• Interactive demonstrations by the instructor

• Guided hands-on practice using real datasets

• Group exercises and troubleshooting sessions

• Daily recap and Q&A

• Final practice project to consolidate learning

Course Requirements

• Basic knowledge of Excel and working with structured data is recommended

• A Windows-based laptop with Power BI Desktop installed (free from Microsoft)

• Internet access for publishing reports and connecting to online services

Course Outcomes

Participants will be able to:

• Confidently use Power BI to connect, model, and visualize data.

• Create professional reports and dashboards for data-driven decision-making.

• Automate and schedule data refreshes for up-to-date reporting.

• Collaborate and share insights using Power BI Service.

​

Course Details

• Duration: 5 days

• Language: English

• Price: $270

• Time: 14:00 - 18:00

• Refreshments: included

• Location: Erbil, mselect office

​

Payment

Must be made 7 working days before the start of the course. Payment can be made in cash, by bank transfer or through exchange offices.

​

How do I register?

You can register by emailing training@mselect.com with the following details:

• Full Name:

• Position:

• Email Address:

• Phone number:

• Name of the course: