Mastering Microsoft Power BI
Created by Pavan Lalwani, Last Updated 07-Feb-2020, Language:English
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
Preview00:04:56 -
File Resources
-
Power BI - Download and Install Power BI Desktop
00:01:54 -
Enable Preview Features
Preview00:02:45 -
Artificial Intelligence in Business Intelligence ( AI in BI)
Preview00:05:04 -
Get Data from Excel
00:06:20 -
Create Power BI Report in 5 mins
Preview00: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
Preview00:03:43 -
Create Animated Bar Chart Race
Preview00: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
Message from Pavan Lalwani...
Fascination is one word that describes my curiosity to understand the world around me I have already created positive change in individuals and institutions that I have engaged and partnered with.
My Mission is to help professionals to take control of their skills and present them in a way that inspires, impress and build confidence in their abilities, products and services. I enjoy contributing new ideas.
I love training people and build them technically enhanced & professionally Confident about the Products and Services. It doesn't even matter who you are and what you do !!
"Never let your memories be greater than your dreams"
Regards,
Pavan Lalwani
INDIA