Tag archive for ‘Datamartist Tool’
-
Datamartist V1.1 Released
We're pleased to announce that V1.1 of the Datamartist tool is now available, and we'd like to thank our customers and testers for all their feedback. Your suggestions and observations have helped us continue to improve the tool, and are a great motivation. Keep them coming! This version is fully backward compatible with all previous [...]
-
Datamartist 1.0.5 Available- with data profiling, Excel import and export to database
We are pleased to announce that V 1.0.5 is now available for download, and that it provides some important new functionality in a number of key areas. It is fully backward compatible with all previous versions of Datamartist, and we encourage all our customers to upgrade to this latest version. Data profiling Datamartist now has [...]
-
Datamartist connectivity enhanced- Beta 2 released
We're pleased to announce the release of Datamartist beta 2, which is officially release candidate 1. The big enhancements in terms of new functionality are in the data import functionality. Datamartist now manages all of its input data sources within a data source repository- that allows configuration of multiple database connections and files as data [...]
-
MS Access vs Excel vs Datamartist
When data analysis requirements really get tough, the tough get going- and start to seriously use databases. Let's face it, if you're considering Microsoft Access chances are what you need to get done is beyond what Excel does well, so you're looking for options. Its also likely that your IT department is unable or un-willing [...]
-
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 [...]
-
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 [...]
