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 resources

  • 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.
Sgraph Infotech
MSBI | DOT NET | AWS | Data Science | Python
Address :
3rd Floor, JP Royale- 90/4, Above ICICI Bank, Outer Ring Road, Opposite Radisson Blu, Marathahalli,
Karnataka - 560037
Tel : 9620885025
Email : sgraphinfotech@gmail.com


Best Android Training in Marathahalli Bangalore

Best .Net Training in Bangalore

Best Oracle SQL Training Institutes in Bangalore

Best PLSQL Training Centers in Bangalore

Best Big Data and Hadoop Training Courses in Bangalore

Best MSBI Training Institutes in Bangalore

Best Microsoft Power BI Training Bangalore

Best Oracle DBA Training at Bangalore


© 2016 | All rights reserved |Developed By Nexevo Technologies | Sitemap