From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Introduction to data analysis with SQL Server Analysis Services (SSAS)

Introduction to data analysis with SQL Server Analysis Services (SSAS) - SQL Server Tutorial

From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Start my 1-month free trial

Introduction to data analysis with SQL Server Analysis Services (SSAS)

“

I'd like to talk about analyzing data, using Microsoft Sequel Server analysis services. Right now our data warehouse lives inside of the Microsoft Sequel Server Database Engine, which was designed to store data, support changes to data, support the backup of data, inquiring data. The tool was not designed for an overall analysis of data. For that, we need to go to the tool called Microsoft Sequel Server Analysis Services. We'll get to that through the Sequel Server data tools. I'll create a new project, the type will be analysis services. I'd like the top option, analysis services multidimensional and data mining project. I'll take the default name and default location. I'd like to demonstrate to you the steps necessary to create a data cube. And a cube is a three dimensional, or four dimensional, or five dimensional structure that stores facts organized by dimensions. Allows for the quick retrieval of the data, and some increased performance in processing basic mathematical functions…

Contents