Power Bi Course Topics Covered
Power BI Training Part 01 Topics CoveredUpcoming Power BI Workshops in Next MonthFor further details : +91 9819006132 |
||||||||||||||||
Power BI Course Module 01: Introduction to Self-Service Business Intelligence | ||||||||||||||||
~ Self-Service BI ~ Power Pivot ~ Power Query |
||||||||||||||||
Power BI Course Module 02: Loading Data | ||||||||||||||||
~ Loading Data in Power Pivot ~ Loading from SQL Tables ~ Loading from SQL Queries ~ Using Linked Tables ~ Loading from Excel ~ Loading from Text Files ~ Loading from the Clipboard ~ Loading from Reports |
||||||||||||||||
Power BI Course Module 03: Data Modelling | ||||||||||||||||
~ Introduction to Data Models ~ Normalization and Denormalization ~ Star Schemas ~ Over Denormalization |
||||||||||||||||
Power BI Course Module 04: Introduction to Power Query | ||||||||||||||||
~ Power Query Introduction | ||||||||||||||||
Power BI Course Module 05 Import Data into Power Query | ||||||||||||||||
~ Import Data from Excel File ~ Import data from other files / folder |
||||||||||||||||
Power BI Course Module 06: Loading and Refresh | ||||||||||||||||
~ Load data and refresh query when source data changes | ||||||||||||||||
Power BI Course Module 07: Data Transformation | ||||||||||||||||
~ Column Transformation ~ Row Transformation |
||||||||||||||||
Power BI Course Module 08: In built transformation in Power Query | ||||||||||||||||
~ Text Transformation ~ Numbers transformation ~ Date transformation ~ Conditional Column transformation |
||||||||||||||||
Power BI Course Module 09: Consolidate and Append Data | ||||||||||||||||
~ Append data from Excel tables within same Excel file ~ Append / Duplicate / Reference multiple Queries ~ Import data from files in a folder ~ Import data from multiple excel files in a folder ~ List of files in folder ~ Changing file path for source data |
||||||||||||||||
Power BI Course Module 10: Merge Queries / Multiple Joins in Power Query | ||||||||||||||||
~ Multiple JOINS in power query (Merge Queries) ~ Different Joins in Power Query ~ Cross Joins / Cartesian Product of Two tables |
||||||||||||||||
Power BI Course Module 11: Building blocks for M language | ||||||||||||||||
~ Introduction to building blocks in M ~ Text functions in Power Query ~ Date functions in Power Query ~ Conditional Functions in Power Query |
||||||||||||||||
Power BI Course Module 12: Case Studies | ||||||||||||||||
~ Self-Service BI ~ Power Pivot ~ Power Query |
||||||||||||||||
Power BI Course Module 13: Power Query Objects | ||||||||||||||||
~ List as object and List functions in Power Query ~ Record as object and Record functions in Power Query ~ Table & other objects and Table functions in Power Query ~ Power Query Objects |
||||||||||||||||
Power BI Course Fee
|
Course Name | Course Duration | Course Fees | Fees (US $) |
Power BI Training Part 01 | 20 sessions of 1 hr. each | 10,000/- | $ 285 |
Power BI Training Part 02 | 20 sessions of 1 hr. each | 12,500/- | $ 360 |
Power BI Training Part 01 & Part 02 | 40 sessions of 1 hr. each | 22,500/- | $ 645 |