Abstract
In this modern age, information and knowledge are crucial in determining the quality of an individual’s life. Data warehousing techniques could integrate raw data taken from different sources properly so that information retrieval is fast, efficient and accurate. This project involves the design and implementation of a Data mart for the crime incident dataset, in the San Francisco metropolitan area. The aim of this tool is to gain knowledge that would help the citizens in finding areas within the San Francisco metro that are relatively safe and habitable. The dataset is from the San Francisco government’s data website. The website is a central repository for all the data generated by the county of San Francisco, which includes many departments. This dataset contains all the petty crimes recorded in the city by the San Francisco Police Department over a certain period. The tool also has a web-based interface through which users can ask questions about crime rate in a particular area based on some conditions. The results are presented as charts and graphs so that users can understand them easily. Tasks involved in the creation of this tool include data collection and pre-processing, designing the Data mart, identifying use cases, generating charts, plotting maps and user management. The Data mart is created using MySQL database and the web application is developed in C# and ASP.NET MVC.