GiTil_BusinessIntelligence

Advanced Information Systems (Business Intelligence) University Project

GiTil_BusinessIntelligence is licensed under the GNU General Public License v3.0

Computer Engineering and Informatics Department
University of Patras
Winter Semester 2016
Advanced Information Systems

Author: Tilemachos S. Doganis

Co-authors: Spiros Kaftanis, Apostolos Kemos

Implements an interactive Data Warehouse with an OLAP Hypercube for Data Analysis of UK Road Traffic Accident Data. The program consists of an ETL package, an OLAP Hypercube, and interactive visualizations.

Makes use of the following software:

• Microsoft SQL Server 2014 (Developer Edition)
• SQL Server Data Tools for Visual Studio 2015
• Microsoft Excel 2010
• Microsoft PowerBI (2.51.4885.543)

Prerequisites:

1. Ensure that 'SQL Server' and 'SQL Server Analysis Services' are launched.
2. Update any filepaths
3. See Report for more information on how and where to place the necessary files for proper data warehouse function.

References:

• https://data.gov.uk/dataset/cb7ae6f0-4be6-4935-9277-47e5ce24a11f/road-safety-data
• https://www.gov.uk/drink-drive-limit

---

Contains public sector information licensed under the Open Government Licence v3.0.