How To Implement Slowly Changing Dimension Type 1 Using Power Query
Learn how to implement slowly changing dimension type 1 using Power Query, and discover how P3 Adaptive Consulting can help you achieve success with SCDs.
Search Results for: power query
Head to Head: Can ChatGPT Replicate Rob’s Inspired Solution to a Power Query Challenge?
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 […]
Power Query for Power BI – DEC 2024 Copy
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!
Power Query for Power BI – DEC 2024
Forecasting can be complex, but it doesn’t have to be. This webinar explores how Power BI and Microsoft Analytics simplify the process, helping you connect your data, refine demand and inventory planning, and avoid common missteps. We’ll focus on straightforward approaches that deliver results.
Power Query for Power BI – October 2024
Forecasting can be complex, but it doesn’t have to be. This webinar explores how Power BI and Microsoft Analytics simplify the process, helping you connect your data, refine demand and inventory planning, and avoid common missteps. We’ll focus on straightforward approaches that deliver results.
Power Query Training Course Files
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 […]
Level Up Series: Power Query for Excel & Power BI Training Course Files
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 Course Files (Digital Chalk)
Online University Power Query Video Series (Digital Chalk) course files for your upcoming class. We look forward to seeing you in class!
Level Up Series: Power Query for Power BI – June 2024
Forecasting can be complex, but it doesn’t have to be. This webinar explores how Power BI and Microsoft Analytics simplify the process, helping you connect your data, refine demand and inventory planning, and avoid common missteps. We’ll focus on straightforward approaches that deliver results.
Level Up Series: Power Query for Power BI – June 2024
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!
Power Query Saves Christmas w/ Gus Miranda
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.
Working with Lists in Power Query – Let’s Count Words
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.