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


Online Tutorials
Show full profile

Online Tutorials

Online Tutorials is a website sharing online courses, and online tutorials for free on a daily basis. You can find the best free online courses and thousands of free online courses with certificates to take your knowledge to the next level with the free courses.

We will be happy to hear your thoughts

Leave a reply

Online College Courses
Register New Account