Datamartist gives you data profiling and data transformation in one easy to use visual tool.

Tag archive for ‘Personal data mart’

  • Putting data analysis into the hands of the business user

    Having too many people involved can slow down the entire analytics process- by using tools that are designed to be accessible by business users, huge gains can be made. However a challenge faced by all companies is connecting the business knowledge and data manipulation knowledge in a way that the data can be used. As […]

  • 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 […]