Sign In   |   View Cart   |     |   Help
 
Course Catalog
 
Print Course information
E-mail to a friend
Return to Course Catalog

Courses and Programs > Computers > Database, Programming & Data Management

Data Warehouse Information & Overview  

Databases storing details of the organization’s day to day operations contain important data to track and make decisions. Data Warehouses facilitate complex analysis by restructuring, consolidating and summarizing operational data. Data Warehouse projects require in-depth analysis to determine data structure to support your organizational goals.

Finding agile solutions in a technical world and delivering technology projects can be difficult, particularly understanding how different technological elements work together towards a solution. This is the recommended eighth class of the Technical Solutions Delivery Certificate that provides an overview of technological understanding to help in the communication of projects and working relationships.

Class format includes lecture, hands-on exercises, and real world examples.

Upon completion of this class, you should be able to:
  • Compare and contrast Online Transaction Processing (OLTP) databases and data warehouses
  • Define the four step design process for data warehouses
  • Outline common data warehouse structures: Star, Snowflake and OLAP
  • Determine what fact tables are and how they measure business performance
  • Understand dimension tables and tracking the details of measurements

Audience: This course is ideal for anyone, but especially communications professionals, who are involved in data project conception. This class is aimed at non IT professionals to gain an overview understanding of the IT world.

 

Data Warehouse Information & Overview

Item: C343 Jillian Lamont Bates
8:00 AM - 4:30 PM ONLINE
Sessions: 1 Tu Location: ONLINE
, WA
1/26/2021 - 1/26/2021 Fee: $375.00
This class is offered online using Zoom.

Zoom Requirements:
  • Access to a computer with speakers & microphone (or the ability to call in via phone).
  • A web camera (suggested but not required).
  • Access to high-speed internet.

  • Zoom link will be sent prior to the start of class.


    Registration for this class will open soon.