Tag archive for ‘Datamartist Tool’
-
Datamartist Public Beta Released
nModal Solutions Inc. is very proud to announce the public beta release of the Datamartist tool. It is currently available for download here. I'd very much like to thank all those who have signed up at datamartist.com over the past months to formally take part in the Beta- and thank you in advance for everyone's [...]
-
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, [...]
-
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 [...]
-
Hierarchies and Tree Structures in Dimensions- an Example Item Dimension (Part 4)
Having a way to create and manage tree structures (Hierarchies) with your dimension and fact tables is a key part of making a dimensional model in any data warehouse or data mart. Hierarchical structures lend themselves to managing a very large number of categories and we use them to create drill down paths. Check out [...]
-
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 [...]
-
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. [...]
-
The Beta pressure is ON!
Well, this blog is supposed to be about new tools- and there's even a rumour about a Beta that might happen some time. The news is that there is actually an application taking shape, and alpha testing is underway! Heres a teaser screen shot, although its still evolving even since this was captured. In the [...]
