Posts From January, 2018

-March 2024+
SMTWTFS
252627282912
3456789
10111213141516
17181920212223
24252627282930
31123456
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (106)
  • Comments (0)

Archives

Data Modeling for the Modern Data Warehouse 

Posted by altadmin Saturday, January 13, 2018 10:33:00 AM


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
Site Map | Printable View | © 2008 - 2024 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund