How to determine the timeline for a BI project?

Question

Dear All,

I have been allocated a project on BI using SAP as the source system and need to provide the project plan for the same. How should I go about determining the timeline for the project for SAP? I am aware that 80% of the time is consumed by the ETL process but is there a standard methodology to determine the BI project timeline.

---

Thanks and Regards, Franco Lopes. Ask a Question and you are fool for a second but if don't ask a question you are fool forever.

Answer 1

We scope projects like this at my company Pragmatic Works. It is hard to scope without a lot of details like: The sources, how many source tables, how many fact tables, how many dimension tables, the amount of data to be moved, cube skills, number of reports to create. I would look into getting help or at least advice from a consulting company like ours.

---

Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

Answer 2

Thanks for your reply. Definite scoping can be done only after the discovery phase which will/should cover the above parameters in details.

---

Thanks and Regards, Franco Lopes. Ask a Question and you are fool for a second but if you don't ask a question you are a fool forever.