Preview Power BI

Section 1 : Introduction to Power BI

1.1 What is Power BI

1.2 Download, Install and upgrade new features in Power BI

New User Interface of Power BI

Quiz

Introduction to Power BI

Assignment

Section 01

Section 2 : Basic Visuals in Power BI

2.0 Basic Charts in Power BI Desktop

2.1 Column Chart in Power BI

2.2 Stacked Column Chart in Power BI

2.3 Pie Chart in Power BI

2.4 Donat Chart

2.5 Funnel Chart

2.6 Ribbon Chart

2.7 Include and Exclude

2.8 Export data from Visual

Quiz

Basic Visuals in Power BI

Assignment

Section 02

Section 3 : Maps

3.1 Creating a Map in Power BI

3.2 filled map

3.3 Map With Pie Chart

3.4 Formatting in Map

3.5 Change Background in Map

3.6 Map of India in Power BI

3.7 Map of Australia in Power BI

Quiz

Maps

Assignment

Section 03

Section 4 : Table and Matrix

4.0 TABLE AND MATRIX

4.1 creating a table in power bi

4.2 FORMATTING IN TABLE

4.3 Conditional Formatting in Table

4.4 AGGREGATION IN TABLE

4.5 Matrix in Power BI

4.6 Conditional Formatting in Matrix

4.7 Hierarchies in Matrix

4.8 Sub-Total and Total in Matrix

4.9 Number Formatting in Table

Quiz

TABLE AND MATRIX

Assignment

Section 04

Section 5 : Other Charts

5.0 Other Charts in Power BI

5.1 Line Chart in Power BI

5.2 Drill Down in Line Chart

5.3 Area Chart in Power BI (1)

5.4 Line vs Column Chart in Power BI

5.5 Scatter Plot in Power BI

5.6 Waterfall Chart in Power BI

5.7 TreeMap in Power BI

5.8 Guage Chart in Power BI

Quiz

Other Charts in Power BI

Assignment

Section 05

When to use which chart

Section 6 : Cards & Filters

6.0 Cards and Filters in Power BI

6.1 Number Card in Power BI

6.2 How to create a Card for Text in Power BI 2020

6.2.1 Formatting of Text Card

6.3 Date Card

6.3.1 Date Card (Relative Filtering)

6.4 Multi-Row Card

6.5 Filter on Visual

6.6 Filter on This Page

6.7 Filter on All Pages

6.8 Drillthrough in Power BI

Quiz

Cards & Filters

Assignment

Section 06

Section 7 : Slicers

7.0 Slicers in Power BI

7.1 Text Slicers in Power BI

7.2 Formatting a Text Slicer

7.3 Date Slicers in Power BI

7.4 Formatting a Date Slicer

7.5 Number Slicers in Power BI

Quiz

Slicers

Assignment

Section 07

Section 8 : Advanced Charts

8.0 Advanced Charts in Power BI

8.1 Animated Bar Chart Race

8.3 Drill down Column chart

8.4 Word Cloud in Power BI (1)

8.4 Word Cloud in Power BI

8.5 Sankey Chart in Power BI

8.6 Infographic in Power BI

8.7 Play Axis in Power BI

8.8 Scroller in Power BI

8.9 Sunburst Chart in Power BI

8.10 Histogram in Power BI

Quiz

Advanced Charts

Assignment

Section 08

Section 9 : Objects & Actions

9.1 Insert Image in Power BI

9.2 Insert Text in Power BI

9.3 Insert Shapes in Power BI

9.4 Insert Buttons in Power BI

9.5 Web URL Action in Power BI

9.6 Page Navigation Action in Power BI

9.7 Bookmark Action in Power BI

9.8 Drillthrough Action in Power BI

Quiz

Objects & Actions

Assignment

Section 09

Section 10 : Power BI Services

10.1 Create a Superstore Report in Power BI

10.2 Create an Account on Power BI Service

10.3 Publish Report to Power BI Service Account

10.4 Export Power BI Report to PPT, PDF or PBIX (1)

10.5 Comment, Share and Subscribe to Power BI Report

10.6 Create a Dashboard in Power BI Service

10.7 Problem in Power BI Dashboard and its solution

10.8 Automatic Refresh in Power BI using Gateway

Quiz

Power BI Services

Assignment

Section 10

Section 11 : Text Functions

11.0 Text Functions in Power Query (Power BI)

11.1 Merge Columns in Power Query (Power BI)

11.2 Split and Trim in Power Query (Power BI)

11.3 Upper,Lower and ProperCase in Power Query (Power BI)

11.4 Prefix and Suffix in Power Query (Power BI)

11.5 Left,Right and Mid Functions in Power Query (Power BI)

11.6 Extract Text with Delimiters

Quiz

Text Functions

Assignment

Section 11

Section 12 : Date Fuinctions

12.0 Date Functions in Power Query

12.1 Year,Quarter,Month and Day Functions in Power Query

12.2 Find Difference between Dates in Power Query

12.3 Month and Day Name in Power Query (Power BI)

12.4 Day,Week of Month,Year in Power Query

12.5 Extract Date, Time in Power Query

12.6 Calculate Age in Power Query (Power BI)

12.7 Day of Year,Quarter,Month in Power Query

Quiz

Date Functions

Assignment

Section 12

Section 13 : Number Functions

13.0 Number Functions

13.1 Basic Number Functions in Power Query

13.2 Percentage,Percent Of, Module in Power Query

13.3 Round Functions in Power Query

13.4 IsEven, IsODD, Sign Power BI Power Query

Quiz

Number Functions

Assignment

Section 13

Section 14 : Appending

14.0 Append Data in PowerBI

14.1 Append multiple CSV files in a folder in Power Query

14.2 Append multiple excel sheets,Tables in Power Query

14.3 Append Excel sheets or Tables with different columns in Power BI

14.4 Append multiple Excel files from a folder in Power BI

14.5 Append different data sources in Power BI

Quiz

Appending

Assignment

Section 14

Section 15 : Merge Query

15.0 Merge Files and Tables in Power BI

15.1 Merge Sheets or Tables in Power Query

15.2 Merge Data from multiple Excel files or Workbooks in Power BI

15.3 Merge data from different data sources in Power Query

15.4 Merge data having multiple criteria in Power BI

Quiz

Merge Query

Assignment

Section 15

Section 16 : Conditional Column & Column From Function

16.0 Conditional Column and Column from example in Power BI

16.1 Column from examples in Power BI - Split Text

16.2 Column from examples in Power BI - Merge Columns

16.3 Column from Examples in Power BI - Date

16.4 Column from Examples in Power BI - Alphanumeric

16.5 Conditional Column in Power BI - One Column

16.6 Conditional Column in Power BI - two columns

16.7 Conditional Column in Power BI - Compare two columns

16.8 Conditional Column in Power BI - on Dates

Quiz

Conditional Column and column from Function

Assignment

Section 16

Section 17 : Very Important Topics

17.0 Very Important Topics in Power Query (Power BI)

17.1 Fill Down in Power BI

17.2 Grouping in Power Query

17.3 Transpose in Power Query

17.4 Unpivot In Power Query

17.5 Data Types in Power Query

17.6 Replace Errors and Values in Power Query (Power BI)

17.7 Keep and Remove Rows in Power Query

17.8 Add,Remove and Goto Columns in Power Query

Quiz

Very Important Topics

Assignment

Section 17

Section 18 : M Language in Power BI Power Query

18.0 Introduction to M Language

18.1 Write a M Function

18.2 Date ISIN function

18.3 Add & Subtract Date in M Function

18.4 Basic Date M Function

18.5 Basic Text M Function

18.6 Simple M Code

18.7 Trick to get 900+ M Functions

Preview - Power BI