|David Haertzen, Principal Enterprise Architect|
Times are changing in the field of data warehousing and business intelligence, so I wrote this tutorial and accompanying book to provide a fresh perspective on the field.
Upon finishing this tutorial, you will understand what data warehousing, business intelligence, and analytics are. You will be familiar with the goals of and components that make up data warehousing, business intelligence, and analytics. In addition, approaches used by data warehousing professionals will become clear. Examples in the tutorial will enable you to be ready to work and manage others in the field of data warehousing.
The book, The Analytical Puzzle: Profitable Data Warehousing, Business Intelligence and Analytics provides even more details - plus over 20 helpful templates to accelerate your data warehousing and analytics projects.
You will better understand:
This tutorial introduces data warehousing and business intelligence. Learn the fundamentals and
benefits of this exciting subject.
Learn how to organize a data warehousing and business intelligence project. Make the winning
moves and avoid the killer mistakes.
Learn the steps of successful data warehousing and business intelligence efforts. These proven
steps can put your time on the path to success.
Learn how to gather and organize business intelligence and data warehousing business
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.
Metadata is often called "data about data". Learn how to manage metadata for your data
warehousing and business intelligence project.
Learn how to use ETL for your data warehousing project. Topics include: ETL architecture, data
mapping, data cleansing, data transformation and loading data.
Which database software and features should you use for you data warehousing project? Learn how
to use database technology for your data warehousing project.
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.
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.
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.
A sustainable program will keep your BI and Data Warehousing efforts moving in the right