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 D
What you'll learn
Understanding of the Power Platform and its products
Familiarity with Power BI and its features
Basic knowledge of data warehousing concepts
Ability to connect Power BI to different data sources
Course objectives
Introduce Power BI and its significance in data analysis