- Power BI Desktop, Power BI Service ,Power Apps and Power Automate
- Free tutorial
- Rating: 3.7 out of 53.7 (12 ratings)
- 1,264 students
- 51min of on-demand video
- Created by Ram Reddy
- English
What you’ll learn
- Power BI Reporting
Requirements
- Basic SQL
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 ViewPower 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
Who this course is for:
- Any One want to work with Power BI
Show less
Course content
1 section • 6 lectures • 51m total length
Introduction6 lectures • 51min
- PBI01_Install Required Softwares and Downloading Data Files06:54
- PBI02_Understanding_Excel_DataSource_Sheets_and_Tables06:23
- PBI03_Import Required Tables and different windows of Power Query08:25
- PBI04_Power Query Transformations08:51
- PBI05_Power Query Data Types05:30
- PBI06_Publishing Report to Power BI Service15:01