Data Model Ideation for Power BI

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

Lost in Translation: Overcoming Data Literacy Gaps

Decision Makers need help in understanding how to use data to improve their strategy. Improving data literacy is key to this.

Data visualization does not provide intrinsic value - the real potential for impact comes from data-informed decision making. The Data Literacy Index shows that large enterprises with higher corporate data literacy — i.e., the ability of a workforce to read, analyze, utilize and communicate data — reap the rewards of a 3–5 % higher enterprise value. Despite this, only 24% of business decision makers are confident in their ability to use data. This talk will discuss pitfalls of data literacy gaps, how to roll out a data literacy program (high level) at an organization and why this should matter to you.

From Chaos to Clarity: Implementing Code Reviews in Power BI

In an enterprise setting, code review of the data models underneath interactive data viz is often overlooked. If you want to avoid wild west style dashboard development, this is a crucial practice to standardize and implement. In addition to enabling easier collaboration on a given dashboard, this process can also educate individual developers on data modeling best practices and increase the overall data viz capacity at an organization. Leslie will show us how she handles code review of Microsoft Power BI data models, some external tools that can help with identifying necessary code changes, and documentation of the code review process.

Familiarity with Power BI data modeling will enable attendees to get more value from this talk.

Demystifying Row Level Security in Power BI

Managing data security is paramount for organizations, even more so for those operating within regulated or government cloud environments. Join us virtually this month for a workshop hosted by Leslie Welch, Power BI DC Co-Organizer and consultant with extensive experience building out and training on Row Level Security (RLS) in Power BI at the enterprise and government levels.

This 1.5-hour workshop is designed to provide Power BI developers, ranging from novices to experienced developers, with a solid foundation to implement RLS in Power BI.

Workshop attendees will learn how to set up RLS start to finish using two approaches, covering setup in both Power BI Desktop the Service. We will tackle some common challenges, discuss model considerations and how they impact RLS, and untangle the differences between access and security in Power BI. The workshop will also address governance considerations and some of the unique challenges present within government cloud infrastructures.

Previous experience in Power BI RLS is not required. Familiarity with data modeling in Power BI helps, but is not required. Familiarity with relational databases will enable attendees to learn something from this session.
Power BI Desktop (still free!) will need to be downloaded prior to session. Power BI Template (*.pbit) will be provided to enable attendees to complete the desktop portion - approximately ~85% of the workshop. Access to a Power BI Workspace will enable attendees to complete the service portion of the workshop.

The Data Must Flow

Without centralized Dataflows, organizations leveraging Power BI often face data inconsistencies, increased maintenance, and performance issues due to managing individual data connections and transformations across multiple reports. This decentralized approach also hampers governance and leads to redundant efforts, making it challenging to ensure data quality and efficiency across the organization. Sound familiar?

Join the #PowerQueryEverything movement and dive into the upgraded Power Query experience through Dataflows!

This talk will cover use cases for dataflows, how to orchestrate them for better performance, governance and standardization, and the number one topic folks want to hear about - how to convert queries in existing reports or semantic models to use dataflows without breaking everything.

This session is about 25% content to cover fundamental concepts for those who are unfamiliar or self taught, and 75% more advanced concepts around orchestration for enterprise or government level deployments.

This session is adapted to work for developers across all four US clouds - no "What about GCC" sadness for federal developers and consultants working in sovereign clouds.

It's a Report - Understanding Power BI Artifacts and When to Use What

Description Coming Soon

This is an overview of the various Power BI artifacts used to serve data to front end users - Reports, Apps, Dashboards, and Scorecards.
This will cover use cases, when to avoid certain artifacts, and how to share with data consumers so they don't get lost.

Unlocking the Power of Data: A Guide to Effective Viz Presentations

In today's data-informed world, the ability to present information in a clear, compelling way is a game-changer. But how do you go from data overload to a presentation that resonates? Join Leslie for an illuminating talk that will elevate your presentation game. In this session, you'll discover:

Practical pointers that can instantly improve your data viz presentations.
Visual cues that make your data easy to understand at a glance
Why the integrity of your axis labels and scales matters, and how to get them right.
The principles behind embedding visuals that not only capture attention but also reinforce your message.

Whether you're a data viz beginner or a seasoned pro, you'll leave this talk armed with actionable insights to make your next data presentation a hit.

Challenging the Norm: An Agile Approach to Data Visualization

Traditionally, Power BI Reports are developed in a waterfall approach - requirements, data shaping, front end visuals. The data modeling phase often happens entirely out of view of stakeholders and report users, with few to no feedback loops. Given that most organizations have significant gaps in standardizing which metrics to use and often even have different interpretations of their meaning, developing reports without early stakeholder input to validate assumptions can lead to significant rework, including model redesign.

In this talk, we'll explore the essentials of adopting an agile approach to data visualization development. Agile approaches promote iterative cycles and continuous feedback, helping teams align visualizations with organizational goals and stakeholders’ mental models. We'll walk through real-world examples to demonstrate how this iterative approach not only saves time and resources but also results in more effective and performant interactive reports and dashboards. Attendees will leave with an immediately usable, practical approach to reducing rework by implementing low-friction feedback loops on both code and visuals early and often.

Authentication, Access, and Security in Power BI

Description Coming Soon

This session is an overview to detangle what happens where - Azure Active Directory Service, Power BI Service, and Power BI Desktop

+unique challenges in cross cloud collaboration with multiple government clouds in the mix