Events

SQLSaturday #58

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server.

SCS Chief of Technology, Brian Larson, will present on the topic of “Using Data Mining to Improve SSIS Data Loads.” Brian will explain how SQL Server 2008 provides a powerful data mining environment. These data mining tools can be used to assist with the data cleansing and data validation process during extract, transform and load process. Let the data tell you which items might be invalid. Only load those records that are most likely to fit your requirements or result in sales. Prevent unwanted data from reaching your database, rather than trying to weed it out later.

SCS Business Intelligence Consultant, Dan English, will present “Leverage the MS BI Toolset to Monitor Performance.” There are many different pieces in the Microsoft BI toolset. In this session, Dan will examine all of the different pieces and utilize each of them to create a unified dashboard, where each component is being leveraged. The tools that will be utilized during this session will include SQL Server 2008, SSRS 2008, SSAS 2008, Excel 2007, Excel Services, PPS 2007, Dashboard Designer, SharePoint Server 2007 and possibly more. The goals of this session include: 1) understanding all of the Microsoft BI components, 2) learning how all of the Microsoft components can work together and 3) providing insights and tips/tricks on leveraging the Microsoft tools.

Date:

Friday, October 29, 2010

Time:

Brian’s session begins at 10:45 a.m.

Dan’s session begins at 12:45 p.m.

Location:
Mystic Lake Casino Hotel
2400 Mystic Lake Blvd.
Prior Lake, MN 55372
Map

For more information on this event visit SQLSaturday #58.