This course consists of a series of tutorials you can follow to learn how to build your first Azure Synapse Analytics using Dimodelo Data Warehouse Studio.
Content
The course consists of the following lessons:
- Overview. What is Dimodelo Data Warehouse Studio and why is it useful.
- Getting Started. Get the course materials and install the necessary software so you can follow along.
- Creating and Configuring a new Dimodelo Data Warehouse Studio Project
- Configuring Dimodelo Data Warehouse Studio for Azure Synapse Analytics
- Connecting to Source Systems
- Staging Data from Source Systems
- Perform complex transformations to prepare data for the Dimensional Layer
- Developing Dimensions
- Developing Facts
- Deploying and Scheduling a Dimodelo Solution
Aim
By the end of this course, you will be able to use Dimodelo Data Warehouse Studio to quickly build and maintain a data warehouse on the Azure Synapse Analytics Data Warehouse platform.