TECHNOLOGY INDEPENDENT COURSES

Course

Course Summary

Dates

Executive Overview of
Data Warehousing

Duration: 1 Day

Time: 8:30 - 16:30

Prerequisites:  None

Who should attend:

• Business Executives
• Business Unit Managers
• Project Leaders

Purpose:   This one day course creates awareness of Data Warehousing / Business Intelligence within an organisation. It discusses various Data Warehouse concepts foreign to non-data warehouse practitioners and the value of data warehousing is explored. A clear distinction is drawn between Data Warehousing solutions and Operational Systems. 

Topics:

• Introduction to Data Warehousing
• Business Value of the Data Warehouse
• Different roles and responsibilities within a Data Warehouse
• Team
• Impact of a Data Warehouse Strategy on Business
• Project Planning and Management
• Reasons for, components and deliverables of and Architectural approach
• Importance of Business Requirements Analysis
• Conceptual overview of Dimensional Modeling and its importance
• The challenges of Business Intelligence
• Conceptual overview of technical concepts
• Business Intelligence Example

Johannesburg 

On Request

Cape Town

On Request

Data Warehouse Concepts and Dimensional Modelling Techniques

Duration:  3 Days

Time: 8:30 - 16:30

Prerequisites:  None

Who should attend:

• Data Warehouse Administrators
• Project Managers
• Database Administrators
• Developers
• Analysts
• Data Warehouse Practitioners

Purpose:  This comprehensive course endeavors to create successful Data Warehouse Practitioners. It covers the complete lifecycle of a data warehouse project / initiative. 

Topics:

• The Data Warehouse and Dimensional Modeling in Perspective
• Evolution, terminology, value and definition of the DW
• DW Project Planning and Management
• Impact of a Data Warehouse Strategy on Business
• Reasons for, components and deliverables of an Architectural Approach
• Business Requirements Definition
• How to Implement a Data Warehouse
• Business and Technical Architecture
• Dimensional Modeling and Design Techniques: Basics and Expanded (including exercises and workshops)
• Implementation Considerations
• Data Warehouse Construction
• High level introduction to Back-end and Front-end processes
         o ETL Overview
         o Deployment Overview

Johannesburg 

25, 26, 27 January
14, 15, 16 March
30, 31 May, 01 June
25, 26, 27 July
26, 27, 28 September
28, 29 30 November

Cape Town

15, 16, 17 February
18, 19, 20 April
20, 21, 22 June
29, 30, 31 August
31 Oct, 01, 02 Nov

Business Analysis for Business Intelligence

Duration:  1 Day

Time: 8:30 - 16:30

Prerequisites:  None

Who should attend:

• Business Analysts
• Data Warehouse Practitioners
• Project Leaders

Purpose: To teach techniques to be utilized during the business analysis phase of data warehouse / business Intelligence initiatives

Topics:

• Introduction to Business Analysis
• The Business Intelligence Landscape
• Introduction to Analytical Systems
• Basic elements of a Data Warehouse
• Operational Systems vs. Analytical Systems
• Value of Analytical Systems
• Architectural Approach
• Business Architecture
  • Deliverables
  • Providing techniques for doing this effectively
  • Describing documentation methods

Johannesburg 

On Request

Cape Town

On Request

TECHNOLOGY SPECIFIC COURSES

Course

Course Summary

Dates

Sagent Query, Reporting and Analysis Course

Duration:  2 Days

Time: 8:30 - 16:30

Prerequisites:  Working knowledge of Windows Environment

Recommended: Understanding of relational database design principles, and basic understanding of database concepts  

Who should attend:

• Users responsible for delivering information to the organisation 
• Power users

Purpose: To enable users to utilise Sagent's front-end tools effectively

Topics:

• Introduction to Data Warehouse concepts 
• Introduction to the Sagent Solution 
• Information Studio - Getting Started with Plans and Snaps 
• Information Studio -Advanced work with Plans and Snaps 
• Sagent Analysis 
• Sagent Reports 
• Excel Integration

Johannesburg 

On request

Cape Town

On Request 

Sagent Solution Course

Duration:  3 Days

Time: 8:30 - 16:30

Who should attend:

• Users responsible for delivering information to the organization
• Developers involved in data integration , data migration, data -de-duplication, data cleansing and automation projects 

Purpose: Participants will be able to create and optimize plans to access, analyse, cleanse, integrate and collaborate on data; use various Sagent transforms to manipulate data. Learn how to Automate processes and administrate the Sagent environment

Topics:

• Overview of the full Sagent Solution
• Introduction to Information Studio and Design Studio
• Working with Plans and Snaps
• Advanced concepts of Information Studio and Design Studio
• Weblink
• Using the data flow editor and plan properties
• Designing Baseviews
• Designing Metaviews
• Sagent Data Flow Transforms
• Advanced Matcher Transform
• Sagent Automation
• Sagent Admin

The focus of this course is on determining data quality issues early in the project life cycle.

Johannesburg 

On Request

Cape Town

 On Request

Profiler Plus

Duration: 1 Day
Time      : 8:30 – 16:30

Prerequisites:  Working knowledge of Windows Environment

Recommended: Understanding of relational database design principles, and basic understanding of database concepts

Who should attend:

• Data Quality Administrators
• DQ Project Managers
• Data Warehouse Practitioners and Data Stewards
• Developers involved in data cleansing and/or data integration projects
• Staff responsible for delivering information to the organization

Purpose:  Participants will learn which aspects about data quality and data cleansing to consider, where to start and how to apply technology. Get an overview of Profiler Plus's architecture, analysis process and key terms. Learn using the Profiler Plus technology to accurately and efficiently analyze and diagnose data quality related problems.
 

  Topics:

• Overview of  Data Quality Issues
• Introduction to Profiler Plus technology
• Key Features and Functionality
• Data Fitness
• Traditional Approach vs. Profiling
• Functional Overview
• DQ Data Analysis
• Administration Tasks
• Data Sources
• Capturing Metadata
• Running Data Profiles
• Analysing Profile Results
• Key, Dependency and Join Testing
• Documenting and working with Issues and Notes
• Profile Reporting

Johannesburg 

On Request

Cape Town

 On Request