[Power BI] How to Clean and Transform MESSY Data using Power Query in Power BI

Описание: 🚨Start creating interactive and dynamic reports with Power BI now. Learn about the Power BI Experience Course: https://powerbiexperience.com/en/cour...

Take advantage of the promotional discount to take the Course and join the Power BI Experience Community.

---------------------------------------------------------------------------------------------------

Download materials: https://bit.ly/lessonspbi_

---------------------------------------------------------------------------------------------------

In this video we will talk about Power Query, the responsible for data processing and structuring in Power BI.

You will learn how to use Power Query to automate the handling of those reports that are extracted from the ERP, but are never the way you need them.

I will show you step by step how to structure your data in Power Query to avoid rework, and we will do this using several cases that are very common in the daily life of those who work with Power BI, will be three distinct examples of Excel files.

Learn once and for all to manipulate Excel files (xlsx) using Power Query in Power BI, just play the video there! 🚀🚀🚀

---------------------------------------------------------------------------------------------------
Content of this video:

00:00 – Introduction
01:21 – Separate column by delimiter
04:54 – Import and transform many files Excel
17:15 – What’s happen When I Add a new file
18:26 – Transform file expense construction

---------------------------------------------------------------------------------------------------

Other Recommendations:

From ZERO to Dashboard: How to Automate your Reports with Power BI:    • [Power BI] From ZERO to Dashboard: How to ...  

Guide to Data Modeling, DAX, Filter Context and CALCULATE function:    • [Power BI] Guide to Data Modeling, DAX, Fi...  

Storytelling and the ART of building IMPRESSIVE Dashboards in Power BI:    • [Power BI] Storytelling and the ART of bui...  

---------------------------------------------------------------------------------------------------

👉 Subscribe to our channel:    / aprendapowerbi  
👉 Activate notifications (click on the bell 🔔)!
👉 Leave your like!

---------------------------------------------------------------------------------------------------

Follow all about Power BI on the other social networks:

👉 Telegram: https://t.me/PBIeXperience
👉 Instagram:   / leokarpa  
👉 LinkedIn:   / leokarpa  

#powerbi #leonardokarpinski #powerbiexperience