Power BI 

Power BI Introduction and Installation

• Understanding Power BI Background  

• Installation of Power BI and check list for installation  

Data Type and Load

• Loading data from multiple sources  

• Data type and the type of default chart on drag drop.  

Power BI Visualization

• Understanding Column Chart  

• Understanding Line Chart  

• Conditional formating  

Power Query Editor  

• Loading data from folder  

• Understanding Power Query in detail  

• Promote header, Split to limiter, Add columns, append, merge queries etc  

Modelling with Power BI

• Loading multiple data from different format  

• Understanding modelling (How to create relationship)  

• Connection type, Data cardinality, Filter direction  

• Making dashboard using new loaded data  

Power Query Editor Filter Data

• Power Query Custom Column & Conditional Column  

• Manage Parameter  

• Introduction to Filter and types of filter  

• Trend analysis, Future forecast  

Customize the data in Power BI

• Understanding Tool tip with information  

• Use and understanding of Drill Down  

• Visual interaction and customisation of visual interaction  

• Drill through function and usage  

• Button triggers  

• Bookmark and different use and implementation  

• Navigation buttons  

Dax Expressions

• Introduction to DAX  

• Table Dax, Calculated column, DAX measure and difference  

• Calculated Column  

• Related, Lookup value, switch, Datedif,Rankx,Date functions  

• Dax Measure and Quick Measure  

SQL 

Introduction to Mysql

• Introduction to Databases  

• Introduction to RDBMS  

• Different types of RDBMS  

• Software Installation(MySQL Workbench)  

SQL Commands and Data Types

• Types of SQL Commands (DDL,DML,DQL,DCL,TCL) and their applications  

• Data Types in SQL (Numeric, Char, Datetime)  

DQL & Operators

• SELECT  

• LIMIT  

• DISTINCT  

• WHERE AND  

• OR  

• IN  

• NOT IN  

• BETWEEN  

• EXIST  

• ISNULL  

• IS NOT NULL  

• ORDER BY  

Group Operations & Aggregate Functions

• Group By  

• Having Clause  

• COUNT  

• SUM  

• AVG  

• MIN  

• MAX  

• COUNT String Functions  

• Date & Time Function  

Joins

• Inner  

• Left  

• Right  

• Cross  

• Self Joins  

• Full outer join  

DDL

• Create  

• Drop  

• Alter  

• Rename  

• Truncate  

DML

• Insert  

• Update & Delete  

Views and Stored Procedures:

• Input & Output Stored Procedures  

• Simple and Complex View  

Advanced-Data Visualization

• Slicers and Filters in Power BI  

• Interactive Visualizations in Power BI  

• Creating Paginated Reports  

• Creating Dashboards in Power BI  

Data Modelling & DAX

• Introduction and Techniques to Data Modelling  

• Creating Measures in DAX  

• DAX Functions  

Publishing Your Dashboards

• Introduction to Power BI Service  

• Collaboration using Power BI