At last week's #BIWisdom TweetChat, we decided to try a different format for this coming Friday. Instead of open chat, we're going to analyze a customer case study and suggest possible solutions.
Our inaugural case study has been contributed by one of our eminent "tribe" members, Jacqui Taylor, Founder and CEO at FlyingBinary.
Case Study: What would you do next?
Background: A large global brand with staff worldwide.
The existing BI infrastructure is one of the large vendor packages which has been in place for over 10 years with the expected Data Warehouse style deploy. Standard ETL and Reporting processes exist. They have approximately 3 Terabytes of data to consider.
Client: The Head of IT
We had been asked to supply a resource to ‘straighten out’ the business users. We were allocated a budget of 7 days to produce some self serve BI reports in order to establish the WIP (Work In Progress) stock position.
Assignment: How did we do?
After 5 days we had not been able to establish WIP stock position, discovered data integrity problems in the data warehouse, clients not invoiced, incomplete sales pipeline data, most of the business users were using Excel extracts to run their business units. Additionally, we were approached by an additional 15 business users whose reporting requirements have not been met by the existing BI infrastructure.
What would you do with the remaining 2 days of the assignment?
Don't forget that this is the last week to participate in our upcoming Mobile Computing & Mobile Business Intelligence Market Study. Participants receive a complimentary copy of the findings.