Designing an Effective Data Warehouse

Course 2191 • 4 Days

E-mail E-mail Print Print Q&A Q&A PDF PDF Facebook Twitter Twitter

You Will Learn How To

Architect a robust data warehouse solution
Ensure a targeted solution by identifying appropriate stakeholders and requirements
Apply dimentional modeling to improve business decisions
Extract, transform and load operational data based on organisational needs
Employ Business Intelligence (BI) tools to slice and dice data
Deploy, maintain and monitor an end-to-end data warehousing project

Course Benefits

Inadequate planning and management of data warehouse projects can lead to failed implementations and dissatisfied stakeholders. A successful data warehousing project involves precise planning and analysis to implement a data store as a basis for the business decision-making process. In this course, you gain the skills needed to develop an effective data warehouse solution.

Who Should Attend

Anyone interested in implementing a data warehouse solution in their organisation, and those who need to re-engineer an existing data warehouse. Prior experience with a data warehousing implementation and/or databases is helpful but not required.

Workshop Course

A continuing case study provides you with the skills to design, plan and implement a data warehouse roadmap. Exercises and workshop activities include:

Analysing the design to identify common flaws
Collecting and analysing business requirements
Completing a database design using a modeling tool
Designing facts and dimensions
Extracting, transforming and loading data
Employing Key Performance Indicators
Assessing the impact of change requests

Course Content

Introduction to Data Warehousing

Identifying data warehouse components
Analysing failed installations
Determining stakeholders
Developing a roadmap for project implementation

Preparing an Implementation Plan

Establishing a foundation

Program vs. project requirements
Scoping the project and evaluating business justification
Comparing Agile vs. waterfall methodologies

Monitoring progress of the roadmap

Tracking stages and communicating milestones
Managing project expectations
Assessing risk and mitigation plans

Analysing Organisational Data Requirements

Determining business requirements

Assessing the business problem
Validating organisational goals
Identifying expected outcomes

Soliciting user requirements

Choosing diverse participants
Ranking feedback based on value to the enterprise

Establishing Dimensional Modeling

Modeling the business process

Star and Snowflake schema
OLTP vs. OLAP
Multidimensional cubes
Hierarchies

Comparing modeling techniques

Inmon and the relational approach
Kimball and the dimensional approach
Selecting the appropriate technique for your environment

Evaluating the model

Creating fact tables and dimensions
Pivoting data in Excel to answer business questions

Building the Data Warehouse

Architecting the Physical Database

Mapping the logical data model to the physical data model
Evaluating hardware considerations

Ensuring data quality

Profiling source data
Configuring the database for change data capture
Refreshing the data warehouse

Extracting data from multiple sources

Connecting to different data sources
Databases
Spreadsheets
Text files

Transforming data during migration

Cleansing and scrubbing data
Mapping data elements and data types
Conforming dimensions and facts

Loading data into a data warehouse

Employing a staging database
Automating incremental data loading
Verifying success for data integrity

Leveraging Business Intelligence for Data Analysis

Identifying levels in the BI stack

Demonstrating SharePoint as a deployment platform
Utilising Excel as a client tool for data analysis
Querying data from the OLAP server
Enumerating the components of the data tier

Exploring business intelligence tools

Drill down through multidimensional hierarchies
Surfacing Key Performance Indicators (KPIs) to evaluate the health of your organisation

Deploying a Complete Data Warehouse Solution

Managing system deployment and support

Assembling the testing group
Organising a pilot project

Taking advantage of industry standard tools and techniques

Identifying available data warehousing tools
Choosing the right tool based on organisational needs
Adopting best practises

Planning for growth

Controlling change management
Choosing a method of data storage
HOLAP
MOLAP
ROLAP

<< Back to Java

Related Courses

Learning Tree AnyWare^TM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.

Course Dates

Most events below can be taken in-class or live, online from your home or office with AnyWare.

UK Dates
24 - 27 Jul	London enrol
30 Oct - 2 Nov	London enrol
26 Feb - 1 Mar	London enrol
US East Coast Dates
17 - 20 Jul	Washington, DC enrol*
14 - 17 Aug	New York enrol*
4 - 7 Sep	Washington, DC enrol*

*Work and train on the same day! Attend live US East Coast Courses online from 2pm to 9pm GMT.

For AnyWare enrolments, please register at least 7 days prior to the start of the course.

More Dates and Locations.

Tuition for Course 2191 (4 Days)

Standard Fee £1,925

Saving Options

Bring this or any Learning Tree Course on-site to your location!

"I have to say that my Learning Tree Course experience was terrific! The sequencing of the content was exceptional, with lessons logically ordered for clarity. The instructor also did a great job of handling questions without derailing or delaying the course".

– B. Lakenan
Business Analyst
Arbitron, Inc.