Shopee Thailand Analytics

A simulated Shopee Thailand marketplace dataset is used as a portfolio case to explore executive-level commercial and operational questions.

Problem

Operational marketplace records need a legible model for connecting sales trends, customer retention, campaign activity and courier performance.

Operational impact

Turns separate commercial and logistics questions into a shared analytical model for clearer review of sales, retention, campaigns and delivery.

Constraints

• The README describes a simulated 300,000-order case; this is not Shopee internal/client data.
• The public repository has no committed PBIX, automated tests, CI workflow or licence file.

SQL analysis modules and a documented Power BI/DAX model for examining sales, customer behavior, campaigns and delivery performance.

Inputs

• Simulated orders
• customers
• products
• campaigns
• shipments
• reviews

Implementation

• Documented star schema centered on marketplace orders.
• SQL modules for sales performance, customer segmentation, campaign effectiveness and logistics performance.
• README-documented DAX calculations for segmentation, YoY and repeat rate.
• MySQL-style SQL analysis
• Documented Power BI/DAX semantic-model logic

• Separate commercial and logistics questionsRevenue, retention, campaign and courier questions require different operational views of the same modeled data.

Evidence classes distinguish what can be inspected directly from what is documented, simulated or reconstructed.

• VERIFIED CODE
  Sales-performance SQL module

  sql/01_sales_performance.sql

• VERIFIED ARTIFACT
  Sales, customer and data-model screenshots

  insights/screenshots/

• README REPORTED
  Dataset scope and documented model

  README.md

• SIMULATED
  Marketplace case-study dataset

  README.md

• กรณีศึกษานี้ใช้ข้อมูลจำลอง; displayed figures are not Shopee or client internal results.
• README-reported figures are not presented as independently reproduced outcomes.