Program Curriculum

Module 1 

INTRODUCTION TO POWER BI 

  • Introduction to Business Intelligence (BI) 
  • Stages of business intelligence (BI) 
  • Use cases of BI 
  • Various BI tools 
  • Overview of Data warehouse & concepts 
  • Introduction to Power BI 
  • Why Power BI 
  • Power BI Components 
  • Power BI pricing structure 
  • Building blocks of Power BI 
  • Architecture of Power BI 
  • Power BI vs Tableau vs QlikView 
  • Introduction of Power BI Desktop 
  • Installation of Power BI Desktop 
  • The key features of Power BI workflow 
  • Process of creating reports in Power BI  

Module 2 

DATA EXTRACTION 

  • Overview of Power BI desktop 
  • Data sources in Power BI 
  • Using files (excel, pdf, csv, etc.) as a data source 
  • Using SaaS connectors 
  • Extracting data from folders, and databases 
  • Working with Azure SQL database and database sources 
  • Connecting to Analysis Services 
  • Other data sources (OData, web, SharePoint etc.) 
  • Python & R script in Power BI 
  • Introduction of power query editor 
  • Advance editor 
  • Query dependency editor

Module 3 

DATA TRANSFORMATION – SHAPING & COMBINING DATA 

  • Shaping data using Power Query Editor 
  • Formatting data 
  • Transformation of data 
  • Understanding of Data types 
  • Data profiling for data quality check 
  • Naming conventions & best practices to consider Identify and create appropriate keys for joins 
  • Working with Parameters Merge Query
  • Append Query 
  • Group by of data (aggregation of data) 
  • Applied steps (query settings) 
  • Duplicate & Reference tables 
  • Transpose of data 
  • Fill 
  • Pivot & Un-pivot of data 
  • Custom columns 
  • Conditional columns 
  • Replace data from the tables 
  • Split columns values 
  • Move columns & sorting of data 
  • Detect data type, count rows & reverse rows
  •  Promote rows as column headers 
  • Hierarchies in Power BI 
  • M query