@skillwave.trainingWith an average rating of 4.88 ⭐ / 5, students LOVE Power Query Academy!
Want to focus on the #DataAnalysis you were actually hired for? Stop repetitive #DataCleansing and #DataPreparation, and start gaining more data insights. 📊🔍
Enroll today at skw-t.com/pqa
@excelguru.ca💡My habit is simple: the first step in any debugging session is clicking Refresh Preview, then checking the loaded output before deciding something is broken.
🧭Takeaway: Refresh the preview before you trust what the Query Editor is showing you.
#DataPreparation #DataAnalytics #BusinessIntelligence
@skillwave.trainingFollowing 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
![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_fullsize/plain/did:plc:ihdq52obivvf6sq3lnalnwrv/bafkreic3owldkbs2x3kxujjl3qafxvataxrkyjyc2lvcrqdbmhc5j7r3x4@png)
@sergiocuellar.bsky.socialAmazon Nova's second post on data preparation for supervised fine-tuning (SFT) dives into advanced strategies like data subset selection, augmentation, and mixing for optimal model training. Measure first before adding more data! #AmazonNova #SFT #DataPreparation
@skillwave.training💡Ken's habit is simple: the first step in any debugging session is clicking Refresh Preview, then checking the loaded output before deciding something is broken.
🧭Takeaway: Refresh the preview before you trust what the Query Editor is showing you.
@mymarketingfile.bsky.socialMost small businesses focus on software licensing fees while ignoring the massive cost of cleaning their messy operational data.
https://cxo.guru/ai-cost-small-business-realistic-breakdown
#SmallBusinessOwner #DataPreparation #TechBudgeting #AISystems
@excelguru.caIt is a small, sneaky bug with a big lesson: consistency in naming conventions saves hours of confused debugging down the road, especially once a tool leaves your own machine.
🧭Takeaway: The bug you can't see is usually the one your brain is auto-correcting for you.