How the Enterprise Data Model can help you build a better Dimensional Data Warehouse by Alex Soltesz, Enterprise Data Warehouse Architect

With 16+ solid years of Data Warehousing and Business Intelligence (BI) experience, Alex Soltesz has been recognized as a key player in numerous successful data warehousing projects. His broad and diverse experience has provided him with a well-founded understanding of the data warehousing lifecycle and the data warehousing industry itself.

Alex is highly skilled at architecting enterprise-wide decision support solutions incorporating Data Mining, OLAP and Query Reporting methodologies.

Synopsys:

This presentation will be a practical and in-depth walkthrough on how to build an Enterprise-class Business Intelligence (BI) framework by bringing together two distinct modelling paradigms that might otherwise be at odds with one another (Entity/Relationship vs. Dimensional). This presentation will address the following topics:

• Top-down Data Warehouse architecture using the Kimball methodology (dimensional)
• The Enterprise Data Model (EDM) – purpose, uses including how it can be used to plan and deliver conformed dimensions as well as development strategies for building it in conjunction with BI application delivery
• Data modeling concepts – conceptual logical and dimensional with examples using Sybase PowerDesigner
• Other data governance considerations – such as Master Data Management)
• Enterprise BI strategies for the public sector – how to think big, but deliver in small successive increments)

Audience:

• BI/DW Architects
• Data architects, data modellers, data stewards, subject matter experts
• Key decision makers: CIOs, project managers/leads, technical leads and technical advisors

When: Thursday, January 16th, 2014

Time: 5:00 p.m. to 7:00 p.m. (17:00 hrs to 19:00 hrs)

Where?

     CORADIX Technology Consulting Ltd.

     151 Slater Street, Suite 1010

     Ottawa, Ontario K1P 5H3

About DAMA Ottawa:

DAMA (Data Management Association) is vendor independent, not-for-profit professional association for Information Management Practitioners. Its primary objective is to, "develop and communicate the knowledge and standards of data management".

In order that DAMA Ottawa may better achieve its purpose, a Code of Ethics is adopted and applies to all DAMA Ottawa members.

To become a DAMA Ottawa member click here.