North Texas SQL Servers Users Group

Next Meeting

Thursday,

April

14

14 April 2016 NTSSUG Meeting

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 21:00 Central Daylight Time
  • Language: English

RSVP Here: None
6:00 - 6:30 - Welcome, Announcements & Food
6:30 - 8:30 - Dimensional Modeling Design Patterns: Beyond Basics by Jason Horner
8:30 - 8:45 - Raffle and closing

Featured Presentation:

Dimensional Modeling Design Patterns: Beyond Basics

Jason Horner, Consultant

Dimensional modeling is arguably one of the most important fundamentals of business intelligence. It is still relevant even as new technologies like PowerPivot and SSAS Tabular Models are 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. This session provides a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover physical design choices. This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.

About Jason:
Hi, my name is Jason I'm a practice lead at Attunix. I spend most of my 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. I'm fluent in several languages including: SQL, C#, Python, and PowerShell. I'm a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years. In my off hours I like to snowboard, karaoke, ride roller coasters and play arcade games


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











Back to Top
cage-aids
cage-aids
cage-aids
cage-aids