Blog Business Intelligence

Spreadmarts: the spreadsheet debate

The term spreadmarts was coined by Wayne Eckerson in 2002. Spreadmarts refers to the partial sets of data that accumulate when users export data from their BI solution into a spreadsheet.

How do spreadsheets fit in with your BI solution?

This is a topic that is highly debatable. People in organizations have become so accustomed to putting data into a spreadsheet and manipulating the data before sending it off to VPs and executives to make important company decisions.

The biggest danger here is that the data in spreadsheets is not linked to current data.

The figures may be outdated before they even reach the desks of decision makers, causing errors in decision making. Each individual that generates a spreadsheet usually has different rules and formulas that are used to aggregate data, so when errors arise deciphering the meaning of the data can become costly and time consuming.

What’s the solution?

Leading BI tools such as Phocas provide users with the capability of rendering data in a format that is user friendly while still being connected to the data warehouse.

Despite this, some users will typically shy away from using the BI solution because they are more familiar with Excel spreadsheets and they feel comfortable with the tool.

Read full article

News From

Phocas Software - Business Intelligence Software and Data AnalyticsPhocas Software
Category: Business Intelligence Software Company about: Phocas Software is a leading business intelligence software firm created by Myles Glashier and Paul Magee in 1999. Phocas has built its model on exceeding customer expectations. We help our customers make data-driven business decisions, uncover new sales opportunities and improve business efficiency by offering an integrated data solution. Whether you are an IT Manager who would like to spend less time performing reports, a Finance professional looking for a quicker way to drill down on a P&am ...