Jamie Tran
Turning business data into clear reports & insights
New to Contra
Jamie is building their profile!
Telecom Customer Churn Analysis
Python • Pandas • Matplotlib • Jupyter Notebook
Overview
Cleaned and analyzed customer-level telecom data to identify patterns associated with customer churn across contracts, tenure, pricing, service adoption, and reported churn reasons.
What I...
Used PostgreSQL to answer five defined business questions from an e-commerce database covering product performance, geographic revenue, repeat customers, seller performance, and delivery time. Each question was translated into a focused SQL query with the corresponding result and a clear, factual answer.
Developed an interactive one-page Power BI dashboard for monitoring retail sales performance. The report combines key KPIs with monthly trends and analysis across product categories, regions, customer segments, top products, and geographic markets. Interactive filtering allows...
Built a one-page Excel dashboard to turn structured retail sales data into a clear management reporting tool. The dashboard provides key performance metrics including sales, profit, order volume, and profit margin, alongside monthly trends and analysis by product category,...
Cleaned and standardized a messy customer transaction dataset using Excel and Power Query. The project included correcting inconsistent text and category values, standardizing dates and phone numbers, converting order amounts into usable numeric data, handling missing values,...
