Turning Text into Gold

The Rosedata Stone: Achieving a Common Business Language using the Business Terms Model

Creating a precise diagram of business terms within your projects is a simple yet powerful communication tool for project managers, data governance professionals, and business analysts.

Similar to how the Rosetta Stone provided a communication tool across multiple languages, the Rosedata Stone provides a communication tool across business languages. The Rosedata Stone, called the Business Terms Model (BTM) or the Conceptual Data Model, displays the achievement of a Common Business Language of terms for a particular business initiative.

With more and more data being created and used, combined with intense competition, strict regulations, and rapid-spread social media, the financial, liability, and credibility stakes have never been higher and therefore the need for a Common Business Language has never been greater. Appreciate the power of the BTM and apply the steps to build a BTM over the book’s five chapters:

  1. Challenges. Explore how a Common Business Language is more important than ever with technologies like the Cloud and NoSQL, and Regulations such as the GDPR.
  2. Needs. Identify scope and plan precise, minimal visuals that will capture the Common Business Language.
  3. Solution. Meet the BTM and its components, along with the variations of relational and dimensional BTMs. Experience how several data modeling tools display the BTM, including CaseTalk, ER/Studio, erwin DM, and Hackolade.
  4. Construction. Build operational (relational) and analytics (dimensional) BTMs for a bakery chain.
  5. Practice. Reinforce BTM concepts and build BTMs for two of your own initiatives alongside a real example.

Request review copy (Instructors only)


Chapter 1: Challenges

Chapter 2: Needs

Chapter 3: Solution

Chapter 4: Construction

Chapter 5: Practice

About Steve

Steve Hoberman

Steve Hoberman has been a data modeler for over 30 years, and thousands of business and data professionals have completed his Data Modeling Master Class. Steve is the author of nine books on data modeling, including The Rosedata Stone and Data Modeling Made Simple. Steve is also the author of Blockchainopoly. One of Steve’s frequent data modeling consulting assignments is to review data models using his Data Model Scorecard® technique. He is the founder of the Design Challenges group, creator of the Data Modeling Institute’s Data Modeling Certification exam, Conference Chair of the Data Modeling Zone conferences, director of Technics Publications, lecturer at Columbia University, and recipient of the Data Administration Management Association (DAMA) International Professional Achievement Award.


Italian (Translated by Nino Letteriello)

Storytelling & Communication Books