Data Modeling: From Requirements to Business Analytics

One-day Course

Certificate Course

Prerequisite: This course assumes basic understanding of relational database concepts

You Will Learn:

   • Concepts of dimensional data modeling
   • The relationship between business metrics and dimensional data
   • Similarities and differences between relational and dimensional data models
   • Requirements gathering techniques for business metrics and dimensional data
   • How to build a logical dimensional model
   • How to translate a logical dimensional model to a star-schema design
   • How dimensional data is used to deliver business analytics and OLAP capabilities

Geared to:

   • Data architects, data mart developers, business analysts, business intelligence and data warehousing program and project managers.

   Dimensional data is a core component of modern business intelligence and data warehousing implementations. Dimensionally organized data offers a more effective and adaptable solution to business analytics needs than can be achieved with relational data structures. Virtually anyone involved in business intelligence and data warehousing projects needs to have fundamental knowledge of the pathway from business questions to business analytics. This course traces that pathway.

   The course begins with a comparison of relational and dimensional data organization and provides an example of business questions not readily answered using more traditional data structures of relational modeling. It then illustrates the steps to design analytic solutions starting from business questions and concluding by demonstrating an OLAP solution. These steps encompass techniques to capture business questions, represent them as a business solution, translate them to a technology solution, and deliver them to those who need information.

Cost:                            $750

RapiMart is a synthesis of “best of breed” manage-ment and technology processes and templates. The theory behind it took over ten years to develop and refine....

The definition of a data warehouse has taken on many meanings and interpretations throughout the years. But at its core, a data warehouse represents a consolidated view of an entity's data – an integration point for all sources into one vision of the organization.

Just imagine walking into a business meeting where all analysts in the meeting are working with the same, accurate, complete set of data. The value of decisions made in those types of meetings is unsurpassable.