The BI Project A case study for the development of a BI data management configuration StayMore, a short-term renting application
Short Description of the project:
The project introduces StayMore, a hospitality industry company. The company wants to serve their customers better and thus become more competitive.
Your team is asked to collect, shape and organize this data, and then build a complete business intelligence and analytics system.
For more information about the project please:
a) Read the pdf " Group Project for Business Intelligence.
b) Watch Project Presentation from D11.
Instruction to run the project:
-
You need to install " MS SQL Server " and Power BI windows softare programs:
https://www.microsoft.com/en-us/sql-server/sql-server-downloads 18.7.1
https://powerbi.microsoft.com/en-us/ -
Restore the database from the link " https://drive.google.com/drive/folders/1riv1iq9LAfpQzppHOx3US5IIpZVxOulO?usp=sharingD06 " "air2-2012version.bak" into MS SQL Server.
Next, run the scripts from the path D06/Scripts/ according to the pdf file "BuildingAndDiagrams". -
Run the Query "ML_Data.sql" from the folder D08 to receive the Machine Learning training features.
-
With Google Colab or python, use the script "StayMore_Machine_Learning.ipynb" to train your model.
-
Finally, you can load the SQL database and ML tables into the Power BI for Visualizations and Reports
-
In D09 " https://drive.google.com/drive/folders/1riv1iq9LAfpQzppHOx3US5IIpZVxOulO?usp=sharingD06 " you can find all the Power BI Visualizations Captured by the team
Deliverables Information:
D01. Problem and proposed solution overview
D02. Analysis of the problems and needs that will be covered with the proposed BI solution
D03. Team organization, tasks identified and project timeline
D04. List of development and collaboration tools used
D05. BI system overview, architecture & system workflow/workflows
D06. Database diagrams and source code (OLTP, Staging, DW, DMs)
D07. Data flow diagram/diagrams & transformations explanations
D08. Code files used for data processing
D09. Data Visualization platform’s (e.g. from Power BI) files, relevant screenshots and description of functionality and intended usage and purpose (see also paragraph 7)
D10.A description and presentation of the analytics along with the source code and other necessary files
D11. Project Evaluation, advantages, limitations and suggestions for future steps