Actual vs. Budget Analysis with Power Query and Power Pivot

Actual vs. Budget Analysis with Power Query and Power Pivot

3.146 Lượt nghe
Actual vs. Budget Analysis with Power Query and Power Pivot
A step by step tutorial of an Actual vs. Budget sales analysis using Power Query And Power Pivot. A Data Model that contains two Transactional Tables (Actual & Budget). We will make some smart transformations with Power Query and create a few DAX expressions. CHAPTERS 02:35 Power Query: Column from Examples 08:50 Power Query: Change Date Type with Locale 10:30 Power Pivot: Create relationships 12:00 Power Pivot: Create DAX Measures #powerquery #powerpivot #dax #excel #dataanalysis