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!


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?

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


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


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 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 is a previous BlueGranite employee. He specializes in converting data into actionable intelligence using Microsoft's SQL Server platform, as well programming languages including C#. Bill is an experienced data and analytics developer and has been a SQL Server MVP with Microsoft since October 2014.  He is active in the community including the Kansas City SQL User Group and SQL Saturdays.







How much energy should we generate next quarter to meet demand?



Based on previous usage history at this location, how many gallons of water with a new customer will likely use per month?



How will a cold Winter affect natural gas usage compared to the past few years?





How many of this item do I expect to sell this month?



Given that it takes a while to get a delivery, how much of each item should I order?

Customer Traffic

Customer Traffic

How many workers should I schedule based on projected customer traffic today?


Information Technology

Infastructure Utilization

Infastructure Utilization

What level of bandwidth utilization should we expect each day this month?

System Outages

System Outages

Given past history of outages, when is the next outage likely to occur?

Personnel Support

Personnel Support

Given the current trending numbers of employees, how many do we suspect we will have to support next year?