DESCRIPTION 📄
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.varius morbi.
GUEST BIO 👤
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.