Jeroen Bosems

In this presentation, we will be discussing the merits of Agile processes in Business Intelligence (BI) development. First of all the focus will be on explaining the differences between Agile methodology and Waterfall processes in BI and why Agile is here to stay. Agile requires a specific mindset in BI projects due to our full stack mindset and we will spend time giving pointers on what rules can make your communication with the business more fluent. This will include the value of maintaining live documentation for both business and developer. We then look at why there are technical limitations for implementing Agile that are specific to BI and examples of how to overcome these. One of the tools we will look at Test Driven Development (TDD) and Behaviour Driven Development (BDD) and how these apply for a BI setting. By following the previous notes we can describe how we're pragmatically going to apply these principles, and elaborate on splitting up the different scopes in a project (staging, Data Warehouse, and reporting layers). This will, in turn, enhance the quality of our deliverables. By the end of this session, you will have a better understanding of Agile development in BI, and some tools of how to apply this to your day to day operations.