FWSSUG Monthly Meetup - Data Modeling for the Modern Data Warehouse

Fort Worth SQL Server Users Group
Fort Worth SQL Server Users Group
Public group

Location visible to members


Ryan Casey will present Data Modeling for the Modern Data Warehouse this month!

A theoretical discussion on the topic of graphical data modeling using enterprise modeling tools.

Discuss why we model data, the different modeling type, and different modeling techniques. Explore why and when to use different modeling techniques. Explain dimensional modeling when developing data warehouses, SSAS Cubes, and Power BI Analytics.

Sample model diagrams will be used to explain these different modeling techniques and try to bring a more tangible aspect to the theoretical aspects of the discussion.

Why Model Data
The Value of Enterprise Data
Business Benefits of Data Modeling

Different Model Types
Conceptual / Logical / Physical
Different Modeling Techniques
Star & Snow Flake Schema
Slowly Changing Dimensions
Many to Many Relationships

Managing BI Architect, Microsoft Data Platform MVP, Friend of Redgate, LinkedIn Group Moderator, and a SQL Saturday Speaker.

• 15+ Fortune 500 Corporations Implementing Data Centers and Warehouses
• 14+ years SQL Server and Oracle (T-SQL, PL-SQL), (Excel, Flat Files, XML)
• 12+ years Visual Studio (SSDT Business Intelligence, DevOps, MVC, C#, VB)
• 11+ years Excel, SSAS, SSIS, and SSRS using Agile Methodology
• 6+ years Leading Large BI Teams (multi-country off-shore locations)

AIM Business Driven Data Solutions combines the collaborative and creative arts included in Technical Communication, the business acumen of a Harvard MBA program, and the technical discipline of object oriented programming and business intelligence (data warehouses).