POWER BI

Name: POWER BI
Rating: 3.9 (30 reviews)

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

Created byRam Reddy

Last updated 2/2024

English

English [Auto],

What you'll learn

Power BI Reporting

Course content

2 sections • 13 lectures • 5h 50m total length

PBI01_Install Required Softwares and Downloading Data Files6:54
Install the Power BI desktop, Microsoft SQL Server, and SSMS, restore the AdventureWorks database, and shape data using Excel with Power Query, Power Pivot, and Power View for wrangling.
PBI02_Understanding_Excel_DataSource_Sheets_and_Tables6:23
Learn to build a dataset from an Excel data source with multiple tables across sheets, enabling multiple reports from one dataset, and understand many-to-one and one-to-many relationships.
PBI03_Import Required Tables and different windows of Power Query8:25
Learn to import data from an Excel workbook into Power BI Desktop, use Power Query Editor, and distinguish sheets versus tables while loading or transforming data in a multi-window environment.
PBI04_Power Query Transformations8:51
Learn how Power Query transformations replace nulls with zero in commission, rename the employee name, and create total salary as salary plus commission in Power BI desktop.
PBI05_Power Query Data Types5:30
Power BI emphasizes keeping proper data types for each column; converting total salary from text to whole number enables correct sum aggregation in reports.
PBI06_Publishing Report to Power BI Service15:01
Learn to filter data in Power Query, save PBIX files, and publish reports to the Power BI service; create workspaces, manage datasets and reports, and understand data source relationships.

POWER BI DEMO58:38
Power BI demo demonstrates connecting SQL Server data, using Power Query to transform two tables into a top ten customers by sales report, and building dashboards in Power BI Desktop.
Power BI installation45:35
Learn to install Power BI Desktop, Microsoft SQL Server, and SQL Server Management Studio, and restore AdventureWorks sample data for practice.
Create Report Using Excel Database58:58
Master Power Query Editor to extract, transform, and load Excel data into a Power BI Desktop semantic model, then build reports and publish to the Power BI service.
PBI_01_02_Power Query Editor Shape data using Excel as source1:00:39
Shape data with Power Query Editor using Excel as data layer, merge customer and sales data, build a Power Pivot model with DAX, publish top ten customers to app.powerbi.com.
PBI_01_03_Power Query Editor Shape data using MySql as input40:31
Shape data with Power Query Editor from MySQL and Excel, build a semantic model, and create reports in Power BI Desktop. Learn data types, null handling, and total salary calculations.
PBI_01_04_optional22:20
Learn how Power BI Desktop integrates Power Query, Power Pivot, and Power View to connect multiple data sources to a semantic model and drive many reports.
PBI_01_04_Power Query Editor Shape data using SQL Server as input13:13
connect to a sql server, import a database and tables, shape data in the power query editor, apply filters, and publish the report to the workspace in power bi.

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

Who this course is for:

Any One want to work with Power BI

POWER BI

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 51min

POWER BI OVERVIEW7 lectures • 5hr

Requirements

Description

Who this course is for: