CACTUSS North

CACTUSS

Capital Area Central Texas User of SQL Server

PASS affiliated user group for Austin, TX

Contact us:
Email: CACTUSS.SQL (at) (gmail) (dot) (com)
Twitter: @CACTUSS_SQL
LinkedIn: https://www.linkedin.com/groups/149440
Meetup: https://www.meetup.com/Austin-SQL-Server-User-Group/

Upcoming Meeting Dates

  North South
Nov 2018
1 week earlier
Tue 11/13/2018
Speaker: Open
Topic: Submit Your Topic
1 week earlier
Mon 11/12/2018
Speaker: Open
Topic: Submit Your Topic
Dec 2018
Tue 12/18/2018
Speaker: Open
Topic: Submit Your Topic
Mon 12/17/2018
Speaker: Open
Topic: Submit Your Topic
 Jan 2019
Split week
Tue 1/15/2019
Speaker: Open
Topic: Submit Your Topic
Split week
Mon 1/21/2018
Speaker: Open
Topic: Submit Your Topic
 Feb 2019
Tue 2/19/2019
Speaker: Open
Topic: Submit Your Topic
Mon 2/18/2019
Speaker: Open
Topic: Submit Your Topic
 Mar 2019
Tue 3/19/2019
Speaker: Open
Topic: Submit Your Topic
 Mon 3/18/2019
Speaker: Open
Topic: Submit Your Topic


Meeting Locations

CACTUSS North

  • Meeting dates: 3rd Tuesday of the month
  • Meeting starts: 5:30 pm with food and a QA session
  • Presentation: 6:00 pm and goes to 7:15 pm
  • Address
    • Quarry Oaks II
    • Microsoft Office
    • Suite 225
    • 10900 Stonelake Blvd.
    • Austin, TX 78759
      • * Free parking
      • * Coming from Braker, go right/straight at the traffic circle and it's the building on the left.
      • * The building is also across from the outdoor basketball court
      • * Not the building attached to the parking garage
      • * Inside the Microsoft office, go right, past the reception desk, to the far back and left
      • * If there is interest, there is sometimes an after-gathering at a local place to talk casually
    • Map: http://binged.it/1HOSMWm

CACTUSS South

  • Meeting dates: 3rd Monday of the month
  • Meeting starts: 5:30 pm with food and a QA session
  • Presentation: 6:00 pm and goes to just after 7:15 pm
  • Address
    • SQLWatchmen Office
    • Suite 234
    • 1524 S IH-35
    • Austin, TX, 78704
      • * Free parking
      • * South bound side
      • * From north of Riverside, use the Woodland exit
      • * From south of Riverside, use the Riverside exit and turn around (it's a long traffic light)
      • * Wooden bridge in the middle of the L shape is the closest entrance
  • Map: http://binged.it/2kMuQQ8
 

Next Meeting

Monday,

December

18

Austin SOUTH
- Data Modeling for the Modern Enterprise -
Ryan Casey

1524 S IH-35 Frontage Rd Suite 234
Austin, Texas 78704
Time: 17:30 - 19:00

Title: Data Modeling for the Modern Enterprise
by: Ryan Casey

Summary:

This session is theoretical with a focus on the many ways that we 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

Speaker: Ryan Casey, BI Architect AIM Business Driven Data Solutions:
Bio: Microsoft Data Platform MVP, Public Speaker, and Group Moderator SQL Saturday Speaker @ • Houston, TX 2018 • Dallas, TX 2018, 2017 (BI), 2016, 2015 • Phoenix, AZ 2018, 2017 (BI) • Kansas City, MO 2017 • Baton Rouge, LA 2017 • Oklahoma City, OK 2016 • San Antonio, TX 2016 SQL User Group Speaker @ • NTSSUG, Dallas, TX • CACTUSS, Austin, TX • OKCSQL, Oklahoma City, OK • MSBIC, Dallas, TX • SALSSA, San Antonio, TX • FWSSUG, Fort Worth, TX 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).

Special Notes:

none

Available Attachments:

Our monthly meetings are made possible by the generosity of these sponsors:

This month's sponsor:

(Feature coming soon)

Ongoing sponsors:

Microsoft

SQL Watchmen  

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