arrow_back
1.Introduction to Power Bi
1.1 Power Bi - Introduction
1.2 Download, Install And Activate New Features In Power Bi
Resource Material
Power BI Material
2.Basic Charts in Power Bi
2.0 Section Overview
2.1 Creating a Column Chart in Power BI
2.2 Creating a Stacked Column Chart in Power BI
2.3 Create a Pie Chart in Power BI
2.4 Create a DONUT CHART in Power BI
2.5 Create a Funnel Chart in Power BI
2.6 Create a Ribbion Chart in Power BI
2.7 WHAT IS INCLUDE AND EXCLUDE
2.8 EXPORT DATA FROM VISUAL
Sample - Superstore
Section 2 - Basic Charts
3.Maps in Power BI
3.1 Basic Map in Power BI
3.2 Creating a Filled Map
3.3 Map with Pie Chart
3.4 Format a Map
3.4 State and UTs of India
3.5 Change background in Map
3.6 Create INDIA map in Power BI
3.7 Create AUSTRALIA map in Power BI
Sample - Superstore
Section 3 - Maps
4.Tables And Matrix
4.0 Table And Matrix
4.1 Creating A Table
4.2 Formatting In Table
4.3 Conditional Formatting In Table
4.4 Aggregation In Table
4.5 Matrix
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
Sample - Superstore
Section 4 - Table and Matrix
5.Other Charts in Power BI
5.0 Introduction to Section
5.1 Line Chart In Power Bi
5.2 Drill Down Line Chart in Power BI
5.3 Area Chart In Power Bi
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
Sample - Superstore
Section 5 - Other Charts
6.Cards And Filters in Power BI
6.0 Introduction to Cards And Filters In Power Bi
6.1 Number Card In Power Bi
6.2 Text Card in Power BI
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
Sample - Superstore
Section 6 - Cards and Filters
7.Slicers in Power Bi
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
Sample - Superstore
Section 7 - Slicers
8-Advanced Charts in Power Bi
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
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
Sample - Superstore
Section 8 - Advanced Charts
9.Power Bi Objects, Bookmarks And 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.7 Bookmark Action In Power Bi
9.8 Drill through Action In Power Bi
Section 9 - Objects and Actions (Hyperlinks)
10.Power Bi Service
10.1 Create A Report In Power Bi
10.2 Create An Account On Power Bi Service
10.3 Publish Report To Power Bi Service
10.4 Export Power Bi Report To PPT, PDF, PBIX
10.5 Comment, Share And Subscribe To Power Bi Reports
10.6 Create A Dashboard In Power Bi Service
10.7 Problem In Power Bi Dashboard And Its Solution
10.8 Automatically refresh reports in Power BI Service
10.1 Sample SuperStore
Section 10 - Publishing Reports to Power BI Service
Section 10 - Reference
Sample Dashboard
11.Text Functions in Power Query
11.0 Text Functions In Power Query
11.1 Merge Columns In Power Query
11.2 Split And Trim
11.3 UPPERCASE, lowercase and ProperCase
11.4 Add Prefix and Suffix
11.5 Left,Right And Mid Functions In Power Query
11.6 Extract Text With Delimiters
11. Power Query - Text Functions
Section 11 - PQ Text Functions
12.Data Functions
12.0 Date Functions
12.1 Year, quarter and Day Functions
12.2 Difference Between Dates
12.3 Month and Day Name
12.4 Day week of Month, Year
12.5 Extract Date, Time
12.6 Calculate Age
12.7 Day of year, Quarter, Month
12. Power Query - Date Functions
Section 12 - PQ Date Functions
13.Number Functions in Power Query
13.0 Number Functions
13.1 Basic Number Functions
13.2 Percentage,Percent Of Module
13.3 Round Functions
13.4 Is Even, is Odd Sign
13. Power Query - Number Functions
Section 13 - PQ Number Functions
14.Append Data in Power Bi
14.0 Append Data In Powerbi
14.0 Appending Files
14.1 Append Multiple Csv Files In A Folder
14.2 Append Multiple Excel Sheets,Tables
14.3 Append Excel Sheets or tables with different columns
14.5 Append Different Data Sources
14.5 Append Multiple Excel Files From A Folder
14.3 Append excel sheets with different columns
14.4 Append Multiple excel files from a folder
14.5 Append different data sources in Power bi
Section 14 - Appending Files and Tables in Power BI
15.Introduction to merge queries
15.0 Merge Queries
15.0 MERGE Files And Tables
15.1 Merge Sheets Or Tables
15.2 Merge Data From Multiple Excel Files
15.3 MERGE DATA FROM DIFFERENT DATA SOURCES
15.4 MERGE DATA HAVING MULTIPLE CRITERIA
Section 15 - Merging Tables in Power Query (Power BI)
16.Introduction to Conditional Column And Column For Example
16.0 CONDITIONAL COLUMN AND COLUMN FROM EXAMPLE
16.1 COLUMN FROM EXAMPLE - SPLIT TEXT
16.2 COLUMN FROM EXAMPLE - MERGE COLUMNS
16.3 COLUMN FROM EXAMPLE - DATE
16.4 COLUMN FROM EXAMPLE - ALPHANUMERIC
16.5 CONDITIONAL COLUMN - ONE COLUMN
16.6 CONDITIONAL COLUMN I- TWO COLUMNS
16.7 CONDITIONAL COLUMN - COMPARE TWO COLUMNS
16.8 CONDITIONAL COLUMN - ON DATES
16.1 Column from Example
16.4 Conditional Column in Power BI
Section 16 - Column from Examples in Power Query (Power BI)
17-Important Topics in Power BI
17.0 IMPORTANT TOPICS IN POWER BI
17.1 WHAT IS FILL DOWN
17.2 HOW TO GROUP
17.3 HOW TO TRANSPOSE
17.4 HOW TO UNPIVOT
17.5 WHAT ARE DATA TYPES
17.6 REPLACE ERRORS AND VALUES
17.7 KEEP AND REMOVE ROWS
17.8 ADD, REMOVE AND GOTO COLUMNS
17. Important Topics in Power Query
Section 17 -Miscellaneous Topics in Power BI
18.M Language
18.0 M LANGUAGE
18.1 INTRODUCTION TO M LANGUAGE
18.2 ISINDATE FUNCTIONS IN M LANGUAGE
18..3 HOW TO ADD AND SUBTRACT DATE M FUNCTIONS
18.4 BASIC DATE M FUNCTIONS
18.5 BASIC TEXT M FUNCTIONS
18.6 HOW TO WRITE A SIMPLE M CODE
18.7 TRICK TO GET ALL 900+ M FUNCTIONS HELP
18. Sample Superstore for M Functions
Section 18 - Introduction to M Language
