Similar Posts
Dimodelo Data Warehouse Studio 2.15 – Whats New
Dimodelo Solutions is proud to announce the release of version 2.15 of Dimodelo Data Warehouse Studio, its data warehouse automation tool for the Microsoft data platform. In this release we have added support for the Microsoft APS platform and SQL Server 2017. We have also redesigned our data management architecture from the ground up, introducing…
Conversations with Data Warehouse Experts – Hans Michiels
Join me for an informative discussion with Hans Michiels, founder and moderator of the Data Warehouse Automation Guide – DataWarehouseAutomation.Guide. Hans is an independent Business Intelligence and Data Warehouse consultant using Microsoft technology, working in the Netherlands. He has a special interest in Data Warehouse Automation and Metadata solutions. You can connect with Hans…
Tutorial 1 – Run ETL Batch
LinkedIn Twitter
Conversations with Data Warehouse Experts – James Serra
In this episode, it is my pleasure to speak with James Serra, Data Platform Solution Architect and Data Warehouse Evangelist at Microsoft. He is a thought leader in data warehousing and data management with over 25 years of experience in data modeling, data governance, and development methodologies. James is also a popular and prolific blogger…
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…
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.