Building a Sales Forecast Dashboard for a Small Indonesian Company

Placeholder

As part of a campus fellowship program, the students were expected to be proactive in pursuing not only academic research but also relationships with companies, such as doing an internship or research collaboration. It was the first year after COVID ended, and after finishing the data science bootcamp, I was thinking of applying the knowledge that I had learned. But the problem is, if the company is too big, what I can contribute is limited. Moreover, company data might be restricted to interns. Fortunately, I found a small company in Indonesia that agreed to share their data with me.

During my first visit to Indonesia after five years of not going home, I was able to build a dashboard that provides sales forecasts and demand predictions. Initially, the frontend was built with Streamlit. For data exploration, I used Jupyter Notebooks to analyze their Excel data. The refined version was made with Next.js as the frontend and Python as the backend. It can be accessed here: apotek.harrybp.com