Power Bi Course Detail

It is a powerful tool that helps individuals and companies to transform their data into insightful and interactive visualizations. The course will help students with the usage of Power BI to create dynamic dashboards and reports, connect to various data sources and conduct data modeling and analysis.

Hands on exposure will be given to students while working with Power BI desktop and power BI service throughout the course. They will learn how to design and create visually compelling stories, charts and graphs that can be shared with others within their organization.

Takeaways

Tables and Matrix in Power BI,
Working with Maps
Cards and Filters
Power Query

Introduction

1 Introduction to Power BI
2 Download, Install and Update Features in Power BI

Basic Charts in Power BI

0 Basic Charts in Power BI Desktop
1 Column Chart in Power BI
2 Stacked Column Chart in Power BI
3 Pie Chart in Power BI
4 Donut Chart in Power BI
5 Funnel Chart in Power BI
6 Ribbon Chart
7 Include and Exclude
8 Export data from Visual

Working with Maps

0 Maps in Power BI
1 Creating a Map in Power BI
2 Filled Map
3 Map with Pie Chart
4 Formatting in Map
5 Change Background in Map
6 Map of India in Power BI
7 Map of Australia in Power BI

Tables and Matrix in Power BI

0 Table and Matrix in Power BI
1 Creating a Table in Power BI
2 Formatting a Table
3 Conditional Formatting in Table
4 Aggregation in Table
5 Matrix in Power BI
6 Conditional Formatting in Matrix
7 Hierarchies in Matrix
8 Sub-Total and Total in Matrix
9 Number Formatting in Table

Other Charts in Power BI

0 Other Charts in Power BI
1 Line Chart in Power BI
2 Drill Down in Line Chart
3 Area Chart in Power BI
4 Line vs Column Chart in Power BI
5 Scatter Plot in Power BI
6 Waterfall Chart in Power BI
7 TreeMap in Power BI
8 Guage Chart in Power BI

Cards and Filters

0 Cards and Filters in Power BI
1 Number Card
2 Text Card
1 Formatting of Text Card
3 Date Card
1 Date Card (Relative Filtering)
4 Multi-Row Card
5 Filter on Visual
6 Filter on This Page
7 Filter on All Pages
8 Drill through in Power BI

Slicers in Power BI

0 Slicers in Power BI
1 Text Slicers in Power BI
2 Formatting a Text Slicer
3 Date Slicers in Power BI
4 Formatting a Date Slicer
5 Number Slicers in Power BI

Advanced Charts in Power BI

0 Advanced Charts in Power BI
1 Animated Bar Chart Race
2 Drill down donut Chart
3 Drill down Column chart
4 Word Cloud in Power BI
5 Sankey Chart in Power BI
6 Infographic in Power BI
7 Play Axis in Power BI
8 Scroller in Power BI
9 Sunburst Chart in Power BI
10 Histogram in Power BI

Objects in Power BI

1 Insert Image in Power BI
2 Insert Text in Power BI
3 Insert Shapes in Power BI
4 Insert Buttons in Power BI
5 Web URL Action in Power BI
6 Page Navigation Action in Power BI
7 Bookmark Action in Power BI
8 Drillthrough Action in Power BI

Power BI Service Introduction

1 Create a data Report in Power BI
2 Create an Account on Power BI Service
3 Publish Report to Power BI Service Account
4 Export Power BI Report to PPT, PDF or PBIX
5 Comment, Share and Subscribe to Power BI Report
6 Create a Dashboard in Power BI Service
7 Problem in Power BI Dashboard and its solution
8 Automatic Refresh in Power BI using Gateway

Power Query – Text Functions

0 Text Functions in Power Query (Power BI)
1 Merge Columns in Power Query (Power BI)
2 Split and Trim in Power Query (Power BI)
3 Upper,Lower and ProperCase in Power Query (Power BI)
4 Prefix and Suffix in Power Query (Power BI)
5 Left,Right and Mid Functions in Power Query (Power BI)
6 Extract Text with Delimiters

Power Query – Date Functions

0 Date Functions in Power Query(Power BI)
1 Year,Quarter,Month and Day Functions in Power Query (Power BI)
2 Find Difference between Dates in Power Query(Power BI)
3 Month and Day Name in Power Query (Power BI)
4 Day,Week of Month,Year in Power Query (Power BI)
5 Extract Date, Time in Power Query (Power BI)
6 Calculate Age in Power Query (Power BI)
7 Day of Year,Quarter,Month in Power Query (Power BI)

Power Query – Number Functions

0 Number Functions in Power Query (Power BI)
1 Basic Number Functions in Power Query (Power BI)
2 Percentage,Percent Of, Module in Power Query (Power BI)
3 Round Functions in Power Query (Power BI)
4 IsEven,IsODD, Sign in Power Query (Power BI)

Power Query – Append Files

1 Append multiple CSV files in a folder in Power Query
2 Append multiple excel sheets,Tables in Power Query
3 Append Excel sheets or Tables with different columns
4 Append multiple Excel files from a folder
5 Append different data sources

Power Query – Merge Files

0 Merge Files and Tables
1 Merge Sheets or Tables in Power Query
2 Merge Data from multiple Excel files or Workbooks
3 Merge data from different data sources in Power Query
4 Merge data having multiple criteria

Power Query – Conditional Columns

0 Conditional Column and Column from example in Power BI
1 Column from examples in Power BI – Split Text
2 Column from examples in Power BI – Merge Columns
3 Column from Examples in Power BI – Date
4 Column from Examples in Power BI – Alphanumeric
5 Conditional Column in Power BI – One Column
6 Conditional Column in Power BI – two columns
7 Conditional Column in Power BI – Compare two columns
8 Conditional Column in Power BI – on Dates

Power Query – – Important Topics

0 Very Important Topics in Power Query (Power BI)
1 Fill Down in Power BI
2 Grouping in Power Query (Power BI)
3 Transpose in Power Query (Power BI)
4 Unpivot In Power Query (Power BI)
5 Data Types in Power Query (Power BI)
6 Replace Errors and Values in Power Query (Power BI)
7 Keep and Remove Rows in Power Query (Power BI)
8 Add,Remove and Goto Columns in Power Query (Power BI)

Power BI Course Detail