KPI Package Offerings:

Data Warehouses and Data Marts Review - KPIDWDM

The data warehouse technical review service provides customers with recommendations and best practices to help ensure their data warehouse project delivers a solid foundation for better BI. The Data Warehouse Technical Review service is aimed at improving performance and stability and ensuring a dependable framework for success. We will deliver a comprehensive, strategic report that articulates the challenges and technical requirements specific to ensuring the success of your Data Warehouse implementation.

A Data Warehouse Technical Review means you will get:

• An experienced KPI BI expert at your site to review your infrastructure, architecture, environment and ETL processes.
• A formal report of our findings that includes clear and actionable recommendations, providing a foundation for your successful warehouse implementation.
• Knowledge transfer of Data Warehouse best practices tailored to your environment.

A STANDARD PROCESS

An experienced KPI BI senior technical consultant meets with you and your team to evaluate and assess your current environment, architecture, and ETL processes. The end result is a comprehensive recommendations document that allows Cognos customers to define optimized standard practices for current and future data warehousing projects.

EACH REVIEW IS UNIQUE

At your location we meet with your team to understand the issues that are important to you. Together the KPI Data Warehousing consultant and your project team review your existing environment and ETL processes. Common areas you may want us to review are:

• Warehouse architecture
• Data mart design
• Metadata
• Build performance and throughput
• Process load balancing
• Administration and Maintenance

RECOMMENDATIONS AND BEST PRACTICES

After completing your Data Warehouse Technical Review, your KPI consultant will meet with you and your team to communicate the results. The report will draw upon existing Cognos best practices, providing impact analysis and risk identification based on our experience with other similarly situated environments. You’ll receive detailed recommendations with preferred approaches for getting the maximum value from your architecture configuration and processing objectives. We’ll also include next-step suggestions. Included along with the report will be relevant collateral material to help you make informed decisions about your choices.

 SERVICE DURATION

Your KPI consultant will spend time both at your location gathering and then presenting information as well as offsite, putting together the review document. The length of the review will vary according to the scale and complexity of your organization’s needs. We recognize each customer’s requirement is unique and the amount of time we spend with you will depend on the overall goals of your specific review.