A comprehensive coworking space management system designed for 'SmartSpaces', incorporating a relational database for efficient space bookings, visitor tracking, employee management, and billing, with Python integration for analytics to support business expansion decisions
With this project, we want to enable ‘SmartSpaces’ to:
- Keep track & monitor their services in different locations throughout Boston.
- Assist in further expanding their business.
- Understand the types of users and their behaviors.
- Recognize the neighborhoods across Boston where the business is currently flourishing and can be further expanded.
create_tables.sql
: Contains the SQL commands to create the database and tables.select_queries.sql
: Contains sample SQL queries to interact with the data.
- The database ‘coworking’ was connected to Python using a Jupyter Notebook.
- Performed analytics to provide insights into how ‘SmartSpaces’ can expand their services across Boston.
- Metrics like ‘Recurring Users’, capacity of neighborhoods, and revenue generated were analyzed to assist in decision-making.