Data Warehouse Concepts
Details
| ID | 2757913 |
| Duration | 2.0 days |
| Methods | Lecture and discussion |
| Prerequisites | General database knowledge |
| Target group | Business Intelligence Developer |
Overview
A data warehouse (DWH) is a database used for reporting and data analysis. It is a central repository of data which is created by integrating data from one or more disparate sources. Data warehouses store current as well as historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons. Online Analytical Processing (OLAP) is an approach to answering multi-dimensional analytical queries swiftly. OLAP is part of the broader category of business intelligence, which also encompasses relational database, report writing and data mining. This training walks you through the typical Business Intelligence project and helps you to understand the elements and architecture of a DWH and the usage scenarios for OLAP.
Dates
Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.
Learn with customized examples and content—precisely tailored to your requirements.
Your benefits at a glance
- Flexible preferred date
- Customized content
- Intensive exchange
- High practical relevance
Services
- Lunch / catering
- Help with hotel / travel
- Comelio certificate
- Flexible: free cancellation up to one day before
Comelio Media
Still looking for additional reading? Discover suitable specialist books in our catalog.
Content
Business Intelligence, OLAP, and Data Warehousing
Goals of a Data Warehouse - Components of a Data Warehouse: Operational Source Systems, Data Staging Area, Data Presentation, Data Access Tools - Dimensional Modeling: Fact Tables, Dimension Tables
The Data Warehouse and Design
Operational Data - The Data Warehouse and Data Models: The Data Warehouse Data Model, The Midlevel Data Model, The Physical Data Model - Normalization and Denormalization - Metadata - Technical and Physical Architecture - Deploying and Supporting the DW/BI System
The Relational and the Multidimensional Models
The Relational Model - The Multidimensional Model - Snowflake Structures - Differences between the Models - Independent Data Marts - OLAP and Aggregations - OLAP Operations
ETL - Loading the Data Warehouse
ETL (Extract, Transformation, and Load) - Designing the Staging Area - Data Structures in the ETL System - Data Flow: Extracting, Cleaning and Conforming - Loading Fact Tables - Integrating OLAP Processing into the ETL System - Development Options of ETL - Data Latency - Data Quality
Dimension Tables
The Basic Structure of a Dimension - The Grain of a Dimension - Flat Dimensions and Snowflaked Dimensions - Date and Time Dimensions - Big and Small Dimensions - Dimensional Roles - Degenerate Dimensions - Slowly Changing Dimensions - Ragged Hierarchies and Bridge Tables
OLAP and Data Mining
Business Intelligence Applications: Direct Access Query and Reporting Tools, Standard Reports, Analytic Applications, Dashboards and Scorecards - Data Mining: Data Mining Overview, Data Mining in the Applications Architecture
Instructor
Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.
Publications
- XML Schema (Comelio Medien )
978-3-939701-54-5 - Das Java Codebook (Addison-Wesley )
3827322359 - Java EE 5 Das Handbuch (Carl Hanser )
978-3446400238 - Oracle PL/SQL (Comelio Medien )
978-3-939701-40-8 - MS SQL Server - T-SQL Programmierung und Abfragen (Comelio Medien )
978-3-939701-02-6 - XML: Standards und Technologien (Comelio Medien )
978-3-939701-21-7