Category archive for ‘Datamartist Tool’ 
-
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 [...]
-
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" [...]
-
Personal Data Marts: cost effective, powerful Analysis
Huge, expensive data warehouse projects often either deliver a huge compromise in terms of functionality, or are impossibly complex and expensive. A bunch of them fail outright. Why do so many people turn to Excel for their analysis needs? Because with excel they are in control. With Excel it IS personal. Massive, expensive data warehouses [...]
-
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. [...]
-
Data Profiling and Data Completeness
There are various steps in data analysis- for me the very first one is always "what have we got?". You have a data set, and some broad requests or ideas about what you want to get out of it, but the first question is how good is the data? In the end, the first thing [...]
-
Datamartist Beta Presented in Toronto
nModal Solutions was proud to present the Datamartist Beta at the financial technology show in Toronto on November 25. We met lots of interesting people, and their positive reaction to the ease of use and functionality of the tool was much appreciated after all the work done to get this far. As with many of our [...]
-
Datamartist at the Financial Technology Show in Toronto
As we get closer and closer to the Beta, a major milestone is coming up fast. nModal Solutions will be proudly presenting the pre-Beta at the Financial Technology Show on Nov. 25 As anyone who has exhibited at a trade show can tell you there is a fair amount of work to be done to [...]
-
Data modelling Hierarchies- how to make a dimension
One of the most useful data model structures in a data mart is a Hierarchy (also called a Tree structure). Tree structures let us take a large number of things and organise them in a way that makes sense. More importantly, a tree structure lets us “drill down” into information. Hierarchy Rules In a simple tree [...]
-
Duplicate Data and removing duplicate records
Duplicate records, doubles, redundant data, duplicate rows; it doesn't matter what you call them, they are one of the biggest problems in any data analyst's life. There are lots of different types of data quality problems, but in this post I'll focus on Duplicates. I'll share some hints on how to find duplicate records and remove duplicate records, [...]
