Topics Sub-Topics
Power BI Introduction and Installation Understanding Power BI Background. Installation of Power BI and check list for perfect installation
Formatting and Setting prerequisits. Understanding the difference between Power BI desktop & Power Query
The Power BI user interface, including types of data sources and visualizations. Getting familiar with the interface BI Query & Desktop Understanding type of Visualisation Loading data from multiple sources
Data type and the type of default chart on drag drop. Geo location Map integration
Sample dashboard with Animation Visual Finanical sample data in Power BI. Preparing sample dashboard as get started.
Map visual Types and usages in different variation Understanding scatter Plot chart with Play axis and the parameters.
Power BI artificial intelligence Visual Understanding the use of AI in power Bi AI analysis in power bi using chart Q&A chat bot and the use in real life Hirarchy tree
Power BI Visualization Understanding Column Chart Understanding Line Chart
Implementation of Conditional formating Implementation of Formating techniques.
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
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
Customize the data in Power BI 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 Eg:- Calendar, Calendar auto, Summarize, Group by etc.
Dax Expressions Calculated Column Related, Lookup value, switch, Datedif,Rankx,Date functions
Dax Expressions Dax Measure and Quick Measure Remove filters, Keep filters, All, Allselected, Time Intelligence Functions,Rolling average,YoY, Running total
Custom Visual Custom visual and understanding the use of custom Loading custom visual, Pinning visual
Loading to template for future use Publishinhg Power Bi
Power BI Service Introduction to app.powerbi.com Schedule refresh Data flow and use power bi from online Download data as live in power point and more.