At ICBC we were able to exercise our Data Warehouse skills to produce a departmental data mart using SQL server.

With a star schema database design and heavy index tuning we effectively managed 20 million transactions with an additional 500,000 being processed, transformed, and summarized each month.

Using stored procedures to process transactions we could pre-calculate many totals and summaries, compare current transactions with historical transactions, and produce trending data for instant analysis by management.

To generate reports we developed a rich wizard based application using Microsoft Access as the front-end to the SQL server datamart.