VisualQuery

About   |   Technologies   |   Requirements   |   Starting   |   Author

🎯 About

Designed and developed a dashboard app for the velezreyez fellowship, the platform consist of a backend developed with FastApi, a mysql database and a frotend developed in reactjs with ts using the chakra-ui library, it was developedd with microservices architecture in mind, it feautures a GUI that allows users to select data from a bigquery database, abstracting all the sql language, users can se a graphical representation of his data, save his favorite queries, comment on other users queries and see all the queries on the database, user can also explore the most important table of the database with pagination, the app counts with multiplayer functionality and persistence.

Hey!, welcome to VisualQuery Alpha, VisualQuery it is a web app that helps you to visualize data from google BigQuery big data tables:

Login

When you go to our Webpage, the first thing youre gonna see, is our landing page, here you can create an user, or if you have one, you can login into the application, no passwords needed =).

Dashboard

After you login, this is the first view you gonna have, our dashboard, here you can build charts based on bigquery data with just some clicks =), you can select the indicator you wanna see data about, choose from a list of countries and years specifics to that data, you can either do one choice or multiple choice, you need to feed all the selections or the chart will not run =0(we are gonna fix that in the beta :$), you can also save the query you choosed to do the chart and save it into our database or queries.

My saved queries

Here you can see your own queries that are saved on the database, select one and run that saved query.

All saved queries

Here you can see all the VisualQuery saved queries, comment on other people queries and run their queries.

DataExplorer

And finally in this one you can see the biggest data table on the data set world education, so you can explore in depth the indicators, it pages about 200 results per page, is something slow, but hoping to optimize that =)

🚀 Technologies

The following tools were used in this project:

• React
• Python
• Docker

✅ Requirements

Before starting 🏁, you need to have Git and Docker installed.

🏁 Starting

# Clone this project
$ git clone https://github.com/forgionyc/visual-query

# Access
$ cd visual-query

# Build the docker images for the backend and the frontend
$ docker compose up -d

# Run the project
$ docker compose run visual-query

# The server will initialize in the <http://localhost:9000> for the frontend and <http://localhost:8000> for the backend

📝

LINK YOUTUBE: https://youtu.be/nJkGY_d2kA0

Made with ❤️ by Carlos Forgiony

 

Back to top