Airport data: Power BI tutorial for advanced users

In today's tutorial we will create a Power BI dashboard from scratch.
It is a Power Bi tutorial for beginners as all the steps are explained in detail, but we are going to do some complex transformations in Power Query and go through the latest updates in Power BI.

Link to excel files: transportstyrelsen.se/sv/luftfart/Statistik/Fly…

To download the sample file, go to our download center, community downloads and get file #40: curbal.com/donwload-center

This are the highlights of this tutorial:
00:00 Intro
06:18 Clean complex data from excel
21:24 Create a function to clean data on multiple excel sheets
23:39 Clean data in multiple excel sheets
26:34. Import multiple workbooks in Power BI
29:32 Create a function to import multiple workbooks in Power BI and clean all the sheets using the same Power Query function.
47:00 Create a Power BI custom calendar - Full tutorial: youtube.com/watch?v=JqVnqMLGWDY
49:59 Change date type to match you date field regional setting
53:10 Drill down functionality in Power BI
55:22 Map cities accurately in Power BI- Full tutorial here: youtube.com/watch?v=fhyfXcsXI9c&ab_channel=…
55:34 Custom colour themes in Power BI - Full tutorial here: youtube.com/watch?v=mnsNteGpPik



SUBSCRIBE to learn more about Power and Excel BI!
youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?su…

Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l

ABOUT CURBAL:
Website: curbal.com
Contact us: curbal.com/contact

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
► Linkedin: goo.gl/3VW6Ky