The Situation

Your organization established a data warehouse which ran smoothly but now faces increasingly frequent problems like:

• Deteriorating report and query performance
• Increasing reliance on application and IT support teams
• Lack of confidence in the data provided
• Trouble loading data in a timely manner or with adding new sources
• A decline in user interest or uptake

The Solution

Analytics8 consultants, through their experience in business intelligence and data warehouse systems, understand the causes of these problems and have developed an assessment service to pinpoint opportunities for improvement. It includes:

• An independent review of your data warehouse and business intelligence system
• Identification of existing or potential problem areas
• Recommendations and strategies for addressing any issues
• Ideas for immediate solutions as well as strategic improvements
• A strategy for a balanced, realistic and business-driven set of recommendations that can be implemented over a realistic timeframe

The Approach

We will work closely with you to accommodate your specific circumstances, interviewing relevant staff and providing a choice of questionnaires covering:

• A technical architecture review
• An ETL review
• A data model review
• A data quality review of end user reporting and other outputs

Typically this assessment will take about 15-20 days depending on your situation and scope of review you choose. 

We summarise our findings in a detailed, actionable report with the further option of a presentation.