IntroductionWhat is Power Platform?What are the products of Power Platform?Power BIPower AppsPower AutomatePower Virtual AgentsWhat are the different BI tools available?Why Power BI? Why not other BI tools like (Tableau/OBIEE/Cognos/SAP-BO/.etc)What are the Products of Power BI (Power BI Desktop/ Power BI Pro / Power BI Premium / Power BI Mobile / Power BI Embedded / Power BI Report Server)What is Power BI Desktop?What is Power Query ?What is Power Pivot ?What is Power View ?What is Power Maps ?What is Power BI Service?What is Power BI Mobile?What is M-Language?What is DAX?Data Warehousing ConceptsWhat is OLTP?What is Data warehouseDifference between OLTP Vs OLAPDifference among Primery Key/Foriegn Key/Surrogate KeyTypes of TablesDimension TablesFact TablesTypes of SchemasStar SchemaSnow Flake SchemaMixed SchemaPower BI DesktopIntroduction to Power BI DesktopPower BI Desktop ComponentsPower Query EditorPower PivotPower ViewPower BI Desktop - Power Query EditorConnecting to new SourceFile Connections (Excel,CSV,XML,JSON,Folder.etc)Connecting to Databases (MySql,MSSqlServer,Access dtatabase,...etc)Cloud Connections(SnowFlake Database, Azure SQL Database.etc)Online Connections(Web,Github,Linkedin.etc)Types of ConnectionsImportDirectLive ConnectionImporting Tables -Basic TransformationsChanging datatypesreplacing nulls with zeroconcatnating columnsComputing new columns from available columnsspliting columnsrenameing columnsobserving transformation stepsunderstanding M-LanguageComputed columns/calculationsM-LanguageAbout Let and InSingle Line comments in M-languageMulti line comments in M-languageHow to write M-language code in multiple linesChange Steps in Query settings and observe in M-languageChange M-language and observe Query Setting StepsBuild Query using M-Language Script from Blank QueryCombine QueriesAppendLearn SQL Queries of union ,Union all,MinusProve Power BI Append is equal to Union all