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
Nov 2019 Tue 11/19/2019
Speaker: Kevin Boles
Topic: Common TSQL Mistakes
Speaker: Shawn Weisfeld
Topic: Quick Introduction to GitHub
Dec 2019 Tue 12/17/2019
Speaker: Jay Falck
Topic: Setting up a test lab with Hyper-V

Meeting Location

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

Next Meeting

Tuesday,

February

20

Austin NORTH<br />- Graphical data modeling using enterprise modeling tools -<br />Ryan Casey

10900 Stonelake Blvd. Suite 225 - Microsoft Office
Austin, Texas 78759
Time: 18:00 - 19:30

Title: A theoretical discussion on the topic of graphical data modeling using enterprise modeling tools
by: Ryan Casey

Summary: Two part series:<br /> • Data Modeling for the Modern Data Warehouse<br /> • Loading SQL Structures Using SSIS and Data Models<br /> <br /> 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.<br /> <br /> 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.<br /> <br /> Why Model Data<br /> • The Value of Enterprise Data<br /> • Business Benefits of Data Modeling<br /> <br /> Different Model Types<br /> • Conceptual / Logical / Physical<br /> • Dimensional<br /> <br /> Different Modeling Techniques<br /> • Star & Snow Flake Schema<br /> • Slowly Changing Dimensions<br /> • Many to Many Relationships<br />

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:
-

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