adventureworks database download microsoft sql server 2012

Download Microsoft SQL Server 2012 AdventureWorks Database for Adventure-filled Data Analysis

The AdventureWorks database is a widely used sample data warehouse provided by Microsoft as part of its SQL Server 2012 software package. The database serves as a comprehensive example of a data warehouse, offering a diverse range of tables and data types that can be used to test and demonstrate various data analysis and reporting scenarios.

To create a Mondrian schema for the AdventureWorks database, we must first understand the structure of the database. The auto-modeler from Analyzer and PUC in Pentaho support only 'star' schemas, making it necessary to manually build the model using PSW and XML to join the Customer dimension with the Geography dimension and the customer key back to the customer key in the Fact table (FactInternetSales).

One of the unique features of the AdventureWorks database is its use of 'snowflake' schema joins between dimension tables. This complexity is the primary reason we are following this workflow for this example.

To build a manual Mondrian schema, start by launching the Pentaho Schema Workbench (PSW) client and constructing the primary parts of the model, such as measures, dimensions, calculations, and more. Alternatively, you can download the complete sample XML schema I built, which you can use in Pentaho Mondrian and Schema Workbench to connect to your SQL Server AdventureWorks Data Warehouse database.

In this example, we will build a model first as an XML document and then use the Pentaho cube design tool, Pentaho Schema Workbench. To follow along, make sure you download the latest version of Pentaho 5.0 product from their official website. You may notice some UI differences and workflow changes in the process.

In this article, we have demonstrated how to create a manual Mondrian schema for the AdventureWorks database using PSW and XML. By following these steps, you can connect to your own SQL Server AdventureWorks Data Warehouse database and start exploring its vast array of data. With Pentaho Business Analytics suite, you can turn your existing SSAS cubes into Mondrian cubes that run natively inside the Pentaho Business Analytics suite.

Whether you're a data analyst or a business intelligence professional, the AdventureWorks database offers a rich playground for testing and demonstrating various data analysis and reporting scenarios. By leveraging the power of Pentaho Business Analytics suite, you can unlock new insights from your data and make more informed business decisions.

Adventureworks database download microsoft sql server 2012