Our Client
The City of Calgary is the municipal government of Calgary, Alberta—a dynamic Western Canadian city with a population of more than one million people.
The Need
The City decided to implement a Business Intelligence system for the Building Regulations Division of the Development and Building Approvals Business Unit. The City recognized that improved analysis would increase productivity for the division and improve its service offerings to the public.
Our Solution
To address these concerns, The City engaged Quadrus to help assess, define and plan the development of the first data mart with the ultimate goal being an Enterprise Data Warehouse. Quadrus assisted The City in selecting and implementing “best of breed” technologies, offering The City a truly integrated and scalable business solution.
The data mart is beneficial to the Building Regulations Division on many levels. Permit revenue analysis will become more efficient and speedy. Information accuracy will improve since all data will be integrated into a single repository and will be obtained from specific known sources. The system will also provide an intuitive interface, which will allow business analysts to easily create data queries and format query results into reports for other clients.
The Result
Scalability was a top priority when providing this solution since, over time, all The City’s business units will be integrated into this Enterprise Data Warehouse system. The architecture is also scalable as an enterprise back office so as The City moves towards an enterprise portal front-end, it can easily expose a wider range of information to its employees, partners and the public.