POWER BI

January 17, 2024 305 0

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