Datamartist gives you data profiling and data transformation in one easy to use visual tool.

Category archive for ‘ETL’ rss

  • Finding balance in your ETL strategy

    Organizations large and small can experience ETL (Extract Transform Load) bottlenecks in one way or another. The task is complex and significant damage to your business can occur due to inadequate ETL strategy (or lack thereof). In general, companies approach solving ETL needs in three different ways. ETL empires These are companies that have a […]

  • Preparing Data for QlikView

    In this blog post, I am going to play with some economic data- specifically, Canadian Import and Export data using Datamartist and then use QlikView Business Intelligence Software to analyze the results. The trick with public data like this is that often (ok almost ALWAYS) either data is missing, or the codes don't match up. […]

  • 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. If you are tired of writing SQL and want to try a visual tool, you should […]

  • 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 […]

  • 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 […]