Business Intelligence - OLAP and Data Warehousing

• Dauer:
  2 Tage
• Zeit:
  10:00 - 16:00
• Lieferart:
  Online
• Zielgruppe:
  Business Intelligence Developer
• Vorkenntnisse:
  General database knowledge
• Methode:
  Lecture and discussion
• Erfahren Sie in der Demo mehr darüber, wie Online-Kurse durchgeführt werden.
• Kursnummer:
  2022998
• 
  Themen:
  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.

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

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 Model - The Multidimensional Model - Snowflake Structures - Differences between the Models - Independent Data Marts - OLAP and Aggregations - OLAP Operations

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

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

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

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.

Veröffentlichungen

• "XML Schema" (Comelio Medien, ISBN 978-3-939701-54-5)
• "Das Java Codebook" (Addison-Wesley, ISBN 3827322359)
• "Java EE 5 Das Handbuch" (Carl Hanser, ISBN 978-3446400238)
• "Oracle PL/SQL" (Comelio Medien, ISBN 978-3-939701-40-8)
• "MS SQL Server - T-SQL Programmierung und Abfragen" (Comelio Medien, ISBN 978-3-939701-02-6)
• "XML: Standards und Technologien" (Comelio Medien, ISBN 978-3-939701-21-7)

Erfahrung: - He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Projekte: - He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining.

Forschung: He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Zertifizierung: Marco Skulschus is "Microsoft Certified Trainer", “Oracle Associate” and passed the ComptiaCTT+ examination.

Bei der Anmeldung von mehreren Teilnehmern bieten wir Ihnen attraktive Rabatte an. Ab drei Teilnehmern kann sich ein Inhouse-Seminar bei Ihnen lohnen. Gern erstellen wir Ihnen ein individuelles Angebot.
Alle Preise zuzüglich der gesetzlichen Mehrwertsteuer.