What is Power Query - Beginner Tutorial
Hey everyone, in this video you will learn all the basics of Power Query. Power Query is one of the best tools to automate your workflow in Excel and work faster in Power BI.
Here i'll guide you step by step on how to start using Power Query, at the end of the video you'll be set to transform the way you work. In the next link i provide you with the material used in the video.
Material:https://1drv.ms/u/s!AgTMpj6Dds3QtUN23...
0:00 - Intro
0:19 - What is Power Query
0:39 - Availability
0:57 - How to use Power Query in Excel
2:27 - Power Query Layout
2:50 - How to use Power Query in Power BI
3:25 - Transform Data in Power Query
7:36 - Merging Data in Power Query
8:32 - Loading Data to Excel - Power BI
9:18 - How to refresh data
9:42 - Why you should use Power Query
10:42 - Next Steps
Connect with me:
Instagram: / digital_lvl_up
LinkedIn: / dariosanchezc