P3 Adaptive
In this episode, Rob Collie and Justin Mannhardt step onto the data gridiron to test if AI can tackle the complexities of fantasy football data. Rob starts with a Power […]
Please click on the links below to download the files for your upcoming Power Query class. You will want to download both the Course Files AND Reference Card prior to arriving at class. Once […]
Download Level Up Series: Power Query for Excel & Power BI Training course files for your upcoming class. We look forward to seeing you in class!
Online University Power Query Video Series (Digital Chalk) course files for your upcoming class. We look forward to seeing you in class!
Power Query Training Copy-paste? Dragging formulas down? SAME THING EVERY WEEK…? No more. Teach your computer how to build your reports for you. Set and forget! Please note the later […]
Today’s guest, Gus Miranda, shares his story of how reducing friction and creating automation introduced even non-data people to the concept that data quality matters. Most importantly, though, today you will learn the underdog story of how Power Query saved Christmas during the Kronos Hack of 2021. Get the inside scoop from crisis meeting to crisis meeting until the moment when Gus stood up to save the day. While other multi-million-dollar companies were paralyzed, shocked, and attempting to ad-hoc calculate payroll and vacations, often incorrectly, Gus’s task force used Power Query to create an effective solution in time to prevent employees from missing Christmas with their families.
Lists in Power Query are something many people know nothing about. Power Query uses them all the time even though you may not realize it, so if you add some List knowledge to your quiver, you’ll be able to kick your Power Query skills up a notch.
It was an honor to sit down with two of the creators of Power Query, Sid Jayadevan and Miguel Llopis. You get to hear the history of Power Query from their perspective!
I’ll get to parameters for dataflows in a bit. To begin, let’s talk about dataflows. Dataflows are Power Query queries that live outside of Power BI reports and can be refreshed on a schedule within Power BI service.
I loved Nar’s post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality.
We are back to finish our discussion on the visualizations for Comparing Rows in Power Query! How to visualize the prices and daily changes The two metals have very different […]
It is straightforward to compare values between each row in an Excel table and the next row.