Power BI is a business intelligence platform introduced by Microsoft in 2011. The self-service tool is used by non-technical business owners for aggregating, analyzing, visualizing, and sharing data. Since the tool has been gaining popularity over the years, it has become a need to understand the subject thoroughly and implement the same. This 4-day Power BI course acts as a guide for those who want to learn and grow.

Course Outline:

• Introduction:
  • Overview of Microsoft Excel’s PowerPivot
  • Importing data from various sources I.E. Excel, text, SQL server, etc.
  • Creating star schema and data models using relationships
  • Understanding evaluation context, row context
  • Creating calculated columns, comparing with measures
  • Creating auto calendars, comparing period over period growth
  • Ranking over a measure, building KPIs
  • Creating hierarchies, grouping data, dynamic drill-downs
  • Building flexible reports using cube formulas in power pivot
  • Creating on-the-fly formulas using variables
  • Creating disconnected tables, slicers, and virtual relationships
• Data Management:
  • Overview of Microsoft Excel’s PowerPivot
  • Using DAX studio for querying and creating custom tables
  • Creating dimension tables from fact tables using power query
  • Visualizing data using power view, power maps, Power BI
  • Creating dashboards using custom visuals in Power BI
  • Cleaning, transforming, and reshaping data using power query
  • Combining multiple sources of data and consolidating using power query
  • Un-pivoting with multiple merged column headers
  • Creating dimension tables using fact tables
• Working with Time Intelligence Functions:
  • Dynamic top product analysis
  • Least performance areas
  • Customer analysis
  • ABC analysis
  • Time patterns I.E. Period over period growth
  • Drill-downs at parent-child levels
  • Dynamic segmentation
  • Bulk sales
  • Moving averages