SQL Server Analysis Services Concepts: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
SQL Server Analysis Services Concepts

page 1 of 6

Published: 22 Sep 2008

Abstract
In this series of articles, Nidal explains how Microsoft has done a great job in the world of business intelligence using Microsoft SQL Server Analysis Services (SSAS). The author deeply examines the concept of OLAP Services and Unified Dimensional Model. He also points out where SSAS fits in SQL Server and also the requirements to work with it in a step-by-step manner.

by Nidal Arabi
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 26368/ 32

Article Contents:

Introduction

SQL Server Analysis Services (SSAS) is a part of the Microsoft SQL Server platform that was introduced in SQL Server 2000 and has been greatly enhanced since Microsoft SQL Server 2005. It provides the platform on which you, as developer, can develop business intelligence solutions using the most advanced tools available in the market.

Concepts

Let us first introduce some concepts that are essential to any developer to begin creating any new project.

SSAS provides a platform for enterprise reporting and data analysis. It is composed of two main core services:

· Online Analytical Processing (OLAP) which is designed for storing and retrieving large amounts of data to be used for ad-hoc reporting and analysis.

· Data mining which provides for data analysis using models to uncover trends and patterns in your data.

View Entire Article

(Page 2) »

User Comments

Title: bbb
Name: bbb
Date: 2012-05-10 6:48:04 AM
Comment:
Yes Good

Title: aaa
Name: aaa
Date: 2008-09-26 12:32:09 AM
Comment:
Yea Good