Course Introduction
- Introduction to Microsoft Power BI Data Analysis & Data Visualization Course
- Download & Install - Microsoft Power BI Desktop
- Download - Microsoft Power BI supporting files (Practice files used)
- 11 reasons why you should learn and use Power BI.
An Introduction to Power BI and Power Query (M Language)
- Overview of Power BI Desktop Interface
- Power BI data sources and how to connect them
- Connect to data sources like Excel, CSV and Website
- Connecting to other data sources
- Combine data from multiple excel files - Use Query Editor to reduce data set
- Power Query Editor - An overview
- M Query Language - An Overview
- Renaming, Editing and Error handling in Power Query advanced editor
- Consolidate and add custom data types in Power BI using M formula language
- Change data types, replace values, group data, transpose and unpivot
- Text column functions (split , format, merge and extract columns)
- Append data to a query, Insert custom columns and index column
- Build relation between tables, merge data, show and hide queries
- Lookup tables in a data set
- Adding Text Formulas in Custom Columns and Conditional Formulas
- Power Query List function
- Groupby aggregation and find sum by unique column values in Power Query
- Date Function in Power Query
- Number Functions in Power Query
- Percentage, Percent of, Fill Up and Fill Down in Power Query
- Add Prefix and Suffix to a Text in Power Query
- Dynamically Merge Related Data Spilled Out in Different Columns
- How to GroupBy All Rows in Power Query
- 3 Ways to Extract Text and Numbers from a string using Power Query
- Reduce row data with Power Query
- Get Top N records using List .Range function in Power Query
- IF Error function in Power Query
- Merge tables based on conditions
- Power Query Let and Nested Let statement
- Create Functions in Power Query - Part 1
- Create Functions in Power Query - Part 2
- How to Add Parameters in a Data Table using Power Query
- Group By Maximum Value in a table using Power Query
- How to use Fill Up or Fill Down in your data based on conditions
- How to Index columns in Power Query to get value of previous row
- How to do conditional join or conditional merge using Power Query
- How to use IF Function in Power Query
- Dynamically change column names using Power Query
- How to create a delimited list in Power Query
- Create Dynamic Start date & End date for data tables in Power Query
- Match data based on Approximate or Close Match in Power Query
- How to Combine tables with Different Columns
- How to work with Nulls or Blank values in Power Query
- How to create a Dynamic Calendar table in Power Query
- How to Pivot data in Power Query
- How to Filter data based on Multiple Criteria using Power Query
- How to Summarize and Group data using Power Query
- Dynamically Rank with Ties in Power Query
- How to convert multiple Columns in to Rows
- How to calculate Running Totals in Power Query
- How to Stack Data from Columns to Rows in Power Query
- Rename and Sort multiple column in Power Query
- Find TopN rows in each group using Power Query
- For Each Group create a Row Number using Power Query
- Retain recent records and remove duplicate records
- How to perform VLOOKUP in Power Query
- Extract Min date & Max date for column category dynamically
- Create Unique Combinations From Multiple Column Values
- How to Unstack data from Uneven Rows to Separate Columns
- How to create a Date Time column in power query
- How to reverse Running Totals in Power Query
- Dynamic Filters in Power Query
- How to add an index column to subgroups
- How to use Custom Function In Power Query
- How to Extract data from Top Rows using Power Query
- Define Data Types and Define Dynamic Data Types
- How to create hierarchies in Power Query
- How to use SUMIF between two table using Power Query
- How to Remove Empty Columns Dynamically in Power Query
- VLOOKUP based on Fuzzy Matching in Power Query
- How to convert a date to Fiscal Periods with Power Query
- How to create Conditional Columns in Power Query
- How to do a full Anti Join in Power Query
- How to add Zeros before Numbers in Power Query
- How to Count the number of times a value appears in a column in Power Query
- Unpivot data Dynamically in Power Query
- Change column names dynamically in a visual using slicer in Power BI
- Complete Hidden Function List in Power Query
- An overview of Power BI Report View (Filters, Visualizations, Fields)
- An overview of Visualizations (Text, chart, Cards, Table, Slicer, Filters)
- Q&A feature in Power BI
Data Modeling and Data Analysis using Data Analysis Expressions (DAX )
- An overview of Data Analysis Expressions (DAX) - Data Modeling and Data Visualiz
- Import data and Create Relationships - Transform data using DAX
- DAX Lookup function - Add a calculated column and get details from a lookup fiel
- Create a DAX function with calculated column to find Product of two column
- Create a DAX function with calculated column to Divide & find difference of two
- DAX Aggregate Functions such as SUM, SUMX
- DAX Aggregate Functions such as MIN, MAX
- DAX Aggregate Functions AVERAGE
- Visualization - Create a Simple Dashboard
- COUNT, COUNTA, COUNTAX, COUNTROWS, COUNTX, COUNTBLANK & DISTINCTCOUNT
- DAX Logical Functions such as AND, OR, NOT, IF, NESTED IF, IFERROR, TRUE, False
- DAX Text Functions such as COMBINEVALUES, SEARCH, FIND, EXACT and TRIM
