POWER BI

5

POWER BI, Power BI Desktop, Power BI Service ,Power Apps and Power Automate.

Course 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 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

 


We will be happy to hear your thoughts

Leave a reply

Online Courses
Logo
Register New Account
Compare items
  • Total (0)
Compare
0