Uploaded October 2024 | Updated November 2026, 1 day ago
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.
RELATED CONTENT π
Linkedin -- linkedin.com/in/miguel-a-s-felix
Blog -- pbiportugal.com
Twitter -- https://x.com/MFelixPBI
GitHub -- github.com/MASFelixPBI
VIDEO CHAPTERS πΊ
0:00 - Video Start
5:00 - Start of Livestream
LET'S CONNECT! π§π½βπ€βπ§π½π
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE π
-- havens-consulting.creator-spring.com
HAVENS CONSULTING PAGES π
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #developermode #pbip #pbir
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.
RELATED CONTENT π
Linkedin -- linkedin.com/in/miguel-a-s-felix
Blog -- pbiportugal.com
Twitter -- https://x.com/MFelixPBI
GitHub -- github.com/MASFelixPBI
VIDEO CHAPTERS πΊ
0:00 - Video Start
5:00 - Start of Livestream
LET'S CONNECT! π§π½βπ€βπ§π½π
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE π
-- havens-consulting.creator-spring.com
HAVENS CONSULTING PAGES π
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=Bb06IBfUgFE
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #developermode #pbip #pbir

![Creating [DAX] SVG Charts using Chat GPT!
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!
RELATED CONTENT π
Brian Juliusβs LinkedIn Post https://bit.ly/3ClyWXP
Creating a Range Bar from a Native Visual https://youtu.be/vowoC_akDcA
BECOME A CHANNEL MEMBER π
https://www.youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE π
https://havens-consulting.creator-spring.com/
LETS CONNECT! π§π½βπ€βπ§π½ π
https://twitter.com/HavensBI
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
https://www.facebook.com/havensconsulting
VIDEO CHAPTERS π₯
0:00 - Start of Video
0:30 - Content Intro
HAVENS CONSULTING PAGES π
Home Page - http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=BsW6J0NxMig
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=BsW6J0NxMig
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=BsW6J0NxMig
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=BsW6J0NxMig
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=BsW6J0NxMig
Online Courses https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=BsW6J0NxMig
Contact & Support - http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=BsW6J0NxMig
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #chatgpt #svg Creating [DAX] SVG Charts using Chat GPT!](https://i.ytimg.com/vi/BsW6J0NxMig/mqdefault.jpg)






![[DAX] Dynamic Format Strings WITHOUT Calculation Groups ?!?
Learn how to add Dynamic Format Strings for individual [DAX] measures in Power BI! This technique doesnβt require calculation groups or Tabular Editor either, and can be done entirely inside of Power BI desktop.
Side note, if you arenβt using Tabular Editor as a model developer you should be. Itβs a fantastic tool for any intermediate to advanced modeling scenarios, and the only way to add calculation groups (today).
RELATED CONTENT π
Dynamic Format Strings in DAX https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings
Kane Snyderβs Linkedin Post https://bit.ly/kane-format-strings-dax
Tabular Editor https://www.sqlbi.com/tools/tabular-editor/
BECOME A CHANNEL MEMBER π
https://www.youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE π
https://havens-consulting.creator-spring.com/
LETS CONNECT! π§π½βπ€βπ§π½ π
https://twitter.com/HavensBI
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
https://www.facebook.com/havensconsulting
HAVENS CONSULTING PAGES π
Home Page - http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=EtrI-q0-ewE
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=EtrI-q0-ewE
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=EtrI-q0-ewE
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=EtrI-q0-ewE
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=EtrI-q0-ewE
Online Courses https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=EtrI-q0-ewE
Contact & Support - http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=EtrI-q0-ewE
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #formatstrings #tabulareditor [DAX] Dynamic Format Strings WITHOUT Calculation Groups ?!?](https://i.ytimg.com/vi/EtrI-q0-ewE/mqdefault.jpg)

