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

Category archive for ‘Personal Data Marts’ rss

  • Putting data analysis into the hands of the business user

    Having too many people involved can slow down the entire analytics process- by using tools that are designed to be accessible by business users, huge gains can be made. However a challenge faced by all companies is connecting the business knowledge and data manipulation knowledge in a way that the data can be used. As […]

  • The Datarati- Advertising discovers data ninjutsu

    I discovered a new term that resonates with me. Datarati- when I heard it, I thought of people who love data, do their own analysis and act quickly and with confidence based on that analysis. I first came across this new word in an article on Googlenomics in Wired. The article quotes Hal Varian, Google's […]

  • Pragmatic Business Intelligence

    I'm a regular reader of datadoodle, and there have been a couple of great posts recently talking about what I think of as "Pragmatic BI". The first one talks to the question of what the perfect BI tool is- answer? One that people actually use. The second uses a story to illustrate that many uses […]

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

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

  • Purchasing Data Mart – cutting costs with analysis (Part 1)

    In these difficult economic times, cutting costs isn't just optimization, it's survival. You can't reduce what you can't quantify so it's critical to analyze the accounts payable (AP), or purchasing data to identify the areas where cost savings are possible. This is one of the most useful financial data marts because spending is often something […]

  • A Cost comparision between Data Marts and a Data Warehouse

    I've noticed a fair bit of search traffic focusing on cost questions, particularly which is cheaper; a series of data marts or a single enterprise data warehouse.  I think it's a bit like the question of lease vs buy.  Starting off building a single departmental data mart will represent a much smaller cash flow out. […]

  • Business Intelligence Strategy in the Recession

    It’s difficult not to notice that the global economy has thrown a recession and we've all been invited.   So until we have some money to spend, we'll stop looking at our data, right? Although its true that in today’s economy, a lot of the multi-million dollar business intelligence projects are going to be cancelled […]