I have two sessions that I will be presenting in Iowa City, hope to see you there.
Increase your SSIS Productivity with Biml
Discover the power of Business Intelligence Markup Language (Biml) and increase your Integration Services development productivity. Biml can take your Integration Services package development to the next level. Creating template packages can add productivity to your Integration Services development effort. If the template design changes after development begins, refactoring to existing packages would be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.
This session will be a demo based session that will inspire you to make Biml your number one Integration Services development tool. Learn how to use Biml scripts to create both staging tables and Integration Services packages. Add metadata to your Biml scripts and really watch the possibilities expand.
Data Discovery with Microsoft Power Query for Excel
Understand how Power Query will fit into your enterprise information management strategy. Power Query, a free add-in for Excel 2010 and 2013, will enhance the self-service business intelligence offering from Microsoft. With Power Query the business analysis along with the BI developer can combine and shape data from a wide variety of data sources in a quick and easy manner. This task can enable more time to be spent in analysis and discover and less time build ETL plumbing.
This session will demo the ease of the data extraction process in Power Query. We will explore multiple data sources and even modify the language to create a foundation for further exploration into Power Query.
For more details go here: Event Site