Get the Course Material

To download Dimodelo Data Warehouse modeler visit the product page.

This course uses two small demo SQL Server databases as the source of the data warehouse you will create. The databases are:

• Service. The service database represents a service business where staff perform tasks for clients and record their time in timesheets.
• Human Resources. A typical human resources system which records information about employees, their positions and tenure.

To complete the course you need to obtain these databases (from the link below) and create them on any accessible SQL Server 2012 or above instance. Alternatively, use an Azure SQL database.

1. Download the Database Scripts ( Databases.zip – approx 500kb).
2. Unzip Databases.zip file. The file contains 2 .sql files – HumanResourcesDatabase.sql and ServiceDatabase.sql.
3. Open and run the scripts using SSMS. Each script will create a database, tables and views in the database and some data.