4 Day(s)


A Data Warehouse has the potential to revolutionise your business. Increased profitability, customer retention, and market penetration are all possible applications of an effective Data Warehouse implementation, but first of all you have to build it. The approach, method and design techniques required to build a Data Warehouse differ significantly from those required to build a database to support on-line transaction processing

This practical course introduces the delegate to all the necessary terminology, architectures, approaches, skills, tools, techniques, and infrastructure required to design and implement a successful Data Warehouse solution. This is largely achieved by guiding the delegate through an easy to understand, incremental, and iterative process, and also through a series of practical exercises


Developers, software engineers, database administrators, data analysts, system analysts or application designers who will be involved in designing, building or maintaining a Data Warehouse

Skills Gained

  • make a business case, assemble a project team, and lay the infrastructure necessary for the Data Warehouse construction to begin
  • design, implement, utilise, maintain, and administer the Data Warehouse
  • build models using the dimensional (star schema) modelling technique
  • extract data from one or more operational systems
  • transform, condition, and cleanse the data
  • populate the Data Warehouse using a variety of mechanisms
  • query, drill-down, and report the data
  • understand the role of extract tools such as OLAP and data mining
  • understand the importance of metadata and issues surrounding its integration
  • assess your organisation's readiness to embark on a Data Warehousing project


  • Delegates require a basic understanding of IT and how business systems use IT; this would be gained by at least a year's experience in IT or business systems development.
  • It is assumed that delegates attending this course will already have had some exposure to Relational Databases and Database Modelling. Systems/Application programming experience would be an advantage. Database modelling skills can be acquired on the Database Analysis and Design course.

Course Specifics

Course Outline


  • Historical background; What is a Data Warehouse and why do we need it? OLTP versus DSS; Benefits to the business; Benefits to IT; Reasons for failure

The Project

  • Skills required; Top down vs. bottom up development; Ownership and funding; Methodology; Scoping and requirements gathering; Questions to ask in determining requirements


  • Review of modelling terminology and techniques; How a Warehouse is different; Logical and physical modelling; 3NF vs. denormalisation

Dimensional Modelling Basics

  • The dimensional model; The fact table; The dimension tables; Using the dimensional model; Modelling Attributes in the Dimensions; Steps in design

Dimensional Modelling Further Considerations

  • Conformed Dimensions; Synonym Dimensions; Mini Dimensions; Snowflaking; Changing Dimension Values; Handling Hierarchies; The importance of Surrogate Keys; Aggregates

Hardware Architectures and Database Architectures

  • SMP; Clusters; MPP; RDBMS, Things to look out for; Database Parallelism; TPC benchmarks

Software Architectures

  • Centralised Data Warehouse; Independent or Federated Data Marts; Hybrid approach; Standards

Data Extraction

  • Extraction method; Tool selection guidelines; Metadata; dependencies; The Data Quality Assessment Process

Data Transformation

  • The Case for data quality; Transformation; Cleansing; Conditioning; Specific data type issues; Transformation methods

Data Loading

  • How to identify what has changed; Snapshot vs. detail data; Full Refresh vs. Delta Capture; Load methodology; Load techniques

Querying the Data

  • Canned queries; Report writers; ROLAP and OLAP tools; Data visualisation; Drilldown analysis; End user training; Performance

Data Warehousing and the Internet

  • Technology overview; Web reporting; Web marts; The Internet as a data source; Extranets; Intelligent agents

Data Mining and Exploration

  • Data mining methodology; Data minining algorithms; Interpreting the output; Formulating a strategy

Operating and Maintaining the System

  • Processes and procedures; Change control; User and privilege administration; Service level agreements; Archive and recovery


  • Being ready for a Data Warehouse; Establishing a plan; Getting the mandate; Training; Feasibility study; Choosing a pilot project

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Course Location Days Cost Date
4 2000 £2000 2018-09-17