Data Analytics Central

VBA code to discover overlapping PIVOT TABLES in Excel

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

Python for Dummies - Numpy Arrays' Shape and Dimensions Clearly Explained

Combine Worksheets with Dynamic Column Names in Power BI

Dynamic Start Date and End Date for Power BI Date Table

Monthly Sales Forecast with Seasonality and Trend - EXCEL regression with dummy variables

Advanced Power Query - Create a Date Table

3.3 - Hierarchies and Date Table - Dashboard in a Day

Market Basket Analysis with Power BI and DAX

Extract All DAX Measures from a PowerPivot Data Model in Excel

VBA code to discover and summarize all ERRORS in all Worksheets

Unpivot Columns based on Condition in Power Query and Power BI

Advanced Power Query - Unpivot Columns with Multiple Headers

1 - Data Loading - Dashboard in a Day

Calculate Customer Refunds with DAX in Power BI

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

Change All Column Names at Once in Power BI

NON LINEAR Regression with Power BI - Logarithmic Growth

Advanced Power Query - Get Data from Web

Approximate Match VLOOKUP with Power BI and Power Query

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

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

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

6 Easy Ways to Perform Linear Regression with Excel

The Fine Difference between CALCULATE with and without FILTER Expression

Complex transformations: get previous row value - Advanced POWER QUERY

Saved by VBA - Unhide different sheets with individual password

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

Excel Like a Boss: Create Macros with ChatGPT

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

Power BI - UK date format DD-MM-YYYY error - SOLVED

Get Previous Row Value in Power BI

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

Combine Files and Extract Value from Cell in Power BI

Dynamic Budget Allocation - Budgeting with Power BI Series

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

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

CONTEXT TRANSITION - the most difficult DAX concept clearly EXPLAINED

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

Advanced Power Query - Append Files from Different Folders

Advanced Power Query - Pivot Horizontally Stacked Sets