This event is available now. It will be available through 5/7/2012 (54 sessions viewable).

Streaming access: $295.00

Streaming and Download Package: $590.00

Speaker: Nancy McQuillen
Location: Olympic Ballroom
Session Type: Registration is Required

Traditional OLAP is a critical aspect of enterprise Business Intelligence, especially where metrics are expected to be consistent and comparable across the organization, e.g. sales statistics or financial performance measures. However many organizations are still living with uncoordinated and unconnected data marts, star schemas, and metrics. Dimensions are the glue that can connect the stars. This session introduces state-of-the-art methods and sample tools for planning and implementing conformed dimensions, thus achieving a data warehouse “bus architecture”. . The techniques are equally applicable for designing a coherent data mart layer in environments utilizing a “corporate information factory” approach, as described by data warehouse leader Bill Inmon. The modeling discussion will progress through three layers, serving three respective audiences: business planners, data mart designers, and data mart implementers. Specific tools are utilized, but the principles apply more broadly: • Dimensional model business requirements ; methods by Ralph Kimball and Laura Reeves; tool Microsoft Office. • Logical and physical dimensional models; tool Embarcadero ERStudio Data Architect. • Dimension and OLAP data mart implementation; tool Microsoft SQL Server Analysis Services.