Tag archive for ‘Personal data mart’
-
Adding self serve data transformation to reduce shadow systems
Do you have lots of unoffical spreadsheets in your organization being used for data analysis? Is the data warehouse use low to non-existent, yet somehow lots of data is appearing in power point presentations and excel spreadsheets all over the company? I believe a key to understanding how information moves around your organization is to [...]
-
MS Access query example and comparision to Datamartist
Microsoft Access allows users to create complex queries and analyze large data sets. However, it can be complicated to use compared to Excel. In this post, I'll talk about ms access queries and the equivalent way to perform the same data transformation in the Datamartist tool- visually and simply. Microsoft Access has a clear role [...]
-
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. [...]
-
Personal Data Marts: cost effective, powerful Analysis
Huge, expensive data warehouse projects often either deliver a huge compromise in terms of functionality, or are impossibly complex and expensive. A bunch of them fail outright. Why do so many people turn to Excel for their analysis needs? Because with excel they are in control. With Excel it IS personal. Massive, expensive data warehouses [...]
