O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

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.

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