SSAS Tabular Model

Overview

I developed a SQL Server Analysis Services (SSAS) Tabular Model using the AdventureWorksDW2019 database in this assignment. I began by connecting to the database, importing key tables, and renaming them for clarity. I then created calculated columns using Data Analysis Expressions (DAX), such as profit calculations and formatted quarter labels, which enhanced the dataset’s usability. Additionally, I defined key measures like Total Revenue, Total Cost, Total Profit, and Margin to provide meaningful business insights.

A major part of the assignment involved structuring data through hierarchies. I created hierarchies for Product, Sales Territory, and Calendar, which improved data organization and made analysis more intuitive. Deploying the model was another essential step, allowing it to be accessed in SQL Server Management Studio (SSMS). Finally, I connected the deployed model to Excel, enabling dynamic data exploration through PivotTables.