Identifying business processes
3 posters
Page 1 of 1
Identifying business processes
Hello
I have been reading articles and books by Kimball and understand the 4 steps process, identify business processes, declare grain, define dimensions and facts. I am new to a DW/BI project in which we are in the initial stage of gathering requirements (mainly source driven requirements gathering) and subsequently starting the dimensional modeling.
I am stumbling on the first step that is identifying the business processes. Usually the way it is explained in the books is that Orders, Shipments, Invoice etc. are business processes. Also it is said that the business processes must not be for some specific calculations or reports. But in my case the requirements are to create a DW/Data marts to support 5 categories of complex reports for various customers. The underlying source for all the reports comes from an OLTP source system which has daily transactions. In this case how should I go about identifying the business processes?
Thanks in advance for any help!
I have been reading articles and books by Kimball and understand the 4 steps process, identify business processes, declare grain, define dimensions and facts. I am new to a DW/BI project in which we are in the initial stage of gathering requirements (mainly source driven requirements gathering) and subsequently starting the dimensional modeling.
I am stumbling on the first step that is identifying the business processes. Usually the way it is explained in the books is that Orders, Shipments, Invoice etc. are business processes. Also it is said that the business processes must not be for some specific calculations or reports. But in my case the requirements are to create a DW/Data marts to support 5 categories of complex reports for various customers. The underlying source for all the reports comes from an OLTP source system which has daily transactions. In this case how should I go about identifying the business processes?
Thanks in advance for any help!
dw.know415- Posts : 1
Join date : 2013-02-12
Location : United States
Re: Identifying business processes
Can you give a bit context around the business process? This will help me / you understand how that should translate into a dimensional model.
1. What is the business?
2. You say you have customers, what type of customers are they?
3. Can you tell us what the reports are showing / calculatiing? What measures, attributes and filters do they contain?
Thanks
1. What is the business?
2. You say you have customers, what type of customers are they?
3. Can you tell us what the reports are showing / calculatiing? What measures, attributes and filters do they contain?
Thanks
thedude- Posts : 21
Join date : 2009-02-03
Location : London
Re: Identifying business processes
Understand the source data model is where I would start. Then take a look at the reporting requirements. When you can rationalize a report to the OLTP model, you're ready to start.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Including two business processes in one report
» Relationship between Fact and Dimension Table - Identifying or non-identifying?
» Identifying fact grain
» Joining indirectly related business processes in a dimensional model
» Modelling two independent business processes related to a single event
» Relationship between Fact and Dimension Table - Identifying or non-identifying?
» Identifying fact grain
» Joining indirectly related business processes in a dimensional model
» Modelling two independent business processes related to a single event
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum