CHAPTER 5
Creating a Data Warehouse
Plans are only good intentions unless they immediately degenerate into hard work.
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 ...
Get Pro SQL Server 2012 BI Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
