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.
