Category archive for ‘Purchasing Analysis’ 
-
Data quality at the burger joint
I have noticed that when I go to a fast food outlet no matter what I get to drink with my meal it is almost always listed as "Cola" on the receipt. But I didn't order Cola. Ever. Usually I get juice, or milk. So every time I order a burger, I'm clearly a source [...]
-
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 [...]
-
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 [...]
