Home » Events » ATX » South Austin SQL Server User Group Meetup
Loading Events

« All Events

  • This event has passed.

South Austin SQL Server User Group Meetup

December 18, 2017 @ 5:30 pm - 7:00 pm

Free

This session is theoretical with a focus on the many ways that people can model data. We will discuss why we select one modeling technique over the other in different user scenarios. These different scenarios will vary by industry and company, two main scenarios include: purchasing a product and storing the data related to the sales transaction, or visualizing the total sales for a product, month over month, for the calendar year 2016. Diagrams will be used to explain these different models and try to bring a more tangible aspect to the theoretical aspects of the discussion. Demos using IDERA ER/Studio Data Architect will be used to conclude the presentation.

Why Model Data
* Business Benefits and Value

Different Model Types
* Enterprise Model
* Conceptual Model
* Logical Model
* Physical Model
* Dimensional Model

Different Modeling Techniques
* Normal Form Modeling
* Star & Snow Flake Schema
* Slowly Changing Dimensions
* Many to Many Relationships

Ryan P. Casey, MBA, SSAS, SSIS, SSRS Architect, BI Architect, AIM Report Writing

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)

Venue

 SQLWatchmen
1524 S IH-35, Suite 209
Austin, TX United States

Organizer

Austin SQL Server User Group
View Organizer Website