This project is a work in progress portfolio piece built to demonstrate my data engineering skills by solving a real business problem using modern tools and best practices.
The goal is to ingest, process, and analyze sales data from the Loyverse API using Python and pandas, enabling better reporting and insight generation for a small business.
The project has a real-world use case: helping a small business streamline and analyze their point-of-sale data. While it’s based on an actual business, the repository is designed to showcase general-purpose data engineering and software practices.
- OAuth integration with Loyverse API
- Paginated receipt data ingestion
- Output as pandas DataFrames
- Tests with
pytestand mocking - Security-conscious token management
- Extensible for monthly data refresh and reporting
- Python 3.12
httpxfor API communicationpandasfor data handlingpytestfor testingrufffor lintinguvfor dependency management
- Flattening and enriching data for reporting
- Visualization layer
- Dockerized local PostgreSQL (optional)
I'm a data engineer passionate about solving practical problems with clean, testable code and modern tooling. This repo is one example of my work — check out the issues and commits for how I think and build.
This project was created to generate sales reports for Anahaw(https://instagram.com/anahawdauin) (my wife's business) using data from the Loyverse POS system.
...
This project uses live data from anahawdauin.com, a yoga studio and plant-based restaurant & bar in the Philippines.