(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.