Other than traditional static reports, performance monitoring and business trend forecast become the core value of the financial data warehouse. With Microsoft office based user interface, data are captured and delivered in the most user friendly utilities. Financial data, both sales and costs, are easily summaries and classified into various regions, client types, product lines..etc. and provide valuable information for management to understand the actual performance of the business compare to the budget one. Future trends can also be generated from this historical data for advance financial planning purpose.

By using the advance Microsoft OLAP technology, we can easily be sliced through volumes of complex financial data which in turn produce accurate and meaningful production KPIs (Key Performance Index). Though rules based financial allocation and sharing, the actual cost centre and profit centre calculation can be automated and those results can be used to compare with the budgeted figures and as a bases for planning and management decision.

• Profit and Loss worksheet to summaries all the cost and income in divisional bases
• Sales reports allows the decision maker to predict the sales performance
• Various break down on sales or income by regions, client types and products
• Manage the budget and cost control on organization with complex structures
• Rule based cost allocation and sharing among divisions
• Consolidate date from ledger and accounting system
• Data extraction/import from external systems
• Comparing budget, actual and forecast
• Provide key performance index
• Easy to access dash board portal
• OLAP services provide on-line data and reports