Implementing a Statistical Database Using Business Intelligence Tools and Data Warehouse Concepts
The Department of Foreign Affairs and Trade (DFAT) provides foreign and trade policy advice to the government and is the lead agency managing Australia's international presence. DFAT has been using their custom built Statistical Analysis and Reporting System (STARS) with data going back 25 years but it is expensive to support and maintain and its inflexibility and unfriendly user interface have hampered productivity & usage. The development & implementation of a new data warehouse that replaces DFAT's traditional statistical database. The STARS application was completely redeveloped using the latest Microsoft technologies and state of the art Business Intelligence tools and OLAP cubes.