You can also store within the consensus tool all of the physical components of the data model. Those kind of things can also be articulated and stored within the tool. And it works inversely. If you have an existing model, you can pull it thorough in and populate the warehouse. But this is really the consensus tool, to us is a core component of that sprint zero, sprint zero being clarity, prototyping, and validation of business need very quickly, very inexpensively but very effectively. It could be done much more rapidly and purposely through the use of the consensus tool.
So if we look at an example of a business model, the question was people want to know payment types, general sales performance by outlet, product and time. This is a kind of 7/11 kind of an example. It’s not this 7/11’s data just to be clear, but that’s the kind of use case we have here. And notice what we’ve done in the consensus tool if you look at the information package, what we have is, this model is going to allow the business to set the answer to the question, or be able to do that kind of analysis.
What we see articulated is the calendar, or the calendar dimension, and note that we see a year and here weekday. There were two different hierarchies. The drill down is granular to the level of day, and we see the day parts which is a retail thing of organizing hours like in a restaurant, the breakfast day part and the lunch day part.
So we are looking at things in that way, and these are defined in six hour increments, and then we have the outlet, and we have the hierarchy, regions to outlets. We see the products. And they were looking at performance by division. Divisions go to department and product groups, and you can see the associates in the promotions and in order to look at things by promotion.
And, down at the green part, what we see are the measures that will be stored in the form of fact tables. So we see sales amounts and sales qualities and transaction counts, and they would calculate measures. Then we can actually go further and do attributes, or you know data attribution in a fully attributed data model within the consensus tool.