Chapter 26. SQL Server Analysis Services

After completing this chapter, you will be able to

  • Build basic data warehouses

  • Understand the dimensional model

  • Build a cube

  • Construct dimensions and measures

  • Construct hierarchies

  • Browse and deploy cubes

  • Select appropriate data mining algorithms

  • Build mining models and mining structures

  • Browse a mining model

Entire books have been written about SQL Server Analysis Services (SSAS) and still they have only scratched the surface of the subject area. This chapter will provide a very basic overview of the two core features within the Analysis Services engine: online analytic processing (OLAP) and data mining. You will learn how to take the SQL2008SBS database and turn it into a structure that allows you to take advantage ...

Get Microsoft® SQL Server® 2008 Step by Step 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.