SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack, to develop Online Analytical Processing (OLAP) solutions. In simple terms, you can use SSAS to create cubes using data from data marts / data warehouse for deeper and faster data analysis. Introduction I am a DBA consultant and several times, in the past, I have been asked for a good tool to generate fast reports to get information about the company like total sales, sales per year, month, week etc SSAS is a Business Intelligence (BI) technology that Microsoft bought from Panorama Software in 1996.
This release contains sample Adventure Works tabular and multidimensional model database backups, scripts, and projects for use with Azure Analysis Services and SQL Server Analysis Services.
Feedback on this release: send to [email protected]
A full database backup of an Analysis Services multidimensional database. This sample is based on Adventure WorksDW2014 sample data. Requires SQL Server 2014 Analysis Services or later.
A sample Analysis Services multidimensional model project. Requires Visual Studio 2015 with SQL Server Data Tools. To use this sample project, you must install an AdventureWorksDW database as a data source.
Instructions to install the AdventureWorksDW2014 multidimensional model from the full database backup, or by using the project.
A collection of completed sample projects for each lesson in the multidimensional modeling tutorial. Requires SQL Server Analysis Services 2012 or later. To use this sample project, you must also install an AdventureWorksDW database as a data source.
A sample AdventureWorks Internet Sales tabular model database at the 1200 compatibility level. To restore, you must have an Azure Analysis Services server or a SQL Server 2016 or later Analysis Services instance.
A sample AdventureWorks Internet Sales tabular model project at the 1200 compatibility level. This sample project requires SQL Server Data Tools (SSDT) for Visual Studio 2015 or Visual Studio 2017 with Microsoft Analysis Services Projects. To load data into the workspace database for this project, you must also install an AdventureWorksDW database as a data source. To deploy this project, you must have an Azure Analysis Services server, or a SQL Server 2016 or later Analysis Services instance.