Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    sales and data analytics
    How Data Analytics Improves Lead Management and Sales Results
    9 Min Read
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Connecting the Dots: Misunderstood Dimensional Models
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Warehousing > Connecting the Dots: Misunderstood Dimensional Models
Business IntelligenceData WarehousingModeling

Connecting the Dots: Misunderstood Dimensional Models

RickSherman
RickSherman
4 Min Read
SHARE

Connect-the-dotsOne of the debates one hears when designing a data warehouse  is that it should be normalized. Specifically, they say to use a third normal form (3NF) or a dimensional model.

Connect-the-dotsOne of the debates one hears when designing a data warehouse  is that it should be normalized. Specifically, they say to use a third normal form (3NF) or a dimensional model.

This debate is often an ideological battle, where people cite Inmon or Kimble to justify their position. At this level, the debate is about theory rather than the business, data or analytical needs of enterprise business people. But before people build a data warehouse, they must understand those needs, as well as the industry best practices that will help fulfill them.

More Read

It’s not about the software… but…
“Unlike some of the other technological evolutions, Cloud Computing is actually a paradigm shift from…”
RulesFest 2011 – Kenny Shi: Scalability in a Real-Time Decision Platform
Investing in Data Warehousing and Business Intelligence During Recessionary Times (Part 1 of 2)
Slow BI and the BIG Method Part 1

The biggest reason why IT groups have this debate is because their view of dimensional data modeling is too simplistic. IT developers generally view dimensional models as fact and dimension tables placed in either a star or snowflake schema.  IT understands how to implement the basic concepts such as surrogate keys and slowly changing dimensions (SCD), but they hardly, if ever, use much of the advanced (also known as hybrid) design constructs.

They see the advanced concepts, such as rapidly changing, casual, hot swappable, heterogeneous or junk dimensions; how to implement hierarchies; bridge and outrigger tables; and when to use the various categories of fact tables, as esoteric.

(Admit it, it was tough just reading this sentence without thinking it was time to check your Facebook page!)

So why is it so tough to grasp these advanced concepts? A big part of the problem is that they are generally explained in an academic context. They’re not being connected to the real-world use cases where they should be used. Thus, they become geek-speak and are ignored.

Complicated as they may sound, the advanced dimensional design approaches have each been formulated based on real-world business and data requirements that occur across all enterprises. Rather than esoteric, these concepts are based on a pragmatic approach to implementing successful data warehouse and BI solutions.

Until IT understands the depth and practicality of advanced dimensional modeling, the decision whether to implement a normalized versus a (simplistic) dimensional model is a false debate. IT either builds an overly complex 3NF data warehouse that quickly gets overwhelming, or they build an overly simplified dimensional model that needs to be continually overhauled to support the inevitable expanding and changing business requirements. In either case, the business is underserved when it comes to getting the information they need, and the costs of BI keeps rising without the expected business ROI.

If companies understand and implement advanced dimensional models, then they can leverage the best practices that have been developed through years of real-world experience.

   

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

sales and data analytics
How Data Analytics Improves Lead Management and Sales Results
Analytics Big Data Exclusive
ai in marketing
How AI and Smart Platforms Improve Email Marketing
Artificial Intelligence Exclusive Marketing
AI Document Verification for Legal Firms: Importance & Top Tools
AI Document Verification for Legal Firms: Importance & Top Tools
Artificial Intelligence Exclusive
AI supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

The Economic Logic Behind Tech and Talent Acquisitions

3 Min Read

Many Companies Unprepared for Big Data Boom

3 Min Read

2012 Research Predictions (The NGMR Twiteratti – Part 1)

10 Min Read

May 2010 Early Indications: Devising the cloud-aware organization

10 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive
ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?