POWER BI, Power BI Desktop, Power BI Service ,Power Apps and Power Automate.
Course Description
- Introduction
- What is Power Platform?
- What are the products of Power Platform?
- Power BI
- Power Apps
- Power Automate
- Power Virtual Agents
- What 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 Concepts
- What is OLTP?
- What is Data warehouse
- Difference between OLTP Vs OLAP
- Difference among Primery Key/Foriegn Key/Surrogate Key
- Types of Tables
- Dimension Tables
- Fact Tables
- Types of Schemas
- Star Schema
- Snow Flake Schema
- Mixed Schema
- Power BI Desktop
- Introduction to Power BI Desktop
- Power BI Desktop Components
- Power Query Editor
- Power Pivot
- Power View
Power BI Desktop – Power Query Editor
- Connecting to new Source
- File 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 Connections
- Import
- Direct
- Live Connection
- Importing Tables –
- Basic Transformations
- Changing datatypes
- replacing nulls with zero
- concatnating columns
- Computing new columns from available columns
- spliting columns
- renameing columns
- observing transformation steps
- understanding M-Language
- Computed columns/calculations
- M-Language
- About Let and In
- Single Line comments in M-language
- Multi line comments in M-language
- How to write M-language code in multiple lines
- Change Steps in Query settings and observe in M-language
- Change M-language and observe Query Setting Steps
- Build Query using M-Language Script from Blank Query
- Combine Queries
- Append
- Learn SQL Queries of union ,Union all,Minus
- Prove Power BI Append is equal to Union all
- Append
- Connecting to new Source
