Triad SQL Business Intelligence User Group

Welcome

The Triad SQL Business Intelligence Users Group is a forum where any one interested in the Microsoft business intelligence stack can meet to learn more about the product, share ideas and make contact with other similar individuals. Our group is run by Microsoft BI professionals for the benefit of anyone interested in participating in the group.

All of our meetings are free and open to anyone who is interested in sharing their knowledge of SQL Server. Our meetings are generally held on the last Tuesday of every month, unless otherwise noted. Pizza and drinks are provided.

Please register on this site to be included on the latest newsletter and emails announcing our next meetings.


Next Meeting: Tue, Apr 29 2014

Triad PASS BI - April 2014 meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

Topic:Create and Load a Staging Environment from Scratch with Biml

Abstract:

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this presentation, the free BIDSHelper add-in for BIDS and SSDT will be used to introduce Biml, and use it to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Paul will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of target table creation scripts, data load packages, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns.

 

Speaker Bio:

Paul S. Waters has almost 20 years of experience working in IT-related fields. Over half of that time, he has focused on designing and implementing data warehouses and business intelligence systems. Paul is the President of the SQL Server Innovators Guild in Greenville, SC. He was the Technical Editor for the book "Microsoft SQL Server 2008 Integration Services Problem-Design-Solution" and contributed to the Wrox book "Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports."

When

iCal
UTC : Tue, Apr 29 2014 22:00 - 00:00
Event Time : Tue, Apr 29 2014 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Tue, Apr 29 2014 22:00 - 00:00

Where

Inmar Building
635 Vine St.
Winston-Salem, North Carolina

Direction: None

Featured Presentation

Create and Load a Staging Environment from Scratch with Biml

Speaker: Paul Waters, Business Intelligence Manager Canal Insurance

Summary: Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this presentation, the free BIDSHelper add-in for BIDS and SSDT will be used to introduce Biml, and use it to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Paul will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of target table creation scripts, data load packages, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns.

About Paul: Paul has over 20 years of experience working in IT-related fields. Over the past 15 years, he has focused on Business Intelligence. Paul was the Technical Editor for the book "Microsoft SQL Server 2008 Integration Services Problem-Design-Solution" and contributed to the Wrox book "Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports."

Attachments

Please visit our sponsors at:
 
 



 

 

 

Contact Us:

Triadsqlbi@Gmail.com

 
 
 

 

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