Data-Analytics-OneU-App

Please view the files in the following order:

1. ETL.ipynb (Extract data from excel file -> Clean data -> Load data to Sql Server)
2. create_object.sql (Create 5 table in SQL Server)
3. trans_summary_daily.sql (Create a summary table and load data into it)
4. OneU_Dashboard.twbx (Include 3 Dashboards about Voucher Analytics)
5. Data Analysis Presentation.pptx (for Presentation)