What is it?
A data analytics abstraction layer that connects to databases and executes pre-constructed SQL queries.
Who is it for?
It is meant as a business intelligence tool for enterprises.
Why build it?
Often times, business teams and/or management teams are interested in certain metrics, for example daily revenue of the business. Normally, data analysts will have to retrieve this data from the database on a daily basis. While seemingly simple, it can get tedious especially when there are a ton of other metrics to query for.
However, with Query Me, data analysts will only need to write the query once, and the query will be stored in the form of a report. Anyone in the company can then load the report anytime to see the desired query results. Reports can also be downloaded as excel files for further analysis or sharing.
How is it built?
Tech Stack:
Postgres, Handlebars (Semantic UI), Express.js, Node.js
ERD:
MetaData DB:
Actual DB:
Business Role
Able to:
- View Reports
- Download Reports as Excel
- Favourite Reports
email: business_test@mail.com
password: 123
Admin Role
Able to:
- ^ All of what a business role can do
- CRUD Reports
- CRUD Users
email: admin_test@mail.com
password: 123
- Log in with admin role credentials.
- Under Report Categories, navigate to any existing report.
- Try editing a report, previewing SQL queries, downloading the results as excel sheet and favouriting the report.
- If you have favourited any reports, you would find them under favourites.
For demo purposes, you will find that most CRUD controls don't work.