POWER BI COURSE CONTENT
Why Power BI Training?
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 is the newest Microsoft BI tool for data mash up, build modelling, and visualize it effectively. It supports mobile devices, it support self-service, and along with its great functionalities, it doesn’t require heavy development or production system.
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.
View this Course
Certified
You have 
