Orbit Q / Data, BI & Automation Systems

Data systems / BI / automation

I turn messy operational data into systems people can actually use.

เปลี่ยนข้อมูลกระจัดกระจาย ให้เป็นระบบที่ตรวจสอบและใช้งานได้จริง

Selected work across reporting models, data pipelines and focused internal tools—shown with evidence, boundaries and the decisions behind them.

View the full work indexHow to work with me
01DATAmessy source exports
02MODELone legible structure
03DECISIONmeasures and rules
04HANDOVERtests and docs
4
case studies, each a public repository
8
evidence grades applied to every claim
100%
displayed claims linked to their source
0
trackers, cookies or third-party scripts

Verified stack

01–02

Selected systems

Two entry points. Full evidence register on the work index.

01 / Case study

Simulated / demonstration scope

Multi‑Channel E‑commerce Sales Pipeline

หนึ่ง dashboard จาก marketplace exports ที่ไม่เหมือนกัน

Power Query/M pipeline and Power BI model for aligning Shopee, Lazada and advertising exports into one inspectable reporting layer.

Operational impact

Creates one comparable reporting layer so a team can inspect channel performance, payout and advertising signals without stitching exports by hand.

  • Power Query/M
  • Power BI
  • DAX
  • CSV
  • Power BI reporting
  • Power Query data cleaning
  • E-commerce reporting
Inspect projectGitHub source
Power BI e-commerce dashboard showing marketplace filters, reporting KPIs and charts.
Committed project artifact. Figures are demonstration data.

02 / Simulated case study

Simulated / demonstration scope

Shopee Thailand Analytics

Marketplace analytics for sales, customers, campaigns and delivery

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

Operational impact

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

  • SQL
  • Power BI
  • DAX
  • Star schema
  • SQL analytics
  • Power BI dashboard
  • E-commerce sales analysis
Inspect projectGitHub source
Shopee analytics sales performance dashboard with filters and revenue trend charts.
Committed case-study screenshot using simulated data.

More systems, experimental work and their evidence boundaries are kept in the full index.

Explore all work
01 / Trace

Start with the source.

Each material claim points back to code, tests, documentation or a committed artifact.

02 / Model

Make the system legible.

Inputs, transformations, decisions and outputs are separated so the work can be inspected.

03 / Bound

State what is not proven.

Simulation, reconstruction and implementation limits remain visible instead of becoming marketing claims.