Sacramento SQL Server User Group

June 3, 2020, 6PM - 8PM PDT (Online Meeting)

RSVP on Meetup:
https://www.meetup.com/Sacramento-SQL-Server-User-Group/events/270795219/

The Art of Dimensional Modeling - Jason Horner

Dimensional modeling is arguably one of the most important fundamentals of business intelligence. It is still relevant even in the age of new technologies and architectures like Power BI and Big Data becoming more popular. Correctly modeling your organization's data not only protects the most important asset your company has but ensures that your data mart or data warehouse will be responsive and capable of accommodating emerging requirements.

In this session, we will first understand the basics of dimensional modeling. Then we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session, you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes.

Jason Horner is a practice lead at Attunix. He spends most of his day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Data Bricks, HDInsight and Azure SQL Database. He is fluent in several languages including SQL, C#, Python, and PowerShell.

Jason is a Microsoft Certified Master of SQL Server (MCM) and has been recognized for his technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.

Twitter: https://twitter.com/jasonhorner
LinkedIn: https://www.linkedin.com/in/jasonhorner

Sacramento SQL Server User Group:
https://www.meetup.com/Sacramento-SQL-Server-User-Group
https://sac.pass.org
https://twitter.com/sacsqlug
https://www.linkedin.com/groups/2825448