POWER BI

• 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

1. 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?
2. 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
3. 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

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

👇👇👇👇 Click Below to Enroll in Free Udemy Course 👇👇👇👇

👇👇 See Also 👇👇