Master Power BI Skills with My Code Tricks
Master Data Visualization and Business Intelligence with our comprehensive Power BI course.
Learn to create stunning Power BI Dashboards, perform advanced Data Analysisfor insightful reporting.
Get hands-on experience with Power Query and Data Modeling to transform data into actionable insights
Learn Power BI fundamentals
Data Transformation
Power BI Projects
Learn the fundamentals of POWER BI to visualise your data
Master Power BI to clean and transform data without coding to powerful reports
Hands on experience on Power BI industry projects
Course Content
1.What IS POWER BI
-
WHY POWER BI
-
WHAT IS GATEWAY
-
BENEFITS OF PBI
-
COMPONENTS OF POWER BI
2. BUILDING BLOCKS OF POWER BI
-
WHAT IS A REPORT
-
TILE
-
DASHBOARD
-
DATASET
-
VISUALISATION​
3. USING POWER BI
-
Understanding Power BI Desktop
-
How to install Power Bi desktop
-
How to import Data
-
How to join data sets
-
Difference in Dashboard and Reports
-
How to create a Dashboard
-
How to share a Dashboard
4. DATA VISUALISATION IN POWER BI
-
Introduction to Charts in Power BI
-
Introduction to Maps in Power BI
-
Introduction to table and Matrix in Power BI
-
Introduction to other charts in Power BI
-
Introduction to cards and filters in Power bi
-
Introduction to Slicers in Power BI
-
How to use Drill Down in Power BI
-
Project on What we Learnt
5.POWER BI QUERY
-
Different Text Functions in Power Query (Power BI)
-
How to Split and Trim in Power Query (Power BI)
-
Upper, Lower, and ProperCase in Power Query (Power BI)
-
How to add Prefix and Suffix in Power Query (Power BI)
-
Left, Right, and Mid Functions in Power Query (Power BI)
-
How to Extract Text with Delimiters in Power Query (Power BI)
-
Introduction to Date Functions in Power Query (Power BI)
-
Year, Quarter, Month, and Day Functions in Power Query (Power BI)
-
How to find Difference between Dates in Power Query (Power BI)
-
How to get Month and Day Name in Power Query (Power BI)
-
How to Day, Week of Month, Year in Power Query (Power BI)
-
How to Extract Date, Time in Power Query (Power BI)
-
How to Calculate Age in Power Query (Power BI)
-
How to Day of Year, Quarter, Month in Power Query (Power BI)
-
Introduction to Number Functions in Power Query (Power BI)
-
Basic Number Functions in Power Query (Power BI)
-
How to get Percentage, Percent Of, Module in Power Query (Power BI)
-
How to Round Numbers in Power Query (Power BI)
-
IsEven, IsODD in Power Query (Power BI)
-
How to Append multiple excel sheets, Tables in Power Query (Power BI)
-
How to Append multiple Excel files from a folder in Power BI
-
How to Append different data sources in Power BI
-
Introduction to Merge Files and Tables in Power BI
-
How to Merge Sheets or Tables in Power Query (Power BI)
-
How to Merge Data from multiple Excel files or Workbooks in Power BI
-
How to Merge data from different data sources in Power Query (Power BI)
-
How to Merge data having multiple criteria in Power BI
-
Introduction to Conditional Column and Column from example in Power BI
-
Conditional Column in Power BI - One Column
-
Conditional Column in Power BI - two columns
-
Fill Down in Power BI
-
How to Group in Power Query (Power BI)
-
How to Transpose in Power Query (Power BI)
-
How to Unpivot In Power Query (Power BI)
-
Different Data Types in Power Query (Power BI)
-
How to find and Replace Errors and Values in Power Query (Power BI)
-
How to Keep and Remove Rows in Power Query (Power BI)
-
How to Add, Remove and Goto Columns in Power Query (Power BI)
6. DATA MODELING IN POWER BI
-
What is a Schema
-
Types of Schemas
-
Different types of relationship between datasets (Like One to Many, One to One etc)
-
How to set up relationship
-
Benefits of setting up relationship between dataset
-
What is Star Schema
-
What is Snowflake Schema
-
How to create Calculated Table
-
How to create Calculated column
-
Managing Time Based Data
-
Introduction of Measures and Functions
-
Practical Examples with projects
7. ADVANCED CHARTS IN POWER BI
-
Advanced Charts & Features in Power BI
8. PROJECT IN POWER BI
​​