DataPebble

Free Portfolio Projects

Real work, free to explore

Every project detail is open — no payment, login, subscription, or email required. Each project lists what it shows, the tools used, and its honest limitations.

Project 1 · Completed portfolio project

E-commerce Sales & Delivery Analytics

Brazilian e-commerce data analyzed with Python, SQL, and Power BI.

This portfolio project uses a public historical Brazilian e-commerce dataset to demonstrate how raw order, customer, product, and review data can be transformed into reporting-ready datasets and interactive business dashboards.

Workflow

  1. Public CSV datasets
  2. Python/pandas ETL
  3. Validation & reconciliation
  4. SQLite & processed CSVs
  5. Power BI dashboards
Illustrative DataPebble Power BI design with Page 1 · Sales Overview and Page 2 · Product & Delivery Performance side by side. BRL sales, sales trend, date filtering, category sales, delivery KPIs and a state summary; unknown values omitted.
Illustrative report design, not a verified Power BI screenshot. Charts and state/category labels are placeholders; unverified KPI values are omitted.View full-size preview ↗

Page 1 · Sales Overview

  • Total sales value
  • Total orders
  • Average order value
  • Units sold
  • Daily sales trend
  • Date filtering

Page 2 · Product & Delivery Performance

  • Product-category sales
  • Average delivery days
  • Late delivery rate
  • Average review score
  • State-level delivery performance

Verified project facts

  • The processed daily sales table contains 612 rows.
  • The product performance table contains 72 rows.
  • The delivery performance table contains 27 rows.
  • Daily sales and product-category sales reconcile to approximately BRL 13.22 million.
  • The ETL validation script passed its current checks for null counts and sales reconciliation.

A successful reconciliation does not prove every transformation is error-free; this is not a complete production-grade audit.

Questions the project is designed to explore

  • How sales change over time.
  • Which product categories contribute most to sales.
  • How delivery performance varies by customer state.
  • How delivery performance relates to customer review scores.

Technologies

PythonpandasSQL / SQLitePower BIDAXCSV data processing and validation

Limitations

  • The dataset is historical and represents Brazilian e-commerce, not a live client integration.
  • Monetary amounts are in Brazilian reais (BRL).
  • The sales measure represents item sales value and does not establish profit or net revenue after refunds and other adjustments.
  • This demo does not prove a live, scheduled cloud pipeline.
  • Raw dataset files are not redistributed on this website.

A public dashboard link will be added here once published.

Project 2 · Completed portfolio project

Data Doctor — Supermarket Data Intelligence

A completed project helping small supermarkets understand sales and plan inventory.

Data Doctor is a portfolio project exploring how data from existing supermarket billing software can be transformed into useful business insights without replacing the store’s existing billing system.

Architecture

  1. Tally Prime
  2. Python Sync Agent
  3. Amazon S3
  4. Amazon SQS
  5. AWS Lambda
  6. Neon PostgreSQL
  7. FastAPI
  8. Streamlit

App screens

Data Doctor Live Dashboard screenLive DashboardData Doctor Money Leakage screenMoney LeakageData Doctor Dead Stock screenDead StockData Doctor Reorder Planner screenReorder PlannerData Doctor Profit & Margin screenProfit & Margin
Data Doctor app screens shown with demo data. Click any screen to view full size.

Use cases

  • Product and category sales analysis
  • Revenue trends
  • Distributor purchase-order support
  • Restocking recommendations
  • Next-day demand prediction
  • Near-expiry product bundling

Technologies

PythonTally Prime integrationAWS S3AWS SQSAWS LambdaPostgreSQL / NeonFastAPIStreamlit

Limitations

  • Screenshots use demo data, not a live client store.
  • No live demo is currently published.
  • No customers, performance statistics, or measured business results are claimed.

Let’s make your reporting simpler.

Tell us about your data sources, reporting challenges, and business goals. We’ll discuss whether DataPebble is a good fit for your needs.

Book a Free Discovery CallExplore Free Projects