Midea Digitalized Office Tool: Datamix

• Built the framework of one online office tool “self-service getting data” in Flask
• Utilized Redis as the cache to improve the read rate; used MySQL to store data plus SQLAlchemy to read and write database; designed entities such as users, tables, databases, and their relationships
• Exerted Celery to realize the functions like asynchronous update of users’ permissions and asynchronously sending error messages by Emails
• Maintained the website: www.xxx.midea.com (Company Intranet), allowing employee-user to self-create the custom query with large enterprise databases

1. Data query
   

2. Converting to graphics
   

3. Customized query fields
   

4. Administrator console
   

5. Graphical dashboard