by webmaster
12. August 2010 18:58
Understanding current trends in business conditions often requires asking a lot of questions, but allowing users to run query after query against your operations databases causes more problems than it solves. By creating a data mart, you can maintain a separate data store that can withstand the heavy query load that business analysis demands. In this webcast, you'll learn why you need a dimensional data model for your data mart, how to quickly build a dimensional model, and how to use control flow and data flow components in Integration Services to build simple packages that populate the dimensional model with data.
Stacia Misner is a consultant, educator, mentor, and author specializing in business intelligence solutions since 1999 with more than 25 years of experience in information technology. She is the author and co-author of eight books about business intelligence, with Microsoft SQL Server 2008 Reporting Services Step by Step and Introducing SQL Server 2008 R2 as her most recent books. Stacia has taught all aspects of Microsoft BI around the world, enlivening the course materials with insights, tips, best practices, and plenty of interaction to help students connect theory to actual practice. Stacia provides consulting and custom education services through Data Inspirations, writes about her experiences with BI at blog.datainspirations.com, and tweets as @StaciaMisner.
Register now!