What is power query & Why it is used? , Data transformation & Benifites , Shape or transform data using power query , Overview of power query , query editer user interface , Ribben (Home , transform , Add column , View tabs) , Power query , filter (auto & basic) , Pivet / unpivet columns , Group rows / group by .
Module 2 : M Language
If , else condition , transform column types , Remove , split , replace value , Table distinct and group by option table , Group , table conv.pivot , Operation & table pivat () it using function.
Module 3 : Data Modeling
Introduction data moduling , Relationship & their needs , Relationship types , Delete a relationship.
Module 4 : Data Function
Data & time function , Text function , logical , math , satstical function , filter function.
Module 5 : Grouping & Binning Introduction
Grouping , creat group & text column , Number column and data column , Sorting data in visuals.
Module 6 : Power Bi Services
Cloud architechr and powerbi services introduction , Creating powerbi services account , sign in & powerbi services account , Data set and app worksspace tab , Data set , work book , report , dashboard , Working with data set & creating report in cloud using published data set.
Module 7 : Creating Dash Board
Advantage of dashboard , Interacting with dashboard , Formating dashboard , Sharing Dashboard.
