POWER BI FIRST TO END OVERVIEW || Microsoft Power BI Training || Certification
Power BI Training & Certification
For more details reach me in whats app at 91 8374899166.
Refer Course Content
https://github.com/rritec/powerbi
Recordings
https://datahexa.com/course/power-bi/
For Updates Follow us on Facebook
/ rritec
For Updates Follow us on linkedin
/ rritec
For Updates Follow us on youtube
/ @rritec
Thanks & Regards ,
RR ITEC,
Emai: [email protected],
Phone no: 91 8374899166 ,
Website: www.datahexa.com.
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
Merge
Inner Join
Left Outer Join
Right Outer Join
Full Outer Join
Left Anti Join
Right Anti Join
Learn how to implement Cross join,Non equi join,self join.
Learn SQL Queries of Joins
Query Folding
Watch video POWER BI FIRST TO END OVERVIEW || Microsoft Power BI Training || Certification online without registration, duration hours minute second in high quality. This video was added by user RR ITEC 21 January 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 73 once and liked it people.