SALES COMMAND CENTER

Sales Performance Intelligence

Analisis transaksi aktual dari dataset aktif Anda.

DATA COVERAGE1 Agu – 5 Agu 2026
SAMPLE BAWAAN AKTIFcontoh sample sales(1).xlsx

Sheet Data · 1.685 baris tervalidasi

TRANSAKSI627558 paid units
PRIVASI DATADiproses lokalTidak dikirim ke server
Global slicersSemua visual mengikuti filter ini
DATA AKTUAL1 Agu – 5 Agu 20261.685 baris dalam scope
Source: contoh sample sales(1).xlsx
01
Net SalesRp1,11 M
◆ Actual627 transaksiLIVE
02
Gross ProfitRp803,13 Jt
◆ ActualGPM 72,1%LIVE
03
Transaksi627
◆ ActualATV Rp1,8 JtLIVE
04
Unit Berbayar558
◆ Actual398 unit jamLIVE
05
Gross Margin72,1%
◆ ActualCost coverage 78,8%LIVE
06
Discount Rate23,1%
◆ ActualRp333,6 JtLIVE
PERFORMANCE SIGNAL

Net Sales Trend

Klik titik tanggal untuk cross-filter seluruh dashboard

TOTAL SELECTED RANGERp1,1 M627 transaksi terfilter
Periode aktifHari sebelumnya
Hari sebelumnya: histori belum lengkap4 dari 5 titik pembanding tersedia pada dataset aktif. Pilihan akan otomatis terisi jika tanggal historis yang sesuai ikut diimpor.
Rp360,1 JtRp270,1 JtRp180,1 JtRp90 JtRp01 Agu2 Agu3 Agu4 Agu5 Agu5 AguRp141 Jt
Rata-rata per hariRp222,7 Jt
Hari tertinggi1 Agu · Rp321,5 Jt
Data coverage5 hari aktual
PORTFOLIO PERFORMANCE

Brand Contribution

Hanya baris berbayar; klik brand untuk cross-filter

CHANNEL MIX

Sales Distribution

Klik channel untuk cross-filter

NET SALESRp1,1 M627 transaksi
TOP OUTLETGrand IndonesiaRp121,1 Jt
PEAK TRADING18–20 WIB30,2% sales mix
TOP SALES ADVISORAulia MaulidaRp73,3 Jt
AVERAGE TICKETRp1,8 Jt558 unit berbayar
OUTLET PERFORMANCE

Outlet Leaderboard

Klik baris untuk memfilter seluruh dashboard

OUTLET AKTIF36dengan penjualan
TOP SHARE10,9%Grand Indonesia
ONLINE SALES15,3%Rp170,4 Jt
#Outlet / RegisterChannelTxnPaid UnitNet SalesGPM*Disc.
01Grand IndonesiaOffline / Outlet4241Rp121,1 Jt77,8%11,7%
02Pondok Indah Mall 2Offline / Outlet3635Rp100,6 Jt75,5%16,8%
03WebsiteWebsite2426Rp70,7 Jt70,2%14,4%
0423 PaskalOffline / Outlet3027Rp55,9 Jt68,2%22,8%
05ShopeeShopee2123Rp51,5 Jt61,6%22%
06Sun Plaza MedanOffline / Outlet2525Rp50,5 Jt76,1%17,8%
07ShopeeShopee1919Rp48,2 Jt64,9%27,9%
08Living World BaliOffline / Outlet2220Rp48,1 Jt74,5%19,4%
09Summarecon Mall BekasiOffline / Outlet2115Rp45 Jt83%23%
10Centre Point MedanOffline / Outlet2320Rp44,4 Jt77%20,8%
11DP Mall SemarangOffline / Outlet1315Rp38 Jt79,4%17,7%
12Central Park2Offline / Outlet2118Rp37,4 Jt81,1%23,9%
13Lippo Mall PuriOffline / Outlet2716Rp36,4 Jt70,8%22,6%
14Summarecon Mall SerpongOffline / Outlet2421Rp34,3 Jt60,3%34,8%

*GPM mengikuti cost pada file sumber. Nilai dengan cost coverage rendah perlu divalidasi.

PROMOTION EFFICIENCY

Discount vs Margin

Paid lines only · klik bucket untuk cross-filter

GROSS SALESRp1,4 M
−
DISCOUNTRp333,6 Jt
=
NET SALESRp1,1 M

Bucket >40% menghasilkan Rp81,9 Jt sales dengan GPM* 47,8%. Gunakan bersama cost coverage sebelum memutuskan promo.

PRODUCT INTELLIGENCE

SKU Performance Explorer

235 SKU dalam scope · baris berbayar

#ProductBrand / TypeQtyNet SalesDiscountGP*Cost
01Classic Mini Grove Rose Gold & Cherry Croc Leather Strap 16mm24000285Olivia BurtonWatch38Rp125,4 JtRp0Rp93,7 JtCovered
02Soft Square Earl Grey Dial with North Star Details 5 Link Bracelet 20mm24000256Olivia BurtonWatch19Rp41,4 JtRp25,3 JtRp23,7 JtCovered
03Classic Grosvenor White & Two Tone Bracelet 28mm24000125Olivia BurtonWatch9Rp26,7 JtRp3 JtRp19,2 JtCovered
04Modern Classic Mini Grosvenor Ivory Sunray Dial, SS/GP Case, Two Tone SS/GP Bracelet - 20mm24000365Olivia BurtonWatch7Rp20,8 JtRp2,3 JtRp15,1 JtCovered
05SWR110P1SWR110P1SeikoWatch5Rp19,5 JtRp4,4 JtRp19,5 JtMissing
06Rectangle White & Carnation Gold Bracelet 21mm24000014Olivia BurtonWatch8Rp16,7 JtRp10,6 JtRp8,8 JtCovered
07Quadro Mini Amber Arch 3-Link Amber Sunray Rose Gold (15.4x18.2)DW00100849Daniel WellingtonWatch6Rp16,1 JtRp9,4 JtRp9,4 JtCovered
08SWR108P1SWR108P1SeikoWatch4Rp15,6 JtRp3,5 JtRp15,6 JtMissing
09Breda Jane Tethered Small 1757A Champagne MOP Dial Gold Mesh 18 mm1757ABredaWatch5Rp15,4 JtRp2,9 JtRp6,8 JtCovered
10Ophelia Mini Beans Link Two-Tone White Gold Silver (25.5x22)DW00100811Daniel WellingtonWatch4Rp14,5 JtRp2,6 JtRp10,2 JtCovered
11Signature Snake JC1L390 Silver Silver - 22 x 31mm Single RoundJC1L390M0015Just CavalliWatch4Rp14 JtRp0Rp10,5 JtCovered
12Seiko SSB345P1 Quartz Men Black Dial Silver Bracelet 43.9mmSSB345P1SeikoWatch3Rp14 JtRp1,1 JtRp14 JtMissing
13Juliette White Braided Mesh Sunray Rose Gold (23x31)DW00100883Daniel WellingtonWatch6Rp13,7 JtRp8,5 JtRp7,9 JtCovered
14Signature Snake JC1L357 Silver Silver - 25 x 39mm Single RoundJC1L357M0015Just CavalliWatch4Rp13,2 JtRp0Rp9,8 JtCovered
15Mini Grove Rose Gold Bracelet 16mm24000283Olivia BurtonWatch4Rp12,6 JtRp1,4 JtRp9,1 JtCovered
PEOPLE PERFORMANCE

Sales Advisor Ranking

API User dipisahkan dari advisor manusia

TRADING RHYTHM

Sales Heatmap

Hari × jam transaksi · klik sel untuk cross-filter

PEAK WINDOW18–20 WIB
DAY / TIME09–1112–1415–1718–2021+
Sab
Min
Sen
Sel
Rab
DATA GOVERNANCE

Data Health & Audit

Kontrol kualitas untuk interpretasi yang defensible

78,8%COST
PERIOD COVERAGE5 hari aktual

1 Agu 2026 – 5 Agu 2026; pembanding membutuhkan tanggal historis yang sesuai.

MISSING COSTRp236,4 Jt

Sales bernilai positif dengan cost nol; GPM* masih bersifat provisional.

ZERO-VALUE LINES1.130 baris

Packaging, GWP, card, dan service; cost Rp5,6 Jt tetap masuk GP.

SERIAL COMPLETENESS297 / 1.685

1.388 baris tidak memiliki serial pada file sumber.

✓

Status & required keys1.685 / 1.685 baris Completed dimuat · 1.685 baris sumber

PASS
✓

Sales vs Sales Inc Tax0 baris tidak reconcile

PASS
✓

Gross Profit formula0 mismatch terhadap Sales − Cost

PASS
!

Cost completeness78,8% dari nilai sales memiliki cost

REVIEW
METRIC CONTRACT

Definisi KPI

Supaya angka dashboard dibaca konsisten

Bundle dihitung sebagai watch
01

Net SalesΣ Sales setelah unit discount

02

Gross SalesNet Sales + Unit Discount × Qty

03

Discount RateDiscount ÷ Gross Sales

04

Gross Profit*Σ (Sales − Cost), termasuk cost baris nol-sales

05

Gross Margin*Gross Profit ÷ Net Sales

06

Paid UnitsΣ Qty hanya untuk baris dengan Sales > 0

07

Watch UnitsPaid Units untuk Type Watch + Bundle

08

TransactionsDistinct Sales Ref Code