Data Scientist with ITIL® 4 Foundation in IT Service Management and PRINCE2® 7 Foundation in Project Management

Basics of Business Intelligence (approx. 2 days)

Fields of application, dimensions of a BI architecture

Basics of business intelligence, OLAP, OLTP, tasks of data engineers

Data Warehousing (DWH): handling and processing of structured, semi-structured and unstructured data

Requirements management (approx. 2 days)

Tasks, objectives and procedures in requirements analysis

Data modeling, introduction/modeling with ERM

Introduction/modeling in UML

- Class diagrams

- Use case analysis

- Activity diagrams

Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment

Databases (approx. 3 days)

Basics of database systems

Architecture of database management systems

Application of RDBMS

Implementation of data model in RDBMS, normal forms

Practical and theoretical introduction to SQL

Limits of relational databases, csv, json

Data Warehouse (approx. 4 days)

Star Schema

Data modeling

Creation of Star Schema in RDBMS

Snowflake Schema, basics, data modeling

Creation of Snowflake Schema in RDBMS

Galaxy Schema: Basics, data modeling

Slowly Changing Dimension Tables Type 1 to 5 - Restating, Stacking, Reorganizing, mini Dimension and Type 5

Introduction to normal, causal, mini and monster, heterogeneous and sub dimensions

Comparison of state and transaction oriented

Fact tables, density and storage from DWH

ETL (approx. 4 days)

Data Cleansing

- Null Values

- Preparation of data

- Harmonization of data

- Application of regular expressions

Data Understanding

- Data validation

- Statistical data analysis

Data protection, data security

Practical structure of ETL routes

Data Vault 2.0, basics, hubs, links, satellites, hash key, hash diff.

Data Vault data modeling

Practical structure of a Data Vault model - Raw Vault, practical implementation of hash procedures

Project work (approx. 5 days)

To consolidate the content learned

Presentation of the project results

Introduction to data analysis (approx. 1 day)

CRISP-DM reference model

Data analytics workflows

Definition of artificial intelligence, machine learning, deep learning

Requirements and role in the company of data engineers, data scientists and data analysts

Review of Python basics (approx. 1 day)

data types

Functions

Data analysis (approx. 3 days)

Central Python modules in the context of data analytics (NumPy, Pandas)

Process of data preparation

Data mining algorithms in Python

Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment

Data visualization (approx. 3 days)

Explorative data analysis

insights

Data quality

Benefit analysis

Visualization with Python: Matplotlib, Seaborn, Plotly Express

Data storytelling

Data management (approx. 2 days)

Big data architectures

Relational databases with SQL

Comparison of SQL and NoSQL databases

Business Intelligence

Data protection in the context of data analysis

Data analysis in a big data context (approx. 1 day)

MapReduce approach

Spark

NoSQL

Dashboards (approx. 3 days)

Library: Dash

Structure of dashboards - Dash components

Customizing dashboards

Callbacks

Text Mining (approx. 1 day)

Data preprocessing

Visualization

Library: SpaCy

Project work (approx. 5 days)

To consolidate the content learned

Presentation of the project results

Introduction to Machine Learning (approx. 5 days)

Why machine learning?

Application examples

Supervised learning, unsupervised learning, partially supervised learning, reinforcement learning

Examples of data sets

Getting to know data

Training, validation and test data

Viewing data

Making predictions

Supervised learning (approx. 5 days)

Classification and regression

Generalization, overfitting and underfitting

Size of the data set

Algorithms for supervised learning

Linear models

Bayes classifiers

Decision trees

Random Forest

Gradient Boosting

k-nearest neighbors

Support Vector Machines

Conditional Random Field

Neural Networks and Deep Learning

Probabilities

Unsupervised learning (approx. 5 days)

Types of unsupervised learning

Preprocessing and scaling

Data transformations

Scaling training and test data

Dimension reduction

Feature engineering

Manifold learning

Principal component decomposition (PCA)

Non-negative matrix factorization (NMF)

Manifold learning with t-SNE

Cluster analysis

k-Means clustering

Agglomerative clustering

Hierarchical cluster analysis

DBSCAN

Cluster algorithms

Evaluation and improvement (approx. 2 days)

Model selection and model evaluation

Tuning the hyperparameters of an estimator

Cross-validation

Grid search

Evaluation metrics

Classification

Project work (approx. 3 days)

To consolidate the content learned

Presentation of the project results

Introduction to Deep Learning (approx. 1 day)

Deep learning as a type of machine learning

Fundamentals of neural networks (approx. 4 days)

Perceptron

Calculation of neural networks

Optimization of model parameters, backpropagation

Deep learning libraries

Regression vs. classification

Learning curves, overfitting and regularization

Hyperparameter optimization

Stochastic gradient descent (SGD)

Momentum, Adam Optimizer

Learning rate

Convolutional Neural Network (CNN) (approx. 2 days)

Image classification

Convolutional layers, pooling layers

Reshaping layers, flattening, global-average pooling

CNN architectures ImageNet-Competition

Deep neural networks, vanishing gradients, skip connections, batch normalization

Transfer Learning (approx. 1 day)

Adaptation of models

Unsupervised pre-training

Image data augmentation, explainable AI

Regional CNN (approx. 1 day)

Object localization

Regression problems

Branched neural networks

Methods of creative image generation (approx. 1 day)

Generative Adversarial Networks (GAN)

Deepfakes

Diffusion models

Recurrent neural networks (approx. 2 days)

Sequence analysis

Recurrent layers

Backpropagation through time (BPTT)

Analysis of time series

Exploding and vanishing gradient problems

LSTM (Long Short-Term Memory)

GRU (Gated Recurrent Unit)

Deep RNN

Deep LSTM

Text processing using neural networks (approx. 2 days)

Text preprocessing

Embedding layers

Text classification

Sentiment analysis

Transfer learning in NLP

Translations

Sequence-to-sequence method, encoder-decoder architecture

Language models (approx. 1 day)

BERT, GPT

Attention layers, Transformers

Text generation pipelines

Summarization

chatbots

Deep reinforcement learning (approx. 1 day)

Control of dynamic systems

Agent systems

Training through rewards

Policy Gradients

Deep Q-learning

Bayesian neural networks (approx. 1 day)

Uncertainties in neural networks

Statistical evaluation of forecasts

Confidence, standard deviation

Unbalanced data

Sampling methods

Project work (approx. 3 days)

To consolidate the content learned

Presentation of the project results

Understanding the key concepts of IT service management (approx. 2 days)

Introduction to the service concept

The ITIL® qualification scheme

Definition of important terms in IT service management ITSM

Key concepts of value creation through services

Key concepts of relationship management

Basic conceptual building blocks of ITIL® (approx. 2 days)

The ITIL® Guiding Principles

Type, use and interaction of the Guiding Principles

The four dimensions of service management

The ITIL® Service Value Systems (SVS) and its components

The Service Value Chain, its activities and their interaction

Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment

The ITIL® Practices (approx. 3 days)

The seven most important ITIL® Practices

The purpose of the other eight ITIL® Practices

Project work, certification preparation and certification exam (approx. 3 days)

ITIL® is a registered trademark of AXELOS Limited, used with the permission of AXELOS Limited. All rights reserved.

Introduction to project management based on PRINCE2® (approx. 1 day)

Definition and characteristics of a project

Project control cycle of project management and the six project dimensions

Challenges in project management - why do projects fail?

Advantages of the PRINCE2® project management method

Customer-supplier environments

Projects in a commercial environment

Structure of the PRINCE2® method and its five integrated building blocks

The PRINCE2® basic principles (approx. 1 day)

The seven basic principles of PRINCE2®

Statements and contents of the basic principles

Relationship between the basic principles and the PRINCE2® topics

Adaptation of PRINCE2® to the project environment

Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment

The importance of people for PRINCE2® projects (approx. 1 day)

Change management

Leadership and management

Communication in the project

The seven topics of PRINCE2® (approx. 3 days)

Business case (benefits management approach and sustainability management approach)

Organization (project structure, roles and responsibilities)

Creation of plans

Quality planning and quality control

Risk management

Issue management

Controlling the progress of the project

The seven PRINCE2® processes (approx. 2 days)

Interaction of the seven PRINCE2® processes in the project process

Activities in the respective PRINCE2® processes

Preparing, steering and initiating a project

Controlling a phase

Managing product delivery

Managing phase transitions

Closing a project

Project work, certification preparation and certification exam (approx. 2 days)

PRINCE2® is a registered trademark of AXELOS Limited, used with the permission of AXELOS Limited. All rights reserved.