Online Live Training on Analyzing Data with Power BI (23th Batch)

01. Chapter 01 : Introduction of Power BI

 1.1 Components of Power BI

 1.2 Installation of Power BI

 1.3 How to load datasets in Power BI from different sources
 

02. Chapter 02: Create reports to explore insights

 2.1 Introduce charts and graphs for data communications

 2.1.1 Add Visualization Items to Reports through default charts in Power BI

 2.1.2 Choose an Appropriate Visualization

 2.1.3 Format and Configure Visualizations

 2.1.4 Use the Play Axis Feature of a Visualization

 2.2 Introduce power BI Table and Matrix

 2.2.1 Format table

 2.2.2 Advanced formatting Table and Matrix

 2.2.3 Create Hierarchies in Matrix

 2.3 Apply Card , Slicer & Filter

 2.3.1 Choose card and multi row card effective visualization

 2.3.2 Formatting slicer to improve the presentation

 2.3.3 Utilize Filter as per requirement in report
 

03. Chapter 03 : Clean and modify datasets through Power Query

 3.1 Handle with null and unnecessary value

 3.2 Introduce Join Query

 3.3 Apply Splitting and Extract for hazy data

 3.4 Creating Conditional Group

 3.5 Find summary from a large dataset

 3.6 Use basic Mathematical Operation

 3.7 Apply Text Function

 3.7.1 Upper , Lower and Proper Text

 3.7.2 Add Prefix , Suffix in Column
 

04. Chapter 04: Enhance Reports for data storytelling

 4.1 How to choose right theme in Power BI

 4.2 How to Align visual elements

 4.3 Insert Text , Shape

 4.4 Insert Button

 4.5 Apply Page Navigation for dynamic presentation

 4.6 Use Advanced chart in Power BI

 4.7 Map visual for Power BI
 

05. Chapter 05: Data Modeling

 5.1 Single-direction relationships

 5.2 Bidirectional relationships

 5.3 Fact tables, Dimension tables

 5.4 Introduce Star Schema and Snowflake Schema
 

06. Chapter 06: Perform Advanced Analysis

     6.1 Introduce Data Analysis Expression (DAX)

     6.2 Using basic table functions

     6.3 Apply Logical Function

     6.4 Understanding CALCULATE and CALCULATETABLE

     6.5 Time intelligence calculations

     6.6 Understanding evaluation contexts

     6.7 Understanding Logical contexts
 

07.Chapter 07 : Advanced Query with M formula language

    7.1 Understanding Power Query M functions

    7.2 Apply Date and Time Function

    7.3 Customize Web data with M language

    7.4 Handle Column names

    7.5 Apply Different Functions

08 . Chapter 08 : The Power BI Service and Sharing
           

     8.1 Publish desktop to web

     8.2 How to create an account in Power BI Service

     8.3 Data Refresh

     8.4 Managing the On-premises Data Gateway

     8.5 How to Share dashboard

     8.6 Build an effective dashboard as per the requirement with different reports