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

Category archive for ‘Data Modelling’ rss

  • Data Warehouse vs Data Mart

    Very often, the question is asked- what's the difference between a data mart and a data warehouse- which of them do I need? Data warehouse or Data Mart? Data Warehouse: Holds multiple subject areas Holds very detailed information Works to integrate all data sources Does not necessarily use a dimensional model but feeds dimensional models. [...]

    12/02/08 • (0)

  • Dimensional Tables and Fact Tables

    One of the secrets to putting together a good set of data marts is the concept of dimensions.  There are two key steps being able to analyse your data, and to build a working data mart model.   Build a set of clean, consistent dimension tables that store reference information about your key dimensions like Product, [...]

    10/30/08 • (0)

  • Data mart Data Modelling 101

    Last time we talked about how much data can comfortably be put into and Excel spreadsheet and I've found that more than a few hundred thousand rows can get awkward.  Plus, certain types of operations are more difficult to automate in excel (often requiring programming skills with macros or visual basic for applications (VBA)).  So- this means [...]

    9/23/08 • (0)