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): 33499/ 96

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

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






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-12-18 5:29:41 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search