Hectic Garage

Owning a garage shop can be troublesome; however, using our software, "Hectic Garage" can make it much easier. Our software aims to minimize loss and provide suggestions that may increase profits.

Comment

Inspiration

Having members with different backgrounds in Software Engineering, Computer Science, and Statistics, we wanted to work on a project that could bring all of our talents together. We wanted to use data to provide meaningful insights, while creating user-friendly interfaces and storing all the information in accessible databases.

What it does

Our software is able to read in csv. files, create professorial visualizations, provide data analytics and perform data preprocessing and postprocessing, such as data cleaning and calculations. To elaborate, the software is able to calculate the revenue gained and revenue loss based on the "First in First out" business model. Our solution can display the amount of accepted and rejected customers based on each car type, while also being able to calculate the total revenue.

How we built it

For the backend we used a combination of juptyr-notebook, pandas, python, firebase and firestorm in order to perform our data preprocessing and postprocessing functions. We used React,Flask and javascript in order to create user interface and provide a canvas for our visualizations.

Challenges we ran into

We ran into issues with importing our functions from juptyr-notebook into python and NoSQL, thus we had to create a master database using the sample csv.

Accomplishments that we're proud of

As a team, we are proud of the visualization of our website and the methods we used for approaching the dataset and how we transformed it. We are also proud of the graphs we created for each relevant subsets of data and being deploy able to deploy a cloud function flask for the time.

What we learned

We learned how to use Flask and Firebase, and the difficulties of working in such a tight deadline. In addition, we learned aspects that will help provide better communication between front-end and bank-end developers.

What's next for Hectic Garage

If we are able to get our full backend functions in the cloud, then we could create visuals that are interactive within our user interface. In addition, we could also provide more statistical knowledge in our "Analytics" page.

Built With

Share this project:

Updates