Skillwave Training
@skillwave_
Followers
2K
Following
2K
Media
1K
Statuses
3K
Your #1 resource for online training on Power BI, Power Query, Power Pivot, and Excel
Joined March 2015
Are you an experienced #PowerBI user thinking of taking Microsoft's PL-300 #DataAnalyst exam? Matt Allington has you covered with this on-demand training. Understand the depth & breadth of the exam, and see where you need to spend more time preparing. See https://t.co/w5SnA1yzyD
0
0
0
Have you ever wanted to add your favourite icons to the QAT (Quick Access Toolbar) in the #PowerQuery editor in #Excel or #PowerBI? 🤔 Wonder no more, as @kpuls shows you how! Check out how he added the "Detect Data Types" button to the Power Query QAT:
0
1
1
#BusinessIntelligence and #DataAnalytics are the driving force behind informed decision-making and sustainable growth for organizations of all sizes. Investing in your knowledge can be a game-changer, and our #Excel and #PowerBI training can help. Go to https://t.co/hVQY0Xk1gy
0
0
0
#DAX can be intimidating, even for experienced users of #PowerBI and #Excel #PowerPivot. 😫 But our Supercharge Power BI training by expert Matt Allington will help you understand DAX, turning you data into actionable insights. 😀 Enroll today at https://t.co/nW0AdmDYVU
0
0
0
A lively debate broke out in our latest AKA when an attendee asked, “When should I use a timeline instead of a slicer to filter dates?” Cue @kpuls favorite answer: “It depends.” 😄 Understanding the differences can completely change how your audience explores a #PivotTable.
0
0
0
Don't forget: daylight savings ends in North America on Sunday, November 2. ☀️ Luckily, our #PowerQuery recipe for converting a UTC DateTime to a Local DateTime is daylight savings aware. Get the full recipe collection at https://t.co/EQYEQyeXPk
#Excel #PowerBI #DataAnalytics
0
0
0
Nice trick!
While performing Grouping in Power Query, you might want to concatenate the values instead of summarizing them. For all those times, here is a neat trick ✌️. I’ve covered many more tips and tricks like this in my #PowerQuery book, Grab your copy here - https://t.co/aHLjhLIj7C
0
0
0
#PowerQuery doesn't have a great concept of row context, making it very difficult to compare values across rows. In this episode of Monkey Shorts, @kpuls demonstrates a super-cool black magic technique that allows you to do exactly that.🧙♀️ https://t.co/G61Gan5I2Y
#Excel #PowerBI
0
0
0
Another happy student! ⭐️⭐️⭐️⭐️⭐️ Elevate your #FinancialReporting game with our advanced #Excel #PowerPivot course by @kpuls. Learn how to correctly lay out chart of accounts, build P&L measures, and generate Balance Sheet measures using #DAX. Enroll at https://t.co/mT2zxDPIQk
0
0
1
The latest edition of our newsletter has just gone out! 📧 Stay up-to-date on what's new in #PowerBI, #Excel, and Monkey Tools, content from our experts, and info on specials, events, and courses - subscribe at https://t.co/53Vtnb8oSm We'll also send a free #PowerQuery eBook. 📗
0
0
1
In an AKA session, @kpuls demo'd a #DAX pattern to suppress zeros dynamically so only meaningful values remain. Watching empty rows of zeros vanish instantly in a #PivotTable was one of those deeply satisfying #Excel moments we love. A small tweak can deliver the biggest clarity!
0
0
0
Following up on yesterday's video about how to "un-fill" in #PowerQuery, here is @kpuls' original article about how to keep only the first instance and replace all subsequent repeating values with the "null" keyword: https://t.co/zEqf1yCnRw
#Excel #PowerBI #DataPreparation
excelguru.ca
Recently I received a question on how to Unfill in Power Query - remove all duplicate instances of a value, replacing them with null
0
0
0
#PowerQuery's fill ⬇️/fill ⬆️ feature is amazing, but what if you need to "un-fill" a selection for some reason? There may not be an un-fill command in the UI, but that doesn't prevent us from doing it! In this Monkey Shorts, @kpuls will show you how:
0
0
0
One of our newest AKA attendees joined this week with a familiar #Excel headache: “Every month I download new CSVs from our billing system – and every month I spend hours cleaning them up.” 😭 @kpuls showed how #PowerQuery can automate every step with single refreshable query.
0
0
0
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 data insights. 📊🔍 Enroll today at https://t.co/QVSEWda2Uj
0
0
0
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 https://t.co/EQYEQyeXPk
#Excel #PowerBI #DataTransformation
0
0
0
Here's where you can get some sweet #DataViz merch!
Some have asked where they can pick up my classic dataviz coasters. If you're interested, they're now available on my Etsy shop, along with a bunch of other dataviz-related things like shirts, cheatsheets, posters, and more. https://t.co/t3O9jsNnq6
0
0
0
Nice to see this option in #PowerBI!
New table column headers auto-size option in Power BI: grow to fit!
0
0
0
AKA "number rows by partition" this is a super useful trick to have in your #PowerQuery arsenal. The goal is to provide each item in a group with a row number, restarting the numbering at row 1 when we move to the next group. @kpuls shows how easy it is:
0
1
0
In an AKA session, we had a spontaneous question about budgeting and #FinancialForecasting techniques. The discussion resulted in a nice forecast sheet built against a #DataModel. It was fully dynamic so that it would update upon refresh, forecasting the next 2 years of sales! 🔥
0
0
0