Category archive for ‘ETL’ 
-
A simple ETL tool with data profiling tools built in
Datamartist is a new idea in ETL and data profiling tools. It gives people who are serious about getting at their data a powerful, simple to use, right sized tool. Easy to install Easy to use ETL features and data profiling capability Avoid using the wrong tool for the job Enterprise ETL tools (Extract Transform [...]
-
Datamartist V1.2 now available
nModal solutions is pleased to announce that Datamartist V1.2 is now available. In this version, we've introduced a Standard and Pro edition, letting customers get the features they need at the right price. Datamartist Standard: $349 Datamartist Professional: $745 A comparison of the feature sets explains the details. Whats new in V1.2 Data source import [...]
-
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. Joins can be said to be INNER or OUTER joins, and the two tables involved are [...]
-
Making rapid prototypes for data warehouse ETL jobs
Data warehouses and even data marts can be expensive, complex projects. They are not projects to start lightly, and they are not projects that you want to launch without doing some solid planning. But there is a way to get a handle on the tricky parts of your data warehouse scope, and to reduce your [...]
-
Data to the people- why self serve ETL
As regular readers of this blog know, I believe in a balance between formal and informal data analysis tools. I believe in an approach that firmly places people in the center of a new way of looking at the data analysis process. In the past, “big business intelligence” created an infrastructure heavy, highly centralised and [...]
-
Self Serve Business Intelligence
Self serve business intelligence dreams of letting everyone whip up any report or analysis they want. The reality is that its often not the report that's the problem- it the underlying data and model. So the idea of self serve business intelligence is a wonderful idea- the problem is that its not all about pretty [...]
-
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 [...]
-
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 [...]
-
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" [...]
