 |
Case Study
Data Warehousing Solutions Development
One of the largest pharmaceutical products distributors in Asia, which handles over 30,000 clients in the region alone and with the large volume of transactions going through its systems daily, the sales management information aspect needed to be updated to cope with the demand by building an improved data warehousing system.
Its business objective for the data warehouse was to implement a Sales Management Information System that would provide: 1) a more flexible analysis and reporting tool for monitoring sales; 2) a facility for sales people to access sales data offline and perform their own analysis; 3) reduce the amount of system processing time, for a more timely and responsive reporting; 4) provide a secured way of presenting data to individual users.
The basis for the design of the data warehouse are text file extracts from an AS/400 system for each of the company’s branches across the Philippines, and involves building an application architecture for the data warehousing system. The system also enables analysis of one or a combination of different dimensions and drill down levels for sales (totals and targets), and also enables analysis of sales statistics specific to end-user requirements, e.g. by branch/sub-branch, by customer class, by sales agent, by period, by customer.
Done in collaboration with Microsoft Consulting Services, FDC’s solution is based on Microsoft Windows Distributed interNet Applications (DNA) Architecture using the following Microsoft enterprise products and application development tools: data warehouse design, data cleansing and loading, cube design, processing performance tuning, report templates/views design, security design, back-up and recovery design; Windows 2000, SQL Server 2000 for the server software, Windows 95 or NT Workstation and MS Office 2000 with MS Query for the client software.
|
|
|
|
