Certificate in POWER BI

Module 1: Introduction to Power BI

• 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

Module 2: Power Query for Data Transformation

• 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

Module 3: Power Pivot and Data Sources

• Using SQL Server data.

• Loading data from cubes.

• Load data from text files.

• Using data from Excel sheets. • Loading data via data feeds.

Module 4: Building PivotTables on Power Pivot

• 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.

Module 5: Introduction Power View

• From personal BI to corporate BI.

• Power View reports in Excel and SharePoint.

Module 6: Authoring Power View reports

• 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.

Module 7: Deploying Power View reports

• Saving Power View reports in document libraries.

• Power Pivot Gallery functionality.

• Printing the report.

• Export to PowerPoint functionality.

Module 8: Power Map

• Mapping geographical data.

• Exploring visualization options. • Working with multiple scenes.

Individual Classes. Arrange your convenient time. Professional Training, Course Conducted by Qualified Lecture.

Send Inquiry