Data Warehousing Fundamentals Part 1: Designing and Planning

This course explores the issues involved in planning designing implementing and managing a successful data warehouse. Students learn the reasons for data warehousing as a popular solution the business imperatives driving data warehousing common data warehousing terminology the components of a data warehouse implementation and data warehouse modeling concepts. Students also explore the computer architectures commonly used to support data warehouses and their benefits and learn the technology requirements of a database server for data warehousing.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

Data Warehouse and Data Mart Administrator Database Administrator Data Warehouse Designer Data Warehouse Project Manager and Implementation Team Member.

Objective

• Define the decision support purpose and end goal of a data warehouse.
• Identify the various technologies required to implement a data warehouse.
• Explain the implementation and organizational issues surrounding a data warehouse project.
• Describe methods and tools for accessing and analyzing warehouse data.

Topics Include

Unit 1: Introducing Data Warehousing

• Meeting a business need.
• Data warehouse overview.
• Oracle warehouse.

Unit 2: Planning a Successful Data Warehouse

• Warehouse development approaches.
• Managing financial issues.
• Managing a data warehouse project.

Unit 3: Analyzing User Query Needs

• Managing user data access.
• Online analytical processing models.
• Query access architectures.

Unit 4: Modeling the Data Warehouse

• Defining the business model.
• Creating the dimensional model.
• Creating modeling summaries.
• Creating the physical model.

Unit 5: Planning Architecture and Storage

• Computing architectures.
• Server data architecture.
• Database protection.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

• Data Warehousing Fundamentals Part 2: Building and Deploying