Data Modeling Case Studies - Providing Pivotal Value to the Business

Data Modeling Case Studies – Providing Pivotal Value to the Business

Max Roy, Country Fire Authority

Data Modeling has, in general, been used to capture the fundamental data elements and associated business rules held within enterprise applications. The canonical data models, especially, provide a vehicle to understand the interacting data flows within the enterprise’s applications while abstracting above their physical implementations. By achieving this level of canonicity, the models can be reused in business transformational programs, as an example.  The models can be applied in various scenarios and phases of an IT project’s lifecycle (SDLC). Data Migration, Integration, Profiling, Quality Assurance and Business Intelligence (BI) are some of the key areas where these models can provide pivotal value.

This presentation reports on the experiences in undertaking Data Modeling at a major Australian University. It elaborates on the approach followed by the Data Modeling team in engaging with the business in producing, first the Conceptual Data Model (CDM); then followed by canonical Logical Data Models (LDM) within each subject area. It summarizes the feedback received from the business stakeholders as well as wider project personnel. The lessons learned are used to plan the way forward in reaching the vision of an Enterprise Data Model that adds value within IT projects.

About the Speaker

My career has spanned over 25 years in roles such as Solution/Data/Application Architect, Project Manager, Business Analyst and IT Faculty/Trainer. I have an innovative, pragmatic approach addressing business needs and end-to-end delivery focus in all phases of the SDLC. Building relationships with key stakeholders in obtaining long-term benefits using IT. Current focus on implementing hybrid Agile methods on mission-critical projects delivering business value.