What is your e-mail address?

My e-mail address is:

Do you have a password?

Forgot your password? Click here
close

Ten Mistakes to Avoid In Dimensional Modeling

Ten Mistakes to Avoid In Dimensional Modeling

December 5, 2011

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.

Please Log In


Back to Top

Channels by Topic

  • Agile BI »
    Includes:
    • Agile
    • Scoping
    • Principles
    • Iterations
    • Scrum
    • Testing
  • Big Data Analytics »
    Includes:
    • Advanced Analytics
    • Diverse Data Types
    • Massive Volumes
    • Real-time/Streaming
    • Hadoop
    • MapReduce
  • Business Analytics »
    Includes:
    • Advanced Analytics
    • Predictive
    • Customer
    • Spatial
    • Text Mining
    • Big Data
  • Business Intelligence »
    Includes:
    • Agile
    • In-memory
    • Search
    • Real-time
    • SaaS
    • Open source
  • BI Leadership »
    Includes:
    • Latest Trends
    • Technologies
    • Thought Leadership
  • Data Analysis and Design »
    Includes:
    • Business Requirements
    • Metrics
    • KPIs
    • Rules
    • Models
    • Dimensions
    • Testing
  • Data Management »
    Includes:
    • Data Quality
    • Integration
    • Governance
    • Profiling
    • Monitoring
    • ETL
    • CDI
    • Master Data Management
    • Analytic/Operational
  • Data Warehousing »
    Includes:
    • Platforms
    • Architectures
    • Appliances
    • Spreadmarts
    • Databases
    • Services
  • Performance Management »
    Includes:
    • Dashboards, Scorecards
    • Measures
    • Objectives
    • Compliance
    • Profitability
    • Cost Management
  • Program Management »
    Includes:
    • Leadership
    • Planning
    • Team-Building
    • Staffing
    • Scoping
    • Road Maps
    • BPM, CRM, SCM
  • Master Data Management »
    Includes:
    • Business Definitions
    • Sharing
    • Integration
    • ETL, EAI, EII
    • Replication
    • Data Governance

Sponsored Links