We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
    chatgpt image jul 21, 2026, 04 34 30 pm
    4 Core Benefits of Predictive Maintenance after Vibration Analysis
    10 Min Read
    How Does Data Mining Boost Customer Satisfaction in Logistics? Harnessing Analytics for Results -- AI-generated illustration
    How Does Data Mining Boost Customer Satisfaction in Logistics? Harnessing Analytics for Results
    11 Min Read
    chatgpt image jul 13, 2026, 04 23 45 pm
    How Data Analytics Helps Companies Improve User Engagement
    19 Min Read
    chatgpt image jul 13, 2026, 03 59 46 pm
    How Data Analytics Improves Multi-Location Search Strategies
    10 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Data warehouse architecture that’s too narrowly focused
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 > Data warehouse architecture that’s too narrowly focused
Business IntelligenceData Warehousing

Data warehouse architecture that’s too narrowly focused

RickSherman
RickSherman
1 Min Read
Data warehouse architecture that's too narrowly focused
Illustration generated with Qwen Image.
SHARE

In my DM Review columns, “The Accidental Architecture” and “Recovering from the Accidental Architecture,”
I discussed whether people understood the “why” of best practices, such
as dimensional modeling and hub-and-spoke architecture. In “Don’t Stop at How, Learn Why,”
I discussed the most common problems when people are too hub myopic,
cloning their source systems or assuming the hub will support all
reporting and analytic needs.

There are also
dangers with being too spoke-centric (with data marts or cubes) and
failing to establish the hub, or data warehouse (DW), as the enterprise
data backbone.

>>> Read the rest of my article "Too Narrowly Focused" on the DM Review website.

More Read

The 10 Best Business Intelligence Tools For Small And Big Business
The 10 Best Business Intelligence Tools For Small And Big Business
Private versus Public Clouds for ERP Software
Q & A With Howard Dresner on Mobile BI
Agile BI (What it is, Why it is)
HP snaps up Vertica

Link to original post

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

Flat editorial illustration: The article's core relationship is the gap between raw bank-feed records and reliable subscription i
Subscription Trackers Have a Transaction Data Problem
Big Data Exclusive
Flat editorial illustration: The article's core relationship is the hypervisor as the abstraction layer that makes hybrid cloud p
7 Best Virtualization Platforms for Hybrid Cloud Environments
Big Data
Flat editorial illustration: The article's core relationship is between aggregated workplace data (occupancy, environmental, feed
How Businesses Can Use Workplace Data to Create Better Office Environments
Big Data Business Intelligence Exclusive
Flat editorial illustration: The article's core relationship is the engineering transition from an AI prototype to a production-r
From AI Prototype to Production: Observability and Scalability Requirements for Data-Heavy SaaS Applications
Artificial Intelligence Exclusive

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

Multi-Channel Retail: Where Big Box Meets Big Data
Big DataBusiness IntelligenceCRMData MiningExclusiveHardwareInside CompaniesMarket ResearchMarketing AutomationMobilitySocial Data

Multi-Channel Retail: Where Big Box Meets Big Data

8 Min Read
Building Brand One Customer at a Time
Best PracticesCRMCulture/LeadershipMarketing

Building Brand One Customer at a Time

13 Min Read
4 huge BI challenges facing CIOs and IT Leaders
Business Intelligence

4 huge BI challenges facing CIOs and IT Leaders

12 Min Read
Using Big Data to Win: How to Create Data Driven Strategies for Your Company
Big DataBusiness Intelligence

Using Big Data to Win: How to Create Data Driven Strategies for Your Company

7 Min Read

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

5 Great Tips for Using Data Analytics for Website UX
5 Great Tips for Using Data Analytics for Website UX
Big Data
How To Get An Award Winning Giveaway Bot
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?