Category archive for ‘Data Transformation’ 
-
Data integration is like a pizza
I enjoy a slice of pizza as much as the next person (perhaps a bit more). The key to a good pizza is the raw materials- use the right stuff, and you'll be happy every time. What's great about pizza is that it has all sorts of great stuff on it, and presents them all [...]
-
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 [...]
-
Adding self serve data transformation to reduce shadow systems
Do you have lots of unoffical spreadsheets in your organization being used for data analysis? Is the data warehouse use low to non-existent, yet somehow lots of data is appearing in power point presentations and excel spreadsheets all over the company? I believe a key to understanding how information moves around your organization is to [...]
-
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 [...]
-
MS Access query example and comparision to Datamartist
Microsoft Access allows users to create complex queries and analyze large data sets. However, it can be complicated to use compared to Excel. In this post, I'll talk about ms access queries and the equivalent way to perform the same data transformation in the Datamartist tool- visually and simply. Microsoft Access has a clear role [...]
-
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, [...]
-
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" [...]
-
Easy to use ETL
As We've been creating Datamartist, we've been trying to avoid using acronyms to describe what it is, but when I'm talking to people who have a background in data warehousing, I only have to say "its an easy to use desktop ETL tool", and suddenly they know what I am talking about. An Extract, Transform, Load (ETL) tool is [...]
