Class / Schedule

Information Technology

Data Warehouse Design and Implementation (2 Days)

01-04-T772
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 warehouse store 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.

Note: This course format is approximately 75% lecture.

    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.
    • Protect the custody of data using security plans.
    • Implement a simple Extract – Transform – Load (ETL) strategy.

    Competencies covered in this course: Data storage and management.

      Intended Audience:  Database administrators and developers.

        Recommended Pre-requisites:  At least one year of experience using SQL Server.

        Scheduled Class Location and Dates
        City Facility Date and Time Course Cost Cancel Date Instructor
        Lacey SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Jul 17 2017 8:00am-4:30pm
        • Jul 18 2017 8:00am-4:30pm
        $795.00 Wed, 06/28/2017 - 17:00 Jim Parshall