Blank

Introduction to Power BI

Location Erbil

Start

Monday, 20 May 2024

End

Thursday, 23 May 2024

​register now
Course overview

Gain a 360° overview of exploring and using Power BI to build impactful reports. In this course, you will learn how to navigate this intuitive tool through hands-on exercises so you can have a better understanding on Power BI’s Data, Model, and Report views. You’ll load multiple datasets in the Data view, build a data model to understand the relationships between your tables in Model view, and create your first bar graph and interactive map visualization in Report view.

​

What is Power BI?

Power BI Desktop is a free Business Intelligence application from Microsoft that lets you load, transform,

and visualize data

​

Course Units

  • Prepare the data

  • Create a model

  • Create Visualization

  • Analyze and prepare insights

  • Deploy and maintain deliverables

Course Content
​
Module 1: Introduction to Power BI

  • Getting Started

  • Class Introduction (BI Basics)

  • Class Introduction (Power BI Desktop Overview)

  • Data Discovery with Power BI Desktop

  • Transforming Data (Basic Transforms)

  • Transforming Data (Add Column from Example)

  • Transforming Data (Appending Queries)

  • Transforming Data (Merging Queries)

  • Transforming Data (Combine Files)

  • Transforming Data (M Query Basics)

  • Transforming Data (Parameters and Templates)

  • Transforming Data (Other Query Features)

  • Introduction to Modeling Data

  • Creating the Data Model (Modeling Basics)

  • Creating the Data Model (Model Enhancements)

  • Creating the Data Model (What If Parameters)

  • Creating Calculated Columns and Tables (DAX Basics)

  • Creating Calculated Columns and Tables (Navigation Function)

  • Creating Calculated Columns and Tables (Calculated Tables)

  • Creating Calculated Measures (Measure Basics)

  • Creating Calculated Measures (Time Intelligence Functions)

Module 2: Introduction to Power

  • Introduction to Visualizing Data

  • Creating Basic Reports with the Power BI Desktop

  • Creating Interactive Reports (Adding Slicers for Filters)

  • Creating Interactive Reports (Visualizing Tabular Data)

  • Creating Interactive Reports (Visualizing Categorical Data)

  • Creating Interactive Reports (Visualizing Data Trends)

  • Creating Interactive Reports (Visualizing Categorical and Trend Data Together)

  • Creating Interactive Reports (Visualizing Geographical Data with Maps)

  • Creating Interactive Reports (Visualizing Goal Tracking)

  • Creating Interactive Reports (Using Custom Visuals)

  • Creating Interactive Reports (Digital Storytelling)

  • Creating Interactive Reports (Other Features)

  • Using the Power BI Service (Deploying to the Power BI Service)

  • Using the Power BI Service (Creating and Sharing Dashboards)

  • Using the Power BI Service

  • Refreshing the Data (Refreshing Data Overview)

  • Refreshing the Data (Installing the Data Gateway)

  • Refreshing the Data (Scheduling a Data Refresh)

Course Outcomes

  • Define and use Power BI

  • Define and use Power BI Desktop

  • Work with CSV, TXT, and Excel Worksheets

  • Connect to Databases

  • Merge, Group, Summarize, and Calculate Data

  • Report

  • Class Introduction (BI Basics)

  • Class Introduction (Power BI Desktop Overview)

​

Requirements

  • Recommended to know the basics of working with data in Excel

  • In the course, you will need a work email address to sign up for the free Microsoft Power BI service

  • Download the Power BI Desktop app which is available free from Microsoft for Windows Power BI Desktop—Interactive Reports | Microsoft Power BI

Time & details

  • Duration: 4 days

  • Time: 14:00 - 17:00

  • Location: Erbil, mselect office

  • Format: classroom based

  • Fee: $250

Payment

Must be made 5 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:

  • City/Town:

  • Email Address:

  • Phone number:

  • Name of the course: