Actual vs. Budget Analysis with Power Query and Power Pivot

3.4 - Business Analysis & DAX Measures - Dashboard in a Day #powerbi

3.3 - Hierarchies and Date Table - Dashboard in a Day #powerbi

3.2 - Drill down, Groups, Interactions - Dashboard in a Day #powerbi

3.1 - Ribbon & Relationships - Dashboard in a Day #powerbi

2 - Data Transformation - Dashboard in a Day #powerbi

1 - Data Loading - Dashboard in a Day #powerbi

Mastering Date and Time Techniques with Power Query: Advanced Tips and Tricks #powerquery

Dynamic Start Date and End Date for Power BI Date Table

Become a Data Ninja with Power Query and Power Pivot #powerquery #powerpivot

Complex transformations: get previous row value - Advanced POWER QUERY #powerquery #etl

Extract All DAX Measures from a PowerPivot Data Model in Excel #powerpivot #dax

Advanced Power Query - Append Files from Different Folders #powerquery #append

Customer Segmentation: K-Means Clustering with EXCEL #kmeans #excel

The Fine Difference between CALCULATE with and without FILTER Expression #dax #calculate

The New LINESTX() DAX Function in Power BI - Clearly Explained #linearregression

NON LINEAR Regression with Power BI - Logarithmic Growth #nonlinear #regression

6 Easy Ways to Perform Linear Regression with Excel

The New LINEST() DAX Function in Power BI - Regression Analysis Made Easy #regressionanalysis

Change All Column Names at Once in Power BI

New in DAX: the WINDOW() Function with an Example

Power Query Ribbon and Menu Options EXPLAINED #powerquery #powerqueryribbon #powerquerymenu

7 Most Useful Mental Models for Life #mentalmodels

Build a Python program using ChatGPT in 1 minute #chatgpt #python

Become a CFO - the FP&A career path

Master Any Skill with ChatGPT

Excel Like a Boss: Create Macros with ChatGPT

Advanced Power Query - Create a Date Table

Advanced Power Query - Get Data from Web

Advanced Power Query - Unpivot Columns with Multiple Headers

Advanced Power Query - Pivot Horizontally Stacked Sets

Find First Non-Null Value in a Row with Power Query and Power BI

Advanced Power Query - Pivot Vertically Stacked Sets

Unpivot Columns based on Condition in Power Query and Power BI

Approximate Match VLOOKUP with Power BI and Power Query

Cumulative Actual vs. Budget - Budgeting with Power BI series

Dynamic Budget Allocation - Budgeting with Power BI Series

Market Basket Analysis with Power BI and DAX

HR Analytics - transform and analyze employee vacation days with Power BI

Combine Files and Extract Value from Cell in Power BI

Combine Worksheets with Dynamic Column Names in Power BI

Dynamic Last Column Selection with M Language in Power Query & Power BI

Dynamic Date Filter with M Language in Power Query & Power BI

Calculate Customer Refunds with DAX in Power BI

Power BI - Change Data Source from Excel to SQL Server - M & Power Query trick

Customer Lifetime Value Dashboard in Power BI

Customer RFM Analysis in Power BI - Recency, Frequency, Monetary

Customer Churn - Find Lost, New & Returning Customers with Power BI

Power BI - CUSTOMERS who bought more than 4 TIMES last 8 WEEKS

Power BI - Find Repeated Tickets less than 10 Days

Get Previous Row Value in Power BI

Combine System Data Table with Manual Data Table in Power BI - Merge Queries with Power Query

DAX Tutorial - Show Products with no Sales

CONTEXT TRANSITION - the most difficult DAX concept clearly EXPLAINED

DAX Tutorial - How many Active Stores each Period?

DAX as a Query Language - clearly explained with EXAMPLES

The LET function in Excel - Simplify complex formulas & Increase execution speed

DAX Magic - Disconnected Slicers in Power BI. Example for changing the currency

FORECASTING BOOTCAMP #4 Triple Exponential Smoothing in Excel (Holt - Winters method)

FORECASTING BOOTCAMP #3 Double Exponential Smoothing in Excel