By Christopher Adamson
A dimensional model transforms data into information—the fundamental objective of every business intelligence (BI) program. Although it has become the de facto standard for data mart design, common mistakes disrupt this crucial function.
The dimensional model is more capable than is generally understood. Often pigeonholed as a data model, it is not exploited as a presentation model in a federated environment, or as a requirements model. Entire subject areas are closed off by the common misconception that some things can only be modeled using entity-relationship techniques.
To attain the full potential of your dimensional model, it is necessary to master a broad range of principles, understand how and what to model, and avoid lapsing into habits from other modeling disciplines.
A dimensional model of your business is an important asset of your BI program. Maximize its value by avoiding these 10 mistakes.
Not a member yet? Learn More
TDWI Membership provides you with EXCLUSIVE access to special TDWI research and publications.
Sign Up Now
In-Depth Education and Research on All Things Data.
For 20 years, TDWI has been helping data professionals get smarter, so the companies they work for can innovate and grow faster.
TDWI advances the art and science of realizing business value from data by providing an objective forum where industry experts, solution providers, and practitioners can explore and enhance data competencies, practices, and technologies.