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
Project description.
Source: Sybase storing operational business data.
Orchestration: Airflow automated scheduled DAGs for extraction, loading, dependency handling, monitoring, and logging into PostgreSQL.
Transformation: dbt applied SQL-based modeling, data cleaning, testing, documentation, and created analytics-ready fact and dimension tables.
Visualization: Power BI dashboards built directly on transformed warehouse data.
Outcome: Fully automated, scalable, and reliable ELT reporting system enabling faster insights and reduced manual effort.
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
Related posts
Sentiment-Driven E-commerce Optimization: Amazon Review Analysis & Rating Prediction.
Project Overview ✅
This project serves as a machine learning proof of concept designed to transform raw Amazon product reviews into actionable business insights. By automating the prediction of review ratings and analyzing customer sentiment, the system enables brands to optimize product listings, proactively address customer pain points, and drive higher conversion rates.
Process ✅
I developed an end-to-end pipeline covering data acquisition, complex text processing, and model deployment. Automated Data Scraping, Integrated the Apify API to extract real-time customer feedback directly from Amazon product URLs. I configured the scraper to handle up to 100 reviews per run, capturing critical metadata including rating scores, review descriptions, and verified purchase status.
Data Refinement & Feature Engineering:
Cleaned a dataset of approximately 1,944 reviews by removing noise (punctuation/symbols) and stop words using NLTK. I implemented TF-IDF Vectorization to convert text into numerical features and applied SMOTE (Synthetic Minority Over-sampling Technique) to address class imbalance, ensuring the model could accurately predict rare negative reviews.
Model Benchmarking ✅
Developed and compared three distinct architectures to identify the most robust predictor:
Naive Bayes: High-speed probabilistic classification.
Support Vector Classifier (SVC): Optimized for high-dimensional text data.
Neural Network (MLPClassifier): To capture complex semantic patterns.
Web App Deployment: Built a dedicated Streamlit dashboard that allows non-technical stakeholders to input raw review text and receive instant rating predictions with confidence scores.
Technical Stack✅
Languages & Tools: Python, Apify Client.
ML & NLP Libraries: Scikit-learn (SVC, Naive Bayes, MLP), NLTK (Tokenization, Stopwords), Imbalanced-learn (SMOTE).
Deployment: Streamlit, Joblib (Model Serialization).
Visualization: Plotly, WordCloud, Matplotlib.
Key Results ✅
Achieved a peak accuracy of 95.27% using the Neural Network model, with the SVC model following closely at 94.46%.
Developed sentiment-based feedback loops within the app: high ratings (4-5 stars) trigger positive marketing recommendations, while low ratings (1-2 stars) alert teams to address product issues like battery life or build quality.
Enabled real-time competitive analysis by providing a user-friendly interface for cross-functional marketing and product development teams to audit customer sentiment at scale.
dashboardPythonmachinelearningMachine Learning EngineeringData AnalysisData VisualizationApifyStreamlit
Interesting
Just finished working on Quant — a modern finance dashboard designed to give users a clear, real-time overview of their income and expenses.
Focused on clean UI, strong UX, and making financial data simple and intuitive to understand. The goal wasn’t just to design something that looks good, but something that actually helps users make better decisions.
Curious to hear your thoughts 👀
Great work.
Trending
Notion
Notion isn’t just where you work, it’s starting to work for you. What agents are you building?
portfolioreview
The best portfolios tell a story, not just show a grid. Share yours for feedback.
brandguidelines
Brand guidelines are becoming living systems, not static documents. What are you building for your clients?
aivideo
AI video tools are moving at warp speed. Which ones are you experimenting with?
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?