Business Intelligence Performance Optimization

Abstract

What happens when you are the Business Intelligence (BI) developer and you need to find a solution for an Analysis Service Job execution that takes more than 20 hours to process over 1.3 terra-bytes of data? This project will presents an atypical scenario for a business solution. In a typical scenario many introductory books, papers or tutorials presents a random company that uses a web site to sell their products such as “Adventure Works”. Adventure works is a company invented by Microsoft where they present a database that they use to teach many concepts, including Business Intelligence. In this project we have a Business Intelligence solution already deployed in a production environment, but the database administrators are reporting performance issues running the data processing to maintain this solution up to date. I will be examining this solution to assess where exactly the problem is and provide a new solution that is capable to improve processing performance. Key Terms - Analysis Services, Business Intelligence, Cube, Data Warehouse, Optimization, Performance