Tag feed

#powerquery

30 posts10 followers

Explore Hashnode

Alternatives

Trending tags this week

YVYash Vardhan Vashisthapower-bi-series.hashnode.devJan 26 · 8 min read

Extraction, Transformation & Load in Power BI

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 ...

0

NRNorman Reynaldo Sabillon Castronormansabillon.hashnode.devSep 11, 2025 · 9 min read

Capítulo 4: Limpieza de Datos - Traduciendo tus Primeros Pasos de Power Query a Pandas

¡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...

0

NRNorman Reynaldo Sabillon Castronormansabillon.hashnode.devAug 26, 2025 · 9 min read

El Primer Paso - Conectando a Datos en Power Query vs. Python con Pandas

¡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...

0

TSTanmay Sharmayoutube-is-not-just-entertainment.hashnode.devAug 24, 2025 · 2 min read

🚀 Building a YouTube Content Intelligence Dashboard (SQL + Python + Power BI)

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...

0

BABhargavi Adeputhefabricinsider.hashnode.devJul 23, 2025 · 8 min read

“Power Query Deep Dive: Combining, Grouping & Advanced Transformations”

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...

0

BABhargavi Adeputhefabricinsider.hashnode.devJul 16, 2025 · 4 min read

How to Clean and Transform Data in Power BI Using Power Query

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...

0

JCJogleen Caliponexcel-analysis.hashnode.devMay 7, 2025 · 7 min read

Enhanced Sales Insights with a Dashboard Built on Power Pivot and DAX

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...

0

ATAhamad Tawsif Chowdhuryahamad.hashnode.devMar 20, 2025 · 2 min read

Power BI: Create Dynamic Queries Using M Code Parameters

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...

0

ATAhamad Tawsif Chowdhuryahamad.hashnode.devMar 19, 2025 · 2 min read

Power BI - Custom Functions in Power Query M to Reuse Blocks of Code

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...

0

ATAhamad Tawsif Chowdhuryahamad.hashnode.devMar 12, 2025 · 3 min read

Power Query UI vs M Code - How to Unlock Advanced Data Transformations

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 ...

0

#powerquery

Search Hashnode

#powerquery

Explore Hashnode

Trending tags this week

Extraction, Transformation & Load in Power BI

Capítulo 4: Limpieza de Datos - Traduciendo tus Primeros Pasos de Power Query a Pandas

El Primer Paso - Conectando a Datos en Power Query vs. Python con Pandas

🚀 Building a YouTube Content Intelligence Dashboard (SQL + Python + Power BI)

“Power Query Deep Dive: Combining, Grouping & Advanced Transformations”

How to Clean and Transform Data in Power BI Using Power Query

Enhanced Sales Insights with a Dashboard Built on Power Pivot and DAX

Power BI: Create Dynamic Queries Using M Code Parameters

Power BI - Custom Functions in Power Query M to Reuse Blocks of Code

Power Query UI vs M Code - How to Unlock Advanced Data Transformations