PowerBI - Pivot UnPivot
26th Lesson
In this lesson we will understand how to use the #PowerQuery #Pivot and #Unpivot features based on a real case useful for creating a small example dashboard.
=========== S O S T I E N I M I ==================
Subscribe to this channel to access the benefits: / @lodovicodincau
Buy a product: https://lodovicodincau.myspreadshop.it/
Donate: https://www.paypal.com/donate/?cmd=_d...
======= SAFE AND AFFORDABLE SOFTWARE! ==
Office, Windows, Antivirus, VPN, Server: https://mrkeyshop.com/it/?MrKey=484
======= MY EQUIPMENT ===============
Mouse: https://amzn.to/3s1XwF2
Yeti microphone: https://amzn.to/3MDCggU
Microphone without stand: https://amzn.to/3LAoWcS
Yeti filter: https://amzn.to/3KwKAO2
Sony Alpha 6400L: https://amzn.to/3t5cN8u
Elgato Stream Deck: https://amzn.to/3NDf0RM
Elgato Cam Link 4K: https://amzn.to/3NHXtIb
Elgato Facecam: https://amzn.to/3F1Cagk
TC Helicon Mixer: https://amzn.to/3TbTmoZ
RGB keyboard: https://amzn.to/3MGytiL
2k Gaming monitors: https://amzn.to/3vYb7OP
Switch: https://amzn.to/372aYl8
Microsoft 365 Family: https://amzn.to/38H85qc
Microsoft 365 Business: https://amzn.to/3OSDQO2
My name is Excel - troubleshooting: https://amzn.to/3vVBPb1
The Definitive Guide to DAX: https://amzn.to/376c7s2
Prime Student 90 days free: https://amzn.to/3MJ8LKw
============ R I S O R S E ====================
Channel index - Available to subscribers only: https://docs.google.com/spreadsheets/...
DOWNLOAD "Student Plus" subscribers: https://drive.google.com/file/d/1ylPc...
Lesson Chapters:
00:00 Introduction
01:25 Files and exercise
01:54 The springs
03:32 Pivots
06:26 UnPivot
07:25 Target addition in the poured
12:05 The data model
12:40 Chart with Small Multiples
14:51 Let's format the graph
16:10 Let's format the internal area
18:56 Let's create the filters
20:11 Downloads and Greetings
#PowerBI #PowerQuery #Indexes #Modelling