Posts filed under Data Modeling

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

Posted on September 5, 2025 and filed under Livestreams, Visualizations, Reporting, Data Modeling.

(Livestream Replay) Communication is the New Code: Beyond Copy/Paste with GPT's (w/ Kurt Buhler)

DESCRIPTION 📄

The landscape of Power BI development is rapidly evolving as AI tools transform how we approach data modeling, DAX development, and report creation. While many professionals are familiar with ChatGPT, the ecosystem of AI assistance has expanded dramatically, offering specialized tools that can revolutionize your Power BI workflow.

In this comprehensive session, we'll explore cutting-edge AI tools that go far beyond basic chatbots:

🤖 Claude Desktop & MCP Servers - Discover how Claude's advanced reasoning capabilities and Model Context Protocol (MCP) servers can provide deeper insights into your data models, suggest optimizations, and help debug complex DAX expressions with unprecedented accuracy.

⚡ GitHub Copilot for Power BI - Learn how this code completion tool adapts to Power BI development, accelerating DAX writing, M queries, and even documentation generation.

🔍 Advanced AI Workflows - See real-world demonstrations of AI-assisted Power BI development, from automated measure generation to intelligent data modeling suggestions.

We'll provide an honest assessment of these tools - the goods (incredible productivity gains), the bads (current limitations), and the uglies (potential pitfalls and over-reliance risks). You'll leave with practical strategies to integrate these AI tools into your daily Power BI development process.

Whether you're a seasoned Power BI developer or just getting started, this session will show you how "communication truly is the new code" in our AI-augmented world.

GUEST BIO 👤

Kurt Buhler is a renowned Power BI expert and prolific content creator. Follow his insights and tutorials at [Kurt's Blog] and connect with the community using #PowerBI #AITools #DataAnalytics #DAX #PowerPlatform #ArtificialIntelligence #DataModeling #BusinessIntelligence

RELATED CONTENT 🔗

Data Goblins

Posted on August 22, 2025 and filed under Livestreams, AI, Reporting, Data Modeling, Copilot.

(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

Posted on April 4, 2025 and filed under Livestreams, Data Modeling, Reporting.

(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