Past Meetup

CBusPASS December 2014 User Group

This Meetup is past

23 people went

Microsoft Polaris Office

8800 Lyra Drive 4th Floor · Columbus, OH

How to find us

Look for the sign that says "CBusPass"!

Location image of event venue

Details

Hey SQL Server warriors, here we go again (in the Microsoft Office at Polaris)!

Give yourself a gift before the holidays! Attend a session on BIML (that's BI Markup Language), presented by Chris Schmidt and Harsh Jain. This technology will change how you approach building ETL.

TOPIC

BIML: Oh Brave New ETL World!

It's estimated that 70% of data warehousing development is in ETL (extract, transformation, and load) between the different source systems, your data warehouse, and/or your data mart. Recently a new tool has entered the marked that promised to revolutionize the way we think about ETL processes. Gone are the days where we need to manually code every component, every event handler, and painstakingly ensure that every package adheres to corporate standards.

In this session, Chris and Harsh will introduce you to the world of BIML and how it can change your world. We'll show you how to quickly create a template in BIML that will make sure all of your packages adhere to corporate standards, and then use metadata to quickly generate dozens of packages to populate your dimensions and facts. Stop spending weeks developing SSIS packages that can be built in hours! You won't want to miss this session that will get your boss to say "I don't think we're paying you enough!

AGENDA

We'll start with dinner at 6pm at Microsoft, followed by networking and the presentation from Chris and Harsh. Centric Consulting is hosting dinner. Please join us!

You can also register as a PASS member for free at sqlpass.org (http://www.sqlpass.org/). This is encouraged but not required for attendance.

TIME & LOCATION

December 11,[masked]:00pm-8:00pm

Microsoft Polaris Office (http://maps.google.com/maps?q=8800%20Lyra%20Drive%2C%20Columbus%2C%20OH)
8800 Lyra Drive
4th Floor
Columbus, OH

SPEAKER

Chris Schmidt is a data architect with Centric Consulting and has experiencing designing business intelligence solutions for a wide variety of companies in multiple industries. His passions include the entire Microsoft BI stack, with a special emphasis on SSIS and SSAS.

Harsh Jain is a data warehouse developer with Centric Consulting and has more than 4 years’ experience developing ETL on a variety of platforms, including SSIS and Informatica. He holds an MIS degree from the University of Cincinnati and is enjoys helping companies solve their data integration challenges.