Information Technology

Data Warehouse Design and Implementation (2 Days) - Virtual or In-person

In this two-day class you will discuss the essentials of data warehousing using the Kimball guide to dimensional modeling. Data warehouses should use a different design than a regular transactional database. The large amount of data the warehouse stores and the different use patterns of business intelligence work more efficiently if the database reflects these characteristics. You will become familiar with those traits and learn how to design a database that your business intelligence teams can use for the best results. This class uses SQL Server as the demo data source though it covers topics useful on a variety of database systems. This class is targeted to anyone working with data warehouses and does not require coding—though SQL knowledge is nice.

    Performance Objectives: Upon completion of this course you should be able to:

    • Design a clean and efficient schema for a data warehouse.
    • Create fact and dimension tables.
    • De-normalize data to give more rapid and efficient access.
    • Create a star or snowflake schema.
    • Implement solutions to Slowly Changing Dimensions.
    • Secure the data within the data warehouse and in transit to users
    • Implement a simple Extract – Transform – Load (ETL) strategy.

    Competencies covered in this course: Data Warehouse Design and Implementation

      Intended Audience:  Database Administrators, Developers, Managers, and Testers

        Recommended Pre-requisites:  6 months experience using SQL Server or another database system

        Virtually Led Trainings: If you’re registering for a virtual training, the classroom link and materials will be sent to you separately within 1-2 business days before the scheduled class date.

        Scheduled Class Location and Dates
        City / Facility Date and Time Course Cost Cancel Date Instructor
        1 Virtual

        Virtual Training
        • Mar 10 2021 8:00am-4:30pm
        • Mar 11 2021 8:00am-4:30pm
        $795.00 Sun, 02/21/2021 - 16:00 Jim Parshall