Training

Data Warehousing Training and Courseware

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Data Warehousing

WA1816 Introduction to Data Warehousing

This 2-day course examines and establishes the fundamental theories, concepts, domains, techniques and terminology that are essential for every business and information technology professional who is involved in data warehousing. Students are introduced to best practice approaches and structures for data warehouse development and implementation. Common definitions and characteristics of data warehouses, data warehouse architectures, readiness issues, incremental data warehouse project planning, data warehouse strategy and mistakes to avoid all receive special emphasis.

This course concentrates on data warehouse deliverables independent of any specific methods, but within the framework of best practices. It focuses on understanding deliverables that may be produced throughout the data warehouse process and issues reasons for producing them. This course closes with exploration for practical next steps the students can take. This includes steps further to develop knowledge and skills, to position oneself for success, and to get started with data warehousing.

 

 

More Info

WA1817 Designing the Data Warehouse Workshop

This workshop focuses on the full end-to-end process of the data warehouse, namely, Gather, Store and Deliver.

More Info

WA1818 Dimensional Modeling Workshop

This 3-day course introduces students to best industry practices for designing data warehouse data structures and databases.

More Info

WA1819 Advanced Data Warehousing

This 3-day course introduces experienced students to best industry practices for dealing with difficult data warehouse data structures, databases and processes.

This class is for experienced data warehouse architects and database designers. If you already have hands-on experience and want to refine your data warehousing skills, this is the class for you. The class will describe the most challenging data warehouse design problems the world of data warehousing has faced. You’ll also have the opportunity to share experiences gained on previous projects with other attendees. This class is intense and fast-paced.

More Info

WA1820 Service Oriented Architecture (SOA) and Data Management

This one day interactive seminar addresses the critical issues data and information management professionals will encounter in a SOA environment. It will define the five layers of SOA and the data management skills, methods and models essential to each layer.

More Info

WA1821 Information Systems Planning

This seminar uses proven techniques to perform an ISP project and to measure the success of its end results. ISP is broken into a set of major tasks; within each task, a set of steps is performed to achieve the desired deliverable. Each of the steps has a simple and easy to understand example. A case study is used to provide practical experience.

More Info

WA1822 Logical Data Modeling

This course is about taking knowledge of the business and its rules and converting these into a stable data model. The data model is a representation of the objects that the business uses, the characteristics of those objects and the rules that govern their relationship.

More Info

WA1823 Advanced Data Modeling

This is a workshop and relies on realistic exercises. You will learn how to apply leading edge data modeling principles to practical and difficult modeling situations. All of the exercises have been derived from real modeling situations.

More Info

WA1824 Database Design

The workshop provides a full discussion of and experience with database design. Three types of trade-offs to the data will be applied – technology, safe and aggressive tradeoffs. Safe compromises are trade-offs that will optimize the data model without compromising integrity or redundancy. An example of a safe trade-off is to partition a table. Aggressive compromises will optimize the data but may comprise data integrity. An example of this is to store redundant data. Technology trade-offs use overhead features of the DBMS, such as indices. Indices can improve query performance but can compromise maintenance performance. You will learn how to apply safe, aggressive  and technology trade-offs for optimizing the data.

More Info

WA1825 An Overview of Object Oriented Development

This seminar presents the concept of OO in simple, clear terms without all the hype. It offers a sensible evaluation of all the OO methods out there. It defines what OO is, and what OODBMSs and pro-gramming languages really are. It cuts through the obtuse terminology and offers a realistic assessment of the pros and cons of OO development.

It shows how to blend the concepts of OO with those in Information Engineer-ing and Structured Analysis and Design.  The result of this workshop is a sensible and versatile approach which provides the Object Oriented Analysis and Design of conventional business systems, but with a faithful rendering of OO technology.

More Info

WA1829 Business and Systems Analysis

This is a pragmatic workshop using a simple and well-known case study. You complete the course with experience in business and systems. The purpose of busi-ness analysis is to define the business needs, independent of implementation technology and organizational structure. You will learn how to select a suitable pro-ject and project scope. You will learn how to complete a business analysis rapidly. You will learn how business needs are rep-resented in stable data and process models. These are integrated through interaction (or usage) matrices.

You will learn state of the art tech-niques for data model abstraction and proc-ess model creation. But, you will not learn just diagrammatic techniques. Most impor-tantly, they will learn how to run a success-ful business analysis project.

Organized in life cycle order, the workshop covers the principles, methods and techniques of Business Analysis.  The methods taught in this course have been used for years with proven success in doz-ens of organizations -- in private industry and government. The workshop will also show how to apply them to any existing CASE product.

More Info

WA1830 System Design

The workshop divides design into Preliminary Design, External Design and Internal Design. Preliminary Design accomplishes the transition from analy-sis and determines the technical architec-ture of the system. It also decides what processes and data will reside on which processors. External Design is design from the viewpoint of the user. It defines dialogue flow and provides screen and report design. Internal Design is design from the viewpoint of the builder. It op-timizes the data, structures the logic and defines interfaces.

It uses the same case study as BAA. You complete the course with experi-ence in design.

The workshop provides a full dis-cussion of logical data base design. You will learn how to apply safe and aggres-sive trade-offs for optimizing the data. Safe trade-offs optimize the data without compromising integrity and redundancy. Aggressive trade-offs optimize the data while providing some compromise of integrity or redundancy.

More Info

WA1831 FASTPATH - A Rapid Application Development Workshop

This seminar provides an improved solution to the problems caused by the explosion in the demand for information and the problems resulting from inadequate systems development productivity. Also discussed will be the benefits to be gained by adopting a rapid but rigorous and integrated approach to developing systems that satisfy business needs and objectives.

More Info

WA1864 DB2 Administration and SQL Procedures for LUW

This course is custom designed to review the Administration of DB2 version 9.7 for LINUX, UNIX and Windows. This course has 4 major sections; basic administration, advanced recovery, “performance and tuning” and SQL Procedures.  DB2 commands and SQL will be used to focus on relevant DB2 activities.  DB2 administration functions and utilities will be reviewed and applied in workshops.  Performance and tuning issues will be reviewed and applied in workshops. Snapshot commands and administrative views will be used to gather performance data. In addition the design and use of stored procedures will be reviewed.  GUI tools may be used to create, test and debug procedures. Design issues for functions and stored procedures will be reviewed and applied in workshops. EXPLAIN tools can be used to analyze SQL access strategy. The impact of index design will be reviewed. The Developers Workbench or IBM Data Studio may be used in workshops.

More Info

WA2355 Data Based Decision-Making

This course, designed for business analyst, marketing and business development staff, uses a case study approach to teach the skills used in data based decision-making.  Participants learn how to: prepare strategies for gathering information; identify underlying issues related to a decision; generate and evaluate multiple alternatives; communicate recommendations and design plans to implement decision.

More Info

WA2356 Data Mining - A Practitioner's Course

This course provides an overview of various data mining techniques with examples of how they are used in various organizations such as retail, finance, biotechnology and social media.  Case studies are used to allow participants to work through several data mining issues using the techniques described.

More Info

WA2357 Data Visualizations - Communicating Numbers Effectively

An increase in the volume and velocity of data has spurred a need for new techniques to understand and convey its meaning.  Data visualizations are graphical means of summarizing and describing data.  This course describes various types of visualizations and teaches participants how to link they data they have and the message they want to deliver to the appropriate visualization.

More Info

WA2358 Evaluating and Improving Data Quality

Participants learn the skills required to conduct projects in the three main areas of a data quality – profiling, assessment and cleaning and process improvement.  Data profiling skills focus on understanding the data available.  Assessment and cleansing expands upon traditional definitions and incorporates multiple perspectives of data quality.  The final section of the course has participants apply a proven process improvement approach to data with the intent of learning how to create ‘good’ data instead of cleaning ‘bad’ data.

More Info

WA2359 Exploratory Data Analysis

Exploratory Data Analysis (EDA) is an approach to data analysis that creates an understanding of the important characteristics of a data set.  As such, it is a critical first step in any decision making process.  The purpose of this course is to provide a systematic method for looking at data and extracting the patterns that are contained in the data. To do that, participants will learn an approach and a set of methods that can accommodate a wide variety of data.

More Info

WA2360 Fundamentals of Data Analytics

In 2006, Tom Davenport wrote an article for Harvard Business Review titled Competing on Analytics.  Even a few short years ago, Data Analytics was a specialized skill set.  Since then much has changed.  New technologies can handle the volume, velocity and variety of Big Data, data mining techniques have improved, and tools have the capacity and capability to move analytics from specialist to business users.  In turn, companies are leveraging these abilities to move from intuition to data-based decision-making.  This course is designed to bring managers and analyst up to speed with the current thinking and techniques used to guide data analytics projects.

More Info