Did you ever try getting Businesspeople and IT to agree on the project scope for a new application? Or try getting Marketing and Sales to agree on the target audience? Or try bringing new team members up to speed on the hundreds of tables in your data warehouse - without them dozing off?
Whether you are a businessperson or an IT professional, you can be the hero in each of these and hundreds of other scenarios by building a High-Level Data Model. The High-Level Data Model is a simplified view of our complex environment. It can be a powerful communication tool of the key concepts within our application development projects, business intelligence and master data management programs, and all enterprise and industry initiatives.
Learn about the High-Level Data Model and master the techniques for building one, including a comprehensive ten-step approach and hands-on exercises to help you practice topics on your own. In this book, we review data modeling basics and explain why the core concepts stored in a high-level data model can have significant business impact on an organization. We explain the technical notation used for a data model and walk through some simple examples of building a high-level data model. We also describe how data models relate to other key initiatives you may have heard of or may be implementing in your organization.
This book contains best practices for implementing a high-level data model, along with some easy-to-use templates and guidelines for a step-by-step approach. Each step will be illustrated using many examples based on actual projects we have worked on. One example spans an entire chapter and will allow you to practice building a high-level data model from beginning to end, and then compare your results to ours. Building a high-level data model following the ten step approach you will read about is a great way to ensure you will retain the new skills you learn in this book.
As is the case in many disciplines, using the right tool for the right job is critical to the overall success of your high-level data model implementation. To help you in your tool selection process, there are several chapters dedicated to discussing what to look for in a high-level data modeling tool and a framework for choosing a data modeling tool, in general.
This book concludes with a real-world case study that shows how an international energy company successfully used a high-level data model to streamline their information management practices and increase communication throughout the organization - between both businesspeople and IT.
Data modeling is one of the under-exploited, and potentially very valuable, business capabilities that are often hidden away in an organizations Information Technology department. Data Modeling for the Business highlights both the resulting damage to business value, and the opportunities to make things better. As an easy-to follow and comprehensive guide on the why and how of data modeling, it also reminds us that a successful strategy for exploiting IT depends at least as much on the information as the technology.
Chris Potts, Corporate IT Strategist and Author of fruITion: Creating the Ultimate Corporate Strategy for Information Technology
The authors of Data Modeling for the Business do a masterful job at simply and clearly describing the art of using data models to communicate with business representatives and meet business needs. The book provides many valuable tools, analogies, and step-by-step methods for effective data modeling and is an important contribution in bridging the much needed connection between data modeling and realizing business requirements.
Len Silverston, author of The Data Model Resource Book series
Table of Contents
- CHAPTER 1
- What is a Data Model?
- CHAPTER 2
- Why Does a
- High-Level Data Model Matter?
- CHAPTER 3
- A More Detailed Look at the
High-Level Data Model
- Very High-level Data Model (VHDM)
- High-Level Data Model (HDM)
- Logical Data Model
- Physical Data Model
- How the Four Levels of Detail Fit Together
- Components of a HDM
- Now You Try It! Using Concepts and Relationships
- Dimensional Models
- Now You Try It! Creating a High-Level Data Model for BI Reporting
- Some Important Terms
- CHAPTER 4
- Layout and Formatting Tips for
- High-Level Data Models
- CHAPTER 5
- What is in a Name?
- CHAPTER 6
- Different Modeling Notations
- CHAPTER 7
- How High-Level Data Modeling
- Fits With Other Data Initiatives
- CHAPTER 8
- Creating a Successful
High-Level Data Model
- Ten steps to completing the HDM
- CHAPTER 9
- High-Level Data Model Templates
- CHAPTER 10
Putting the Pieces Together
- The Ice HDM
- The Ice Cube HDM
- CHAPTER 11
- Justifying a Data Modeling Tool for the High-Level Data Model
- CHAPTER 12
- Key Data Modeling Tool Features
for the High-Level Data Model
- Integration with Other Tools
- Design Layers with Linking Capability
- Verbalization from the Data Model
- Sensible Notation for High-Level Data Models
- Ability to Capture Business Metadata
- Presentation of Models
- Repository Integration
- Ease of Use for Business Users
- Now You Try It! Creating Your Criteria for a Tools Evaluation
- CHAPTER 13
- An Approach for Evaluating
- Data Modeling Tools for Your
High-Level Data Model
- Why do we Need to Follow a Selection Method?
The Outline Method
- Step 1: Identify requirements
- Step 2: Identify organizational constraints
- Step 3: Tailor the evaluation criteria
- Step 4: Assign weights to the evaluation criteria
- Step 5: Compile a short list of candidate products
- Step 6: Evaluate the products
- Step 7: Apply the evaluation criteria against the products
- Step 8: Score and rank the products
- Step 9: Perform sensitivity and 'what if' analysis
- Step 10: Present the findings
- CHAPTER 14
- Case Study: Using VHDMs and HDMs at an International Energy Company
- APPENDIX A
- Answers to “Now You Try It!”
- Examples and Quizzes
- WORKS CITED
- SUGGESTED READING
- Title: Data Modeling for the Business: A Handbook for Aligning the Business with IT using High-Level Data Models
- Release date: April 2009
- Publisher(s): Technics Publications
- ISBN: 9780977140077