Posts Tagged ‘Scrum’

BI Projects – SCRUM Methodology

April 8, 2012 Leave a comment

Here discussing, Applying Scrum usage on BI projects. Please consider it is purely based on my experience with Scrum.

Any BI project is mainly having 4 phases in terms of Scrum methodology

           •   Business requirements
           •   Initial prototype and estimates
           •   Design and Implementation
           •   Handover process including post project work


Planning and implementation of the project schedule is based on the results of each phase/scrum rather than with the initial estimated/forecasting schedules.
Every phase of the project is considered as a Scrum and schedule of every scrum will be based on the scope and complexity of the scrum. In general the most of the scrums will be at monthly schedules while sprints are at weekly schedules.

           •     Points to consider
               o     Having knowledge on the Business Domain
               o     New system/migration of a legacy system
               o     Implementing the extension of the system


Every Scrum of the project will have at least 2 sprints (here considering 2 sprints) based on the Scrum schedule and implementation of the tasks at sprint duration.
Every sprint is having its tasks besides status on previous sprints tasks.

           •     Points to consider
               o     Sprints duration depends on the tasks complexity and the dependency of the tasks
               o     Every sprint results needs to be assess and consider for the Scrum schedule
               o     Strong coordination of team members requires for the successful sprints
               o     Most of the times, sprints results are the bottom line success of the project

Project Schedule:

Every scrum/sprint of the project is having interdependency so sprints results will play a major role on the project schedule. Every sprint results need to be considering for the project schedule adjustments and here requires contribution from all team members.

How Scrum includes Agile:

1. Every Scrum is divided into sprints while having the coordination among the scrums during project implementation.
2. Every sprints results will consider for the status of the Scrum and intern will also to project schedule
3. Scrums and sprints will have a circular implementation of the project so team will have the flexibility of adjustments to project/task scope variations and it is one of the main concern for consulting organisations
4. Considering the variations and additional scoping at every sprint will directly impact the project schedule which makes clear on the schedules. This makes clear vision of the project schedule to the project sponsors and the business users.

A realistic situation of applying Scrum to any new BI Project will have estimates for the major team members as

      1. First Scrum

                     • Business requirements                sprint 1         sprint 2
                                 o Analyst/Designer –           90%                60%
                                 o Technical Consultant –      10%                40%

      2. Second Scrum

                    • Initial prototype and estimates:
                                 o Analyst/Designer –           70%                40%
                                 o Technical Consultant –      30%                60%

      3. Third Scrum

                    • Design and Implementation:
                                 o Analyst/Designer –           70%                10%
                                 o Technical Consultant –      30%                90%

      4. Fourth Scrum

                   • Handover process:
                                 o Analyst/Designer –           10%                  5%
                                 o Technical Consultant –      90%                95%

Points to consider:

1. Here discussed the Scrum usage on BI Projects purly based on my experience
2. Presented only the higher over view of the Scrum at project planning
3. Scrum is really useful whenever we don’t have well defined scope of the project
4. Additional information will be available here for reference

Categories: Misc Tags: