Categories

Simple and easy transformations for a better analysis - Power Query

Published: 13 January 2024
on channel: Alejandra Horvath
517
30

Simple transformations can help you to optimize your data, making your analysis more efficient.

Hope you will find this useful. 😉

Subscribe and share. 👍

Working file is available here:
https://docs.google.com/spreadsheets/...


Thanks for watching 😊

#PowerQuery #MSExcel #DataAnalysis #DataTransformation #DataAnalyst #PivotTables #PowerQueryGirl #AlejandraHorvath #Empowered2XL #TimeSavingTips #AutomateYourWork

play_arrow
163
2

Hand Gesture OpenCV and QT C++ and Raspberry

Hand Gesture OpenCV and QT C++ and Raspberry
play_arrow
8,504
21

⚠️Porque me aparece SERVICIOS de GOOGLE PLAY sigue DETENIÉNDOSE: SOLUCIÓN

⚠️Porque me aparece SERVICIOS de GOOGLE PLAY sigue DETENIÉNDOSE: SOLUCIÓN
play_arrow
19
3

Деньги правят миром. Секрет прост

Деньги правят миром. Секрет прост
play_arrow
328
10

Эко Паста для Шугаринга

Эко Паста для Шугаринга "Марокканская роза" описание и способ применения
play_arrow
219
3

Shadow of the Tomb Raider 4K - Wonder Woman Outfit and Claire Redfield Hair - Mod -

Shadow of the Tomb Raider 4K - Wonder Woman Outfit and Claire Redfield Hair - Mod -
play_arrow
112
9

What you don't know about conventional loans

What you don't know about conventional loans
play_arrow
19,469
1K

Особое мнение / Виталий Манский // 10.05.21

Особое мнение / Виталий Манский // 10.05.21
play_arrow
638
2

StalkerOnline Квест Избавление от бесов От Вани Ад

StalkerOnline Квест Избавление от бесов От Вани Ад
Related
play_arrow
Running Totals - Power Query

Running Totals - Power Query
play_arrow
Table Schema can help you to select columns to keep (or remove)

Table Schema can help you to select columns to keep (or remove)
play_arrow
Dynamically Remove Empty Columns in Power Query

Dynamically Remove Empty Columns in Power Query
play_arrow
Double Headers - Power Query

Double Headers - Power Query
play_arrow
How I use the =DROP( ) function in Excel! - MS365

How I use the =DROP( ) function in Excel! - MS365
play_arrow
AGGREGATE - This Excel Function is a Real Treasure!

AGGREGATE - This Excel Function is a Real Treasure!
play_arrow
For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables

For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables
play_arrow
Dynamically Keep a Single Value Using Power Query - Bonus: Create a Custom Function!

Dynamically Keep a Single Value Using Power Query - Bonus: Create a Custom Function!
play_arrow
#Flashfill #AlejandraHorvath #Empowered2XL #Tutorial #MSExcel

#Flashfill #AlejandraHorvath #Empowered2XL #Tutorial #MSExcel
play_arrow
Filter With Wildcard #excel #tutorial

Filter With Wildcard #excel #tutorial
play_arrow
You Can Filter Several Columns At Once in Power Query!

You Can Filter Several Columns At Once in Power Query!
play_arrow
Are you creating the query in the same workbook? Do it fast and efficiently!

Are you creating the query in the same workbook? Do it fast and efficiently!
play_arrow
How Do You Decide =ARRAYTOTEXT( ) or =TEXTJOIN( ) ?

How Do You Decide =ARRAYTOTEXT( ) or =TEXTJOIN( ) ?
play_arrow
How to be the hero at work with Power Query & Power Pivot

How to be the hero at work with Power Query & Power Pivot
play_arrow
Optimize Table.SelectRows for better results! #PowerQuery

Optimize Table.SelectRows for better results! #PowerQuery
play_arrow
Convert Text To Date And Group By Quarters - Power Query

Convert Text To Date And Group By Quarters - Power Query
play_arrow
How To Start Working With Pivot Tables In Excel

How To Start Working With Pivot Tables In Excel
play_arrow
M - Lists Overview

M - Lists Overview
play_arrow
Simple and easy transformations for a better analysis - Power Query

Simple and easy transformations for a better analysis - Power Query
play_arrow
How I Dynamically Transform Column Names With Power Query

How I Dynamically Transform Column Names With Power Query
play_arrow
How I Replace Special Characters In a Text

How I Replace Special Characters In a Text
play_arrow
Table.TransformRows or Table.TransformColumns

Table.TransformRows or Table.TransformColumns
play_arrow
Replace Multiple Values With Power Query - Short Version

Replace Multiple Values With Power Query - Short Version
play_arrow
WRAPROWS & WRAPCOLS -You Will Love Them!!!

WRAPROWS & WRAPCOLS -You Will Love Them!!!