Following up on the Monkey Shorts episode shared yesterday, here's our #PowerQuery Recipe card that outlines the steps to number your data by grouped rows. 👩🍳 You can get the full collection (over 95 handy recipes!) at skw-t.com/pqrecipes
#Excel #PowerBI #DataTransformation #DataPreparation
#Excel #PowerBI #DataTransformation #DataPreparation
![Master Your Data in Excel & Power BI
Pattern Difficulty: Lo Code
Number Grouped Rows Recipe
Initial Preparation
Sort any [Dimension] column(s) to group the data
Sort the [Fact] column -> Descending
Re-apply the column data types
Group the Data
Go to Transform -> Group -> Advanced
Group by the [Dimension] column(s)
Add a new column called “Data” -> All Rows
Add Row Numbers
Go to Add Column -> Custom Column
Name: Custom
Formula: =Table.AddIndexColumn([Data], "Index", 1, 1)
Right click the [Custom] column -> Remove Other Columns
Expand all columns from [Custom]
Re-order the columns if desired
(Image of a Source Table containing data first listed by Group, then category. A second Table With Numbered Rows image shows the addition with an index column where each Category within a Group is numbered sequentially by row.)
DBAs know this output as using SQL’s ROW_NUMBER with PARTITION
For more data patterns, check out our courses at skillwave.training](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:ihdq52obivvf6sq3lnalnwrv/bafkreic3owldkbs2x3kxujjl3qafxvataxrkyjyc2lvcrqdbmhc5j7r3x4)
October 2, 2026 at 5:26 PM
Following up on the Monkey Shorts episode shared yesterday, here's our #PowerQuery Recipe card that outlines the steps to number your data by grouped rows. 👩🍳 You can get the full collection (over 95 handy recipes!) at skw-t.com/pqrecipes
#Excel #PowerBI #DataTransformation #DataPreparation
#Excel #PowerBI #DataTransformation #DataPreparation
Learn how to extract numeric values from filenames, use them in column calculations, and batch-process multiple files—all in one workflow! youtu.be/94JmH6fnStU
#originpro2026b #originlab #originpro #scientificgraphing #datavisualization #dataanalys #dataimport #datacalculation #DataTransformation
#originpro2026b #originlab #originpro #scientificgraphing #datavisualization #dataanalys #dataimport #datacalculation #DataTransformation
September 29, 2026 at 1:13 PM
Learn how to extract numeric values from filenames, use them in column calculations, and batch-process multiple files—all in one workflow! youtu.be/94JmH6fnStU
#originpro2026b #originlab #originpro #scientificgraphing #datavisualization #dataanalys #dataimport #datacalculation #DataTransformation
#originpro2026b #originlab #originpro #scientificgraphing #datavisualization #dataanalys #dataimport #datacalculation #DataTransformation
In this week's episode of Monkey Shorts 🐵🩳, I look at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter: www.youtube.com/watch?v=3hPM...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataTransformation
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataTransformation
Splitting Records with Power Query - Monkey Shorts Episode 040
In this week's episode of Monkey Shorts, Ken looks at how we can split text into columns or rows using Power Query, and why you may want to do the latter.
www.youtube.com
August 21, 2026 at 5:02 PM
In this week's episode of Monkey Shorts 🐵🩳, I look at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter: www.youtube.com/watch?v=3hPM...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataTransformation
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataTransformation
In this week's episode of Monkey Shorts 🐵🩳, @excelguru.ca looks at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter: www.youtube.com/watch?v=3hPM...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataTransformation
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataTransformation
Splitting Records with Power Query - Monkey Shorts Episode 040
In this week's episode of Monkey Shorts, Ken looks at how we can split text into columns or rows using Power Query, and why you may want to do the latter.
www.youtube.com
August 20, 2026 at 4:16 PM
In this week's episode of Monkey Shorts 🐵🩳, @excelguru.ca looks at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter: www.youtube.com/watch?v=3hPM...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataTransformation
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataTransformation
FYI: LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #AI #MarketingTech #DataTransformation #AdTech
LiveRamp opens its agent network to outside builders with new LAB program
LiveRamp today opened its platform to partner-built AI agents through the new LAB program, covering planning, activation, measurement, and data transformation.
ppc.land
June 20, 2026 at 8:11 PM
FYI: LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #AI #MarketingTech #DataTransformation #AdTech
ICYMI: LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #AI #Marketing #DataTransformation #DigitalMarketing
LiveRamp opens its agent network to outside builders with new LAB program
LiveRamp today opened its platform to partner-built AI agents through the new LAB program, covering planning, activation, measurement, and data transformation.
ppc.land
June 18, 2026 at 8:10 PM
ICYMI: LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #AI #Marketing #DataTransformation #DigitalMarketing
LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #LABProgram #AIAgents #DataTransformation #MarketingTech
LiveRamp opens its agent network to outside builders with new LAB program
LiveRamp today opened its platform to partner-built AI agents through the new LAB program, covering planning, activation, measurement, and data transformation.
ppc.land
June 17, 2026 at 8:08 PM
LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #LABProgram #AIAgents #DataTransformation #MarketingTech
FYI: LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #AI #MarketingTech #DataTransformation #AdTech
LiveRamp opens its agent network to outside builders with new LAB program
LiveRamp today opened its platform to partner-built AI agents through the new LAB program, covering planning, activation, measurement, and data transformation.
ppc.land
June 20, 2026 at 8:11 PM
FYI: LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #AI #MarketingTech #DataTransformation #AdTech
ICYMI: LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #AI #Marketing #DataTransformation #DigitalMarketing
LiveRamp opens its agent network to outside builders with new LAB program
LiveRamp today opened its platform to partner-built AI agents through the new LAB program, covering planning, activation, measurement, and data transformation.
ppc.land
June 18, 2026 at 8:10 PM
ICYMI: LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #AI #Marketing #DataTransformation #DigitalMarketing
LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #LABProgram #AIAgents #DataTransformation #MarketingTech
LiveRamp opens its agent network to outside builders with new LAB program
LiveRamp today opened its platform to partner-built AI agents through the new LAB program, covering planning, activation, measurement, and data transformation.
ppc.land
June 17, 2026 at 8:08 PM
LiveRamp opens its agent network to outside builders with new LAB program #LiveRamp #LABProgram #AIAgents #DataTransformation #MarketingTech
Your data is growing.
Your AI is evolving.
But is your ETL platform keeping up?
blog.9cv9.com/top-10-extra...
#ETLSoftware, #ETLTools, #DataIntegration, #DataEngineering, #ELT, #CloudETL, #DataPipelines, #BigData, #DataWarehouse, #DataTransformation, #ChangeDataCapture, #CDC,
Your AI is evolving.
But is your ETL platform keeping up?
blog.9cv9.com/top-10-extra...
#ETLSoftware, #ETLTools, #DataIntegration, #DataEngineering, #ELT, #CloudETL, #DataPipelines, #BigData, #DataWarehouse, #DataTransformation, #ChangeDataCapture, #CDC,
Top 10 Extract, Transform and Load (ETL) Software in 2026
Discover the top 10 ETL software in the world in 2026. Compare features, pricing, pros, cons, and the best data integration platforms.
blog.9cv9.com
July 10, 2026 at 9:13 AM
Your data is growing.
Your AI is evolving.
But is your ETL platform keeping up?
blog.9cv9.com/top-10-extra...
#ETLSoftware, #ETLTools, #DataIntegration, #DataEngineering, #ELT, #CloudETL, #DataPipelines, #BigData, #DataWarehouse, #DataTransformation, #ChangeDataCapture, #CDC,
Your AI is evolving.
But is your ETL platform keeping up?
blog.9cv9.com/top-10-extra...
#ETLSoftware, #ETLTools, #DataIntegration, #DataEngineering, #ELT, #CloudETL, #DataPipelines, #BigData, #DataWarehouse, #DataTransformation, #ChangeDataCapture, #CDC,
🚀Why Learn Power Query?
📊Automate data preparation in #Excel and #PowerBI with intuitive tools
⚡Enhance efficiency with #DataTransformation, #ETL, and #DataAutomation techniques
📈Gain hands-on experience in #BusinessIntelligence and #DataAnalytics
📊Automate data preparation in #Excel and #PowerBI with intuitive tools
⚡Enhance efficiency with #DataTransformation, #ETL, and #DataAutomation techniques
📈Gain hands-on experience in #BusinessIntelligence and #DataAnalytics
What is Power Query?
Learn what is Power Query and discover its benefits, differences from other tools, and how it can enhance your data analysis skills.
www.igmguru.com
February 28, 2025 at 7:43 AM
🚀Why Learn Power Query?
📊Automate data preparation in #Excel and #PowerBI with intuitive tools
⚡Enhance efficiency with #DataTransformation, #ETL, and #DataAutomation techniques
📈Gain hands-on experience in #BusinessIntelligence and #DataAnalytics
📊Automate data preparation in #Excel and #PowerBI with intuitive tools
⚡Enhance efficiency with #DataTransformation, #ETL, and #DataAutomation techniques
📈Gain hands-on experience in #BusinessIntelligence and #DataAnalytics
Developers harness subagents to convert raw data into interactive analyses for publication. Utilizing GitHub, Interactive Claude Artifacts, and Medium's Curated List, they extract insights from years of curated content. #DataTransformation #InteractiveAnalysis https://medium.com/aiguys/data-analysi…
https://medium.com/aiguys/data-analysis-pipeline-with-claude-code-2-486-medium-articles-to-interactive-insights-45d39417334b?source=rss----decdbc13dde6---4
A developer’s journey using specialized subagents to transform raw data into publication-ready, interactive analysis. GitHub repo…
medium.com
September 11, 2025 at 2:44 PM
Developers harness subagents to convert raw data into interactive analyses for publication. Utilizing GitHub, Interactive Claude Artifacts, and Medium's Curated List, they extract insights from years of curated content. #DataTransformation #InteractiveAnalysis https://medium.com/aiguys/data-analysi…
Machine learning boosts performance by applying Kernel methods for non-linear transformations efficiently. #MachineLearning #DataTransformation https://machinelearningmastery.com/kernel-methods-machine-learning-python/
https://machinelearningmastery.com/kernel-methods-machine-learning-python/
machinelearningmastery.com
January 28, 2025 at 4:46 PM
Machine learning boosts performance by applying Kernel methods for non-linear transformations efficiently. #MachineLearning #DataTransformation https://machinelearningmastery.com/kernel-methods-machine-learning-python/
The real teaching moment went beyond the mechanics of #DataTransformation. Sometimes It's best to separate context from detail, transform each piece correctly, and then recombine them once the logic is sound. Trying to force everything in one step often creates silent errors that only show up later.
January 19, 2026 at 5:35 PM
The real teaching moment went beyond the mechanics of #DataTransformation. Sometimes It's best to separate context from detail, transform each piece correctly, and then recombine them once the logic is sound. Trying to force everything in one step often creates silent errors that only show up later.
I showed how we can manually build a custom function in #PowerQuery – complete with a sample transform to update the query in future – for each individual sheet type. From there a little bit of conditional logic, and we’re off to the races! 🐎
#DataTransformation #PowerBI Excel
#DataTransformation #PowerBI Excel
October 21, 2025 at 4:49 PM
I showed how we can manually build a custom function in #PowerQuery – complete with a sample transform to update the query in future – for each individual sheet type. From there a little bit of conditional logic, and we’re off to the races! 🐎
#DataTransformation #PowerBI Excel
#DataTransformation #PowerBI Excel
We had an awesome time at yesterday's Vancouver #PowerBI and Modern #Excel meet-up! Chandeep Chhabra shared lots of practical tips and tricks, including the use of M, to enhance #DataTransformation processes. 📽 Watch the recording here: www.youtube.com/watch?v=bwlX...
#PowerQuery #DataPreparation
#PowerQuery #DataPreparation
www.youtube.com
February 14, 2025 at 8:54 PM
We had an awesome time at yesterday's Vancouver #PowerBI and Modern #Excel meet-up! Chandeep Chhabra shared lots of practical tips and tricks, including the use of M, to enhance #DataTransformation processes. 📽 Watch the recording here: www.youtube.com/watch?v=bwlX...
#PowerQuery #DataPreparation
#PowerQuery #DataPreparation
There's still time to RSVP for tonight's Vancouver #PowerBI and Modern #Excel meet-up! Joseph Yeates will show what's new in PBI. Then, Alejandra Horvath will show how to make #DataTransformation more efficient and effective by using M in #PowerQuery. 🔥
Sign up here: www.meetup.com/vancouver-po...
Sign up here: www.meetup.com/vancouver-po...
Improve Your Data Transformations Using M in Power Query | Alejandra Horvath, Thu, Aug 22, 2024, 5:00 PM | Meetup
**SESSION TRACK:**
Excel & Power BI
**SESSION OUTLINE:**
First, we will take a look at some of the latest features and updates to Power BI Desktop with Joseph Yeates. Next
www.meetup.com
August 22, 2024 at 4:30 PM
There's still time to RSVP for tonight's Vancouver #PowerBI and Modern #Excel meet-up! Joseph Yeates will show what's new in PBI. Then, Alejandra Horvath will show how to make #DataTransformation more efficient and effective by using M in #PowerQuery. 🔥
Sign up here: www.meetup.com/vancouver-po...
Sign up here: www.meetup.com/vancouver-po...
Unlock AI success by solving data foundation challenges. Learn 5 critical strategies for enterprise AI readiness and overcome implementation barriers. Join Hylaine's free webinar on October 15. #AIStrategy #DataTransformation
October 8, 2025 at 2:28 AM
Unlock AI success by solving data foundation challenges. Learn 5 critical strategies for enterprise AI readiness and overcome implementation barriers. Join Hylaine's free webinar on October 15. #AIStrategy #DataTransformation
🧠 Python & Spark SQL Transforms
Use Python for custom logic or Spark SQL for distributed processing. Mix both for maximum control.
Build fast. Iterate faster.
#PythonETL #SparkSQL #DataTransformation #DataPipelines #ETL #OpenSource #OpenETL #DataOmni #BigData #FlexibleEngineering #BuildInPublic
Use Python for custom logic or Spark SQL for distributed processing. Mix both for maximum control.
Build fast. Iterate faster.
#PythonETL #SparkSQL #DataTransformation #DataPipelines #ETL #OpenSource #OpenETL #DataOmni #BigData #FlexibleEngineering #BuildInPublic
July 16, 2025 at 3:30 AM
🧠 Python & Spark SQL Transforms
Use Python for custom logic or Spark SQL for distributed processing. Mix both for maximum control.
Build fast. Iterate faster.
#PythonETL #SparkSQL #DataTransformation #DataPipelines #ETL #OpenSource #OpenETL #DataOmni #BigData #FlexibleEngineering #BuildInPublic
Use Python for custom logic or Spark SQL for distributed processing. Mix both for maximum control.
Build fast. Iterate faster.
#PythonETL #SparkSQL #DataTransformation #DataPipelines #ETL #OpenSource #OpenETL #DataOmni #BigData #FlexibleEngineering #BuildInPublic
What an amazing night at the @BritDataAwards! We are incredibly proud to be here tonight and to be amongst the wider data community.
Come and say hello 👋 if you haven't already.
Best of luck to everyone shortlisted.
#datatransformation #digital #data
Come and say hello 👋 if you haven't already.
Best of luck to everyone shortlisted.
#datatransformation #digital #data
May 20, 2026 at 7:22 PM
What an amazing night at the @BritDataAwards! We are incredibly proud to be here tonight and to be amongst the wider data community.
Come and say hello 👋 if you haven't already.
Best of luck to everyone shortlisted.
#datatransformation #digital #data
Come and say hello 👋 if you haven't already.
Best of luck to everyone shortlisted.
#datatransformation #digital #data
March 17, 2026 at 2:01 PM
From Bronze to Gold layers, our solution restored trust in data and accelerated time to value.
Explore the full case study to see how we’re powering fintech agility 👇
ow.ly/gIrj50WUGxr
#EnterpriseAIAccelerator #DataTransformation #FasterWithBrillio
Explore the full case study to see how we’re powering fintech agility 👇
ow.ly/gIrj50WUGxr
#EnterpriseAIAccelerator #DataTransformation #FasterWithBrillio
Building a Scalable Data Backbone for a European Fintech Leader
Discover how Brillio helped a leading European fintech company modernize its data infrastructure using Microsoft Fabric. The metadata-driven solution improved compliance, reporting, and real-time anal...
ow.ly
September 10, 2025 at 3:58 PM
From Bronze to Gold layers, our solution restored trust in data and accelerated time to value.
Explore the full case study to see how we’re powering fintech agility 👇
ow.ly/gIrj50WUGxr
#EnterpriseAIAccelerator #DataTransformation #FasterWithBrillio
Explore the full case study to see how we’re powering fintech agility 👇
ow.ly/gIrj50WUGxr
#EnterpriseAIAccelerator #DataTransformation #FasterWithBrillio