Laboratory of Data Science

Project of Laboratory of Data Science course, Data Science and Business Informatics - University of Pisa

A. Carnevale, F. Canepuzzi

Introduction

Starting from a raw Tennis dataset which contains information about challenged matches, it is required to build a Datawarehouse in order to answer useful query and plot relevant dashboard. The project is made up of 3 parts which are described in detail below.

Part 1

• Datawarehouse building with Microsoft SQL Server Management Studio
• Data Preprocessing
• ETL process

Part 2

• Query DW using SQL Server Integration Service (SSIS) control flow

Part 3

• OLAP Cube building with Microsoft SQL Sever Analysis Service (SSAS)
• MDX quering
• Power BI dashboard