Post

Skillwave Training
@skillwave.training

A question sent in for our recent 'Ask Ken Anything' (AKA) session tackled a common reporting headache: how do you compare hours logged in a project management system against data from time-tracking software? 🕒 @excelguru.ca walked through a solution he built using #PowerQuery and #PowerPivot. 🧵

Skillwave Training
@skillwave.training

1️⃣ Clean both sources. 2️⃣ Replace "0:00:00" entries with nulls so empty records wouldn't clutter the #PivotTable. 3️⃣ Build shared employee and calendar tables 4️⃣ Write measures to calculate the variance.

Skillwave Training
@skillwave.training

The breakthrough was one small step: The time tracker stored durations, which turned into tiny, meaningless decimals next to the project hours. Using Transform > Duration > Total Hours converted 5 h, 59 m, 50 s into 5.997 hours, making the two systems directly comparable. 💡 No dividing by 24 and 60!

0 reposts0 likes

Skillwave Training
@skillwave.training

🧭Takeaway: When time data won't compare cleanly, make sure you’re using a common data type! Bring your trickiest data puzzles to the AKA and see them solved. Enroll in our #SelfServiceBI (skw-t.com/ssbi) or #Excel Fundamentals (skw-t.com/excelfun) Academies to gain access, or at skw-t.com/aka

skw-t.comSelf Service BI AcademyPrepare to change your company's reporting game forever! In the Self Service BI Academy, Ken Puls will teach you how to use Excel, Power Query, and Power BI together to build robust Self Service BI…