Jan 26 · 8 min read · Executive Summary This article is the first one of this series where I will focus on helping beginners to be comfortable with building reports on Power BI. Ultimately, you will be able to create a report similar to the one on the cover image of this ...
Join discussion
Sep 11, 2025 · 9 min read · ¡Bienvenido de nuevo a "El Puente al Machine Learning"! En el capítulo anterior, conectamos nuestro entorno a un origen de datos. Ahora, vamos a arremangarnos y hacer lo que define el 80% del trabajo de un analista: la limpieza de datos. Seguro te ha...
Join discussion
Aug 26, 2025 · 9 min read · ¡Bienvenido al tercer capítulo de "El Puente al Machine Learning"! En el post anterior, instalamos nuestro laboratorio de ciencia de datos. Ahora que tienes tu entorno listo, es hora de hacer lo que mejor sabemos hacer: conectarnos a un origen de dat...
Join discussion
Aug 24, 2025 · 2 min read · YouTube is not just entertainment — it’s data gold. Every like, view, and comment tells a story. In this project, I built a YouTube Content Intelligence Platform using SQL, Python, and Power BI to uncover what drives engagement, subscriber growth, an...
Join discussion
Jul 23, 2025 · 8 min read · Power Query is not just about basic cleaning—it is a powerhouse for transforming, combining, and preparing data for advanced reporting in Power BI. In this post, we will dive into some powerful features like merging, appending, grouping, column trans...
Join discussionJul 16, 2025 · 4 min read · Power Query is a tool in Power BI that helps you get, clean, and prepare your data before analysis. It has a graphical interface to connect to data sources (like Excel, CSV, or databases) and a Power Query editor to apply transformations easily. Usin...
Join discussionMay 7, 2025 · 7 min read · Workflow Consolidate all data Build a data model Established foundational DAX measures for KPIs Store each KPI in the Power Pivot Develop a dashboard designed for end users, allowing them to understand the results easily. Tools Tools:MS Excel...
Join discussion
Mar 20, 2025 · 2 min read · Dynamic queries let you adapt your data transformations on a whim without having to manually edit each step in the transformation that would be affected by the change. This can be done using parameters. What are Parameters in M Code? Parameters are v...
Join discussion
Mar 19, 2025 · 2 min read · Power BI's data transformation has two interfaces, there is the Graphical UI where you can select different preselected steps to put them in a certain order and there's also the M code editor where you can dive straight into the code behind the trans...
Join discussion
Mar 12, 2025 · 3 min read · Most Power BI users rely on the Power Query UI for data transformations, this is the window that opens up when you click "Transform data" in the Home tab. Clicking and adding different steps in the Transform window actually generates M code. opening ...
Join discussion