Skip to content

README.md

Latest commit

 

History

History
120 lines (81 loc) · 2.63 KB

README.md

File metadata and controls

120 lines (81 loc) · 2.63 KB
Raw

AdventureWorks OLAP Cube Analysis

This project presents the design and implementation of an enterprise-style multidimensional OLAP cube created in SQL Server Analysis Services (SSAS) using the AdventureWorksDW database.

The solution focuses on multidimensional data modeling, analytical processing, KPI implementation, perspectives configuration, and interactive business intelligence reporting.

Project Overview

  • OLAP cube development in SSAS
  • Multidimensional data modeling
  • Fact and dimension table integration
  • KPI implementation and analysis
  • Perspectives configuration
  • Cube browsing and analytical reporting
  • Business-oriented data exploration
  • Hierarchy and relationship management

Cube Components

Fact Table

  • FactInternetSales

Dimensions

  • Customer
  • Product
  • Promotion
  • Currency
  • Sales Territory
  • Date
  • Order Date
  • Ship Date

Measures

  • Sales Amount
  • Order Quantity
  • Unit Price
  • Discount Amount
  • Freight
  • Tax Amount
  • Total Product Cost

Cube Structure

Dimension Usage

KPI Implementation

The project includes a KPI named:

Sales Performance

The KPI compares Sales Amount against a predefined business goal and visualizes performance status and trends within the OLAP environment.

KPI

Perspectives

A dedicated analytical perspective was created to simplify business-oriented reporting and improve cube usability.

Perspectives

Browser Analysis

The cube was processed and tested using the SSAS Browser interface to analyze:

  • Sales by product categories
  • Sales performance across years
  • KPI evaluation
  • Aggregated business metrics

Browser

Dataset

The project uses the AdventureWorksDW sample database provided by Microsoft for data warehousing and business intelligence practice.

AdventureWorks is a widely used enterprise-style dataset for OLAP, SSAS, and multidimensional modeling exercises.

Technologies

  • SQL Server Analysis Services (SSAS)
  • Microsoft SQL Server
  • SQL Server Data Tools (SSDT)
  • Visual Studio
  • AdventureWorksDW Database
  • OLAP / Multidimensional Modeling

Goal

The goal of this project is to demonstrate practical skills in multidimensional database design, OLAP cube processing, KPI implementation, and business intelligence analysis using Microsoft technologies.

Results

The solution successfully demonstrates:

  • Cube deployment and processing
  • Dimension integration
  • KPI configuration
  • Perspective creation
  • Interactive multidimensional analysis
  • Business data aggregation and reporting

Author

Paulina Broda