Tag archive for ‘Datamartist Tool’
In this post I’ll show you how to do all the main types of Joins with clear SQL examples. The examples are written for Microsoft SQL Server, but very similar syntax is used in Oracle, MySQL and other databases. If you are tired of writing SQL and want to try a visual tool, you should […]
-
Inner and outer joins SQL examples and the Join block
In this post I’ll show you how to do all the main types of Joins with clear SQL examples. The examples are written for Microsoft SQL Server, but very similar syntax is used in Oracle, MySQL and other databases. If you are tired of writing SQL and want to try a visual tool, you should […]
-
Datamartist presented at Democamp Toronto
As I always do I had a great time at Democamp in Toronto this past Thursday. But this Democamp was very special for me, as I was one of the presenters, and had a chance to show off the beta of the next version of Datamartist. Thanks to Geoffrey Wiseman who covered the event on […]
-
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 […]
