Case Studies

Apply for Business Intelligence Certification Now!!

Case Study A: Business Reporting and Customer Information XYZ Architecture Setup and Roll-out for a Global IT Company

Environment: Business Objects 5.1, Oracle8i, Informatics, Web Intelligence

To determine the scope, define and articulate a structured, systemized architecture to capture and report business metrics and financial dashboards for XYZ

• Assess existing processes and techniques to capture and report business metrics and financial dashboards
• Define the scope for systemised data capture and reporting of business metrics and financial dashboards
• Key emphasis: Capex, Opex, Receipts and Payments, Profitability Analysis
• Define processes, systems and techniques for systemised data capture and reporting of business metrics and financial dashboards
• Articulate systems and techniques for systemised data capture reporting of business metrics and financial dashboards

To determine the scope, define and articulate the framework for building a Customer Information Data mart Architecture for XYZ

• Assess existing processes and systems to capture all customer contact information for XYZ
• Determine the scope framework for systemised data capture of customer intelligence data
• Determine the scope for pilot (for actual data capture and roll-out), with the framework containing the XYZ perspective
• Delineate data definitions, the structure, data capture processes, business logics and system rules, and applications and techniques for Data mart
• Design and execute

Case Study B: Data Warehouse and Consolidation Report for XYZ Contact Centre

Environment: Business Objects 5.1, Oracle8i, Informatics, Web Intelligence

The scope of deliverables included

• Understanding and analyzing User Requirements
• Slot in design augmentation to the data warehouse
• Improve and modify the ETL

Devise and develop the following reports

• DNA Report
• Scorecard
• Compensation Report – KPI
• Compensation Report – Revenue
• Reseller Report (RSI)
• Campaign Report
• Operation KPI
• IDA Reports (Government Accounts)
• Agent Direct Report

Case Study C: Automation of Global Planning Data

Environment: Business Objects 5.1, Oracle8i, Informatics, Web Intelligence

The automation of global planning data facilitated the data storage with respect to demand planner and sales, as well as order system, and is a part of ABC’s global data warehouse One view – a single window data warehouse for all business activities of ABC in all project areas. Data from different sources, such as Oracle ERP, etc has been loaded to data warehouse.

The functions of the LMN consultants included

• User interaction
• Requirement scrutiny
• Designing and developing ETL process in Informatics
• Design of Business Objects Universes
• Design assessment
• Security management and Sharing
• Testing

http://www.vskills.in/certification/Certified-Business-Intelligence-Professional