This comprehensive Dimodelo Data Warehouse Studio training course will give you an excellent overview of the entire Dimodelo Data Warehouse Studio product. You will get hands-on introduction to all the main features, facets, and functions to build a staging and data warehouse. This Dimodelo Data Warehouse Studio instructor-led training will help novice to data warehouse and experts to understand how Dimodelo Data Warehouse Studio 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 Data Warehouse Studio Requirements
3.Dimodelo Data Warehouse Studio Download and Installation
4.Creating a Dimodelo Solution
5.Configuring Dimodelo Data Warehouse Studio 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