Multi-tenant web application, which helps small business owners to record their business activities and analyze business performance. Multiple users use the same instance of this application and only see their own data. This application contains three main parts: maintaining product catalog, transactions batch upload, and analysis reports.
- Technologies Used
- How to maintain product catalog
- How to batch upload transactions
- How to show business performance
- Data Model
- Flask
- Python
- Postgres
- SQLAlchemy
- Javascript(JQuery, Ajax)
- Chart.js
- HTML
- Bootstrap
User can add one product by filling in the form. A product is a type of item users sale, and each product has different attribute. In additon, users can add and remove as many user-defined attributes as they want. The reason why it’s possible is that all attributes are not stored as columns in the product table but as rows in separate child table.
After having this product, Users can record its purchase and sales transactions. Choose a csv file to upload. The content of the file will be read by the system and return the result as a Flash massage. If some row upload failed, users can use the flash massage to correct it.
Recording business activities is only one part. The more important is to show how uesers' business performance.
Sisi Wang is a software engineer, and she was a data analyst five years ago.