Definition

spreadmart (spreadsheet data mart)

Spreadmart is short for spreadsheet data mart. In business intelligence, the term has a negative connotation.  It is used to describe a situation where a business has multiple spreadsheets created by different people or groups that provide inconsistent views of the company's data.

Because spreadsheets are easy to work with, many businesses rely on them to take the place of a data mart or data warehouse. Instead of providing a consistent view of the entire company’s data, however, spreadsheets have unique views of limited amounts of data. It is up to the spreadsheet creator to decide what metrics are important, what data needs to be collected, how the data is formatted and what level of granularity is required. Multiple spreadsheets become isolated data silos and make it difficult for analysts to extract, transform and load data into a central database so it can be interpreted at an enterprise level.  

This was last updated in November 2015

Continue Reading About spreadmart (spreadsheet data mart)

Dig Deeper on Business intelligence software

PRO+

Content

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

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

File Extensions and File Formats

Powered by:

SearchDataManagement

SearchAWS

SearchContentManagement

SearchCRM

SearchOracle

SearchSAP

SearchSQLServer

SearchSalesforce

Close