Speaking at SQL Saturday #394 Iowa City

SQLSaturday #394 - Iowa City 2015

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


About Reeves Smith

Reeves Smith is a consultant and trainer. He holds a Bachelor’s Degree in Applied Mathematics from University of Colorado at Colorado Springs and a Microsoft Certified Master with over 17 years of experience working with SQL Server. Reeves is an independent BI consultant and teammate with Linchpin People. He is an active member of the Denver, CO, PASS chapter and delivers technical presentations at local and regional conferences and user groups. He has had the opportunity to work on various development and data warehouse projects within industries like banking, DoD, energy, entertainment, gaming, healthcare, manufacturing, oil and gas, travel, and telecommunication. You can follow him on Twitter at SQLReeves.
This entry was posted in Uncategorized. Bookmark the permalink.

1 Response to Speaking at SQL Saturday #394 Iowa City

  1. Pingback: News About PASS For Week Ending May 30, 2015 | PASSWatch

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s