Download - sharing kuadran
![Page 1: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/1.jpg)
QUADRANT ANALYSIS
SEBAGAI ALAT PERUMUSAN STRATEGI
Dian Srirezeki24 Juni 2014
![Page 2: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/2.jpg)
AGENDA
2
1
STEP BY STEP : SCATTERPLOT QUADRANT
ANALISA KUADRAN
3 ANALISA QUADRANT DENGAN FUNGSI IF
![Page 3: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/3.jpg)
AGENDA
2
1
STEP BY STEP : SCATTERPLOT QUADRANT
ANALISA KUADRAN
3 ANALISA QUADRANT DENGAN FUNGSI IF
![Page 4: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/4.jpg)
4
![Page 5: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/5.jpg)
5
![Page 6: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/6.jpg)
6
![Page 7: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/7.jpg)
7
Learn to use data visualitation
to present complex information
simply, elegantly and
beautifully
![Page 8: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/8.jpg)
ANALISA KUADRAN
Sebagai navigasi/pemandu
dalam memahami posisi
produk dengan cepat dan
tepat.
Plotting data dapat
ditransformasikan sesuai
kapabilitas internal dan
digunakan untuk membuat
strategi serta action yang
efektif.
8
![Page 9: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/9.jpg)
MEMAHAMI DATA …..
9
LOKASI ATM UNIT ATM TRN/ATM FBI/ATM
PESANTREN 7 6,015 4,506,014
PERTOKOAN 7 2,089 3,945,414
MINIMARKET 3 1,459 3,673,567
INDUSTRI 22 3,479 3,563,227
KANTOR POS 1 1,169 3,526,000
SPBU 18 1,874 3,276,906
RUMAH MAKAN 1 1,027 3,043,500
MALL 13 1,743 2,805,992
CABANG 731 3,227 2,786,503
SUPERMARKET 5 1,719 2,419,920
SEKOLAH/UNIVERSITAS 30 2,030 2,229,687
RUMAH SAKIT 30 1,480 2,135,823
PASAR 2 1,340 2,023,300
PERKANTORAN 6 2,481 1,925,783
APOTIK 5 1,112 1,813,960
HOTEL 5 1,296 1,706,380
BPR/ BANK LAIN 7 888 1,585,343
TEMPAT UMUM/ WISATA/
OLAHRAGA6 656 1,293,717
PEMERINTAHAN DAERAH 10 553 811,890
MOBIL ATM 9 95 63,967
KANWIL UNIT ATMTransaksi /ATM
(X)
FBI/ATM
(Y)
I 2013,724 3,446,981
II 226 2,889 2,293,819
III 274 2,835 2,509,460
IV 108 1,872 1,576,353
V 109 3,071 3,874,081
![Page 10: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/10.jpg)
AGENDA
2
1
STEP BY STEP : SCATTERPLOT QUADRANT
ANALISA KUADRAN
3 ANALISA QUADRANT DENGAN FUNGSI IF
![Page 11: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/11.jpg)
STEP BY STEP : SCATTERPLOT QUADRANT (1)
11
1. Sort Data, Insert Scatter
![Page 12: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/12.jpg)
STEP BY STEP : SCATTERPLOT QUADRANT (2)
12
2. Atur Layout dan Format Data Series
3. Input Titik Potong dalam Scatter
- Klik Scatter
- Add data series baru (X dan Y)
![Page 13: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/13.jpg)
STEP BY STEP : SCATTERPLOT QUADRANT (3)
13
Apotik
BPR
Cabang
Hotel
Industri
Kantor Pos
Mall
Mini Market
Mobil ATM
Pasar
Pemerintahan Daerah
Perkantoran
Pertokoan
Pesantren
Rumah Makan
Rumah Sakit Sekolah/Univ
SPBU
Super Market
Tempat Umum
-
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
- 1,000 2,000 3,000 4,000 5,000 6,000 7,000 8,000
-
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
- 2,000 4,000 6,000 8,000
4. Ubah Format Data Series titik potong X dan Y
- Klik Data Series (salah satu titik potong)
- Klik kanan, Format Data Series
- Marker Options : None
- Line Color : Solid Line
- Line Style : Dash Type
- Beri Label Data (manual untuk Office dibawah 2010)
![Page 14: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/14.jpg)
MAPPING PERFORMA ATM BSM BERDASARKAN LOKASI
APRIL 2014
14
Note :
ATM yang memiliki Total transaksi/ATM tertinggi adalah Pesantren.
ATM yang memiliki Total transaksi/ATM terendah adalah Mobil ATM.
ATM yang memiliki FBI/ATM tertinggi adalah Pesantren.
ATM yang memiliki FBI/ATM terendah adalah Mobil ATM.
Transaksi ATM (X)
FBI (Y)
( 2,958 ; 2,713,899)
918 ATM
LOKASI ATM UNIT ATM TRN/ATM FBI/ATM
PESANTREN 7 6,015 4,506,014
PERTOKOAN 7 2,089 3,945,414
MINIMARKET 3 1,459 3,673,567
INDUSTRI 22 3,479 3,563,227
KANTOR POS 1 1,169 3,526,000
SPBU 18 1,874 3,276,906
RUMAH MAKAN 1 1,027 3,043,500
MALL 13 1,743 2,805,992
CABANG 731 3,227 2,786,503
SUPERMARKET 5 1,719 2,419,920
SEKOLAH/UNIVERSIT
AS30 2,030
2,229,687
RUMAH SAKIT 30 1,480 2,135,823
PASAR 2 1,340 2,023,300
PERKANTORAN 6 2,481 1,925,783
APOTIK 5 1,112 1,813,960
HOTEL 5 1,296 1,706,380
BPR/ BANK LAIN 7 888 1,585,343
TEMPAT UMUM/
WISATA/ OLAHRAGA6 656
1,293,717
PEMERINTAHAN
DAERAH10 553
811,890
MOBIL ATM 9 95 63,967
Apotik
BPR
Cabang
Hotel
Industri
Kantor Pos
Mall
Mini Market
Mobil ATM
Pasar
Pemerintahan Daerah
Perkantoran
Pertokoan
Pesantren
Rumah Makan
Rumah Sakit Sekolah/Univ
SPBU
Super Market
Tempat Umum
-
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
- 1,000 2,000 3,000 4,000 5,000 6,000 7,000 8,000
![Page 15: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/15.jpg)
MAPPING PERFORMA ATM per KANWIL APRIL 2014
15
Transaksi ATM (X)
FBI (Y)
KANWIL UNIT ATMTransaksi /ATM
(X)
FBI/ATM
(Y)
I 2013,724 3,446,981
II 226 2,889 2,293,819
III 274 2,835 2,509,460
IV 108 1,872 1,576,353
V 109 3,071 3,874,081
( 2,958 ; 2,713,899)
918 ATM
I
II
III
IV
V
-
500,000
1,000,000
1,500,000
2,000,000
2,500,000
3,000,000
3,500,000
4,000,000
4,500,000
5,000,000
- 500 1,000 1,500 2,000 2,500 3,000 3,500 4,000
![Page 16: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/16.jpg)
AGENDA
2
1
STEP BY STEP : SCATTERPLOT QUADRANT
ANALISA KUADRAN
3 ANALISA QUADRANT DENGAN FUNGSI IF
![Page 17: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/17.jpg)
ANALISA QUADRANT DENGAN MENGGUNAKAN FUNGSI IF
MAPPING AVAILABILITY DAN FBI ATM APRIL 2014
17
92.68%
Kuadran I II III IV TOTAL
KANWIL 1 78 14 75 34 201
KANWIL 2 57 13 136 20 226
KANWIL 3 71 24 141 38 274
KANWIL 4 9 82 17 108
KANWIL 5 40 7 43 19 109
TOTAL 255 58 477 128 918
AVAILABILITY ATM
Availability
12814%
47752%
IV III
I
586%
25528%
FBI ATM
2,713,899
FB
I A
TM
II
=IF(AND(O3>=$O$921,I3>=$I$921),"I",IF(AND(O3<$O$9
21,I3>=$I$921),"II",IF(AND(O3<$O$921,I3<$I$921),"IV",IF
(AND(O3>=$O$921,I3<$I$921),"III",0))))
Note :
Kuadran I : Availability ↑ rata2 & FBI ↑ rata2
Kuadran II : Availability ↓ rata2 & FBI ↑ rata2
Kuadran III : Availability ↑ rata2 & FBI ↓ rata2
Kuadran IV : Availability ↓ rata2 & FBI ↓ rata2
Kuadran II memiliki availability di bawah rata-rata
sehingga membutuhkan perhatian khusus dan tindak
lanjut Tim Operasional
Kuadran III memiliki FBI di bawah rata-rata sehingga
membutuhkan perhatian khusus dan tindak lanjut Tim
Bisnis.
Kuadran IV memiliki availability dan FBI di bawah
rata-rata sehingga membutuhkan perhatian khusus dan
tindak lanjut Tim Bisnis dan Operasional
![Page 18: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/18.jpg)
KESIMPULAN
Penyajian data secara
tepat dan menarik dapat
membantu pemahaman
kondisi internal dan
perumusan strategi
serta action yang
efektif.
18
![Page 19: sharing kuadran](https://reader034.vdocuments.us/reader034/viewer/2022042513/589afb471a28ab3e288b696d/html5/thumbnails/19.jpg)
terima kasih