data warehouse and business intelligence training

Business Intelligence or Data warehousing project managers.

Business Intelligence or Data warehousing program managers.

How to determine the best-fit architecture and methodology for your data warehousing program.

Project management implications of various approaches.

How to assess the time-to-delivery implications of various methodologies.

How to assess the cost and value implications of various architectures.

Dependencies between data warehousing architecture and development methodology.

Top-down, bottom-up, and hybrid data warehousing methodologies.

Hub-and-spoke, federated, and independent architectures.

Basic architectural concepts for business intelligence and data warehousing.

Closed-loop systems such as budgeting and forecasting systems.

Operational Data Stores (ODS), data warehouses, and data marts.

We will also address how the following components fit into the architectural mix:

You'll learn how to assess your resources and requirements, and then make informed decisions about the best data warehousing architectures and methods for your organization. We'll examine include the size and scope of the data warehousing program, expected timing and frequency of deliverables, anticipated return-on-investment, staff size and skill, available tools and technology.

This course explains the differences and helps you sort through the choices to determine the best fit for your organization. The choice of architectures ranges from the 'integration hub data warehouse' to 'independent data marts', and different approaches - including top-down, bottom-up, and hybrid methodologies. It's critical that a data warehouse support and reinforce the objectives of the entire enterprise, not just a single group. For example, the data reported from an organization's warehouse may not be integrated across the organization, so business users get confusing and conflicting results. A lot can go wrong when a data warehouse is built without a solid architecture.

Data warehouse and business intelligence training