Course Overview


Power BI is one of the newest additions to Office 365. In this course you will learn Power BI from beginner to advance. Power BI Course enables you to perform Simple Data Analysis as well as Complex Business intelligence scenarios and advanced dash boarding. This power BI course will cover five major components of power BI: Power Pivot and Power Query. The other two are for data visualization: Power View and Power Map.

Power BI Architecture
Power BI introduction and overview
Introduction Power BI desktop and Power BI in Excel
Connecting with Data
Introduction to Power BI Components: Power Query, Power Pivot, Power View &Power Map

Installation, Requirements, and Configuration
Different versions of Power Query
Power Query Introduction
Query Editor
Transformation GUI
Row Transformations
Column Transformations
Data Type
Adding Column
Text Transformations
Number Column Calculations
Date and Time Calculations
Data types, Lists, Records, and tables in M
M built-in functions

Using SQL Server data.
Loading data from cubes.
Load data from text files.
Using data from Excel sheets.
Loading data via data feeds.

Building pivot tables on top of Power Pivot.
Using Pivot Charts.
Working with Slicers.
Building custom sets.
Combine Power Pivot data with Sparklines.
Deploying PivotTables to Excel Services.

From personal BI to corporate BI.
Power View reports in Excel and SharePoint.

Create tables and Matrices.
From table to chart.
Interactive sorting, filtering and highlighting.
Working with bubble charts.
Slicers, cards and multiples.
Adding maps to Power View.
Working with multi-view reports.
Improving Power Pivot models for Power View reporting.

Saving Power View reports in document libraries.
Power Pivot Gallery functionality.
Printing the report.
Export to PowerPoint functionality

Mapping geographical data.
Exploring visualization options.
Working with multiple scenes.