Speaker

Leslie Welch

Leslie Welch

I solve problems.

Arlington, Virginia, United States

Actions

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 she creates collaborative environments across data practitioners and the numerous data stakeholders.

Leslie is co-organizer of Power BI DC, and frequently attends and speaks at data community meetups in the DC metro area including but not limited to Data Viz DC, Data Science DC, Women Who Code DC, Washington DC Power Platform User Group, and Generative AI DC. Leslie was recognized as a 2023 New Power Woman in Tech by DCA Live.

Area of Expertise

  • Information & Communications Technology

Topics

  • Data Literacy
  • Data Governance
  • Data / Data Ops / Data Governance
  • Data Modeling
  • Data Visualization
  • Data Visualization Tools
  • Azure Data & AI
  • Microsoft Power BI
  • Power Platform
  • Microsoft Power Automate
  • Microsoft Power Apps
  • Azure Data Factory
  • Azure Active Directory
  • Microsoft Fabric
  • Data Platform
  • Data Analytics
  • Data Science & AI
  • Azure Data Platform
  • All things data
  • Azure Databricks

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

DynamicsCon Virtual Sessionize Event Upcoming

November 2024

Power BI Days DC User group Sessionize Event

June 2024 Washington, Washington, D.C., United States

Public Affairs Council Digital & Media Advocacy Summit

Skill-Building Round 2: PowerBI Basics

Discover how Power BI can transform your organization's data into actionable insights. Our expert will highlight practical examples and best practices, providing you with the knowledge to oversee the development of impactful reports and dashboards, understand the key considerations for deriving value from your data, and use Power BI reports to support both external-facing initiatives and internal decision-making processes. This session is tailored to meet the needs of public affairs professionals who are eager to maximize their data's potential without delving into the technical intricacies of enterprise-level report development.

June 2024 Washington, Washington, D.C., United States

Leslie Welch

I solve problems.

Arlington, Virginia, United States

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top