POWER BI

About this course

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

Course objectives

• Introduce Power BI and its significance in data analysis
• Compare Power BI with other BI tools
• Explore the key components of Power BI Desktop