Data Warehousing and Business Intelligence at the Data Management Center 

Data Warehousing Tutorial

Learn Data Warehousing and Business Intelligence.
Jump start your data warehousing efforts.
Bookmark and Share

 

Welcome to Data Warehousing and Business Intelligence Tutorials including: OLAP, BI, architecture, data marts, and more.

David Haertzen David Haertzen, Principal Enterprise Architect

These data warehousing and business intelligence tutorial articles will help you to:

  • Understand what Data Warehousing is, its goals, and its components
  • Know the top Data Warehousing terms
  • Understand how to benefit from Data Warehousing and Business Intelligence
  • Be positioned to learn more about Data Warehousing

You will better understand: 

  • HOW TO plan and organize a successful data warehouse project
  • HOW TO get the right people involved in the project
  • HOW TO determine warehouse business requirements
  • HOW TO choose between a data warehouse and data mart
  • HOW TO create a data warehouse data model
  • HOW TO load the data warehouse
  • HOW TO select data going into the data warehouse
  • HOW TO avoid traps and pitfalls
  • HOW TO repeat benefits of Business Intelligence
  • HOW TO present information to users
  • HOW TO manage the ongoing data warehouse

 


 Data Warehousing and Business Intelligence Introduction

This tutorial introduces data warehousing and business intelligence. Learn the fundamentals and benefits of this exciting subject.
more...


Project Management for Data Warehousing

Learn how to organize a data warehousing and business intelligence project. Make the winning moves and avoid the killer mistakes.
more...


Data Warehousing and Business Intelligence Methodology

Learn the steps of successful data warehousing and business intelligence efforts. These proven steps can put your time on the path to success.
more...


Data Warehousing Business Requirements

Learn how to gather and organize business intelligence and data warehousing business requirements.
more...


Data Modeling for Data Warehouse

Data models are key to successful for data warehouses and data marts. Design patterns for each part of the data warehouse will help you to design needed databases.
more...


Metadata for Data Warehousing and Business Intelligence

Metadata is often called "data about data". Learn how to manage metadata for your data warehousing and business intelligence project.
more...

ETL : Extract, Transform, Load

Learn how to use ETL for your data warehousing project. Topics include: ETL architecture, data mapping, data cleansing, data transformation and loading data.
more...


Data Warehousing Databases

Which database software and features should you use for you data warehousing project? Learn how to use database technology for your data warehousing project.
more...


OLAP / MOLAP / ROLAP

OLAP (OnLine Analytical Processing) is a key technology for data warehousing and business intelligence. Learn how to strengths and weaknesses of OLAP forms: MOLAP, ROLAP and HOLAP.
more...


BI / Business Intelligence

Business intelligence tools are used to analyze and present data. Gain an understanding of types of business intelligence (BI) that can help with your data warehousing project.
more...


Data Warehousing Rollout

The rollout is the project phase when the data warehousing / business intelligence system is made available to its users. Follow these steps to increase your chances of success.
more...


Sustaining BI and Data Warehousing

A sustainable program will keep your BI and Data Warehousing efforts moving in the right direction.
more...