BI and Data Warehousing Webcasts

Office 2007 will deliver a wide array of new BI capabilities, especially when combined with the BI and data warehousing features of SQL Server 2005. If you're new to BI and DW, or just new to SQL 2005, there are four info-packed TechNet webcasts coming in the weeks ahead that you'll want to check out. You can learn about SQL Server's BI and DW now, and be ready to build on that knowledge with Microsoft Office Sharepoint Server 2007 when it's released later this year.

Here are the details, with links to sign up or get more info ...

Microsoft Business Intelligence (BI) Using the Kimball Method (Level 200)

When: June 6, 2006

9:30 a.m. to 10:30 a.m. Pacific Daylight Time

Presenter: Warren Thornthwaite

Real success in business intelligence (BI) is defined by both short and long-term results. For the short term, you can win with top priority, data quality, appealing to broad interest and high value. Long-term success however, requires constant growth and expansion, as well as a solid, well-designed foundation. Join this webcast to learn how to build a strong, scalable Microsoft BI architecture. Learn about the basic Kimball Method, the data warehousing/BI Lifecycle, the three tracks of the development phase, and many more details and issues you would be hard-pressed to anticipate on your own.

Designing a Scalable Data Warehouse / Business Intelligence (DW/BI) System (Level 200)

When: June 20, 2006

9:30 a.m. to 10:30 a.m. Pacific Daylight Time

Presenter: Joy Mundy

When you are building a data warehouse / business intelligence (DW/BI) system, scale is likely to be a major concern. Either you have a large system now, or you hope to grow to have a large system; or you have a small system but a tight budget, and you want to do more with less. What does large scale even mean? Is it determined by data volume, the number of users, complexity, or something else? What are the most important factors to consider? Join this webcast to learn techniques for addressing these and many other DW/BI issues. The session introduces and explains the Kimball Method lifecycle, and shows how to apply it to a scalable DW/BI system.

Using SQL Server 2005 Integration Services to Populate a Kimball Method Data Warehouse (Level 200)

When: July 11, 2006

11:00 a.m. to 12:00 p.m. Pacific Daylight Time

Presenter: Joy Mundy

How do you combine the tasks and transforms offered by Microsoft SQL Server 2005 Integration Services (SSIS) into a real extraction, transformation, and loading (ETL) system? In this webcast, we present design patterns for building an application that is maintainable, auditable, and scalable to populate your dimensional Kimball Method data warehouse and Microsoft SQL Server 2005 Analysis Services database. Learn best practices for overall system design, for populating dimension and fact tables, and for populating the audit dimension.

Getting Started with Data Mining (Level 200)

When: July 17, 2006

11:30 a.m. to 12:30 p.m. Pacific Daylight Time

Presenter: Warren Thornthwaite

Join this webcast for a comprehensive overview of data mining from a database development perspective. We begin with a discussion of the business value and uses of data mining, such as prediction and forecasting. Learn how to detect anomalies, and how to recognize scenarios for which Microsoft data mining technology is best suited. Using a typical business-driven approach to data mining, we show how to identify data mining opportunities, and cover the practical elements needed to make it work well, such as data preparation, model building, and validation. We then examine the output, consider different implementation methods, and conclude with recommendations on how to maintain your data mining solution.