Power BI

In-Person/Online

2 Days

English/Arabic

Learning Objectives

Identify what is power BI.
Open power BI desktop.
Explore how to work with CSV, TXT, and excel worksheets.
Apply connecting to databases.
Use merging, grouping, summarizing, and calculating data.

In-Person/Online

2 Days

English/Arabic

Learning Objectives

Identify what is power BI.
Open power BI desktop.
Explore how to work with CSV, TXT, and excel worksheets.
Apply connecting to databases.
Use merging, grouping, summarizing, and calculating data.

Modules

Module 1: Power BI

What is Power BI?
Examining power BI suite of products
Identifying differences between products

Module 2: Power BI Desktop

Installing power BI desktop
Exploring the power BI desktop interface
Utilizing file types; PBIX vs PBIT
Examining data sources
Discussing data refresh
Understanding data types

Module 3: Working With CSV, TXT and Excel Worksheets

Importing, transforming, and loading data
Appending operations
Working with folders and files
Using pivot tables

Module 4: Connecting to Databases

Working with relational data
Understanding relationships
Importing from SQL server analysis services multidimensional and tabular

Module 5: Merging, Grouping, Summarizing, and Calculating Data

Understanding the issues with merges
Performing merges
Grouping options
Summarizing & calculating

Module 6: Reporting

Creating reports
Utilizing the matrix visualization
Utilizing the map visualization
Utilizing the card visualization
Utilizing the chart visualization
Utilizing slicers

Power BI

Learning Objectives

Learning Objectives

Modules

Module 1: Power BI

Module 2: Power BI Desktop

Module 3: Working With CSV, TXT and Excel Worksheets

Module 4: Connecting to Databases

Module 5: Merging, Grouping, Summarizing, and Calculating Data

Module 6: Reporting

Our Partners

Quick links

Quick links

Quick links

Welcome to our beta version!