Home
Topics
Business intelligence technology and platforms
Business intelligence software
spreadmart (spreadsheet data mart)

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.

Related glossary terms: decision tree, MicroStrategy, data science, mobile business intelligence, Amazon RedShift, location intelligence (LI), statistical analysis, collaborative BI (collaborative business intelligence)

This was last updated in June 2010

Posted by: Margaret Rouse

Email Alerts

Register now to receive SearchBusinessAnalytics.com-related news, tips and more, delivered to your inbox.

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

More News and Tutorials

Textual data becomes new frontier for BI applications

Unstructured text data can hold valuable insights, but analyzing it has been a challenge. New tools are changing that, opening up additional data-analysis opportunities and enabling better decision making.
Mobile BI software picking up the pace with corporate users

Mobile business intelligence (BI) technology is becoming more mainstream, thanks to the rise of smartphones and tablet PCs and demand from business users for on-the-go access to BI data.
BI, analytics and performance management software sees growth in 2011

Gartner’s 2011 revenue estimates indicate the worldwide BI, analytics and performance management software market experienced another strong year, with figures that look remarkably similar to 2010.

Do you have something to add to this definition? Let us know.

Send your comments to techterms@whatis.com

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Research More Tech Terms

Search thousands of tech definitions
Browse tech definitions
Browse Alphabetically:
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- Z
- #

Powered by WhatIs.com

File Extensions and File Formats

File Extension and File Formats List:

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
#

Powered by WhatIs.com

More from Related TechTarget Sites

Data Management
Data Management UK
Content Management
CRM
Oracle
SAP
SQL Server

Data Management
- New BI stack tackles data load at Boston Children's Hospital
  
  Boston Children's Hospital upgraded its business intelligence architecture to boost enterprise reporting, a move that also required retraining users.
- Expanded Hadoop use cases will drive need for new enterprise features
  
  With user interest rising, Hadoop vendors are trying to pave a path to higher adoption with add-ons that target issues holding the technology back.
- Jim Goodnight on SAS in-memory analytics and the data scientist
  
  A podcast Q&A with SAS execs Jim Goodnight and Jim Davis looks at big data enablers, including in-memory analytics, and the role of data scientists.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Content Management
- Get 'em ready: Tips for planning a SharePoint 2013 training program
  
  SharePoint is a complex application. But training business users for an upgrade to SharePoint 2013 doesn't have to be a daunting task for IT teams.
- The organization of the future: Not just hybrid IT, but hybrid people
  
  The adoption of hybrid IT approaches creates a need for executives who can both formulate business objectives and assess IT requirements.
- SharePoint technology feels growing pains as 2013 release arrives
  
  SharePoint 2013 adds new features to the collaboration software. But it comes at a time when SharePoint's value is being questioned in some quarters.
CRM
- ACCE conference honors the best workers in the call center industry
  
  The ACCE conference celebrated its 10th anniversary with the ICMI awards dinner. Find out which companies were recognized for excellence in service.
- Windows 8 operating system a marked change in touchscreen environments
  
  Move aside iOS: Windows 8 operating system could be what turns tablets and smartphones into serious business platforms.
- Mobile technology makes time management challenging
  
  Mobile technology has made it easier to solve problems at the office while we aren't at the office. But all that connectedness could mean more work and less play.
Oracle
- Domain-specific Oracle master data management
  
  Oracle master data management products are starting to merge various data management hubs, which is a help in particular vertical industries.
- Privileged user management a must for DBAs
  
  Trust, but verify. Ronald Reagan made it popular, and it's certainly relevant for DBAs in today's consolidated, virtualized IT world.
- John Webb: Why the new PeopleSoft applications are big news
  
  Lena Weiner-Bishop catches up with Oracle's vice president of PeopleSoft strategy, who explains the excitement around new PeopleSoft applications.
SAP
- Analyst Jon Reed on SAP SapphireNow 2013, SAP Fiori
  
  Analyst Jon Reed gives his take on SAP Fiori, a collection of apps intended to cover a wide range of business processes as simply and efficiently as possible.
- Ariba Network announces QuickBooks integration
  
  At its annual conference, Ariba announced a new tool by partner Dell Boomi that lets small businesses integrate their QuickBooks accounting with the Ariba Network.
- Software license audits come in different forms, expert says
  
  Your next software license audit may be an inventory optimization exercise in disguise. Either way, the trick is to be prepared, writes one analyst.
SQL Server
- Database index design and optimization: Some guidelines
  
  What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.
- Adam Machanic talks SQL Saturday
  
  We caught up with Adam Machanic, group leader of the New England SQL Server user group, at SQL Saturday Boston. Find out what he shared with us.
- SQL Server meets database application security
  
  Make sure your SQL Server is secure by studying these general guidelines for secure database applications from SQL Server expert Roman Rehak.

All Rights Reserved,Copyright 2010 - 2013, TechTarget