Meet & Greet at 6:30PM Presentation at 7PM
Please join and
RSVP at our
FWSSUG MEETUP page!
Abstract:
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
Dimensional
Different Modeling Techniques
Star & Snow Flake Schema
Slowly Changing Dimensions
Many to Many Relationships
Bio:
Ryan Casy: 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).
Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors.
4055 International Plaza Fort Worth, Texas 76109