Mastering Microsoft Power BI

Simply Easy Learning

Created by Pavan Lalwani, Last Updated 07-Feb-2020, Language:English

What Will I Get ?

The course is designed especially for beginners, and explains topics from scratch.
It provides holistic end to end guidance on Power BI usage.
It teaches you about ETL (Power Query), Data Modelling (Power Pivot ), Visualization ( Power View ), M Language and DAX Functions.

Requirements

Very Basic Excel knowledge requirement.

Description

Power BI is a business analytics tool from Microsoft. It lets you visualize your data and share insights across your organization, or embed them in your app or website. Its interface is simple enough for end users to create their own reports and dashboards. It is ranked number one in Business Intelligence Tools.

Power BI provides cloud-based BI services, known as "Power BI Services", along with a desktop based interface, called "Power BI Desktop". It offers data warehouse capabilities including data preparation, data discovery and interactive dashboards

How simple is this course?

90% of concepts are explained in button clicks, which means no coding knowledge is required. Making it EASIER THAN EXCEL

Course Content

Introduction To Power BI

7 Lectures 00:27:31
- Introduction to Power BI
  
  Preview
  
  00:04:56
- File Resources
- Power BI - Download and Install Power BI Desktop
  
  00:01:54
- Enable Preview Features
  
  Preview
  
  00:02:45
- Artificial Intelligence in Business Intelligence ( AI in BI)
  
  Preview
  
  00:05:04
- Get Data from Excel
  
  00:06:20
- Create Power BI Report in 5 mins
  
  Preview
  
  00:06:32
Simple Charts in Power BI

5 Lectures 00:24:13
- Create Stacked Bar Chart
  
  00:08:39
- Create Pie Chart
  
  00:03:52
- Create Scroller
  
  Preview
  
  00:03:43
- Create Animated Bar Chart Race
  
  Preview
  
  00:04:15
- Create Decomposition Tree
  
  00:03:44
Introduction to Power Query - ETL Tool

8 Lectures 00:44:03
- Power Query Introduction
  
  00:02:29
- Text Function Part 1
  
  00:11:12
- Text Function Part 2
  
  00:03:56
- Text Function Part 3
  
  00:07:28
- Date Function Part 1
  
  00:04:26
- Date Function Part 2
  
  00:04:29
- Number Function
  
  00:05:38
- Artificial Intelligence In Business Intelligence (AI in BI) - ETL Tool
  
  00:04:25
Append Queries in Power Query

4 Lectures 00:21:23
- Append Excel Tables
  
  00:04:52
- Append CSV Files
  
  00:04:44
- Append Files from different data sources
  
  00:03:23
- Append Excel Files from Folder
  
  00:08:24
Merge Queries in Power Query

2 Lectures 00:11:23
- Merge Table from Excel
  
  00:06:52
- Merge Queries from Different data sources
  
  00:04:31
Get Data in Power BI

4 Lectures 00:15:09
- Get Data from PDF
  
  00:05:09
- Get Data from MS Access
  
  00:03:23
- Get Data from SQL
  
  00:02:37
- Get Live data from Website
  
  00:04:00
Conditional Column in Power Query

5 Lectures 00:16:49
- Conditional Column Example 1
  
  00:03:24
- Conditional Column Example 2
  
  00:03:16
- Conditional Column Example 3
  
  00:03:44
- Column from Examples 1
  
  00:03:35
- Column from Examples 2
  
  00:02:50
Miscellaneaous Topics in Power Query

6 Lectures 00:23:10
- Unpivot In Power Query
  
  00:03:18
- Pivot In Power Query
  
  00:04:26
- Fill Down
  
  00:02:16
- Data Type
  
  00:04:41
- Error Fixing
  
  00:05:02
- Group By
  
  00:03:27
M Language in Power Query

5 Lectures 00:21:36
- M Function Date 1
  
  00:04:47
- M Function Date 2
  
  00:04:07
- M Function Date 3
  
  00:04:41
- Basics of M Language
  
  00:02:54
- Decoding M Language
  
  00:05:07
Introduction to Power Pivot

2 Lectures 00:03:06
- Power Pivot Introduction
  
  00:01:42
- Power Query vs Power Pivot
  
  00:01:24
Connect different data in Power Pivot

3 Lectures 00:13:43
- Connect to different Data Sources
  
  00:05:58
- Connect tables with difference Column Names
  
  00:03:04
- No VLOOKUP, No Merge Queries
  
  00:04:41
Introduction to DAX Functions in Power Pivot

6 Lectures 00:27:21
- DAX - Date Function - Part 1
  
  00:06:35
- DAX - Date Function - Part 2
  
  00:05:48
- DAX - Date Function - Part 3
  
  00:05:54
- DAX - Text Function - Part 1
  
  00:03:24
- DAX - Text Function - Part 2
  
  00:02:24
- DAX - Number Function Part 1
  
  00:03:16
Handle Large Data in Power Pivot

2 Lectures 00:08:08
- Append 5 Million Records
  
  00:02:56
- Measures Vs Columns in Power BI
  
  00:05:12
Time Intelligence Functions in DAX (Power Pivot)

7 Lectures 00:25:19
- DAX - CALCULATE Single Criteria
  
  00:04:46
- DAX - CALCULATE Multiple Criteria
  
  00:03:40
- DAX - Time Intelligence Function Part 1
  
  00:04:22
- DAX - Time Intelligence Function Part 2
  
  00:03:26
- DAX - Time Intelligence Function Part 3
  
  00:02:02
- DAX - Time Intelligence Function Part 4
  
  00:03:48
- DAX - Time Intelligence Function Part 5
  
  00:03:15
Table Functions in DAX (Power Pivot)

4 Lectures 00:10:25
- DAX - FILTER
  
  00:02:49
- DAX - DISTINCT
  
  00:02:55
- DAX - ALL Function
  
  00:01:57
- DAX - CALENDARAUTO
  
  00:02:44
Introduction to Power View

7 Lectures 00:30:21
- Table Format
  
  00:04:35
- Sort, Keep Only, Exclude
  
  00:03:43
- Aggregation
  
  00:03:54
- Conditional Formatting
  
  00:05:56
- Matrix
  
  00:05:06
- Matrix rows and columns hirearchy
  
  00:05:20
- Create Hirearchy
  
  00:01:47
Basic Charts in Power BI

10 Lectures 00:27:17
- Line Chart in Power BI
  
  00:03:02
- Map with Pie Chart in Power BI
  
  00:02:26
- Filled Map in Power BI
  
  00:01:07
- Line Chart Formatting
  
  00:03:36
- TreeMap
  
  00:02:06
- Funnel
  
  00:02:13
- Line Chart Forecast
  
  00:02:29
- Ribbon
  
  00:02:18
- Waterfall Chart
  
  00:03:37
- Map
  
  00:04:23
Card and KPI in Power BI

5 Lectures 00:18:48
- Card (Number)
  
  00:03:12
- Card (Text)
  
  00:04:59
- Card (Date)
  
  00:02:55
- Multi Row Card
  
  00:03:52
- KPI In Power BI
  
  00:03:50
Slicers and Filters in Power BI

8 Lectures 00:23:16
- Slicer (Text)
  
  00:03:12
- Slicer (Date)
  
  00:04:00
- Hirearchy Date Slicer
  
  00:03:44
- Slicer (Number)
  
  00:01:47
- Timeline Slicer
  
  00:02:12
- Filter on Visual
  
  00:02:51
- Filter on All Pages
  
  00:01:51
- Drill through
  
  00:03:39
Fancy Charts in Power BI

9 Lectures 00:26:03
- Word Cloud
  
  00:02:13
- Sankey Chart
  
  00:02:19
- Infographic
  
  00:02:44
- Play Axis
  
  00:02:24
- Walkers Animated Pictogram
  
  00:01:34
- Scatter Plot
  
  00:05:29
- Sunbrust
  
  00:02:44
- Drill Down Count
  
  00:02:20
- Guage Chart
  
  00:04:16
Builing blocks for Dashboard in Power BI Service

3 Lectures 00:07:36
- Insert Image
  
  00:01:51
- Insert Shape
  
  00:01:24
- Bookmarks
  
  00:04:21
Introduction to Power BI Service

6 Lectures 00:13:32
- Publish to Power BI Service
  
  00:03:58
- Export to PPT and PDF
  
  00:02:57
- Edit Report In Power BI Service
  
  00:01:18
- Comments in Power BI Service
  
  00:01:40
- Subscribe reports in Power BI Service
  
  00:01:57
- Share Reports from Power BI Service
  
  00:01:42
Dashboards in Power BI Service

4 Lectures 00:10:58
- Create Reports in Power BI Service
  
  00:04:38
- Dashboard Limitations
  
  00:02:45
- Add Video in Power BI Service
  
  00:01:49
- Create Alerts in Power BI Service
  
  00:01:46

Pavan Lalwani

Pavan Lalwani hold a B.E. in Computer Science from M.I.T College, Pune. Pavan is a Corporate Trainer with 6 Years of Training Experience on various technologies. He specializes in MS Office Tools, IBM Rational Tools, HP Testing Tools, and Software Testing.