Multiple column transformations
The operations team is pleased with the insights you've given them so far!
Now, they want more information on average occupancy and how the values trend over time. This will help them understand which months of the year generate higher workload pressure.
In this exercise, you will leverage your knowledge of numeric, text, and date/time transformations to get them the necessary insights. Let's get started!
If you lost any progress, load the 3_4_multiple_column_transformations.xlsx workbook from the Exercises folder and open the Power Query editor.
Questo esercizio fa parte del corso
Introduction to Power Query in Excel
Esercizio pratico interattivo
Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi
Inizia esercizio