How to be the hero at work with Power Query & Power Pivot

Опубликовано: 03 Февраль 2024
на канале: Alejandra Horvath

1,914

108

End those long hours of copying and pasting, by automating your reports with Power Query & Power Pivot.

Working files are available here:
https://drive.google.com/drive/folder...

Thanks for watching 😊

#MSExcel #PowerQuery #PowerPivot #AlejandraHorvath #PowerQueryGirl #Empowered2XL #BeTheHero #AutomateReports #SaveTime

0:00 Introduction to Power Query and Power Pivot
0:37 Overview of the final product: Utilities Chart
0:43 Demonstrating the source files (2019-2022)
1:39 Preparing the data for transformation
1:57 Importing data from folder using Power Query
2:18 Transforming binary content into Excel workbooks
4:16 Expanding and promoting headers in Power Query
6:02 Combining multiple tables into one big table
7:18 Creating a connection to the data model
8:04 Accessing and enabling the Power Pivot tab
10:10 Importing additional tables (Accounts and Cost Centers)
12:22 Connecting dimensional and fact tables in Power Pivot
13:30 Creating a PivotTable from the data model
14:00 Configuring PivotTable fields and formatting
16:01 Creating custom measures (Actuals, Budget, Variance)
18:33 Formatting measures in PivotTable
19:05 Adjusting PivotTable layout and creating a chart

Note: Timestamps generated by #ChatGPT