Explain Me Like I'm Smart - Dynamic Arrays
Data Analytics Central
Explain Me Like I'm Smart - Dynamic Arrays
11:22
Actual vs. Budget Analysis with Power Query and Power Pivot
Data Analytics Central
Actual vs. Budget Analysis with Power Query and Power Pivot
20:33
3.4 - Business Analysis & DAX Measures - Dashboard in a Day #powerbi
Data Analytics Central
3.4 - Business Analysis & DAX Measures - Dashboard in a Day #powerbi
12:15
3.3 - Hierarchies and Date Table - Dashboard in a Day #powerbi
Data Analytics Central
3.3 - Hierarchies and Date Table - Dashboard in a Day #powerbi
14:21
3.2 - Drill down, Groups, Interactions - Dashboard in a Day #powerbi
Data Analytics Central
3.2 - Drill down, Groups, Interactions - Dashboard in a Day #powerbi
9:56
3.1 - Ribbon & Relationships - Dashboard in a Day #powerbi
Data Analytics Central
3.1 - Ribbon & Relationships - Dashboard in a Day #powerbi
8:33
2 - Data Transformation - Dashboard in a Day #powerbi
Data Analytics Central
2 - Data Transformation - Dashboard in a Day #powerbi
16:12
1 - Data Loading - Dashboard in a Day #powerbi
Data Analytics Central
1 - Data Loading - Dashboard in a Day #powerbi
11:26
Mastering Date and Time Techniques with Power Query: Advanced Tips and Tricks #powerquery
Data Analytics Central
Mastering Date and Time Techniques with Power Query: Advanced Tips and Tricks #powerquery
27:19
Dynamic Start Date and End Date for Power BI Date Table
Data Analytics Central
Dynamic Start Date and End Date for Power BI Date Table
6:18
Become a Data Ninja with Power Query and Power Pivot #powerquery #powerpivot
Data Analytics Central
Become a Data Ninja with Power Query and Power Pivot #powerquery #powerpivot
3:15
Complex transformations: get previous row value - Advanced POWER QUERY #powerquery #etl
Data Analytics Central
Complex transformations: get previous row value - Advanced POWER QUERY #powerquery #etl
6:42
Extract All DAX Measures from a PowerPivot Data Model in Excel #powerpivot #dax
Data Analytics Central
Extract All DAX Measures from a PowerPivot Data Model in Excel #powerpivot #dax
2:07
Advanced Power Query - Append Files from Different Folders #powerquery #append
Data Analytics Central
Advanced Power Query - Append Files from Different Folders #powerquery #append
4:11
The Fine Difference between CALCULATE with and without FILTER Expression #dax #calculate
Data Analytics Central
The Fine Difference between CALCULATE with and without FILTER Expression #dax #calculate
2:26
The New LINESTX() DAX Function in Power BI - Clearly Explained #linearregression
Data Analytics Central
The New LINESTX() DAX Function in Power BI - Clearly Explained #linearregression
8:20
NON LINEAR Regression with Power BI - Logarithmic Growth #nonlinear #regression
Data Analytics Central
NON LINEAR Regression with Power BI - Logarithmic Growth #nonlinear #regression
9:19
The New LINEST() DAX Function in Power BI - Regression Analysis Made Easy #regressionanalysis
Data Analytics Central
The New LINEST() DAX Function in Power BI - Regression Analysis Made Easy #regressionanalysis
10:28
Change All Column Names at Once in Power BI
Data Analytics Central
Change All Column Names at Once in Power BI
3:16
New in DAX: the WINDOW() Function with an Example
Data Analytics Central
New in DAX: the WINDOW() Function with an Example
5:43
Power Query Ribbon and Menu Options EXPLAINED #powerquery #powerqueryribbon #powerquerymenu
Data Analytics Central
Power Query Ribbon and Menu Options EXPLAINED #powerquery #powerqueryribbon #powerquerymenu
13:27
7 Most Useful Mental Models for Life #mentalmodels
Data Analytics Central
7 Most Useful Mental Models for Life #mentalmodels
6:05
Build a Python program using ChatGPT in 1 minute #chatgpt #python
Data Analytics Central
Build a Python program using ChatGPT in 1 minute #chatgpt #python
5:33
Become a CFO - the FP&A career path
Data Analytics Central
Become a CFO - the FP&A career path
5:11
Master Any Skill with ChatGPT
Data Analytics Central
Master Any Skill with ChatGPT
4:30
Excel Like a Boss: Create Macros with ChatGPT
Data Analytics Central
Excel Like a Boss: Create Macros with ChatGPT
3:28
Advanced Power Query - Create a Date Table
Data Analytics Central
Advanced Power Query - Create a Date Table
3:20
Advanced Power Query - Get Data from Web
Data Analytics Central
Advanced Power Query - Get Data from Web
8:40
Advanced Power Query - Unpivot Columns with Multiple Headers
Data Analytics Central
Advanced Power Query - Unpivot Columns with Multiple Headers
5:19
Advanced Power Query - Pivot Horizontally Stacked Sets
Data Analytics Central
Advanced Power Query - Pivot Horizontally Stacked Sets
4:41
Find First Non-Null Value in a Row with Power Query and Power BI
Data Analytics Central
Find First Non-Null Value in a Row with Power Query and Power BI
4:57
Advanced Power Query - Pivot Vertically Stacked Sets
Data Analytics Central
Advanced Power Query - Pivot Vertically Stacked Sets
4:33
Unpivot Columns based on Condition in Power Query and Power BI
Data Analytics Central
Unpivot Columns based on Condition in Power Query and Power BI
4:35
Approximate Match VLOOKUP with Power BI and Power Query
Data Analytics Central
Approximate Match VLOOKUP with Power BI and Power Query
6:23
Cumulative Actual vs. Budget - Budgeting with Power BI series
Data Analytics Central
Cumulative Actual vs. Budget - Budgeting with Power BI series
5:55
Dynamic Budget Allocation - Budgeting with Power BI Series
Data Analytics Central
Dynamic Budget Allocation - Budgeting with Power BI Series
9:31
Market Basket Analysis with Power BI and DAX
Data Analytics Central
Market Basket Analysis with Power BI and DAX
8:52
HR Analytics - transform and analyze employee vacation days with Power BI
Data Analytics Central
HR Analytics - transform and analyze employee vacation days with Power BI
15:41
Combine Files and Extract Value from Cell in Power BI
Data Analytics Central
Combine Files and Extract Value from Cell in Power BI
8:23
Combine Worksheets with Dynamic Column Names in Power BI
Data Analytics Central
Combine Worksheets with Dynamic Column Names in Power BI
7:28
Dynamic Last Column Selection with M Language in Power Query & Power BI
Data Analytics Central
Dynamic Last Column Selection with M Language in Power Query & Power BI
7:25
Dynamic Date Filter with M Language in Power Query & Power BI
Data Analytics Central
Dynamic Date Filter with M Language in Power Query & Power BI
6:15
Calculate Customer Refunds with DAX in Power BI
Data Analytics Central
Calculate Customer Refunds with DAX in Power BI
9:57
Power BI - Change Data Source from Excel to SQL Server - M & Power Query trick
Data Analytics Central
Power BI - Change Data Source from Excel to SQL Server - M & Power Query trick
5:00
Customer Lifetime Value Dashboard in Power BI
Data Analytics Central
Customer Lifetime Value Dashboard in Power BI
6:52
Customer RFM Analysis in Power BI - Recency, Frequency, Monetary
Data Analytics Central
Customer RFM Analysis in Power BI - Recency, Frequency, Monetary
8:41
Customer Churn - Find Lost, New & Returning Customers with Power BI
Data Analytics Central
Customer Churn - Find Lost, New & Returning Customers with Power BI
6:40
Power BI - CUSTOMERS who bought more than 4 TIMES last 8 WEEKS
Data Analytics Central
Power BI - CUSTOMERS who bought more than 4 TIMES last 8 WEEKS
5:59
Power BI - Find Repeated Tickets less than 10 Days
Data Analytics Central
Power BI - Find Repeated Tickets less than 10 Days
5:22
Get Previous Row Value in Power BI
Data Analytics Central
Get Previous Row Value in Power BI
7:40
Combine System Data Table with Manual Data Table in Power BI - Merge Queries with Power Query
Data Analytics Central
Combine System Data Table with Manual Data Table in Power BI - Merge Queries with Power Query
7:12
DAX Tutorial - Show Products with no Sales
Data Analytics Central
DAX Tutorial - Show Products with no Sales
5:10
CONTEXT TRANSITION - the most difficult DAX concept clearly EXPLAINED
Data Analytics Central
CONTEXT TRANSITION - the most difficult DAX concept clearly EXPLAINED
8:37
DAX Tutorial - How many Active Stores each Period?
Data Analytics Central
DAX Tutorial - How many Active Stores each Period?
6:42
DAX as a Query Language - clearly explained with EXAMPLES
Data Analytics Central
DAX as a Query Language - clearly explained with EXAMPLES
18:00
The LET function in Excel - Simplify complex formulas & Increase execution speed
Data Analytics Central
The LET function in Excel - Simplify complex formulas & Increase execution speed
2:43
DAX Magic - Disconnected Slicers in Power BI. Example for changing the currency
Data Analytics Central
DAX Magic - Disconnected Slicers in Power BI. Example for changing the currency
4:37
SOLVER in Excel CLEARLY EXPLAINED - Transportation optimization solution
Data Analytics Central
SOLVER in Excel CLEARLY EXPLAINED - Transportation optimization solution
4:19
Power BI - UK date format DD-MM-YYYY error - SOLVED
Data Analytics Central
Power BI - UK date format DD-MM-YYYY error - SOLVED
1:52
VBA code to discover and summarize all ERRORS in all Worksheets
Data Analytics Central
VBA code to discover and summarize all ERRORS in all Worksheets
2:14
VBA code to discover overlapping PIVOT TABLES in Excel
Data Analytics Central
VBA code to discover overlapping PIVOT TABLES in Excel
2:11
Saved by VBA - Unhide different sheets with individual password
Data Analytics Central
Saved by VBA - Unhide different sheets with individual password
3:47
Python for Dummies - Introduction to Pandas by Excel analogy
Data Analytics Central
Python for Dummies - Introduction to Pandas by Excel analogy
7:47
Python for Dummies - Numpy Arrays' Shape and Dimensions Clearly Explained
Data Analytics Central
Python for Dummies - Numpy Arrays' Shape and Dimensions Clearly Explained
7:54
DAX for SQL Folks - DAX as a Query Language
Data Analytics Central
DAX for SQL Folks - DAX as a Query Language
9:19