Business Intelligence with Microsoft Power BI
Created by Pavan Lalwani, Last Updated 26-Nov-2020, Language:English
Business Intelligence with Microsoft Power BI
Don't wait for another day to comeback . Start NOW
Created by Pavan Lalwani, Last Updated 26-Nov-2020, Language:English
What Will I Get ?
- Design beautiful reports and dashboards for presentation
- Get Insights of data in fast and easy way
- Cleaning data using Power Query (ETL tool)
- Visualize data using Power View
- Work with Advanced cards and Slicers
- Create Advanced visuals in minutes
- Create Maps of different countries and regions
Requirements
- Microsoft Power BI Desktop tool
- No Prior knowledge of any tool required.
- Basics of Excel would be great but not mandatory
Description
We would do the same thing here by torturing the data but with a new Business Intelligence tool by Microsoft i.e Power BI .
This course is designed from scratch right from downloading and installing a software to publishing and sharing dashboards to all end users.
So here course is designed for any user having no coding knowledge or any prior knowledge of any tool.
90% of training would be by button clicks , so no coding .
By End of training, a person can learn Power BI and would be eligible to work in a company for cleaning data, creating reports and dashboards.
Here Power BI as a package is considered having various tools in it. This course would cover Power Query, Power View and Power BI Service.
So lets get ready !!!
Who this course is for:
- Anyone looking to learn Power BI from scratch
- Data analyst migrating from Excel
- Data Scientist moving from Tableau, Qlikview or any other BI Tool
- Anyone looking to pursue career in Data analysis and business Intelligence
- Excel user looking to automate manual daily routine process
- Excel user willing to learn VBA, as this can be best alternative for automation
Course Content
-
Introduction to Power BI
2 Lectures 00:10:50-
Power BI - Introduction
Preview00:06:36 -
Download, Install and Activate new features in Power BI
Preview00:04:14
-
-
Basic Charts in Power BI
9 Lectures 00:24:49-
2.0 Section Overview
Preview00:01:06 -
2.1 Creating a Column Chart in Power BI
Preview00:05:06 -
2.2 Creating a Stacked Column Chart in Power BI
Preview00:02:03 -
2.3 Create a Pie Chart in Power BI
Preview00:02:37 -
2.4 Create a DONUT CHART in Power BI
Preview00:01:19 -
2.5 Create a Funnel Chart in Power BI
00:01:06 -
2.6 Create a Ribbion Chart in Power BI
00:03:44 -
2.7 Include and Exclude in Power BI
00:03:45 -
2.8 Export data from Visual In Power B
00:04:03
-
-
Maps in Power BI
7 Lectures 00:20:28-
3.1 Creating a Map in Power BI
Preview00:03:19 -
3.2 filled map
00:02:22 -
3.3 Map with Pie Chart
00:03:39 -
3.4 Formatting in Map
00:04:27 -
3.5 Change background in Map
00:01:56 -
3.6 Create INDIA map in Power BI
00:02:33 -
3.7 Create AUSTRALIA map in Power BI
00:02:12
-
-
Tables and Matrix in Power BI
10 Lectures 00:32:56-
4.0 Tables And Matrix Overview
Preview00:01:22 -
4.1 Creating a Table
00:02:09 -
4.2 Formatting a Table
00:04:00 -
4.3 Conditional Formatting in Table
00:05:35 -
4.4 Aggregation in Table
00:02:50 -
4.5 Matrix in Power BI
Preview00:02:40 -
4.6 Conditional Formatting in Matrix
00:03:30 -
4.7 Hierarchies in Matrix
00:04:40 -
4.8 Sub-Total and Total in Matrix
00:02:45 -
4.9 Number Formatting in Table
00:03:25
-
-
Other Charts in Power BI
9 Lectures 00:34:55-
5.0 Introduction to Section
00:01:07 -
5.1 Line Chart in Power BI
00:03:54 -
5.2 Drill down Line Chart in Power BI
00:04:29 -
5.3 Area Chart in Power BI
00:02:31 -
5.4 Line Chart vs Column Chart in Power BI
00:04:26 -
5.5 Scatter Plot in Power BI
00:06:35 -
5.6 Waterfall Chart in Power BI
00:03:11 -
5.7 TreeMap in Power BI
00:03:06 -
5.8 Guage Chart in Power BI
00:05:36
-
-
6.0 Cards and Filters in Power BI
11 Lectures 00:44:32-
6.0 Introduction to Cards and Filters in Power BI
00:01:08 -
6.1 Number Card in Power BI
Preview00:04:33 -
6.2 Text Card in Power BI
00:07:02 -
6.2.1 Formatting a Text Card in Power BI
00:02:35 -
6.3 Date Card
00:05:05 -
6.3.1 Date Card (Relative Filtering)
00:03:44 -
6.4 Multi-Row Card
00:04:05 -
6.5 Filter on Visual
00:03:26 -
6.6 Filter on This Page
00:03:26 -
6.7 Filter on All Pages
00:03:47 -
6.8 Drillthrough in Power BI
00:05:41
-
-
SLICERS IN POWER BI
6 Lectures 00:19:54-
7.0 Slicers in Power BI
00:00:51 -
7.1 Text Slicers in Power BI
00:05:08 -
7.2 Formatting a Text Slicer
00:03:39 -
7.3 Date Slicers in Power BI
00:04:32 -
7.4 Formatting a Date Slicer
00:03:07 -
7.5 Number Slicers in Power BI
00:02:37
-
-
8.0 ADVANCED CHARTS IN POWER BI
10 Lectures 00:34:33-
8.0 Advanced Charts in Power BI
Preview00:02:41 -
8.1 Animated Bar Chart Race
00:05:19 -
8.3 Drill down Column chart
00:03:29 -
8.4 Word Cloud in Power BI
00:02:27 -
8.5 Sankey Chart in Power BI
00:03:37 -
8.6 Infographic in Power BI
00:04:10 -
8.7 Play Axis in Power BI
00:02:47 -
8.8 Scroller in Power BI
00:04:33 -
8.9 Sunburst Chart in Power BI
00:02:30 -
8.10 Histogram in Power BI
00:03:00
-
-
Power BI Objects, Bookmarks and Actions
8 Lectures 00:26:12-
9.1 Insert Image in Power BI
00:03:22 -
9.2 Insert Text in Power BI
00:02:04 -
9.3 Insert Shape in Power BI
00:02:36 -
9.4 Insert Buttons in Power BI
00:02:34 -
9.5 Web URL Action in Power BI
00:03:14 -
9.6 Page Navigation Action in Power BI
00:02:52 -
9.7 Bookmark Action in Power BI
00:04:29 -
9.8 Drill through action in Power BI
00:05:01
-
-
Power BI Service
8 Lectures 00:52:42-
10.1 Create a Report in Power BI
00:14:58 -
10.2 Create an account in Power BI Service
00:03:40 -
10.3 Publish Report to Power BI Service
00:02:50 -
10.4 Export Report to PPT, PDF, PBIX
00:03:21 -
10.5 Comment, Share and Subscribe to Power BI reports
00:06:56 -
10.6 Create a Dashboard in Power BI Service
00:06:09 -
10.7 Problems in Power BI Dashboard and its Solution
00:04:32 -
10.8 Automatically refresh reports in Power BI Service
00:10:16
-
-
Text Functions in Power Query
7 Lectures 00:30:09-
11.0 Text Functions in Power Query
00:01:28 -
11.1 Merge Columns in Power Query
00:09:22 -
11.2 Split and Trim
00:04:42 -
11.3 UPPERCASE, lowercase and ProperCase
00:03:36 -
11.4 Add Prefix and Suffix
00:02:51 -
11.5 Left, Right and Mid Functions in Power Query
00:05:09 -
11.6 Extract Text with Delimiters
00:03:01
-
-
Date Functions in Power Query
8 Lectures 00:21:17-
12.0 Date Functions in Power Query
Preview00:02:02 -
12.1 Year, Quarter, Month and Day Functions in Power Query
00:04:42 -
12.2 Find Difference between Dates in Power Query
00:02:29 -
12.3 Month and Day Name in Power Query (Power BI)
00:01:39 -
12.4 Day, Week of Month, Year in Power Query
00:01:46 -
12.5 Extract Date, Time in Power Query
00:01:36 -
12.6 Calculate Age in Power Query (Power BI)
00:02:48 -
12.7 Day of Year, Quarter, Month in Power Query
00:04:15
-
-
Number Functions
4 Lectures 00:14:12-
13.0 Number Functions
00:01:00 -
13.1 Basic Number Functions in Power Query
00:05:40 -
13.2 Percentage, Percent Of Module in Power Query
00:04:54 -
13.3 Round Functions in Power Query
00:02:38
-
-
Append Data in Power BI
6 Lectures 00:31:16-
14.0 Append Data in Power BI
00:01:34 -
14.1 Append multiple CSV files in a folder in Power Query
00:06:51 -
14.2 Append multiple excel sheets, Tables in Power Query
00:04:07 -
14.3 Append Excel sheets or Tables with different columns in Power BI
00:05:49 -
14.4 Append multiple Excel files from a folder in Power BI
00:09:13 -
14.5 Append different data sources in Power BI
00:03:42
-
-
Merge Files and Tables in Power BI
5 Lectures 00:17:06-
15.0 Merge Files and Tables in Power BI
00:01:17 -
15.1 Merge Sheets or Tables in Power Query
00:05:15 -
15.2 Merge Data from multiple Excel files or Workbooks in Power BI
00:03:49 -
15.3 Merge data from different data sources in Power Query
00:03:10 -
15.4 Merge data having multiple criteria in Power BI
00:03:35
-
-
Conditional Column and Column from example in Power BI
9 Lectures 00:29:50-
16.0 Conditional Column and Column from example in Power BI
Preview00:01:03 -
16.1 Column from examples in Power BI - Split Text
00:05:53 -
16.2 Column from examples in Power BI - Merge Columns
00:03:54 -
16.3 Column from Examples in Power BI - Date
00:03:48 -
16.4 Column from Examples in Power BI - Alphanumeric
00:02:54 -
16.5 Conditional Column in Power BI - One Column
00:03:53 -
16.6 Conditional Column in Power BI - two columns
00:03:14 -
16.7 Conditional Column in Power BI - Compare two columns
00:03:01 -
16.8 Conditional Column in Power BI - on Dates
00:02:10
-
-
Very Important Topics in Power Query (Power BI)
9 Lectures 00:35:27-
17.0 Very Important Topics in Power Query (Power BI)
Preview00:01:15 -
17.1 Fill Down in Power BI
00:02:15 -
17.2 Grouping in Power Query
00:04:34 -
17.3 Transpose in Power Query
00:03:09 -
17.4 Unpivot In Power Query
00:02:52 -
17.5 Data Types in Power Query
00:05:56 -
17.6 Replace Errors and Values in Power Query (Power BI)
00:06:44 -
17.7 Keep and Remove Rows in Power Query
00:04:55 -
17.8 Add, Remove and Goto Columns in Power Query
00:03:47
-
-
M Functions in Power BI
8 Lectures 00:39:17-
18.0 - Introduction to M Language
Preview00:06:28 -
18.1 Add and Subtract Date M Functions in Power BI
00:03:10 -
18.1.1 Basic Date M Functions in Power BI
00:02:55 -
18.2 Basic Text M Functions in Power BI
00:05:30 -
18.3 - IsIn Date Functions in M Language - Power BI
00:09:42 -
18.4 M Language in Power Query
00:02:06 -
18.5 Simple M Code in Power BI
00:04:34 -
18.6 Trick to get all 900 M Functions in Power BI
00:04:52
-
Pavan Lalwani
Corporate trainer
Pavan Lalwani is a Freelancer Technical trainer in this industry from last 10 Years.
Having a worked with diverse domains in industry like Healthcare, Banking, Finance, HR, Marketing, IT, Mechanical and many more; he is well versed with the pattern of work and type of problems faced in those domains.
He is knowledgeable of 22 Softwares belonging to Microsoft, HP, IBM and Tableau.
His USP is SIMPLE , EASY, INTERESTING AND EFFECTIVENESS.
Lastly he likes Tea :)
