O'Reilly logo

Pro SQL Server 2012 BI Solutions by Caryn Mason, Randal Root

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 5

image

Creating a Data Warehouse

Plans are only good intentions unless they immediately degenerate into hard work.

—Peter F. Drucker

When all the planning is done, it is time to create the data warehouse. SQL Server makes this task quite simple and effortless.

In this chapter, we discuss how to use the SQL Server 2012 Management Studio (SSMS) application to create a data warehouse. We look at several techniques to accomplish this, including SQL code, a table designer, and a diagramming tool that lets you visually create all of the data warehouse objects. When you have completed this chapter, you will have a working data warehouse that is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required