The training course is suitable to a wide range of professionals but will greatly benefit:
Systems Analysts
Programmers
Data Analysts
Database Administrators
Project Leaders
Software Engineers
Managers
Any Professional involved in Data Analytics
Programme Overview
Data Management, Security and Warehousing training course is designed for professionals and companies that want to take full advantage of Big Data thrive. As the Big Data phenomenon appeared the companies are relying more and more on adequate Data Analytics and Data Science to properly plan, prepare, react to the business challenges, as well as to innovate the way they are conducting their business and increase the level of service to their customers while at the same time reduce costs and streamline their processes. It has become so widespread that the term Industrial Revolution 4.0 become a household name.
With Big Data comes to the challenge of data management, as just having the data does not suffice, Data Management is defined as an administrative process that includes acquiring, validating, storing, protecting, and processing required data to ensure the accessibility, reliability, and timeliness of the data for its users.
Objectives
At the end of this training course, you will:
Learn how to plan the steps in the data warehousing project
Acquire the knowledge to determine why there is an escalating need for strategic information
Get acquainted with the fundamental problem of data management and data warehousing
Learn the strategies of data security
Be able to determine what methods and tactics you should use in the Big Data era
Methodology
Data Management, Security and Warehousing training course adopts a problem‐based learning approach, in which delegates are presented with a series of real problems drawn from the widest possible range of applications – they range from economy models to supply chain and logistics, from oil and gas to civil engineering, and from production optimization to financial risk assessment. Each problem presents and exemplifies the need for a different modelling or analytical approach. This training course is entirely oriented towards planning, preparing and executing Data Warehousing project, with the focus on Data Management and Data Security.
Course Outline
DAY 1 - Agile Enterprise Data Warehousing
Agile Manifesto
The Scrum Method
Extreme Programming Approach
Lean Software Development
Sources for Data Warehousing Standards
DAY 2 - Data Security Strategies
How to determine if you can trust your data?
ISO Standard ISO/IEC 17728
EU General Data Protection Regulation (GDPR)
Protecting the Data Warehouse
The Lifecycle of a Dataset
DAY 3 - Data Warehouse: The Building Blocks
Data Defining Features
Data Warehouses and Data Marts
Data Warehouse Components Overview
Dimensional Analysis of Data
Requirements as the Driving Force for Data Warehousing
DAY 4 - Data Warehouse: Architecture and Infrastructure Requirements for Data Warehousing
Hardware and Operating Systems
Database Software
Automation of Warehousing Tasks
Data Warehouse Architecture
Business Conceptual Model
Logical Data Model
Physical Data Model
DAY 5 - Data Management, Security and Warehousing Implementation
Data Extraction, Transformation, and Loading
Data Design and Data Preparation-data Dimensional Modeling
