O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

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 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 ...

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