Q
Problem solve Get help with specific problems with your technologies, process and projects.

A Central DSS Report Development Center

What are some of the positive and negative aspects of creating a Central DSS Report Development center? Are you...

aware of any of your clients that have done so and would be willing to share what they learned?

As an industry, we've done a terrible job at putting out common definitions for DW architectures and components so I hope I address what you mean with your terminology.

A Central DSS Report Development center sounds like a centralized data warehouse where most corporate reports are run from, something that many have created. This would be in opposition to another popular architecture, one that is also popular, but sometimes not planned -- independent data marts. Most folks are somewhere in the middle and some are providing bridges between the marts and the warehouse(s) via a "federated" approach.

Based on some of my client experiences with this architecture, I would count the major benefits of the centralized approach as having to do with efficiencies and economies -- less operational impact, lowered overall staff requirements and tool standards leading to a lowered overall cost to serve. Data standards -- wide use of accepted data representations -- provide the greatest benefit. You can see my DM Review article at http://www.dmreview.com/master.cfm?NavID=198&EdID=2162 and my recent article for Teradata magazine at http://www.teradatamagazine.com/articles/2Q_2002/enterprise/default.htm for more on this topic.

For more information, check out SearchCRM's Best Web Links on Data Warehousing.


This was last published in July 2002

Dig Deeper on CRM industry news

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataManagement

SearchSAP

SearchOracle

SearchAWS

SearchContentManagement

SearchSalesforce

Close