Data Modeling

An Experienced Data Architect Makes All the Difference

Enterprise Data Models

An Enterprise Data Model (EDM) gives you the full view of what’s important to your business and how each of those components relate to each other.

We capture the institutional knowledge of your subject matter experts and coalesce this disparate information into an easy-to-use resource accessible to key stakeholders. We design your EDM to be used at all levels within the organization. Executives use it to quickly assess the big picture. Management uses it to identify pain points and efficiencies. Project Managers use it to understand and define scope. Developers use it to navigate the system they’re working on.

Project Specific Data Models

The data models for specific projects and applications are optimally derived from the Enterprise Data Model, but even without an EDM, we can deliver conceptual and logical data models that capture and reveal critical details that help developers better understand the system, giving them a better chance of getting it right the first time. Additionally, DBAs benefit from generating the physical data model from the logical model because it increases their accuracy in representing the real world in the database.

Dimensional Models

We build dimensional models to help you slice and dice your data into practical, analyzable information so that you can make more informed decisions about your business.

Business Glossary

Ask two subject matter experts in two different departments what a customer is. Unforturnately, you will most likely get two different answers – IF you don’t employ a business glossary. This isn’t just an annoying, inconsequential factoid. If your project team isn't on the same page when they’re discussing problems, the solution will probably be wrong. By the time that's discovered, it's cost you additional time and money. This type of trial and error doesn't have to be a standard part of your project workflow.

We work through the jargon of various groups which too often cause avoidable confusion, mistakes, and delays, and evolve it into a stable and reliable lexicon, which gives your teams a running start on every project.

Data Stewardship

Your business glossary will continue grow as your business evolves. We serve as your on-call data steward to keep it functioning as its peak, vetting new entries and updating the glossary as needed.

Training

Effective data modeling requires more than just knowing the concept of normalization or facts and dimensions. Modelers must also master how to explore and understand the products, services and stakeholders critical to your organization. Our training gives your team a strong data modeling foundation.