Posts From May, 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

"Real World" Examples on How to Load Data Warehouse Structures using SSIS 

Presented by Ryan Casey
Posted by altadmin Monday, May 14, 2018 6:14:00 PM


Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
In this session we will discuss the value of a SSIS Framework, explore forward engineering benefits, and demonstrate SSIS design patterns on loading SQL structures when developing Data Warehouses, SSAS Cubes, and Power BI Analytics.

Live Demo SSIS Framework
    Load & Error Meta Data
    Restart ability, Rollback, Reload Count
    Master Load ID, LoadID, ExecutionID (SSISDB), Refresh
    Package Sequencing and Signatures
    Connections, Expressions, Parameters, Event Handlers
    Alerting (SMTP), Error Flows (XML Destination Script)

Forward Engineering SQL Structures
    Relationships, Primary & Foreign Keys
    Data Types, Nullability, Indexes

Demos for Multiple Design Patterns
    Dimensions (Slowly Changing)
    Facts (Inserts, Updates, Deletes)
    Bridges / Snowflakes

AutoBiography:
Ryan Casey, MBA, LLC
@AimYourData on Twitter
BI Architect, AIM Business Driven Data Solutions

Website: http://www.aimyourdata.com/
LinkedIn: https://www.linkedin.com/in/ryancaseymba/
Facebook: https://www.facebook.com/aim.yourdata.9
Blog: http://www.rhynodata.com/
You Tube Channel: https://www.youtube.com/channel/UCd4RTLBn8sjVR5D3gfJhq9Q

Microsoft Data Platform MVP, Public Speaker, and Group Moderator

SQL Saturday Speaker @
• 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).



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