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

Tag archive for ‘Excel Performance’

  • Datamartist Beta tests out on 100 Million rows

    Since one of the key features I want Datamartist to have is the ability to manage very large data sets, I've built in some new caching functionality- and was kicking the tires late one night recently. First, using a custom program, I generated a 100 million row data file with 10 columns (three integer measures, [...]

    2/22/09 • (1)

  • Creating a Fact Table with the Vendor dimension Purchasing DM (Part 2)

    In creating a data warehouse or data mart data model there are two key types of tables- fact tables and dimension tables. Fact tables hold the data to be analyzed, dimensional tables provide categories and analysis values that organize the data. So we have our mission from Part 1: to analyze the "Acme does everything" [...]

    2/05/09 • (1)

  • Importing Data into Excel

    I've seen lots of Business Intelligence (BI) solutions, (data marts, data warehouses and the accompanying reports and dashboards) using all sorts of different tools. But I'll tell you- NO tool has yet been as successful as Microsoft Excel for providing a do it yourself data analysis platform to import data into. Now, I'm not suggesting [...]

    9/01/08 • (Comments Off)