Power Query: limpia datos desordenados antes de analizarlos en Power BI

In this tutorial, you'll learn how to perform simple and effective data cleaning using Power Query in Power BI. We'll start with an Excel file containing unsorted data in a single column and apply transformations to convert it into a table ready for analysis. We'll see how to split columns by delimiter, use headers, remove unnecessary rows, detect data types, and correct whitespace. We'll also review useful Power Query tools such as column quality, column distribution, and column profiling to better validate our data before loading it into Power BI. Download the files needed for the exercise: https://datdata-my.sharepoint.com/:f:... 🧠 Get a 20% discount on our courses by visiting: https://datdata.com/guille In this video you will learn: How to connect Power BI to an Excel file How to transform data with Power Query How to split a column using a custom delimiter How to use the first row as a header How to remove top rows How to automatically detect data types How to review the data preview How to show whitespace How to use column quality, distribution, and profile How to review applied steps in Power Query How to trim leading and trailing whitespace from each cell 👇 More resources on YouTube: PivotTables for Beginners:    • Tablas dinámicas en Excel: Aprende rápido ...   How to do conditional formatting with field parameters:    • Formato condicional dinámico en Power BI c...   Conditional Columns in Power Query:    • Cómo crear columnas condicionales en Power...   ▶️ Segments 00:00 Welcome 00:34 Dataset presentation – Excel file 01:51 Connecting a file to Power BI – Importing data from Excel 02:12 Transforming data 03:11 Splitting a column by a custom delimiter 05:12 Using the first row as a header 05:26 Removing top rows 05:50 Detecting data type 06:43 Data preview 07:10 Showing whitespace and replacing values 08:21 Column quality, column distribution, and column profile 09:26 Reviewing applied steps 10:16 Trimming whitespace Beginning and end of each cell 🔔 Remember to subscribe to the channel:    / @datdata   💬 Follow and contact Guille at https://linktr.ee/guillermope_ and   / guillermoperdomo   ✅ Follow us on social media: Instagram:   / datdata   Twitter:   / datdatacom   LinkedIn:   / datdata   Facebook:   / datdatacom   Website: https://www.datdata.com