Category archive for ‘Cost Reduction’ 
-
Reduce Business Intelligence cost through better data migration
Managing Business Intelligence cost is not an easy task. But poorly or inconsistently structured data can make the task even harder. Unfortunately, a lazy data migration project can generate all sorts of headaches that will cause your Business Intelligence cost to explode. Of course, bad data quality also has many other costs and risks associated [...]
-
Spreadmarts and Data Shadow Systems- The Debate
When business users are not getting what they want out of the enterprise business intelligence system they very rarely just give up. Successful business people didn't get where they are by giving up when someone doesn't deliver something, they take things into their own hands and get it done. Knowing this, it's not surprising that [...]
-
Joining the Dimension Table to the Fact Table- Purchasing Data mart (Part 5)
After we have created the dimension tables and the fact table and populated them with data the final step to getting a star schema is of course to actually join the dimension tables to the fact table. In the datamartist tool we do this with a Join block. Check out the first four parts of [...]
-
Connecting the dimension table to the fact table- Vendor Example (Part 3)
In parts one and two of this series we introduced our challenge (to make a data mart to analyze the Acme Company's spending) and showed how the Datamartist tool could import millions of rows of data and then turn it into a fact table we can use in Excel. Now we need to create a [...]
-
A Cost comparision between Data Marts and a Data Warehouse
I've noticed a fair bit of search traffic focusing on cost questions, particularly which is cheaper; a series of data marts or a single enterprise data warehouse. I think it's a bit like the question of lease vs buy. Starting off building a single departmental data mart will represent a much smaller cash flow out. [...]
-
Business Intelligence Strategy in the Recession
It’s difficult not to notice that the global economy has thrown a recession and we've all been invited. So until we have some money to spend, we'll stop looking at our data, right? Although its true that in today’s economy, a lot of the multi-million dollar business intelligence projects are going to be cancelled [...]
