Sales Data Mart Model
3 posters
Page 1 of 1
Sales Data Mart Model
Hello,
I'm actually developing a Business Intelligence website for small businesses. I want to develop the sales area for the moment, so I designed a Data Mart with a star model aproach for this area of the business. I want it to be as general and standard as possible so that many small different businesses can fit in the model and upload their sales information. This is my actual model, any recommendation? What do you think about my model?
https://imgur.com/6VmBNHX
I'm actually developing a Business Intelligence website for small businesses. I want to develop the sales area for the moment, so I designed a Data Mart with a star model aproach for this area of the business. I want it to be as general and standard as possible so that many small different businesses can fit in the model and upload their sales information. This is my actual model, any recommendation? What do you think about my model?
https://imgur.com/6VmBNHX
rodcj92- Posts : 1
Join date : 2015-11-16
Re: Sales Data Mart Model
"Sales Person Marital Status" ... I'd love to see how you plan to use that one
Which product did you use to draw the model?
Which product did you use to draw the model?
Re: Sales Data Mart Model
Do you already have a set of small businesses that you are building this BI website for - and this design is based on their requirements - or is this being built "on spec" with the hope that you can persuade businesses to use it?
If you are designing it "on spec" then I think you will quickly run into issues: designing a "one size fits all" model normally results in a design that doesn't actually suit anyone. Each customer will want to categorise their products in slightly different ways; they'll have different hierarchical structures for their sales organisations; they'll want to know different things about their customers; etc. etc.
By the time you've customised the model to meet each customer's requirements it would be easier to have started from scratch with each one. The challenge (and the time consuming part of any BI project) is understanding requirements and designing a data model that will support those requirements. The data model that you have come up with is basically the same generic model that anyone doing data modelling would come up with if asked to spend 10 minutes describing a sales star - and there are versions of it in 1000s of websites and books (such as Kimball's). Taking this basic model and turning it into something relevant for a particular business is what adds value and makes it useful - IMO
If you are designing it "on spec" then I think you will quickly run into issues: designing a "one size fits all" model normally results in a design that doesn't actually suit anyone. Each customer will want to categorise their products in slightly different ways; they'll have different hierarchical structures for their sales organisations; they'll want to know different things about their customers; etc. etc.
By the time you've customised the model to meet each customer's requirements it would be easier to have started from scratch with each one. The challenge (and the time consuming part of any BI project) is understanding requirements and designing a data model that will support those requirements. The data model that you have come up with is basically the same generic model that anyone doing data modelling would come up with if asked to spend 10 minutes describing a sales star - and there are versions of it in 1000s of websites and books (such as Kimball's). Taking this basic model and turning it into something relevant for a particular business is what adds value and makes it useful - IMO
nick_white- Posts : 364
Join date : 2014-01-06
Location : London
Similar topics
» Data model for Sales Order and Sales
» How to model target KPI Values in a Data Mart
» How to model comparible store sales for retail data
» Modeling a Sales Order to Billing to Shipping consolidated data model
» difference between data mart and data warehouse at logical/physical level
» How to model target KPI Values in a Data Mart
» How to model comparible store sales for retail data
» Modeling a Sales Order to Billing to Shipping consolidated data model
» difference between data mart and data warehouse at logical/physical level
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum