Talknoteのピボットの裏話

Slide 1

Slide 1 text

5BMLOPUFͷzϐϘοτzͷཪ࿩ #Z

Slide 2

Slide 2 text

ར༻اۀ ࣾҎ্ͷࣾ಺4/4

Slide 3

Slide 3 text

ࣗݾ঺հ ౻Ҫ୓໵ &OHJOFFS ɾτʔΫϊʔτ։ൃ੹೚ऀ ɾݩʑখઆՈࢤ๬͕ͩͬͨɺ ɹࡀͷͱ͖ΤϯδχΞʹϐϘοτͨ͠ ɾ࠷ॳ͸4*FSۀքͰಇ͍͍͕ͯͨɺ ɹࡀͷͱ͖ελʔτΞοϓʹ ɹϐϘοτͨ͠ ɾීஈ͸ਈ͕࢜ͩɺ ɹ͜ͷલͳ͔ͥখٽ͖δδΠʹͳͬͯ ɹ࿡ຊ໦ͷ໷ͰϐϘοτ ย଍ટճ ͨ͠

Slide 4

Slide 4 text

ϐϘοτ QJWPU

Slide 5

Slide 5 text

#$὎## 1JWPU

Slide 6

Slide 6 text

5BMLOPUFЌ൛ϦϦʔε ೥݄೔ ࠷ॳ͸ΨνͰ#$ૂ͍

Slide 7

Slide 7 text

IUUQXXXWFOUVSFOPXKQOFXT@IUNM τʔΫϊʔτɺϝʔϧ୅ΘΓʹޮ཰తͳίϛϡχέʔγϣϯਤΔ ʮ5BMLOPUFʯ

Slide 8

Slide 8 text

d5BMLOPUF͸ɺ5XJUUFSͳͲͷϛχϒϩάʹ͍ۙΠϯλʔϑΣ ΠεͰ༑ਓؒͱͷϝοηʔδΛڞ༗͢ΔαʔϏε͕ͩɺ5XJUUFS ͷϝοηʔδ͕ެ։ܕͰl୭͔ͱ஌Γ߹͑Δzͷʹରͯ͠ɺ Ϋϩʔζυͳ؀ڥԼͰzطʹϝʔϧΞυϨεΛ஌͍ͬͯΔ༑ਓz ͱϝʔϧ୅ΘΓʹޮ཰తͳίϛϡχέʔγϣϯΛਤΓɺͦͷϩ άΛϊʔτͱͯ͠ه࿥͢Δ͜ͱΛ໨తͱ͍ͯ͠Δɻd #$Λૂ͍ͬͯͨ౰࣌ɺ ͢ͰʹΫϩʔζυɺϝʔϧͷ୅ସΛاਤ͍ͯͨ͠ هࣄൈਮ

Slide 9

Slide 9 text

౰࣌ͷϓϨʔϠʔͷঢ়گ d೥ ΧΧΦτʔΫ ϦϦʔε 'BDFCPPL ೔ຊ๏ਓઃཱ 7JCFS ָఱ ϦϦʔε -*/& ϦϦʔε ɹɹɹɹɹЌ൛ ϦϦʔε ࠃ಺Ϣʔβສ $PNN %F/" ϦϦʔε ऴྃ ɹɹɹɹɹΤϯλʔϓϥΠζ൛ ϦϦʔε

Slide 10

Slide 10 text

ͳͥ#$ྖҬ͔Βఫୀ͔ͨ͠ʁɿࢢ৔ ᶃ ϝʔϧˠ*. ᶄ1$ΨϥέʔˠεϚϗ

Slide 11

Slide 11 text

εϚϗར༻ऀ ࠃ಺ ͷঢ়گ ৘ใ௨৴നॻฏ੒೥൛͔Βൈਮ ฏ੒೥ ೥ εϚϗΛ࣋ͭਓ͸ਓʹਓ ฏ੒೥ ೥ εϚϗΛ࣋ͭਓ͸ਓʹਓ εϚϗར༻ऀͷ֦େ܏޲͕໌֬ʹ

Slide 12

Slide 12 text

εϚʔτϑΥϯɿܹಈͷ࣌୅ ɹॳ୅J1IPOFൃച ΞϝϦΧ ɹJ1IPOF(ࠃ಺ൃച ɹJ1IPOF(4ൃද ɹ,%%*͕"OESPJE*4 *4ൃද ɹJ1IPOFൃച ɹ,%%*"OESPJE*4ൃද ɹJ1IPOF4ൃച ͜ͷลΓͰ ࠃ಺Ͱ͸ΩϟζϜӽ͑

Slide 13

Slide 13 text

ΩϟζϜͷ͓͞Β͍ ΩϟζϜ ˝

Slide 14

Slide 14 text

౰࣌ͷϓϨʔϠʔͷঢ়گ d೥ ΧΧΦτʔΫ ϦϦʔε 'BDFCPPL ೔ຊ๏ਓઃཱ 7JCFS ָఱ ϦϦʔε -*/& ϦϦʔε ɹɹɹɹɹЌ൛ ϦϦʔε ࠃ಺Ϣʔβສ $PNN %F/" ϦϦʔε ऴྃ ɹɹɹɹɹΤϯλʔϓϥΠζ൛ ϦϦʔε ΩϟζϜલ ͜͏ͯ͠ΈΔͱ-*/&ͷ ࢢ৔ࢀೖλΠϛϯάͷ ੌ͕͞Θ͔Δ

Slide 15

Slide 15 text

ͳͥ#$ྖҬ͔Βఫୀ͔ͨ͠ʁɿڝ߹ ΧΧΦτʔΫɿεϚϗಛԽܕ ΧΧΦ͕ࣾʹϦϦʔεɻ $&0ͷۚൣᔩ ΩϜɾϘϜε ͸ݩʑ͸ؖࠃϋϯήʔϜͷ૑ۀऀɻ ˞ϋϯήʔϜ͸ؖࠃ࠷େͷ*5اۀɺ/)/ ݱωΠόʔ ͷલ਎Ͱɺ ɹͦͷ೔ຊ๏ਓ/)/+BQBO͕-*/&ͷ։ൃݩɻͳΜͱ͍͏ҼՌɻ 'BDFCPPLɿϚϧνσόΠεܕ આ໌ෆཁɻβοΧʔόʔάɺιʔγϟϧɾωοτϫʔΫɻ ڝ߹ɺڧ͗͢ ʀЧʆ

Slide 16

Slide 16 text

ͳͥ#$ྖҬ͔Βఫୀ͔ͨ͠ʁɿࣗࣾ ౰࣌ͷࣾһ਺ ɹਓ ࣾ௕ؚΊ ΦϑΟε͸ ौ୩ͷϫϯϧʔϜϚϯγϣϯ ώτɺΧωɺϫβ ͢΂͕ͯͳ͍ঢ়ଶ

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

##ଆɿࢢ৔ ᶃ࢖͍ʹ͍͘ΤϯλʔϓϥΠζ੡඼ ᶄΫϥ΢υ΁ͷγϑτ ᶅυϝεςΟοΫͳࢢ৔

Slide 19

Slide 19 text

ᶃ࢖͍ʹ͍͘ΤϯλʔϓϥΠζ੡඼ Θ͚͕Θ͔Βͳ͍Αʜ

Slide 20

Slide 20 text

೥લޙ͔ΒੈքతͳτϨϯυʹ (PPHMFτϨϯυɿʮFOUFSQSJTFDMPVEʯ ᶄΫϥ΢υ΁ͷγϑτ

Slide 21

Slide 21 text

ᶅυϝεςΟοΫͳࢢ৔ ࠃ͝ͱͷ঎׳शɺจԽ ۀք͝ͱͷ׳शɺจԽ اۀ͝ͱͷ׳शɺจԽ ίϛϡχέʔγϣϯจԽ ίϛϡχέʔγϣϯΛ੍͢Δʹ͸ จԽΛ஌ΒͶ͹Βͳ͍

Slide 22

Slide 22 text

##ଆɿڝ߹ ւ֎ ϦϦʔε ૑ۀऀ͸ݩ1BZ1BM$00ͷσϏουɾβοΫε ϚΠΫϩιϑτ͕ԯ64υϧʢ໿ԯԁʣͰങऩ ϦϦʔε ݩ͸4BMFTGPSDFDPN͕ങऩͨ͠(SPVQ4XJNɻ

Slide 23

Slide 23 text

##ଆɿڝ߹ ࠃ಺ Α͋͘Δڞ௨తͳ໰୊ɿ ɹɾεϚϗରԠ͕ऑ͍ ɹɾػೳ͕ଟͯ͘࢖͍ʹ͍͘ ɹɾσβΠϯ͕͍͚ͯͳ͍ ˞͚ͩ͜͜ͷ࿩ɺ5BMLOPUF΋μϝμϝͳͱ͜Ζ͕͋ͬͨ

Slide 24

Slide 24 text

##ଆɿࣗࣾ ᶃ ࣾ௕ͷਓ຺͕͋ͬͨ ᶄ ͢Ͱʹ๏ਓͷސ٬͕͍ͨ ᶅ ೔ຊاۀ ᶆ ϚϧνσόΠεͰγϯϓϧͳ੡඼ ˞୯ʹػೳෆ଍ͩͬͨɺͱ͍͏࿩΋ ΉʹΌΉʹΌ

Slide 25

Slide 25 text

##ͳΒͰ͸ͷػձ ऑऀͷઓུ 1JWPUɿ݁࿦

Slide 26

Slide 26 text

8&5὎%3: 8&5 1JWPU

Slide 27

Slide 27 text

8&5 ɹ%3:ʁ

Slide 28

Slide 28 text

5BMLOPUF͕໨ࢦ͍ͯ͠Δΰʔϧ ίϛϡχέʔγϣϯΛྑͯ͘͠ ʮ͍͍ձࣾʯΛ࡞Δ

Slide 29

Slide 29 text

ʮͰɻ5BMLOPUFͰച্͕͋Μͷʁʯ

Slide 30

Slide 30 text

ʮ ௚઀తʹ͸ ͕͋Γ·ͤΜʯ

Slide 31

Slide 31 text

Ϳͪ͋ͨͬͨ໰୊ ίϛϡχέʔγϣϯͷՁ஋͸ Θ͔Γʹ͍͘ ͦͯ͠اۀͷελϯεɺจԽʹܹ͘͠ґଘ͢Δ

Slide 32

Slide 32 text

͜Μͳձࣾͱ͔

Slide 33

Slide 33 text

͜Μͳձࣾ ͱ͔

Slide 34

Slide 34 text

ࣾ಺ίϛϡχέʔγϣϯͷ ࡏΓํ͸اۀʹΑ༷ͬͯʑ

Slide 35

Slide 35 text

5BMLOPUF͕࡞Ζ͏ͱͨ͠ίϛϡχέʔγϣϯ 8&5 ϝϯόʔؒͷରਓೝ஌ΛਂΊΔ FHօ͕ϑϨϯυϦʔͳ৬৔ ձࣾͷϛογϣϯ΍اۀཧ೦Λਁಁͤ͞Δ  FHاۀͷΫϨυɺ(PPHMFͷʮ%PO`UCFFWFJMʯ

Slide 36

Slide 36 text

%3: ;ͭ͏ͷձࣾͰඞཁͳίϛϡχέʔγϣϯ ใࠂɺ࿈བྷɺ૬ஊ ۀ຿஌ࣝͷڞ༗ Ϛωδϝϯτ FUDFUDʜ

Slide 37

Slide 37 text

%3: %3: 8&5 5BMLOPUF͕ߟ͑Δ ʮ͍͍ձࣾʯ ී௨ͷձࣾ

Slide 38

Slide 38 text

%3: %3: 8&5 45&1 5BMLOPUF͕ߟ͑Δ ʮ͍͍ձࣾʯ ී௨ͷձࣾ ·ͣ͸ίϛϡχέʔγϣϯͷΠϯϑϥʹͳΔ

Slide 39

Slide 39 text

%3: %3: 8&5 5BMLOPUF͕ߟ͑Δ ʮ͍͍ձࣾʯ ී௨ͷձࣾ 8&5 ίϛϡχέʔγϣϯʹ෇ՃՁ஋Λ͚ͭΔ 45&1

Slide 40

Slide 40 text

࣮ࡍʹ΍ͬͨ͜ͱ ᶃ ະಡطಡػೳ ᶄ λεΫ؅ཧͷ։ൃ ᶅ ϝοηʔδػೳͷվળ

Slide 41

Slide 41 text

·ͣ͸࢖ͬͯ΋Β͏ 1JWPUɿ݁࿦

Slide 42

Slide 42 text

ϑΟʔυ὎ϝοηʔδ 1JWPU

Slide 43

Slide 43 text

౤ߘ6* લޙʹ͸ؔ࿈ͤͣɺ ͦΕͧΕ͕ಠཱͨ͠τϐοΫ ࠷৽ͷτϐοΫ͕ৗʹ Ϣʔβͷ໨ʹೖΔΑ͏ʹ ഑ྀ͞Ε͍ͯΔͨΊɺ ࣌ܥྻ͕ٯ τϐοΫʹؔ͢Δίϝϯτ͸ ҙࢥૄ௨ͷͨΊʹ࣌ܥྻॱ ϑΟʔυ6* 'BDFCPPL

Slide 44

Slide 44 text

લޙͰؔ࿈͠߹ͬͨ৘ใͷྲྀΕ Ϣʔβ͸࣌ܥྻͰྲྀΕΛ௥͍ɺ ௥ՃͷϙετΛ͢Δɻ ౤ߘ6* ϝοηʔδ6* ྫ(NBJM

Slide 45

Slide 45 text

࣌ܥྻ ౤ߘ6* ͦͷଞͷྫɿ4MBDL ΤϯδχΞେ޷͖

Slide 46

Slide 46 text

ຊ౰ͷҧ͍͸Կ͔ʁ

Slide 47

Slide 47 text

ϑΟʔυ͸ʮԿ͔ʯΛڞ༗͢Δ

Slide 48

Slide 48 text

ϝοηʔδ͸ʮ୭͔ʯͱ࿩͢

Slide 49

Slide 49 text

ϝοηʔδ6* ϑΟʔυ6* 6*ͷར఺ ࣌ܥྻʹԊͬͨ૒ํ޲Ͱͷ ҙࢥૄ௨ʹద͍ͯ͠Δ ಛఆͷ৘ใΛ޿͘ڞ༗͠ɺ ෳ਺ਓͰҙݟަ׵Λ͢Δͷʹద ͍ͯ͠Δ Ϣʔβͷࢥߟॱং ୭ͱˠԿΛ ԿΛ ˠ୭ͱ ڞ༗͠΍͍͢৘ใ ɾݸਓؒͷ࿈བྷ ɾλεΫνʔϜ΁ͷ࿈བྷ ɾχϡʔε ɾෆಛఆଟ਺΁ͷप஌ ɾ2" ୡ੒͠΍͍͢ ϕωϑΟοτ ɾۀ຿ޮ཰ͷ޲্ ɾڞ༗஌ͷৢ੒ 6*ͷಛ௃੔ཧ

Slide 50

Slide 50 text

ɾʮ୭ͱʯ࣠ͷίϛϡχέʔγϣϯ͸ ɹʮԿΛʯ࣠ͷίϛϡχέʔγϣϯΑΓ΋ൃੜ͠΍͍͢ɻ ɾʮ୭ͱʯ͕࣠ᐆດ ෆಛఆଟ਺ ͷঢ়ଶͰɺ ɹʮԿΛʯ࣠Ͱίϛϡχέʔγϣϯ͢Δγʔϯ͸ݱ࣮ʹ͸গͳ͍ɻ ɹɹɹ˞͢ͳΘͪχʔζ͕ബ͍ɻ ɹɹɹɹͨͩ͠ɺ૊৫ͷن໛͕େ͖͘ͳΔʹͭΕͯॏཁੑ͕૿͢ɻ ୭ͱʼ୭ͱԿΛʼԿΛ ར༻γʔϯͷଟ͞ ཱͯͨԾઆ

Slide 51

Slide 51 text

૊৫ن໛ͱͷχʔζͷ૬ؔੑ ࡶײ খن໛૊৫ େن໛૊৫ ڞ༗஌ͷৢ੒ ˚ ˕ ۀ຿ޮ཰ͷ޲্ ˕ ˕

Slide 52

Slide 52 text

౤ߘྔͷભҠ 100,000 200,000 300,000 400,000 500,000 600,000 700,000 2011.3 2012.3 2013.3 2014.3 2015.3 ϝοηʔδૹ৴਺ ౤ߘɾίϝϯτ਺ ͜ͷ͋ͨΓ͔Βঃʑʹ ϝοηʔδʹྗΛೖΕ࢝Ίͨ

Slide 53

Slide 53 text

࠷ॳʹରͷ ίϛϡχέʔγϣϯΛੜΈग़͢ 1JWPUɿ݁࿦

Slide 54

Slide 54 text

ࣾ಺4/4὎ʁ 1JWPU

Slide 55

Slide 55 text

࢓ࣄͷίϛϡχέʔγϣϯ͸Ͳ͔͜Βདྷͯɺ Ͳ͜΁͍͘ͷ͔ʁ اۀ ෦ॺ Ϙε ސ٬ ࢲ ಉ྅ औҾઌ ֎͔Βདྷͯ֎΁ؐΔ

Slide 56

Slide 56 text

େ͖͍ձࣾͱখ͍͞ձࣾ େ͖͍ձࣾ ࣾ֎ ࣾ಺ ࣾ֎ খ͍͞ձࣾ ࣾ಺ ࣾ಺ίϛϡχέʔγϣϯͷྔ͸ͲͪΒ͕ଟ͍͔ʁ w w

Slide 57

Slide 57 text

λʔήοτاۀ͸େاۀʁ ʮࣾ಺ʯ͚ͩʹϑΥʔΧε͢ΔͳΒ େاۀͷ΄͏͕χʔζ͕ڧ͍ʁ େاۀ͸ಋೖϋʔυϧ͕ߴ͘ɺ ސ٬୯Ձ͕ߴ͘ͳ͍ͱίετ͕ݟ߹Θͳ͍ ˞4BB4ͱ૬ੑ͕ѱ͍

Slide 58

Slide 58 text

ࠃ಺ن໛ผࣄۀॴ਺ͷׂ߹  ૯ܭɿ໿ສࣾ dਓ dਓ ਓҎ্ ن໛ผैۀһ਺ͷׂ߹  ૯ܭɿສਓ dਓ dਓ ਓҎ্ ࣄۀऀͷߏ੒ൺ ฏ੒೥ɿ૯຿ল

Slide 59

Slide 59 text

اۀ਺ͱैۀһ਺ ᶃ ਓະຬͷاۀ਺͸શମͷ ᶄ ࿑ಇऀͷ͸ਓະຬͷاۀʹ͍Δ ίϛϡχέʔγϣϯྔͷ૯࿨͸ɺ ਓະຬͷاۀͷ΄͏͕ଟ͍͸ͣ

Slide 60

Slide 60 text

খ͍͞ձࣾͷχʔζ ࣾ֎ খ͍͞ձࣾ ࣾ಺ ඞવతʹ ͜͜ͷχʔζ͕ڧ͘ͳΔ