Realtime E-Commerce Data Pipeline ● Built an end-to-end streaming pipeline ingesting live e-comme...

Realtime E-Commerce Data Pipeline ● Built an end-to-end streaming pipeline ingesting live e-comme...Realtime E-Commerce Data Pipeline ● Built an end-to-end streaming pipeline ingesting live e-comme...

The network for creativity

Join 1.25M professional creatives like you

Connect with clients, get discovered, and run your business 100% commission-free

Creatives on Contra have earned over $150M and we are just getting started

Back to feedPost

ABDELKADER ANMIRA

• 2d

Realtime E-Commerce Data Pipeline

● Built an end-to-end streaming pipeline ingesting live e-commerce events into Snowflake via Kafka, Airflow, and a Python consumer with upsert logic. ● Modeled a dbt Star Schema and designed a Power BI dashboard with 12+ DAX measures for churn, retention, and revenue analysis.

Data Analysis Web Scraping Apache Airflow dbt Microsoft Power BI Data Engineering

Julian Vance

• Jul 21

I built a small data-cleaning workflow around one simple rule: bad rows should never silently disappear.

Synthetic demo results:

• 20 raw order records • 16 clean rows • 2 duplicates removed • 2 invalid rows quarantined • $3,690 paid revenue reconciled

The output includes a clean CSV, a rejected-row file, an audit log, and an Excel dashboard. Dates, names, emails, regions, products, and payment statuses are standardized.

The key design choice is quarantine + reasons, not just dropping bad rows and exporting. That lets a reviewer trace exactly what changed and decide whether rejected records should be repaired.

Portfolio: https://contra.com/p/WPLXml6R-demo-automated-sales-data-cleaning-and-excel-reporting

For recurring exports, what needs the most manual review in your workflow: duplicates, inconsistent labels, or invalid amounts and dates?

Data Analysis Microsoft Excel Python

Srujana Reddy

• Jul 21

Title: 💳 Customer Churn Analysis Dashboard

Description:

Built an interactive Customer Churn Analysis Dashboard to identify customer churn patterns, retention trends, churn risk, customer lifetime value, and key factors influencing customer attrition. Designed dynamic KPI cards, predictive insights, and interactive visualizations using Microsoft Excel, SQL, and Power BI to help businesses improve customer retention, reduce churn, and make data-driven decisions.

Business Analysis Data Analysis Microsoft Excel SQL Microsoft Power BI

Srujana Reddy

• Jul 20

Title:

📊 AI-Powered Customer Behavior Analysis Dashboard

Description:

Built an interactive Business Intelligence dashboard to analyze customer behavior, sales performance, customer segmentation, revenue trends, KPIs, and AI-driven business insights using Excel, SQL, Power BI, and Tableau.

Business Analysis Data Analysis Microsoft Excel Microsoft Power BI SQL