Havens ConsultingLearn how to compare the first or last values in a Power BI chart using visual calculations! In this tutorial, I’ll walk you through adding a dynamic line marker and error bar comparison that highlights the change from beginning to end, perfect for trend visuals and executive summaries.
Highlight First or Last Value Comparisons in Power BI with Visual Calcs!Havens Consulting2025-06-17 | Learn how to compare the first or last values in a Power BI chart using visual calculations! In this tutorial, I’ll walk you through adding a dynamic line marker and error bar comparison that highlights the change from beginning to end, perfect for trend visuals and executive summaries.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #visualcalcs #visualcalculationsGrow Your Skills & Visibility in Microsoft Fabric (with Shannon Lindsay)Havens Consulting2025-10-04 | Fabric Community Contests are a great way to get hands-on with Microsoft Fabric, grow your skills, and build visibility in the data community. In this livestream, we'll take a closer look into recent Fabric Community Contests - including Notebooks, Translytical Task Flows, and the Dataviz World Champs. We'll share how participants have gained confidence, recognition, and even new career opportunities.
We’ll also preview upcoming contests in the Fabric Skills Fest and share tips for building a portfolio that stands out. Whether you’re looking to practice your skills, share your work, or simply get inspired, this session will show you how contests can open doors.
GUEST BIO (Shannon Lindsay) 👤 Shannon’s background in global public health has shaped her commitment to community and accessibility, guiding her work leading Fabric Community Engagement at Microsoft. She loves helping people find their place in the data world—a journey that began when she first discovered the magic of Power Query, sparking a lasting enchantment with Microsoft BI tools. Now, whether she’s conjuring up data insights with the Workout Wednesday team, gathering with fellow data witches in user groups, or brewing up connections, Shannon’s focus is on making data feel less intimidating. She’s dedicated to building a welcoming community where data pros and newcomers alike can learn, grow, and connect—casting spells of empathy and connection to bring people together.
#PowerBI #DataViz #powerplatform #microsoft #businessintelligence #data #excel #datavisualization #dashboard #bi #analytics #community #skills #contestsPower Query DELETING Your Relationships? Heres How to Restore Them Using TMDL!Havens Consulting2025-09-30 | Have your Power BI relationships mysteriously disappeared after changing a Power Query? You're not alone! When you modify Power Query transformations - even seemingly harmless changes - Power BI's data lineage breaks and deletes your relationships. But there's a solution!
In this video, I'll show you how to use TMDL (Tabular Model Definition Language) view to backup your relationships BEFORE making Power Query changes, so you can easily restore them when lineage breaks.
🎯 What You'll Learn:
- How data lineage can break your relationships - How to save your relationships using TMDL view before making changes - How to restore relationships after Power Query modifications delete them - Real-world scenarios where this problem happens (Excel → Database migrations, adding transformations, etc.)
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodelMastering Roster & Timesheet Reporting: From Minutes to Millions (with Kane Snyder)Havens Consulting2025-09-06 | 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 (Kane Snyder) 👤 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.
#PowerBI #DataViz #DashboardDesign #PowerBIChampionship #DataStorytelling #JonSandmann #PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #licensing #capacitySneak Peek: New PBI Multi-Tool Cleanup Features! Themes, Visuals & Bookmark RemovalHavens Consulting2025-08-12 | Get an exclusive first look at the upcoming Power BI Multi-Tool cleanup features! 🧹 This update makes report maintenance easier than ever by automatically removing unused:
• Themes • Visuals • Bookmarks
Streamline your PBIP files, reduce clutter, and keep your Power BI projects running smoothly. Perfect for anyone looking to optimize and organize their reports with just a few clicks.
#PowerBI #PBIP #DAX #DataModeling #PowerBIDesktop #AnalyticEndeavors #BIDynamic Matrix Columns in Power BI: Show/Hide Based on Row HierarchyHavens Consulting2025-07-29 | 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!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #fieldparametersPower BI DataViz Championship: Watch the Winners & Finalists Present Their Reports!Havens Consulting2025-07-26 | 🔥 Join us for a special livestream showcasing the Top 3 finalists from the Power BI DataViz Championship — including Jon Sandmann, the first-ever global champion!
🎨 See the best of Power BI data storytelling as these top-tier report designers walk you through the visualizations that wowed the judges.
👀 In this session, you’ll: ✅ Get behind-the-scenes insights into their design process ✅ See expert techniques for layout, UX, and interactivity ✅ Learn how to craft truly impactful data stories with Power BI
🧠 Whether you're a Power BI beginner or a seasoned pro, this event is packed with inspiration, tips, and creative spark.
📅 Don't miss it — hit that reminder and join the chat live!
GUEST BIO (Injae Park) 👤 Injae Park is a Microsoft Data Platform MVP who combines his technical expertise with a passion for teaching by sharing his insights and practical tips through his YouTube channel @PowerBIPark. Injae's content ranges from beginner tutorials to advanced techniques, and as part of the Power BI Core Visual Representatives - he aims to bridge the MS Developer team with the Power BI community. His education in psychology and economics as well as his experience in consulting gives him a well-rounded perspective on the Power BI Developer experience, making his tutorials both engaging and accessible.
GUEST BIO (Shannon Lindsay) 👤 Shannon is a data and analytics witch with a background in global public health. She’s currently casting spells at Microsoft, working to ensure Power BI is accessible to all users. Shannon spends as much time as possible in the data community, participating in user groups and working with the fabulous Workout Wednesday team.
GUEST BIO (Lakshmi Ponnurasan) 👤 Lakshmi is a Microsoft MVP and certified Power BI specialist known for her creative, insight-driven reports. As a Product Lead, she combines her technical skills with a passion for storytelling and community engagement. A 2025 DataViz Championship finalist, she also shares tips on her blog and mentors aspiring professionals in the data space.
GUEST BIO (Javier Gomez) 👤 Javier is a certified Power BI instructor and founder of one of the largest Spanish-speaking data analytics academies. Originally from Mexico, he began his digital journey at age 9 and has since combined his background in engineering and business to empower others through data. Passionate about making analytics accessible, he now helps professionals visualize and understand their data using tools like Excel and Power BI.
#PowerBI #DataViz #DashboardDesign #PowerBIChampionship #DataStorytelling #JonSandmann #PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #licensing #capacityCreate a Variance Line ONLY Between First and Last Values in Power BIHavens Consulting2025-07-15 | 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.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #visualcalcs #visualcalculationsEverybodys Favorite Power BI & Fabric Topic: Licensing! (with Stephanie Bruno)Havens Consulting2025-07-12 | Many of us would prefer to avoid the topic of Power BI and Fabric licensing like the plague, and it's no wonder why. Between Premium, PPU, Pro, and Free options, Power BI licensing was already complicated enough. With the introduction of Fabric capacities and even more considerations to think through, it can quickly get overwhelming.
But fear not, the witch and wizard are in the house to break it down and simplify it for you by explaining the details and even providing a high-level calculator. We'll have an engaging discussion on some of the nuances and how to decide what you need so you'll be on your way and ready to make some decisions.
GUEST BIO (Stephanie Bruno) 👤 Stephanie is the co-founder and grand high witch at data-witches.com. She is a Microsoft Data Platform MVP who specializes in turning complex data into clear insights using Fabric and Power BI. Before becoming a full-time witch (and like so many of us in this field) she had a long and winding career path. In her case, it was mostly spent working on a shoestring budget at non-profits, where she learned how to get as much as possible accomplished with few resources (the inspiration for the licensing calculator). When not at her computer she can be found chasing after her kids, doing never-ending laundry, mixing cocktails, baking goodies, and planning her next adventure.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodelIntroducing Fabric Workloads & PowerTable for Fabric Data Apps w/ Live Writeback (with Gopal)Havens Consulting2025-07-04 | PowerTable by Lumel is a Fabric workload that enables business users to build no-code, write-back-enabled table applications directly on Microsoft Fabric. It connects live, with full bi-directional sync, to your cloud data warehouse tables including Fabric SQL, Fabric Data Warehouse, Azure SQL, Snowflake, Databricks, and other major data platforms.
PowerTable also integrates seamlessly with your Power BI semantic models, supporting no-code write-back scenarios that are distinct from Translytical Task Flows, which are designed for pro-code use cases.
In this session, you’ll also learn how PowerTable is fundamentally different from traditional table app solutions like Airtable, SmartSheet, or Microsoft Access, offering a fully governed, enterprise-grade approach designed for the Microsoft Fabric ecosystem.
PowerTable by Lumel is a Fabric Workload that allows business users to build no-code, writeback-enabled table apps on Microsoft Fabric. It connects live (with bi-directional sync) to your cloud data warehouse tables in platforms such as Fabric SQL, Fabric Data Warehouse, Microsoft Azure SQL, Snowflake, Databricks and other major data platforms.
Key Capabilities of PowerTable: • Manage dimension tables and flat files within Power BI & Fabric • Create new governed tables from Excel or spreadsheets in minutes • Live sync with Fabric SQL, Fabric DWH, Azure SQL, Snowflake, DataBricks, BigQuery, Redshift, and PostGres database tables • Built-in approval workflows and full audit tracking • Advanced CRUD security, row-level permissions, and governance
GUEST BIO (Gopal Krishnamurthy)👤 Gopal is the Founder and CEO of Lumel. He is a visionary who saw the rise of cloud data platforms and adopted very early on (Snowflake, Databricks, DBT) with Visual BI and successfully divested and exited the consulting business (Visual BI) with the sale to Atos in 2021. When he also saw the BI market consolidating with Power BI, he positioned Lumel to become the #1 Microsoft Fabric and Power BI AppSource Partner. He also predicted the rise of native apps on top of data platforms as organizations look to eliminate data silos as a prerequisite to make their data AI-ready. So, he doubled down on his vision of building an integrated Lumel native app that consolidates planning, master data, reporting, and analytics on top of semantic models and envisions Lumel as the new “Face of Data” for everyday application needs.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #writeback #fabricworkloads #governance #SQL #warehouse #lakehouseAdd Positive/Negative Color Error Bars Using Visual Calcs!Havens Consulting2025-07-01 | 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!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #visualcalcs #visualcalculationsPower BI Core Visuals - Whats New & Exciting! (June 2025)Havens Consulting2025-06-13 | Join us for an exciting discussion on everything NEW and EXCITING from this last quarter (2 2025) that has come out from the Core Visuals Team! Each quarter we'll gather together a rotating list of quests from both the #PBICoreVisuals team plus community members to have an engaging discussion between us and the live audience. Hope to see you there!
GUEST BIO (Injae Park) 👤 Injae Park is a Microsoft Data Platform MVP who combines his technical expertise with a passion for teaching by sharing his insights and practical tips through his YouTube channel @PowerBIPark. Injae's content ranges from beginner tutorials to advanced techniques, and as part of the Power BI Core Visual Representatives - he aims to bridge the MS Developer team with the Power BI community. His education in psychology and economics as well as his experience in consulting gives him a well-rounded perspective on the Power BI Developer experience, making his tutorials both engaging and accessible.
GUEST BIO (Matthew Lee) 👤 Matthew Lee is a dynamic Program Manager at Microsoft based in Seattle, with a proven track record of quickly mastering new domains and driving impact in complex environments . A proud University of Washington alumnus, Matthew brings both technical depth and strategic insight to his role. With hundreds of professional connections and a reputation for adaptability and innovation, he is passionate about sharing practical lessons, fostering collaboration, and inspiring fellow technologists.
GUEST BIO (Jacinda Eng) 👤 Dedicated and customer-centric product manager with experience in the data analytics industry. Excels in cross-functional collaboration, working closely with engineers and designers to ensure the successful launch of innovative products to meet customers’ requirements. A multi-tasker with strong analytical skills to balance driving the development of multiple projects backed by data-driven insights. Enjoys playing the piano and harp along with dancing ballet in her free-time.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #reporting #visualizations #pbicorevisuals #visuals #fieldparametersInvisible (and Built-In) Categorical Sorting Trick for Columns in Power BIHavens Consulting2025-06-03 | Ever wanted your matrix or table in Power BI to sort by a hidden value — without showing that value in the visual?
In this video, I’ll show you a powerful trick using zero-width Unicode characters to embed an invisible sort order directly into your categorical columns. We’ll walk through a demo using a dataset of transaction IDs and regions, and show how you can control sort behavior without cluttering your visuals. Tune in to learn more!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodelIntroducing Power Designer and Embedded Accelerator - Entelexos (with Mike Carlo)Havens Consulting2025-05-31 | This March two new software products were released from Carlo Solutions, Power Designer, and Entelexos. In this session, Mike and Reid unpack these two new software offerings, discuss why these solutions were developed and how they can help your business become more effective with Power BI. Learn about use cases for Power BI embedding, and why you need to thing about a Power BI designer user persona.
GUEST BIO (Mike Carlo)👤 Mike Carlo is a multi-venture entrepreneur and a driving force in the Power BI ecosystem. As the founder of PowerBI.tips, Entelexos, Power Designer, and the world’s most beloved Theme and Wireframe Generator, Mike has been shaping the way professionals build and visualize data since becoming a Microsoft MVP in 2017.
From his early days as a mechanical engineer to now leading cutting-edge Modern Data Warehouse and Power BI implementations, Mike’s journey is a testament to the transformative power of data. His passion for learning and sharing has made him a cornerstone of the Power BI community—especially as a leader of the Milwaukee (Brew City) Power BI User Group.
Whether he’s speaking at events, crafting video tutorials, or diving deep into the latest Power BI features, Mike brings energy, clarity, and innovation to everything he touches. Power BI didn’t just change his career—it became his mission.
Blog -- https://powerbi.tips/ Explicit Measures Podcast -- https://powerbi.tips/explicit-measures-power-bi-podcast/ Training from PowerBI.tips -- https://training.tips
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #pbitips #acceleratorsUsing Paired Columns in Power BI Field Parameters for Accurate GroupingHavens Consulting2025-05-20 | Field parameters in Power BI offer powerful flexibility when using them for custom visual hierarchies. However, certain columns shouldn’t be used alone, especially when they’re part of a hierarchy or grouped relationship. In this video, I demonstrate how to create a field parameter setup that ensures key columns are always selected together. This approach avoids misleading rollups and duplicated values in matrix visuals, keeping your reports accurate and intuitive.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodelLearn About Power BI Consulting (with Eugene Meidinger)Havens Consulting2025-05-03 | Many people consider becoming a Power BI freelancer or consultant, but they often have the wrong focus. Consulting requires placing the customer first and understanding their needs. In this discussion we’ll cover all of the pieces involved with becoming a Power BI consultant. We’ll also demo some custom GPTs designed for practicing requirements gathering.
GUEST BIO (Eugene Meidinger)👤 Eugene Meidinger works as an independent BI consultant and Pluralsight author, specializing in Power BI and Microsoft Fabric. He has been working with data for over 10 years and speaks regularly at user groups and conferences. He is also Microsoft MVP.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #courses #learning #trainingBookmarks + Field Parameters = Better Hierarchy Controls!Havens Consulting2025-04-22 | Learn how to combine Bookmarks with Field Parameters to give users the option for one-click hierarchy configurations but also custom hierarchy level ordering for advanced configurations. Tune in to learn more!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodelMaking a Real Report Fully Bilingual: Harder Than you Thought! (with Bernat Agulló)Havens Consulting2025-04-05 | 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 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.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #tabulareditor #bilingual #multilanguage #languageInforiver Super Filter for Power BI – Visual Slicer Reimagined!Havens Consulting2025-03-25 | In this video, we explore the Inforiver Super Filter, a powerful custom visual that takes filtering in Power BI to the next level.
✅ Multi-field filtering across tables and data types ✅ Searchable, collapsible, and hierarchical filters ✅ Compact design that replaces multiple slicers ✅ Syncs with native filters and respects row-level security ✅ Personalized filter presets for different users
Whether you're building executive dashboards or self-service reports, the Super Filter gives you unmatched control and clarity over your data.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #Inforiver #CustomVisualsPower BI Core Visuals - Whats New & Exciting! (March 2025)Havens Consulting2025-03-22 | Join us for an exciting discussion on everything NEW and EXCITING from this last quarter (Q1 2025) that has come out from the Core Visuals Team! Each quarter we'll gather together a rotating list of quests from both the #PBICoreVisuals team plus community members to have an engaging discussion between us and the live audience. Hope to see you there!
GUEST BIO (Injae Park) 👤 Injae Park is a Microsoft Data Platform MVP who combines his technical expertise with a passion for teaching by sharing his insights and practical tips through his YouTube channel @PowerBIPark. Injae's content ranges from beginner tutorials to advanced techniques, and as part of the Power BI Core Visual Representatives - he aims to bridge the MS Developer team with the Power BI community. His education in psychology and economics as well as his experience in consulting gives him a well-rounded perspective on the Power BI Developer experience, making his tutorials both engaging and accessible.
GUEST BIO (Andrii Morozov) 👤 Andrii Morozov is a seasoned software engineer with over 15 years of experience in the tech industry. For the past decade, Andrii has specialized in Power BI, contributing to the development of numerous features that enhance data visualization and analytics. Among the most notable features Andrii has built are the slicers (hierarchical, date, numeric), field parameters, small multiples, bookmarks, report tooltips, and visual calculations. Andrii is also the tech-lead for features involving filters, ensuring seamless integration and functionality.
GUEST BIO (Miguel Myers) 👤 Miguel Myers is a Principal Product Manager at Microsoft, where he plays a pivotal role in shaping the future of Power BI. With a strong background in product management and a passion for data visualization, Miguel has been instrumental in driving innovation and enhancing user experiences within the Power BI ecosystem. As a highly regarded and accomplished Business Intelligence Professional, Graphic Designer, and Data Scientist with a demonstrated history of success in the computer software industry, Miguel is dedicated to fostering a community of learning and growth.
He frequently engages with the broader Power BI community, including users, designers, and developers, providing valuable guidance and unwavering support. His contributions have made a significant impact on the Power BI community, and he continues to inspire others with his knowledge and enthusiasm.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #reporting #visualizations #pbicorevisuals #visuals #fieldparametersBuilding Income Statements in Power BI (with Chris Barber)Havens Consulting2025-03-08 | 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)👤 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.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #reporting #visualizations #finance #fpna #pnl #financialreporting #financialstatementsDemystifying Copilot in Microsoft Fabric (with Kerry Kolosko & Kurt Buhler)Havens Consulting2025-02-21 | 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.
VIDEO CHAPTERS 📺 0:00 - Video Start 00:05:00 - Start 00:06:28 - Intro Kerry 00:07:00 - Intro Kurt 00:07:45 - Technical writing as a career or professional task 00:10:00 - Intro to the topic 00:12:45 - Is Copilot an assistant? 00:16:15 - What is Copilot in Fabric and who uses it? 00:21:55 - Overview of the Copilot Process - how does it work? 00:22:50 - Step 1: User provides an input 00:29:55 - Step 2: Preprocessing of input 00:31:00 - Copilot can send data points to Azure OpenAI 00:32:00 - Step 3: Send preprocessed input to Azure OpenAI 00:33:50 - Step 4: Processing of input by LLM 00:34:08 - What are tokens? 00:34:35 - Copilot consumption is determined by tokens 00:35:30 - Copilot is a background operation 00:37:00 - Step 5: LLM response and postprocessing 00:39:55 - Q: Is Copilot or ChatGPT better for DAX or Power Query? 00:44:10 - Q: How does Responsible AI affect Copilot outputs? 00:46:10 - Copilot can produce inaccurate and low-quality content 00:50:20 - Step 6: Copilot returns output to user 00:50:50 - Where Copilot experiences differ in the process 00:56:55 - Demo 1: Generating measure descriptions 01:02:16 - Demo 2: Generating report summaries (Power BI Desktop thick report) 01:09:15 - Mini-rant: Assumptions and over-extrapolation of business processes by technical professionals and AI 01:13:13 - Q: Ask Copilot to suggest a visual for the report 01:17:00 - Demo 3: Generating DAX Queries in the DAX Query view 01:18:00 - Off the rails: The Expanse prop auction 01:29:45 - Q: How much effort is required to make a model "Copilot-ready"? 01:32:45 - Demo 4: Asking data questions to a model or report with Copilot and exploring its output 01:42:40 - Demo 5: Generating a report page with Copilot 01:48:40 - Mini-rant: Why aren't there more templates for reports and visuals? 01:55:05 - Concluding discussion
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #reporting #visualizations #copilot# semanticlink #lakehouse #warehouseFixed-Window Charting in Power BI: Auto-Adjusting Calendar PeriodsHavens Consulting2025-01-28 | 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!
#PowerBI #BusinessIntelligence #DataAnalytics #DataVisualization #DAX #PowerQuery #Microsoft #DataScience #DashboardDesign #Analytics #PowerPlatform #MicrosoftFabricAuto-magically Checking For Broken Visuals in Power BI (with John Kerski)Havens Consulting2025-01-25 | 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 Kerski) 👤 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 -- https://blog.kerski.tech/ LinkedIn -- linkedin.com/in/john-kerski Test for Broken Visuals -- https://blog.kerski.tech/bringing-dataops-to-power-bi-part43/ Automate with DevOps -- https://blog.kerski.tech/bringing-dataops-to-power-bi-part44/
VIDEO CHAPTERS 📺 0:00 - Video Start 5:00 - Start of Livestream
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #reporting #visualizationsCreating a Dynamic Label Toggle Button Using ONE VISUAL!Havens Consulting2025-01-14 | Learn how to leverage the newer tile slicer (thanks #PBICoreVisuals Team!), a bit of [DAX] Magic, and some clever techniques to create a single button toggle slicer using only a single visual! Plus, this single button even has a dynamic (on/off) label. Tune in to learn more!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #PBICoreVisuals #FieldParametersIntroduction to Fabric Studio (with Gerhard Brueckl)Havens Consulting2025-01-11 | In this session I will give you an introduction to the Visual Studio Code extension "Fabric Studio" which allows you to manage your Fabric environment directly from within VSCode. Leveraging the Fabric REST APIs you can easily browse through Fabric items and run various tasks. For not so common API calls there is also the ability to user VSCode notebooks offering intelli-sense and auto-complete from all existing API calls. It further allows you to modify existing items like semantic models, notebooks, pipelines, etc. in the VSCode IDE and publish your changes back to the Fabric service. It also features a OneLake browser to inspect the output of your operations.
GUEST BIO (Gerhard Brueckl) 👤 Gerhard has been working with the Microsoft Data Platform for almost 20 years. From building traditional BI/DWH solution on the MSSQL server stack to designing and implementing whole data platforms hosted in the Microsoft Azure cloud. He is also familiar with OSS technologies in that area like Hadoop, Spark and Delta Lakes. When not working on customer projects, Gerhard is an active member in the community and shares his knowledge in his blog or when speaking at conferences and meet-ups.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #devops #cicd #azure #vscodeWaterfall Charts with Categories (and Considerations...)Havens Consulting2025-01-07 | As a follow up to a my previous video on creating an enhanced vertical/horizontal waterfall chart. In this video I'm going to show you that it's "possible" to create a categorical waterfall chart, but with a few considerations and caveats. Tune in to learn more!
RELATED CONTENT 🔗 Vertical Waterfall Charts with Visual Calcs -- youtu.be/Ju4y98yU2KE
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #visualcalcsIntroducing the Core Visuals - Vision Board (Miguel Myers & Alper Sarikaya)Havens Consulting2024-12-28 | ABSTRACT 📄 Gain firsthand knowledge about the newest and most recent features and improvements in Power BI Core Visuals directly from the experts who developed them.
Miguel Myers and members of the Core Visuals team will showcase the latest and greatest features they've been working on over the past few months. Discover how new features and enhancements can transform your data visualization experience. This session will also highlight the innovative Core Visuals Vision Board, a valuable resource that allows the community to stay informed about the ongoing development of Power BI Core Visuals.
Don't miss this opportunity to learn from the experts and see firsthand the future of Core Visuals!
GUEST BIO (Miguel Myers) 👤 Miguel Myers is a Principal Product Manager at Microsoft, where he plays a pivotal role in shaping the future of Power BI. With a strong background in product management and a passion for data visualization, Miguel has been instrumental in driving innovation and enhancing user experiences within the Power BI ecosystem. As a highly regarded and accomplished Business Intelligence Professional, Graphic Designer, and Data Scientist with a demonstrated history of success in the computer software industry, Miguel is dedicated to fostering a community of learning and growth.
He frequently engages with the broader Power BI community, including users, designers, and developers, providing valuable guidance and unwavering support. His contributions have made a significant impact on the Power BI community, and he continues to inspire others with his knowledge and enthusiasm.
GUEST BIO (Alper Sarikaya) 👤 Alper Sarikaya is a Senior Data Visualization Engineer at Microsoft working on Power BI and its visualization features. His experience has focused on enabling people to create summary visualizations for the purposes of effectively communicating trends, patterns, and distributions in large amounts of data.
Prior to joining Microsoft, Alper earned his PhD in Computer Sciences from the University of Wisconsin-Madison with a concentration in data visualization. His research is available on his website: https://alper.datav.is
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #tabulareditor #te3 #AI #externaltoolsBox (and Whisker) Plot Visual with Native Visuals + Error BarsHavens Consulting2024-12-17 | Learn how to leverage error bars and native visualizations to create a box and whisker style visualization using a bit of [DAX] magic. Tune in to learn more!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #boxplot #denebWaiving the Magic Wand of Data Storytelling (Kristoffer West)Havens Consulting2024-12-14 | ABSTRACT 📄 Join us for an insightful session on “Waiving the Magic Wand of Data Storytelling,” where we dive deep into the crucial steps that often get overlooked in data reporting. This livestream will cover what it takes before you even start visualizing your data, including defining persona groups, crafting a compelling storyline, and asking the right business questions. Whether you’re an analyst or a report designer, this session will provide practical tips and strategies to help you deliver impactful insights with your reports. Tune in for expert advice, real-world examples, and a live Q&A session to answer your toughest data storytelling challenges!
GUEST BIO (Kristoffer West) 👤 Kristoffer West is a Senior Data Insights Consultant and Head of Academy at twoday, where he combines his passion for storytelling with deep technical expertise in Power BI. Known for his innovative approach to report design, Kristoffer spends his time exploring the latest features and translating them into actionable insights. As an educator, he’s dedicated to empowering others with the skills needed to turn data into compelling narratives. With a focus on practical, real-world applications, Kristoffer brings a wealth of knowledge to the session, making complex concepts accessible and engaging for all levels of experience.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #tabulareditor #te3 #AI #externaltoolsPower BI Upgrade: Easy Vertical Waterfall Charts with Visual CalcsHavens Consulting2024-12-10 | Learn how to build a dynamic vertical waterfall chart using Power BI's native stacked column visual and visual calculations. This step-by-step tutorial covers setting up the data, creating measures using the RUNNINGSUM() function, and handling common challenges such as cumulative calculations and visual formatting. Perfect for showcasing trends, financial analysis, or any scenario requiring clear visualization of increases and decreases over time.
🔍 In this video, you’ll discover: • How to create a vertical waterfall effect with transparent base calculations • Tips for using visual-level DAX functions efficiently • Techniques for handling monthly data and segment slicing
📊 Level up your data visualization skills with this powerful technique for clearer and more effective storytelling in Power BI!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #visualcalcsIntroduction to Power BI Deployment Pipelines!Havens Consulting2024-12-03 | Learn about the basic benefits of utilizing Deployment Pipelines in Microsoft Fabric / Power BI, saving you time, effort, and reducing complexity for report/model management. Tune in to learn more!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #deploymentpipelinesDynamic Constant Line Data Labels!Havens Consulting2024-11-26 | Learn how to create a dynamic constant line data label using a disconnected slicer and some [DAX] magic for Power BI. Tune in to learn more!
RELATED CONTENT 🔗 Creating a Range Bar from a Native Visual -- youtu.be/vowoC_akDcA
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodelCreating [DAX] SVG Charts using Chat GPT!Havens Consulting2024-11-19 | Learn how to leverage the POWER of Chat GPT to generate any SVG chart you can imagine, as a [DAX] measure for tables and matrix native visuals in Power BI Desktop. Tune in to learn more!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #chatgpt #svgAI Assistant for Tabular Editor (Andrzej Leszkiewicz)Havens Consulting2024-11-16 | ABSTRACT 📄 Discover how to enhance your Power BI workflow with Tabular Editor and the OpenAI API. This presentation demonstrates how, with a few simple C# scripts, you can directly access the OpenAI API from Tabular Editor to create a custom AI assistant with full access to your Power BI report’s data model—including tables, columns, relationships, measures, calculation groups, and more. Use this assistant to comment on DAX code, generate model documentation, write measures, and more, harnessing the full power of the latest OpenAI models—all without the need for Power BI Premium or Fabric capacity. An OpenAI API subscription is required, and Tabular Editor 3 is necessary.
GUEST BIO (Andrzej Leszkiewicz) 👤 Andrzej is a Power BI and data visualization developer and consultant, data explorer, explainer, and visualizer. He creates highly customized, interactive visualizations using the Vega visualization grammar and Deneb. Andrzej has introduced IBCS-styled data visualizations, embedded into Power BI's built-in Table, Matrix, and Card visuals. An IBCS® Certified Analyst, he is a passionate advocate of IBCS standards. With a background as an IT project manager and CIO in non-IT companies, Andrzej has been a full-time independent freelance Excel and VBA developer and consultant since 2011, focusing entirely on Power BI and data visualization since 2020. Through his YouTube channel, LinkedIn, and other social media, Andrzej shares his knowledge and passion for data visualization and related topics.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #tabulareditor #te3 #AI #externaltoolsCreating a Range Bar with a Native Visual!Havens Consulting2024-11-12 | 🔍 In this video, I show you how to transform a simple stacked column chart into a powerful range bar visual, complete with left and right data labels for added clarity. No custom visuals needed—just native Power BI features!
💡 Perfect for anyone looking to level up their Power BI reports with more dynamic and informative visuals.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodelExploring Practical Front-End Techniques for Power BI Reporting (Gustaw Dudek)Havens Consulting2024-11-02 | ABSTRACT 📄 During the front-end development phase, we face many choices that will affect the usability, appearance, and overall experience of the report. To shed light on some of these issues, Gustaw will share his approach and thought process, conveying his experiences through selected use cases. Among the topics, there will be information on specific charts and nuances of their formatting, as well as Power BI functionalities like field parameters and conditional formatting, illustrated with concrete examples. The subjects discussed during the live session are intended for all Power BI users regardless of their experience level—beginners, intermediate, and advanced. Some aspects may also appeal to users of other data visualization tools, given the universal nature of certain approaches.
GUEST BIO (Gustaw Dudek) 👤 Gustaw Dudek is the Head Of Business Intelligence at the Polish Company - Enterium. He has multiple years of experience in the field of data analytics. He implements and provides business reporting solutions for various industries using Power BI tools. Gustaw is also IBCS® Certified Analyst, Enterprise DNA Platform Expert and Microsoft Power BI Community Representative. He developed extensive Power BI Portfolio, which includes diversified array of financial and operational reports as well as various demonstrative dashboards created in the frames of international BI challenges. He regularly shares his personal PowerBI-related experience through Linkedin Platform by showcasing diverse data visualization techniques.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #developermode #pbip #pbirSemantic Model Ideation for Power BI (Leslie Welch)Havens Consulting2024-10-19 | Building a performant star schema semantic model for Power BI enables simpler DAX, improved load time and responsiveness, and ensures that you are able to use the visuals that will best communicate your data. When starting with a snowflake, disparate data sources, or one big table, it can be a challenge to build something from the start that is going to fit your user requirements.
Enter the semantic model ideation process. My team and I use this process to help clients create performant secure data models aligned to a star schema and Power BI best practices. Attendees will walk away with an understanding of what information they need to start this process, how to work through the steps, and how to validate the proposed model will support their visuals. We will work backwards from what data you need to support the user questions, what Power BI needs to support the visuals, and an overview of the approach to building out your medallion architecture technical requirements for Synapse or Databricks to enable Power BI semantic models.
GUEST BIO (Leslie Welch) 👤 Leslie Welch is the Principal Fellow of AI & Analytics at Excella with over 16 years of experience in automation, data analysis and visualization, and strengthening organizations’ knowledge of data. Leslie has worked end to end in the data arena from capture and ETL to database design/engineering to analysis and dashboard design to ML use cases with a focus on improving productivity, performance, and data quality. She has extensive experience in enterprise deployment of Power BI, both as an admin and Power BI architect and a trainer and technical community organizer. She is passionate about data governance, truth telling in data, and responsible application of ML/AI. Leslie is co-organizer of Power BI DC, and frequently attends and speaks at data community meetups in the DC metro area. Leslie was recognized as a 2023 New Power Woman in Tech by DCA Live, and made the 2024 RealLIST Engineers for her role in helping the DMV tech ecosystem grow.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #developermode #pbip #pbirMore Variance Comparisons to Stacked Column ChartsHavens Consulting2024-10-15 | Learn of a few more designs, methods, and techniques for adding comparison variance values to stacked column charts. Currently native stacked columns don’t support adding direct (error bar) comparisons. So this technique uses a combo chart to achieve it’s result. Tune in to learn more!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodelPower BI Developer Mode: Connecting the Dots and Merging the Chaos! (Miguel Felix)Havens Consulting2024-10-12 | Ever feel like Power BI is throwing you into a maze of connections and scattered reports? Fear not! In this fun and interactive session, we’ll dive into Power BI's Developer Mode to demystify the process of updating connections on your models and seamlessly merging two reports into one masterpiece. No more data juggling or report chaos—just a smooth path to Power BI harmony! Whether you're a data wrangler or a curious BI enthusiast, this session will have you laughing, learning, and connecting all the right dots.
GUEST BIO (Miguel Felix) 👤 Miguel Félix is a Lead BI Architect, with a background in finance with experience in several different areas like banking, events, manufacturing, wholesale, services. Data analysis was always a part of his daily tasks and the change from Excel to Power BI was a step in the right direction allowing him to change to consulting in BI in 2021. The engagement with the community was also a natural and he is a Super User in the Fabric community since the start of the program back in 2018 that allowed him to achieve a Microsoft MVP for the first time in 2019, after that came the blog and the presentations about everything related with Power BI and Fabric.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #developermode #pbip #pbirExamples for Comparing Values (Ratios) to TargetsHavens Consulting2024-10-08 | Learn about some alternative examples on how to compare targets to ratio percentages using native visuals and a bit of design magic. Tune in to Learn More!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodelDAX Query View Testing Patterns (with John Kerski)Havens Consulting2024-10-05 | Are you struggling with managing issues in your semantic models/datasets? Would you like to conduct tests and easily share those tests with your team? In this session I show you a DAX Query View Testing Pattern. This pattern combines the new DAX Query View feature in Power BI Desktop and DataOps principles to help you improve project delivery and reduce errors.
GUEST BIO (John Kerski) 👤 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 -- https://blog.kerski.tech/ LinkedIn -- linkedin.com/in/john-kerski Test for Broken Visuals -- https://blog.kerski.tech/bringing-dataops-to-power-bi-part43/ Automate with DevOps -- https://blog.kerski.tech/bringing-dataops-to-power-bi-part44/
VIDEO CHAPTERS 📺 0:00 - Video Start 5:00 - Start of Livestream
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #semanticmodel #daxqueryviewITS HERE! Dark Mode for Power BI Desktop 📢Havens Consulting2024-10-01 | Coming straight from the FabCon Europe announcement, we have Dark Mode for Power BI Desktop finally here! Join me, and a member of the Power BI team (Harleen Kaur). Tune in to learn more!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodelImproving Value Comparisons for Line ChartsHavens Consulting2024-09-24 | Learn how to combine a bit of DAX magic with visual features such as error bands to improve comparing values between each other on native line chart visuals in Power BI. Tune in to learn more!
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodelThe Cost of a Workaround in Power BI (with Injae Park)Havens Consulting2024-09-21 | From using SVGs or DENEB to create unique visuals, to page level security with RLS - workarounds are often necessary to overcome limitations and achieve desired functionalities in Power BI. However, these workarounds come with their own set of costs and considerations. This session discusses the key factors to help developers evaluate workarounds in Power BI, ensuring that the benefits outweigh the potential drawbacks.
To do this, we will explore some real-life workarounds in Power BI such as code-based Custom Visuals (DENEB, SVGs, HTML, Python), Page level security, and storing a custom PowerQuery library in Github. We will also dive into the trade-offs involved, including maintainability, impact on development, and technical debt.
GUEST BIO (Injae Park) 👤 Injae Park is a Microsoft Data Platform MVP who combines his technical expertise with a passion for teaching by sharing his insights and practical tips through his YouTube channel @PowerBIPark. Injae's content ranges from beginner tutorials to advanced techniques, and as part of the Power BI Core Visual Representatives - he aims to bridge the MS Developer team with the Power BI community. His education in psychology and economics as well as his experience in consulting gives him a well-rounded perspective on the Power BI Developer experience, making his tutorials both engaging and accessible.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #semanticmodel #python #svgPractical Use Cases for DAX Calculated Columns (Tristan Malherbe)Havens Consulting2024-09-14 | Over the last few years, many debates arose in the Power BI community about the use of DAX Calculated Columns. In this session, Tristan Malherbe will show concrete & real-life use cases to illustrate the power of DAX Calculated Columns. The main topics covered will be:
- Context Evaluation (Filter context, Row Context, Context Transition) - Static Segmentation based on DAX measures - Pre-Computing flags in Dimension tables to boost your Power BI reports' performance and ease your DAX calculations - Inter-table calculations - Inter-row calculations and windowing patterns with the new DAX windowing functions
GUEST BIO (Tristan Malhernbe) 👤 Tristan Malherbe is a Microsoft Data Platform MVP since 2017. He is the creator and current co-leader of the French Power BI User Group (Club Power BI, 7,000+ members) and more recently the French Fabric User Group (Club Fabric, 300+ members). Over the last 7 years, Tristan gave 150+ Power BI conferences & trainings in America, Europe and Middle-East. His favorite topics are Data Architecture, Data Modelling/DAX & performance tuning. Tristan is also the co-founder of Data Pulse, a Fabric & Power BI consulting firm (14 people) based in France.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #svgFabric & Power BI: Awesome Use-Cases with DAX Query View (with Zoe Douglas)Havens Consulting2024-09-07 | Join us live as we dive into the world of Microsoft Fabric! In this session, Zoe will walk you through the process of creating semantic models using three powerful approaches: Direct Lake, Import, and DirectQuery (DQ). We'll explore how each of these methods can be utilized within Microsoft Fabric to build robust and scalable models tailored to your data needs.
But that's not all—once we've crafted these models, I'll demonstrate how you can leverage them to write efficient DAX queries using the DAX Query View. Whether you're new to Microsoft Fabric or looking to refine your skills, this demo will provide valuable insights and practical techniques you can apply to your projects.
Bring your questions and curiosity, and let's explore the possibilities together!
GUEST BIO (Zoe Douglas) 👤 Zoe is a Product Manager at Microsoft working on Power BI in Microsoft Fabric with features such as DAX query view, Direct Lake, Model Explorer, and Copilot. Before coming to Microsoft I was a Power BI consultant and mentor, enjoying the Power BI community forum and taking on data challenges.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #semanticmodelCreating Accessible Ops Data with Real-Time Intelligence in Fabric (with Will Thompson)Havens Consulting2024-08-31 | At Microsoft Build in May, we announced Real-Time Intelligence which brings our messaging, time-series analytics and real-time action systems together in Fabric. We’ll look at how these help data engineers and business analysts ingest, analyze, and take action on streaming and real-time data. I’ll demo Eventstreams, Eventhouse, Real-Time Dashboards, and Data Activator.
GUEST BIO 👤 Will is a self-confessed data geek, working his way through sysadmin and DBA roles before joining Microsoft. He spent 5 years helping customers in the UK implement and get value out of Microsoft’s BI solution. When an opportunity arose to move into product engineering in 2012, he jumped at it and took ownership of Power BI’s visual and modeling features. In 2022 he started running Product Management for Data Activator, a new product for monitoring and acting on changes in data.
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #dataactivator #fabricDynamic Rank Conditional Formatting for Tables in Power BIHavens Consulting2024-08-27 | Learn how to leverage What If Parameters to apply dynamic conditional formatting to values on tables or matrix visuals in Power BI Desktop. Tune in to learn more!