Level: Introductory to Intermediate
Are you interested in starting a data warehousing project but are unsure of the necessary steps, including the pitfalls you'll need to avoid? Join Craig Utley for a full-day session that walks through the entire process of data warehousing. You'll learn to design a dimensional model to address a business issue, design the ETL (extraction, transformation, and loading) to load the dimensional model, build an Analysis Services cube from the dimensional data, and then deliver the data using a variety of tools to support diverse user needs. Craig Utley has been working with the Microsoft BI stack since the betas of SQL Server 7.0 and is a former Program Manager with the Microsoft SQL Server Customer Advisory Team (SQLCAT), where he worked with some of the world's largest SQL Server data warehouses. This session will not only show you how to build a warehouse, but will also discuss best practices and pitfalls.
You will learn:
- How to design the dimensional model that is at the heart of you BI solution
- Understand the entire BI creation process
- How to build a BI solution and deliver value to the business