|
Written by aptude
|
|
Tuesday, 12 July 2011 17:06 |
|
Challenge A global, multi-billion dollar manufacture of retail goods desired an Executive Dashboard. The Dashboard and subsequent scorecard analytics were to provide information on Global Strategic Planning, Corporate Marketing, Distributor Compensation and Sales Requirements Leverage data from from the Global Data Warehouse, Finance Hyperion and Survey Capture
Leveraging the CSV file populated by client’s IT department, create a new Scorecard Metric Fact Table and expose the data for ad-hoc reporting and existing Time, Exchange, Currency, and Geography BI dimenions
Based on the current MS Excel template, produce a Global Strategic Planning scorecard that is accessible through the current standard portal for reporting.
Based on the current MS Excel template, produce a Corporate Marketing scorecard that is accessible through the current standard portal for reporting
Based on the current MS Excel template, produce a Distributor Compensation & Sales scorecard that is accessible through the current standard portal for reporting
Solution Created a new Scorecard Metric Fact table in the GDW, along with processes to populate the table with data from a CSV file created by IT. This was developed as a repeatable process
Defined and implemented a process for annotating the scorecards with user provided information. The users provided information and we included all the other metric data in the CSV file
Exposed the data in the new GDW to the business for ad-hoc reporting purposes
Leveraged the new Scorecard Metric Fact table to produce executive scorecards
Implemented the new development into production and supported the product for the first three weeks after the roll out.
Technology · Oracle Business Intelligence Enterprise Edition (10.1.3.4)
|
|
Last Updated on Tuesday, 12 July 2011 17:55 |
Case Studies 
