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)
Next Lesson
Overview
Develop an Azure Synapse Analytics Data Warehouse with Dimodelo Data Warehouse Studio
Overview
Lesson Content
0% Complete
0/1 Steps
Why Dimodelo Data Warehouse Studio
Back to Course
Next Lesson
Scroll to top
Scroll to top
Light
Dark
