I've been having a great week doing some consulting work and leading a #PowerQuery course for a private client. There's nothing better than introducing people to the #DataCleaning and #DataPreparation magic performed by Power Query! 📈🧹
Contact us for private team training: excelguru.ca/contact-us/
5 Data Preparation Methods for Domain-Specific LLMs
Learn how to prepare high-quality data that transforms generic models into domain experts: www.dataversity.net/articles/5-d...
#LLMtraining #datapreparation #AImodels #syntheticdata
Feature Engineering Best Practices: A Guide for Data Scientists
#FeatureEngineering #DataScience #MachineLearning #MLBestPractices #DataPreparation #DataPreprocessing #AI #ModelBuilding #BigData #Analytics #DataEngineering #MLModels #TechInsights #EkasCloud
How ai training data services Solve the Biggest Data Preparation Challenges in Machine Learning
AI training data services deliver clean, unbiased labeled data to boost accuracy, cut rework, and speed models to production.
shorturl.at/QvjPP
#MachineLearning #DataPreparation #AITrainingData #MLOps
Get Professional Data Preparation for Smarter Machine Learning
Before your AI can learn, your data needs to be clean, structured, and ready to perform.
Let your AI learn from the best-prepared data: www.hitechbpo.com/data-prepara...
#datapreparation #datapreparationforML
In this video, I demonstrate how to use #PowerQuery to perform approximate matching when working with multiple criteria. Inspired by a student question, I'll walk through the solution using a fictitious employee salary dataset: www.youtube.com/watch?v=ZZC7...
#Excel #PowerBI #DataPreparation
Watching the #PivotTable update automatically after a simple refresh without having to touch the query makes the payoff obvious. 🔁😎
#BusinessIntelligence #DataAnalytics #DataPreparation
🧭Takeaway: The best automation is the one that fits how your data actually arrives.
LAOMUSIC ARTS 2025
presents
I just finished the course “Data Preparation, Feature Engineering, and Augmentation for AI Models” by Dan Sullivan!
Check it out:
www.linkedin.com/learning/dat...
#lao #music #arts #laomusicarts #ai #retrievalaugmentedgeneration #datapreparation #featureengineering
LAOMUSIC ARTS 2025
presents
I just finished the course “Data Planning, Strategy, and Compliance for AI Initiatives” by Dan Sullivan!
Check it out:
www.linkedin.com/learning/dat...
#lao #music #arts #laomusicart #ai #aistrategy #datastrategies #datapreparation #datastorage
In this Monkey Shorts video 🐵🩳, I'll show you how #PowerQuery's 'Column Profiling' tools work, and how I set my defaults for every day use: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
In this Monkey Shorts video 🐵🩳, @excelguru.ca shows how #PowerQuery's 'Column Profiling' tools work, and how he sets his defaults for every day use: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
While functions in #Excel and #PowerQuery are often quite similar, there are some key differences. The most important thing to remember is that all functions in Power Query, whether text, logic or anything else, are case sensitive - “if” is not the same as “IF”.
#DataAnalytics #DataPreparation
Ever noticed that you have to refresh your #PowerQuery twice in order to get the changes to show up in your #Excel #PivotTable? In this episode of Monkey Shorts, I'll show you how to fix this issue. 👏
www.youtube.com/watch?v=gTtt...
#DataPreparation #DataAnalyticsTools #BusinessIntelligenceTools
Ever noticed that you have to refresh your #PowerQuery twice in order to get the changes to show up in your #Excel #PivotTable? In this Monkey Shorts, @excelguru.ca will show you how to fix this issue. 👏
www.youtube.com/watch?v=gTtt...
#DataPreparation #DataAnalyticsTools #BusinessIntelligence
Discover the top 10 best data preparation software for 2026 to streamline, clean, and transform data for smarter business insights.
blog.9cv9.com/top-10-best-...
#DataPreparation, #DataPreparationSoftware, #Top10DataPreparationTools, #BestDataPreparationSoftware2026,
In this Monkey Shorts episode, I show the first #PowerQuery setting I change when I install #Excel. 👊 www.youtube.com/watch?v=ZAY7...
#DataPreparation #DataAnalytics #BusinessIntelligence
In this Monkey Shorts episode, @excelguru.ca shows the first #PowerQuery setting he changes when he installs #Excel. 👊 www.youtube.com/watch?v=ZAY7...
#DataPreparation #DataAnalytics #BusinessIntelligence
🚀 Replay Available! DP-600 Lab – Create and Use Dataflows (Gen2) in Microsoft Fabric
🎥 Watch the full live stream:
www.youtube.com/live/hPAs6mH...
#MicrosoftFabric #DP600 #FabricAnalyticsEngineer #DataflowsGen2 #PowerQueryOnline #DataEngineering #DataPreparation #PowerBI #FabricCommunity
Up to 80% of an #AI project’s time goes to data prep — and it’s worth it. 🧠 Clean, labeled, bias-free data turns AI from hype into real impact. Check out our practical playbook on making your data #AI-ready 👉 www.instinctools.com/blog/prepari...
#instinctools_services #data #datapreparation
If your #ML model won’t improve no matter how you tune it, the issue might be your data. 🔍 Catch problems early and make it #AI-ready! Our playbook shows how to build a solid data prep foundation 👉 www.instinctools.com/blog/prepari...
#datapreparation #ArtificialIntelligence
Watching her realize she’d never have to “copy-paste and clean” again was pure magic! #DataPreparation #DataCleanup
The best part? Other students jumped in with their own automation tips, showing just how collaborative the @Skillwave.Training community really is. 🤝
Your data may be haunted by bias, duplicates & outliers 👻 Ignore them—and your #ML pipeline turns into a nightmare. Prep data right, and #AI results become a treat 🎃 Read our playbook 👉 www.instinctools.com/blog/prepari...
#instinctools_services #data #datapreparation #ArtificialIntelligence
Following up on the video I shared last week about how to "un-fill" in #PowerQuery, here is my original article about how to keep only the first instance and replace all subsequent repeating values with the "null" keyword: excelguru.ca/unfill-in-po...
#Excel #PowerBI #DataPreparation
Following up on yesterday's video about how to "un-fill" in #PowerQuery, here is @excelguru.ca's original article about how to keep only the first instance and replace all subsequent repeating values with the "null" keyword: excelguru.ca/unfill-in-po...
#Excel #PowerBI #DataPreparation
Watching her realize she’d never have to “copy-paste and clean” again was pure magic! #DataCleanup #DataPreparation
The best part? Once the other participants heard what she was working on, they jumped in with their own tips, showing just how collaborative the Skillwave community really is. 🤝
(Skillwave Training logo) Review inside speech bubble: "Excellent sequence of information. Videos provide good examples." M.W. (5 stars) Power Query Academy Free eBooks with registration: - Master Your Data with Excel and Power BI - Power Query Recipes
With an average rating of 4.92 ⭐ / 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 insights from your data. 📊🔍
Enroll today at skw-t.com/pqa
#Excel #PowerBI
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 90 handy recipes!) at skw-t.com/pqrecipes
#Excel #PowerBI #DataTransformation #DataPreparation
Transform Data in Power Query Part 79 :
Transform Data in Power Query lets you clean, shape, and prepare your data before loading it into Excel for analysis.
#PowerQuery #ExcelTips #DataCleaning #TransformData #ExcelTutorial #DataPreparation #ExcelPowerQuery #ExcelMastery
The best part of testing is the learning, but the prep work? Tedious and error-prone.
What if you had an AI "genie" to handle the menial steps?
www.youtube.com/watch/WBU33i...
#SoftwareTesting #AI #DataPreparation #TestAutomation #APITesting #QA
#DataPreparation in #PowerBI can be very simple using #PowerQuery #ColumnByExample #AI feature. It works well with #PowerBIDesktop #Excel #Dataflow in #PowerBIService and #MicrosoftFabric, all editions of #PowerQueryEditor
Today, in this video, I explained how that works:
youtu.be/kKHBpsuAwKE