Training agenda
  1. Introduction to Data Warehousing

    • Overview of Data Warehousing
    • Considerations for a Data Warehouse Solution
  2.  Planning Data Warehouse Infrastructure

    • Considerations for data warehouse infrastructure.
    • Planning data warehouse hardware.
  3.  Designing and Implementing a Data Warehouse

    • Data warehouse design overview
    • Designing dimension tables
    • Designing fact tables
    • Physical Design for a Data Warehouse
  4.  Columnstore Indexes

    • Introduction to Columnstore Indexes
    • Creating Columnstore Indexes
    • Working with Columnstore Indexes
  5.  Creating an ETL Solution

    • Introduction to ETL with SSIS
    • Exploring Source Data
    • Implementing Data Flow
  6. Implementing Control Flow in an SSIS Package

    • Introduction to Control Flow
    • Creating Dynamic Packages
    • Using Containers
    • Managing consistency.
  7. Debugging and Troubleshooting SSIS Packages

    • Debugging an SSIS Package
    • Logging SSIS Package Events
    • Handling Errors in an SSIS Package
  8.  Implementing a Data Extraction Solution

    • Introduction to Incremental ETL
    • Extracting Modified Data
    • Loading modified data
    • Temporal Tables
  9.  Enforcing Data Quality

    • Introduction to Data Quality
    • Using Data Quality Services to Cleanse Data
    • Using Data Quality Services to Match Data
  10. Using Master Data Services

    • Introduction to Master Data Services
    • Implementing a Master Data Services Model
    • Hierarchies and collections
    • Creating a Master Data Hub
  11.  Extending SQL Server Integration Services (SSIS)

    • Using scripting in SSIS
    • Using custom components in SSIS
  12.  Deploying and Configuring SSIS Packages

    • Overview of SSIS Deployment
    • Deploying SSIS Projects
    • Planning SSIS Package Execution
  13.  Consuming Data in a Data Warehouse

    • Introduction to Business Intelligence
    • An Introduction to Data Analysis
    • Introduction to reporting
    • Analyzing Data with Azure SQL Data Warehouse