Tag Archives: business intelligence

Online Resources – Calculating Data Warehouse and Business Intelligence Project ROI

Here are a couple of online resources that provide complimentry views on determining the ROI of your Data Warehouse and Business Intelligence efforts:

Data Warehouse Justification and ROI by William McKnight published in DMReview
Realizing Data Warehouse ROI by Lisa Slutter published in TDWI – What Works
Data Warehousing ROI: Justifying and Assessing a Data Warehouse published in [...]

Survey – What tools and technologies did you use for your data warehouse infrastructure?

var PDF_surveyID = ‘398CBD641761C876′;
var PDF_openText = ‘Click here to take the survey and share with the community what tools and technologies you used to build your data warehouse and/or business intelligence infrastructure (6 questions – estimated time 1 minute)’;

Click here to take the survey and share with the community what tools and technologies you [...]

Measuring the ROI of Your Data Warehouse and Business Intelligence Efforts – Part 9 – Ease of Access to Accurate Data

We touched on the benefits of the Reduced Cost for collecting the data and formatting data consistently in Part 2 of this series. There are benefits beyond just the costs savings to produce this repository of reliable data. This is the ease with which the accurate data can be accessed.
Once the data [...]

Measuring the ROI of Your Data Warehouse and Business Intelligence Efforts – Part 8 – Automation is the Enabler

The enabler for an effective data warehousing and business intelligence strategy is automation. The process of loading a data warehouse and prepping the data for consumption, is analogous to building an assembly line or refinery that follows consistent processes to produce reliable data for decision making.
Like any “assembly line” whether producing cars or [...]

Measuring the ROI of Your Data Warehouse and Business Intelligence Efforts – Part 7 – Reduced Risk of Incorrect Information

Risk of not having Data Warehouse and Business Intelligence strategy can be measured by looking at the cost of getting inconsistent or the wrong answers.
If the answers are inconsistent across the enterprise then the organization is not going to be in alignment. They are going to spend more time bickering, wasting energy, or going [...]

Measuring the ROI of Your Data Warehouse and Business Intelligence Efforts – Part 6 – Transparency into the Information Compilation Process

Transparency is the visibility of classifications, business rules, definitions and calculations of for everybody in the enterprise to see.
The value of transparency is that it is easy to get not just at the desired result but being able to reproduce it. It is not unusual, especially when it comes to regulatory reports that the [...]

Measuring the ROI of Your Data Warehouse and Business Intelligence Efforts – Part 5 – Consistency of Information

Consistency of information across departments in the enterprise is when everyone in the enterprise gets the same answer when they ask the same question.
When different departments across the enterprise try to pull together the answers to the same they may not get the same results for several reasons. An example of data consistency issues [...]

Measuring the ROI of Your Data Warehouse and Business Intelligence Efforts – Part 4 – Accuracy of Information

The Data Warehouse and Business Intelligence combination improves the accuracy of information reported.
This may sound simple enough but in even a small organization the same information could be stored in multiple systems and I use that term “system” loosely. The “system” could be a vendor or home grown application in the best case, a [...]

Measuring the ROI of Your Data Warehouse and Business Intelligence Efforts – Part 3 – Timelines of Information

The Data Warehouse and Business Intelligence combination reduces the time required to conduct analysis and make decisions before the data gets stale.
If it takes too long to sift through the data to get to information opportunities may be lost. This could mean getting at the data in seconds after it is available or several [...]

Measuring the ROI of Your Data Warehouse and Business Intelligence Efforts – Part 2 – Reduced Cost to Get to the Answers

One of the benefits for a Data Warehouse and Business Intelligence combination is the reduced cost for the enterprise to get to the answers.
In the scenario where there is no Data Warehouse, this could mean having an army of people working with spreadsheets trying to put together the numbers needed for various business needs. [...]