Tutorial 1 – Wizard
Similar Posts
Creating and Using a Derived Staging Table
What is a derived staging table? It’s a table created in your Staging database that derives its data from other already existing Staging tables. Its useful for creating aggregations, or allocations of data prior to the transform and load process into your Data Warehouse. It can also be useful for tables that don’t have any…
The Dimodelo Data Warehouse Studio code generation process
This post discusses in detail how Dimodelo Data Warehouse Studio generates code to create and manage a Data Warehouse, including creating and managing Data Warehouse Databases, Tables and ETL procedures. While Dimodelo Data Warehouse Studio has a set of predefined Generation Templates and Generation Providers , it is also extensible, allowing end users to create their own Generation Templates and Generation Providers.
Tutorial 1 – Getting Started
In this tutorial you will learn how to use Dimodelo Data Warehouse Studio to:
Create a new Data Warehouse project.
Create a connection to a Source System.
Use the Wizard to generate the Meta Data for a Data Warehouse and its Extract, Transform and Load processes (ETL).
Generate the code to create the Data Warehouse and Staging databases, and the ETL to move data from the source through to the Data Warehouse.
Deploy the code to the Server.
Execute the ETL batch.
Conversations with Data Warehouse Experts – James Rowland-Jones
In this episode I speak with James Rowland-Jones (JRJ), Principal Program Manager for Microsoft. He is passionate about delivering highly scalable solutions that are creative, simple and elegant in their design. James specializes in scale out data solutions such as Azure SQL Data Warehouse, Microsoft Analytics Platform System and Hadoop. JRJ is a keen advocate…
Data Driven Design with Agile for Data Warehousing
An introduction to using Data Driven Design and the Agile Project Methodology to quickly deliver a Data Warehouse.
Conversations with Data Warehouse Experts – Dr. Claudia Imhoff
In this episode, it is my pleasure to speak with Dr. Claudia Imhoff, a real rock star in our corner of the technology universe. She not only has the technical chops and but also an in-depth understanding of the business landscape. In 1992 she founded her consulting company, Intelligent Solutions, Inc., and in 2006 she…