Jamie Tran

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,...