I turn messy data into actionable decisions using Python, SQL, and BI dashboards across financial and enterprise data.
↗ Reduced manual portfolio updates and improved content consistency across all projects.
A web-based portfolio management system with an admin dashboard to manage projects, links, and highlights in one place. Built to replace manual editing and improve efficiency.
Comprehensive presentation deck covering churn prediction model evaluation, algorithm comparison, and actionable business insights.
Built and evaluated predictive models to identify customers at risk of churning. Compared multiple ML algorithms with business insights.
Presentation deck for credit scoring model using ML classification algorithms. Covers model evaluation and business recommendations.
Potential customer segmentation using K-Means clustering. Enabled targeted marketing strategy and improved campaign conversion potential.
Presentation deck covering optimized bikeshare strategy for H2 2018 with data exploration and visualization.
SQL query documentation for Bikeshare Trip analysis — covering data exploration, aggregation, and visualization prep.
Interactive Looker Studio dashboard for TheLook eCommerce — visualizing sales trends, product performance, and customer behavior.
SQL-based operational analysis for caller and agent data — performance metrics and efficiency insights.
Improved v2.0 dashboard for Bikeshare Trip Analysis in San Francisco with deeper trip pattern exploration.
Business Requirements Document for enhancement project — Bikeshare Trip Analysis H2 2018 version 2.0.
Interactive Looker Studio dashboard visualizing Superstore sales, profit, and regional performance metrics end-to-end.
Analyzed customer behavior and operational efficiency in NYC food delivery data. Identified peak hours, bottlenecks, and revenue optimization opportunities.
Analyzed member activity and event participation patterns using Python. Surfaced engagement drop-off points and recommended retention strategies.
Case study on business development. Built sales performance dashboard tracking KPIs and revenue metrics.
Python-based user retention analysis on Superstore dataset using Google Colaboratory. Identified churn signals and retention drivers.
Exploratory data analysis on TheLook eCommerce dataset using Python and Google Colab.
Deep data insights from TheLook eCommerce dataset. Uncovered trends and patterns in customer behavior and revenue.
Data insights from TheLook eCommerce uncovering revenue trends, product performance gaps, and customer behavior patterns.
Dynamic Power BI dashboard tracking pizza sales performance — revenue, order volume, product mix, and time-series trends.
Business Requirements Document and full presentation deck covering Superstore dashboard, Looker Studio, and SQL BigQuery analysis.
Marketing analysis deck using SQL BigQuery and Looker Studio. Applied ANOVA and regression to evaluate campaign effectiveness across segments.
Presentation deck for Superstore user retention analysis built with Python and Google Colaboratory.
Led a cross-functional team to build Looker Studio dashboard analyzing San Francisco bikeshare trips for H2 2018 strategy.
Team lead presentation deck with insights and strategic recommendations for Bikeshare Trip Analysis H2 2018.
Business Requirements Document for Bikeshare Trip Analysis in San Francisco — strategy for the second half of 2018.
SQL documentation and query scripts for Dataset Superstore — covering data exploration, transformation, and analysis.
SQL Business Intelligence documentation covering queries, data models, and analytical frameworks.
SQL queries and analysis for business development case study — covering sales, revenue, and operational metrics.
Sales analytics dashboard built in Excel tracking revenue, volume, and performance trends.
Operational data analysis for caller and agent performance using Excel and SQL.
Excel-based sales analysis case study covering product performance, regional trends, and revenue insights.
Business development case study analysis using Excel — covering sales pipeline, conversion rates, and growth opportunities.
Have a question or want to collaborate? Send Ade Desfrianto a message and get a reply within 24 hours.