(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

(Livestream Replay) Demystifying Copilot in Microsoft Fabric - with Kerry Kolosko & Kurt Buhler

DESCRIPTION 📄

Are you curious about Copilot in Microsoft Fabric but unsure where to start? Join us for an in-depth livestream with Reid Havens, Kerry Kolosko, and Kurt Buhler, as we demystify Copilot and dive into what it can (and can’t) do for you.

In this session, we’ll cover:

  • The different types of Copilot in Fabric and how they work

  • Key features, limitations, and practical use cases for both small businesses and large enterprises

  • Honest discussions on whether Copilot’s cost is justified and how it fits into Microsoft’s vision for Fabric We’ll also touch on challenges like missing functionalities in Fabric, the steep learning curve, and whether Copilot is a distraction or a game-changer for organizations. Expect real talk, practical advice, and insights into what the future might hold.

This is a must-watch for data professionals, tech leaders, and anyone curious about AI-driven tools in Microsoft Fabric. Stick around for the live Q&A—bring your toughest questions!

GUEST BIO (Kerry Kolosko)👤

Kerry Kolosko is a data visualization consultant hailing from Adelaide, South Australia. With several years experience in a variety of roles across a diverse range of industries, along with a background in psychology and a passion for the arts, Kerry brings a considered and creative edge to BI and data visualization. Also a Microsoft Data Platform MVP and an avid blogger, she shares her designs and design tips at her website (link below).

GUEST BIO (Kurt Buhler)👤

Kurt Buhler is a Power BI data goblin, speaker, and consultant. Kurt discovered his passion for working with & analyzing data during his doctoral research in Biomedical Sciences. Since then, he has worked as a consultant and bridge-builder between IT & Business in organizations to derive value from their data using actionable visuals and solutions. He advocates a design-thinking, user-centric approach to data projects to ensure solutions meet business needs and improve effectiveness. He's a lover of cats, tabletop roleplaying games, and all things Power BI & data related.

RELATED CONTENT 🔗

Kerry’s Website
Buy Kerry a Coffee
Kurt’s Website/Blog
Kurt’s LinkedIn

Posted on February 21, 2025 and filed under Livestreams, Copilot, Fabric.

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

Posted on January 28, 2025 and filed under DAX, Data Modeling, Visualizations.

(Livestream Replay) Auto-magically Checking For Broken Visuals in Power BI - with John Kerski

DESCRIPTION 📄

A.K.A - Avoiding the "Grey Box of Death!"

Have you ever updated a semantic model/dataset and didn't realize it broke a visual in a Power BI report? Have you ever seen that "grey box of death" (or your customers call you about it) after making an update to Power BI? In this session, I demonstrate a way to combine Microsoft Playwright and Azure DevOps to automatically test for broken visuals and notify you about those issues.

GUEST BIO 👤

John leverages his 10+ years of technical and government leadership experience to help Federal Agencies, and private sector clients utilize Microsoft products to their fullest potential. His certifications with Microsoft products offers customers a high rate of return when looking to invest in Microsoft solutions.

RELATED CONTENT 🔗

Blog
LinkedIn
Test for Broken Visuals
Automate with DevOps

Posted on January 24, 2025 and filed under Livestreams, Visualizations, Azure.