Mastering Roster & Timesheet Reporting: From Minutes to Millions - with Kane Snyder

DATE/TIME 📅

September 5th at 1:30 PM (Pacific Time)

DESCRIPTION 📄

Ready to transform your workforce data from basic hour tracking into strategic business intelligence? This deep dive takes you through real-world techniques for handling complex timesheet analytics with minute-level precision. We'll tackle the challenging DAX calculations, data modeling considerations, and performance optimizations that make the difference between simple reports and enterprise-grade workforce insights that actually drive decisions.

What You'll Learn:

• Advanced time intelligence DAX for overlapping shifts and complex scenarios

• Data modeling strategies and optimization for granular timesheet data

• Roster vs. actual comparison techniques

• Real-world implementation patterns from enterprise solutions

Perfect for:

Power BI developers, business analysts, and anyone dealing with complex workforce reporting requirements who wants to move beyond basic time summaries to actionable workforce intelligence.

GUEST BIO 👤

I’m Kane Snyder, a Head of Analytics, Principal Fabric Architect and Analytics Practice Lead with deep expertise in Power BI, DAX and Microsoft Fabric. I’ve guided multiple organisations—across banking and finance, tourism, risk management, environmental emissions, HR, IT governance, law, freight, transport and sales—to build end-to-end analytics solutions that balance cost efficiency with business value. I have a background in business management and have held numerous leadership roles both in business and the analytics space.

I live on the Sunshine Coast in Queensland Australia where I spend my time surfing, camping, 4 wheel driving and playing music.

RELATED CONTENT 🔗

SQLBI Events in Progress DAX Pattern
Kanes Blog
Kanes LinkedIn

Dynamic Matrix Columns in Power BI: Show/Hide Based on Row Hierarchy

Video by: Reid Havens

Ever wish your Power BI matrix could respond intelligently to what’s visible in the row hierarchy? In this video, I’ll show you how to create a dynamic matrix where column values, like department, title, or other employee attributes appear or disappear based on what’s selected in your row-level hierarchy.

We’ll combine a few clever modeling tricks to keep your matrix clean, relevant, and user-driven. Tune in to learn more!

RELATED CONTENT 🔗

Field Parameters in Power BI

Create a Variance Line ONLY Between First and Last Values in Power BI

Video by: Reid Havens

Wrap up the Power BI visual calculation series by drawing a variance line between the first and last values in your chart! In this tutorial, you’ll learn how to use two visual calcs to anchor the start and end points, then connect them with a custom line and error bars — perfect for highlighting overall change over time.

RELATED CONTENT 🔗

Visual Calcs in Power BI
Highlight First or Last Value Comparisons in Power BI with Visual Calcs!
Add Positive/Negative Color Error Bars Using Visual Calcs!

Add Positive/Negative Color Error Bars Using Visual Calcs!

Video by: Reid Havens

Take your Power BI visuals to the next level by applying dynamic positive/negative color formatting to your first-to-last comparison line! This tutorial expands on the previous visual calculation setup by adding conditional color cues to highlight trends at a glance, great for dashboards and storytelling. Tune in to learn more!

RELATED CONTENT 🔗

Highlight First or Last Value Comparisons in Power BI with Visual Calcs!
Visual Calcs in Power BI