From Google Colab to Production: Bridging Data Analysis and Web Applications
I am an enthusiastic researcher and developer with a passion for using technology to innovate in business and education.
By Ariska Hidayat
When people think about data analytics, they often imagine spreadsheets, Python scripts, Jupyter Notebooks, or Google Colab.
When people think about software engineering, they think about APIs, databases, web applications, and cloud infrastructure.
In reality, many organizations need both.
A data analysis project may start in Google Colab, but eventually someone asks:
Can this be accessed by other team members?
Can this run automatically every day?
Can this be connected to our application?
Can we provide this through an API?
Can managers view the results from a dashboard?
This is where the gap between data analysis and software engineering becomes visible.
The Challenge
Google Colab is an excellent environment for experimentation and analysis.
Data analysts can quickly:
Import datasets
Clean data
Build reports
Create visualizations
Explore business trends
A typical workflow looks like this:
CSV / Database
↓
Google Colab
↓
Pandas Analysis
↓
Charts & Insights
This works well during the research phase.
However, when the analysis needs to serve real users, new challenges emerge.
Organizations often need:
Authentication
APIs
Databases
Scheduled processing
Dashboards
Deployment
Monitoring
These requirements extend beyond the scope of a notebook environment.
Where I Fit In
I'm a Fullstack Developer with a strong interest in backend systems, databases, and deployment infrastructure.
Rather than focusing solely on data analysis itself, I'm interested in helping transform analytical workflows into production-ready applications.
My work typically involves:
Backend API development
PostgreSQL database design
VPS deployment
Infrastructure setup
System integration
Analytics integration
In other words:
Data analysts generate insights. I help make those insights accessible through applications.
From Notebook to Application
A common evolution of a project looks like this:
Google Colab
↓
Python Script
↓
Backend API
↓
PostgreSQL
↓
Frontend Dashboard
↓
Production Deployment
At this stage, the analysis is no longer limited to the notebook author.
The results become available to:
Business owners
Managers
Sales teams
Customers
Mobile applications
External systems
This transformation is where software engineering creates additional business value.
An Experiment: Express Pandas Analytics
To explore this idea, I built a small project that combines web development and data analytics concepts.
Live Demo
Source Code
express-pandas-analytics on GitHub
The goal is straightforward:
Process analytical data using Python and Pandas.
Expose results through web APIs.
Make analytics accessible to web applications and dashboards.
Instead of keeping analysis locked inside notebooks, the results can be consumed by other systems.
Why This Matters
Many businesses already collect large amounts of data.
The challenge is rarely data collection.
The challenge is turning data into information that can be used for decision-making.
A report that exists only inside a notebook has limited reach.
A report that can be accessed through APIs, dashboards, and applications can support daily operations across an organization.
This is one of the reasons I'm interested in the intersection of:
Software Engineering
Backend Development
Data Analytics
Deployment Infrastructure
Technologies I Enjoy Working With
Backend Development
Node.js
JavaScript (ESM)
Express
Hono
Databases
PostgreSQL
Drizzle ORM
Analytics
Python
Pandas
Google Colab
Infrastructure
Linux VPS
Nginx
SSL
Self-hosted services
What I'm Exploring
I'm currently learning more about:
Data analytics workflows
Business reporting systems
Analytics APIs
Data processing pipelines
Production deployment for analytical applications
My goal is not only to build software that stores data, but also to help make that data useful and accessible.
Let's Connect
I'm always interested in connecting with:
Developers
Data Analysts
Startup Founders
Product Teams
Small Business Owners
Especially those working on projects that combine:
Web applications
Backend systems
PostgreSQL
Analytics workflows
Data-driven decision making
If you're building analytical solutions in Google Colab and looking for ways to bring them into production environments, I'd love to exchange ideas and learn from your experience.
Because the journey doesn't end when an analysis is completed.
Often, that's where the real work begins.
