Module 1: Introduction to Data Warehousing

• Concepts and benefits of data warehousing
• Data warehouse architecture and components (staging area, data warehouse, data marts)
• Online Transaction Processing (OLTP) vs. Online Analytical Processing (OLAP)
• Types of data warehouses (enterprise, data mart, operational data store)
• Data warehousing lifecycle
• Practical session: Identifying the key components of a data warehouse architecture for a given business.

Module 2: Dimensional Modeling

• Principles of dimensional modeling
• Fact tables: types and design considerations
• Dimension tables: attributes and hierarchies
• Star schema and snowflake schema
• Data granularity and partitioning
• Practical session: Designing a star schema for a given business scenario.

Module 3: ETL Concepts and Architecture

• Overview of the Extract, Transform, Load (ETL) process
• ETL architecture and flow
• Importance of staging area
• Different approaches to ETL (batch vs. real-time)
• Metadata management in ETL
• Practical session: Mapping data flow from source systems to a target data warehouse.

Module 4: Data Extraction Techniques

• Identifying data sources (databases, flat files, APIs)
• Connecting to various data sources
• Data extraction methods (full vs. incremental)
• Handling different data formats
• Change data capture (CDC) techniques
• Practical session: Extracting data from a sample flat file and a relational database.

Module 5: Data Transformation Processes

• Data cleaning: handling missing values, duplicates, inconsistencies
• Data integration: schema mapping, data type conversion
• Data standardization and normalization
• Data enrichment and augmentation
• Data aggregation and summarization
• Practical session: Implementing data cleaning and transformation rules on a sample dataset.

Module 6: Data Loading Strategies

• Initial load vs. incremental load
• Different loading techniques (full refresh, append, update)
• Handling slowly changing dimensions (SCDs)
• Error handling and data reconciliation during loading
• Performance considerations during data loading
• Practical session: Implementing different data loading strategies for slowly changing dimensions.

Module 7: ETL Tool Selection and Best Practices

• Overview of popular ETL tools (e.g., Informatica PowerCenter, Apache NiFi, Talend)
• Key features and capabilities of ETL tools
• Factors to consider when selecting an ETL tool
• Best practices for ETL development and deployment
• Performance optimization techniques in ETL tools
• Practical session: Comparing different ETL tools based on specific requirements.

Module 8: Data Quality Management in Data Warehousing

• Importance of data quality in data warehousing
• Defining data quality dimensions (accuracy, completeness, consistency)
• Implementing data quality checks and validation rules
• Data profiling and data cleansing techniques
• Monitoring and reporting data quality metrics
• Practical session: Identifying data quality issues in a sample dataset and proposing solutions.

Module 9: Performance Tuning of ETL Processes

• Identifying performance bottlenecks in ETL workflows
• Techniques for optimizing ETL performance (parallel processing, indexing)
• Resource management and allocation for ETL jobs
• Monitoring and tuning ETL performance
• Best practices for large data volume processing
• Practical session: Analyzing an ETL workflow to identify potential performance bottlenecks.

Module 10: Data Warehouse Implementation and Business Intelligence

• Data warehouse implementation methodologies (Waterfall, Agile)
• Project planning and management for data warehousing projects
• User training and adoption
• The role of data warehousing in business intelligence (reporting, analysis, dashboards)
• Future trends in data warehousing
• Practical session: Outlining a high-level implementation plan for a data warehouse project.

Requirements:

·       Participants should be reasonably proficient in English.

·       Applicants must live up to Armstrong Global Institute admission criteria.

Terms and Conditions

1. Discounts: Organizations sponsoring Four Participants will have the 5th attend Free

2. What is catered for by the Course Fees: Fees cater for all requirements for the training – Learning materials, Lunches, Teas, Snacks and Certification. All participants will additionally cater for their travel and accommodation expenses, visa application, insurance, and other personal expenses.

3. Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.

4. The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

5. Approval of Course: Our Programs are NITA Approved. Participating organizations can therefore claim reimbursement on fees paid in accordance with NITA Rules.

Booking for Training

Simply send an email to the Training Officer on training@armstrongglobalinstitute.com and we will send you a registration form. We advise you to book early to avoid missing a seat to this training.

Or call us on +254720272325 / +254725012095 / +254724452588

Payment Options

We provide 3 payment options, choose one for your convenience, and kindly make payments at least 5 days before the Training start date to reserve your seat:

1. Groups of 5 People and Above – Cheque Payments to: Armstrong Global Training & Development Center Limited should be paid in advance, 5 days to the training.

2. Invoice: We can send a bill directly to you or your company.

3. Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

1. Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

2. Participants may cancel attendance 14 days or more prior to the training commencement date.

3. No refunds will be made 14 days or less before the training commencement date. However, participants who are unable to attend may opt to attend a similar training course at a later date or send a substitute participant provided the participation criteria have been met.

Tailor Made Courses

This training course can also be customized for your institution upon request for a minimum of 5 participants. You can have it conducted at our Training Centre or at a convenient location. For further inquiries, please contact us on Tel: +254720272325 / +254725012095 / +254724452588 or Email training@armstrongglobalinstitute.com

Accommodation and Airport Transfer

Accommodation and Airport Transfer is arranged upon request and at extra cost. For reservations contact the Training Officer on Email: training@armstrongglobalinstitute.com or on Tel: +254720272325 / +254725012095 / +254724452588