By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    predictive analytics in dropshipping
    Predictive Analytics Helps New Dropshipping Businesses Thrive
    12 Min Read
    data-driven approach in healthcare
    The Importance of Data-Driven Approaches to Improving Healthcare in Rural Areas
    6 Min Read
    analytics for tax compliance
    Analytics Changes the Calculus of Business Tax Compliance
    8 Min Read
    big data analytics in gaming
    The Role of Big Data Analytics in Gaming
    10 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    Promising Benefits of Predictive Analytics in Asset Management
    11 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Connecting the Dots: Misunderstood Dimensional Models
Share
Notification Show More
Latest News
ai digital marketing tools
Top Five AI-Driven Digital Marketing Tools in 2023
Artificial Intelligence
ai-generated content
Is AI-Generated Content a Net Positive for Businesses?
Artificial Intelligence
predictive analytics in dropshipping
Predictive Analytics Helps New Dropshipping Businesses Thrive
Predictive Analytics
cloud data security in 2023
Top Tools for Your Cloud Data Security Stack in 2023
Cloud Computing
become a data scientist
Boosting Your Chances for Landing a Job as a Data Scientist
Jobs
Aa
SmartData Collective
Aa
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
Last updated: 2012/01/12 at 1:11 PM
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

ai digital marketing tools

Top Five AI-Driven Digital Marketing Tools in 2023

Is AI-Generated Content a Net Positive for Businesses?
Combat AI-Powered Threats with Cybersecurity Simulations & Other Practices
Utilizing Data to Discover Shortcomings Within Your Business Model
Embedded BI Tools Bring Huge Benefits to Business Applications

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.

   

RickSherman January 12, 2012
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai digital marketing tools
Top Five AI-Driven Digital Marketing Tools in 2023
Artificial Intelligence
ai-generated content
Is AI-Generated Content a Net Positive for Businesses?
Artificial Intelligence
predictive analytics in dropshipping
Predictive Analytics Helps New Dropshipping Businesses Thrive
Predictive Analytics
cloud data security in 2023
Top Tools for Your Cloud Data Security Stack in 2023
Cloud Computing

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

Sign Up for Our Newsletter

Subscribe to our newsletter to get our newest articles instantly!

[mc4wp_form id=”1616″]

You Might also Like

ai digital marketing tools
Artificial Intelligence

Top Five AI-Driven Digital Marketing Tools in 2023

6 Min Read
ai-generated content
Artificial Intelligence

Is AI-Generated Content a Net Positive for Businesses?

5 Min Read
cybersecurity simulations
Artificial IntelligenceExclusiveITSecurity

Combat AI-Powered Threats with Cybersecurity Simulations & Other Practices

7 Min Read
utlizing big data for business model
Big Data

Utilizing Data to Discover Shortcomings Within Your Business Model

6 Min Read

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

ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?