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

(Livestream Replay) Making a Real Report Fully Bilingual: Harder Than you Thought! - with Bernat Agulló

DESCRIPTION 📄

Translating a model metadata does almost nothing in the direction of translating a real report. Translating the data is necessary, and you need to be able to translate titles and display names, even those coming from field parameters. Different strategies are needed to translate the different bits of the model and bring it back to the report so that with a single click everything changes the language. It's a lot of work.

GUEST BIO (Bernat Agulló)👤

Bernat is an enthusiast Power BI developer from Barcelona, part-owner of Esbrina and Data Platform MVP since 2022. He blogs mostly about calculation groups and Tabular Editor C# Scripting, but also about challenges he has found as a consultant. One of his latest challenges has been making a Japanese-only report turn into an English-Japanese report. Other recent highlights include modifying the report layer with a c# script or integrating Visual Studio and VS code with Tabular Editor to leverage GitHub Copilot to author C# Scripts.

RELATED CONTENT 🔗

Blog
LinkedIn
YouTube
GitHub
Bilingual Report Part 1
Bilingual Report Part 2

(Livestream Replay) Building Income Statements in Power BI - with Chris Barber

DESCRIPTION 📄

Profitability is a key metric for any business, as profits can be distributed back to shareholders either directly or indirectly. An income statement—also known as a Profit and Loss (P&L) statement—answers high-level questions such as “What was our net profit last year?” while summarizing key revenue (e.g., product revenue) and expense (e.g., R&D) items.

Unlike static reports, a P&L semantic model provides granular detail, enabling users to explore insights such as “How was R&D spending distributed across projects, fiscal periods, or legal entities?” With a well-structured model, users can analyze financials dynamically through Power BI reports, PivotTables, and Excel formulas.

GUEST BIO 👤

Chris Barber is a Chartered Accountant (ACMA, CGMA), four-time Microsoft MVP, and author of Income Statement Semantic Models. He runs StarSchema.co.uk and has created popular YouTube videos (100K+ views) and courses (1K+ participants) focused on building Profit and Loss (P&L) reports in Power BI.

RELATED CONTENT 🔗

Website
Linkedin

Fixed-Window Charting in Power BI: Auto-Adjusting Calendar Periods

Video by: Reid Havens

Learn how to create a chart that always displays the same number of calendar periods, driven by slicer period selection, and regardless of if there is existing data (yet) for a period. This leverages a [DAX] generated table, relationships, and some auto-magic features. Tune in to learn more!

RELATED CONTENT 🔗

Creating a MTD/QTD/YTD Time Intelligence Slicer