DATA MANAGEMENT, SECURITY AND WAREHOUSING

Objective:

• Understand the data lifecycle and the specific requirements of data warehousing at each stage
• Plan, develop, and implement effective data warehousing projects
• Address challenges associated with data management and data warehousing
• Apply data security strategies throughout the entire data lifecycle
• Understand modern data management approaches and tactics in the era of Big Data

Content:

Agile Enterprise Data Warehousing

• Understanding the Agile Manifesto and its principles
• Applying the Scrum methodology in data warehousing projects
• Exploring the Extreme Programming approach
• Understanding Lean Software Development principles
• Identifying sources and standards for data warehousing practices

Data Security Strategies

• Assessing data reliability and trustworthiness
• Understanding ISO/IEC 17728 data security standards
• Overview of the EU General Data Protection Regulation (GDPR)
• Protecting data warehouse environments
• Understanding the lifecycle of a dataset

Data Warehouse Fundamentals and Building Blocks

• Understanding key data defining features
• Exploring data warehouses and data marts
• Overview of data warehouse components
• Applying dimensional analysis to data structures
• Understanding requirements as the foundation of data warehousing

Data Warehouse Architecture and Infrastructure

• Understanding hardware and operating system requirements
• Exploring database software requirements
• Automating data warehousing tasks
• Designing effective data warehouse architectures

Data Management, Security and Warehousing Implementation

• Understanding data extraction, transformation, and loading (ETL) processes
• Applying data design and preparation techniques
• Understanding dimensional data modelling
• Managing key elements of data quality
• Aligning information with user requirements
• Applying Online Analytical Processing (OLAP)
• Exploring Big Data processing in cloud environments

For Whom:

• Data Analysts and Data Scientists
• Database Administrators
• Systems Analysts
• Software Engineers and Programmers
• Project Leaders and IT Managers
• Business Professionals involved in data-driven decision-making
• Professionals working in data analytics, data management, and information systems