Ph US: 323 521 4640 Asia Pacifc: +61 407 698 591 contact@dimodelo.com

Step By Step Training Videos

This comprehensive Dimodelo Architect training course will give you an excellent overview of the entire Dimodelo Architect product. You will get hands-on introduction to all the main features, facets, and functions to build a staging and data warehouse. This Dimodelo Architect instructor-led training will help novice to data warehouse and experts to understand how Dimodelo Architect works, and how quick a data warehouse can be created.

Download the HumanResource and Service database backups/scripts for your SQL Server Edition

Service Database backup for SQL Server 2016

HumanResources Database backup for SQL Server 2016

HumanResources and Service Database Scripts for SQL Server 2008R2/2012/2014

 

1.Introduction to Dimodelo Solutions

 

2.Dimodelo Architect Requirements

 

3.Dimodelo Architect Download and Installation

 

4.Creating a Dimodelo Solution

 

5.Configuring Dimodelo Architect for Target SQL Server Version

 

6.Configuring Configuration files for Staging and Data Warehouse Part 1

 

7.Configuring Configuration files for Staging and Data Warehouse Part 2

 

8.Creating Dimodelo Connections to Data Sources

 

9.Creating a Source System Record for Connection Managers

 

10.Using Star Scheme Wizard to Design a Data Warehouse and Import Staging Tables

 

11.Generating and Deploying Staging and Data Warehouse