Develop an Azure Synapse Analytics Data Warehouse with Dimodelo Data Warehouse Studio
Overview
1 Topic
Why Dimodelo Data Warehouse Studio
Getting Started
3 Topics
Get the Course Material
Install Dimodelo Data Warehouse Studio
Install Dimodelo Shift
Creating and Configuring a new Dimodelo Data Warehouse Studio Project
Configuring a Dimodelo Data Warehouse Studio Project to target Azure Synapse Analytics
Configure a Dimodelo Data Warehouse Studio project to target Azure SQL database
Configure a Dimodelo Data Warehouse Studio project to target SQL Server
Connecting to Source Systems
Build your First Persistent Staging tables
5 Topics
Full Extract Staging table
Incremental Extract Staging Table
Generate and Deploy the code
Run your first ETL batch
Review Persistent Staging results
Extent your Persistent Staging layer.
3 Topics
Change Tracking Extract Staging Table
Multi File Extract Staging Table
Date Range Extract Staging table
Perform complex transformations to prepare data for the Dimensional Layer
Developing Dimensions
4 Topics
Create a Task Dimension
Create a Dimension Transform
Changing Dimensions
Reloading Dimensions
Developing Facts
Dimodelo ETL Architecture
2 Topics
Persistent Staging
Dimodelo Shift Architecture
Deploying, scheduling and monitoring a Dimodelo Solution
1 Topic
Configuring Batch Dashboard (PowerBI)
Previous Topic
Next Lesson
Reloading Dimensions
Develop an Azure Synapse Analytics Data Warehouse with Dimodelo Data Warehouse Studio
Developing Dimensions
Reloading Dimensions
Previous Topic
Back to Lesson
Next Lesson
Scroll to top
Scroll to top
Light
Dark
