This is the recommended eighth class of the Technical Solutions Delivery Certificate. Finding agile solutions and delivering technology projects can be difficult. It can be especially difficult for a non-IT professional to understand how different technological elements work together. This certificate provides an overview of the programs and systems commonly used in projects so that you can communicate and collaborate effectively with your project team.
Organizational databases store crucial information for tracking and decision making. Data warehouses help you analyze complex data by organizing and summarizing operational information. For data warehouse projects, thorough analysis is crucial to establish the data structure that aligns with your organizational objectives. This class provides you with an overview of data warehouse systems. The class format includes lecture, hands-on exercises, and real-world examples.
Performance Objectives: 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 engaged in project planning. It equips non-IT professionals with a basic understanding of the IT world.