Improve SQL Server Data Warehouse Delivery Webinar

Using a Patterns-Based Approach

Recorded September 2016
What if we told you that 90% of your data integration development in SQL Server could be automated? In 5 years, you will be "old fashioned" if you are hand coding SSIS packages.

Today, plans to acquire new insights by adding data to relational databases are often thwarted by the realization that data integration and transformation will require a substantial amount of time and effort. This results in data insights continuing to be ignored as the enterprise data warehouse project backlog grows well beyond capacity.

Developers with different skill levels and design preferences create databases and SSIS packages however they see fit to get the job done. Documentation is frequently omitted. Maintenance and small enhancements consume too much development time while manual errors and inconsistencies slip through the testing and release process.

You can take advantage of tools and frameworks to rearrange the development process and alleviate these common problems. The implementation and automation of design patterns leads to improved efficiency and communication. Join us in this session to learn how to use Business Intelligence Markup Language (Biml) and Excel to facilitate metadata-driven SSIS development. We'll use database schema information plus Excel inputs to implement a small data mart from staging through the dimensional model, all in an hour!

 

 
 
 
 
 
54:02
 
 
 
54:02
 
 
 
 
 
 
 
 
 
 
 
Wistia video thumbnail - Webinar - Improve SQL Server Data Warehouse Delivery with a Patterns-Based Approach
 

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?

Cancel
message
 
 
 
Please register to watch this webinar
Error text
 
 
 
 
 
 

 Webinar GOALS

  • Learn about de-coupling design patterns from their package-specific implementation to increase consistency and quality
  • Use existing metadata and light technical documentation to automate SSIS development
  • Implement a small change across multiple SSIS packages with minimal development effort

Webinar DETAILS

  • Recorded September 2016
  • Content is intended for BI/DW Professionals and Data Scientists

PRESENTERS

Meagan Longoria
Senior Solutions Consultant BG_blogbio_MeaganLongoria-3.png

Meagan has been with BlueGranite since December 2014, offering her expertise in Microsoft business intelligence and data warehousing for technical pre-sales, solution envisioning, architecture design, solution development, training and support. She is a speaker at user groups and conferences across the country, including PASS Summit and SQL Saturday.  She is also a co-organizer of SQL Saturday Kansas City, which is on-deck this fall 2016. Meagan blogs at DataSavvy.me. Creating effective data integration solutions is a passion of Meagan's and she looks forward to sharing her real-world insights with you during this BlueGranite monthly webinar.

bill-fellows.jpgBill Fellows
Senior Solutions Consultant
SQL Server MVP

Bill has been with BlueGranite since November 2015 and specializes in converting data into actionable intelligence using Microsoft's SQL Server platform, as well programming languages including C#. He is an experienced data and analytics developer and has been a SQL Server MVP with Microsoft since October 2014.  Bill is active in the community including the Kansas City SQL User Group and SQL Saturdays.   Check out Bill's blog at http://billfellows.blogspot.com which includes several articles on Biml and Modern SQL Server design patterns.

QUESTIONS? 

CONTACT US TODAY