Summary
This chapter introduced basic data warehousing terms and concepts, including OLAP, BI, dimensions, and facts. We also reviewed the process and procedures you use to quickly set up a sample SSAS cube using BIDS. You worked with the AdventureWorks sample and connected to it with an Excel pivot table to give you a quick view of an OLAP solution from an end user's perspective. In the next chapter, we'll dig deeper into OLAP concepts and explore basic modeling for cubes.
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.
