財ååæã®äž»ãªç®çã¯ãäŒç€Ÿã®åçæ§ãå®å šæ§ãçç£æ§ãæé·æ§ãåæããçµå¶ç¶æ ãææ¡ããããšã§ãã財ååæã«ãã£ãŠããéã®æµããå¥å šãªç¶æ ã«ä¿ãããŠããããæ¹åãã¹ãç¹ã¯ã©ãããšãã£ãåé¡ç¹ãææ¡ããããšãã§ããŸãããããŠãå©çãçã¿åºããµã€ã¯ã«ãä»åŸãç¶ç¶å¯èœããããŸããŸãªææšãçšããããšã§ç¢ºèªããããšãå¯èœã§ãã
äŒæ¥ãå¥å šãªçµå¶ãç¶ããæé·ããããã«ã¯ã財ååæã«ãã宿çãªçµå¶ç¶æ ã®ãã§ãã¯ãæ¬ ãããŸãããçµå¶å±æ©ãåé¿ããããã«ã財ååæã¯æçšã§ãã
ãããã財ååæã®ããã®ããŒã¿åéãåæã«æéãæéãããã£ãŠããã®ã§ã¯ããã®æçšæ§ãéããããã®ã«ãªã£ãŠããŸããŸããåžžã«ææ°ã®ããŒã¿ãçšããŠãã®æã ã®çµå¶ç¶æ ãã¢ãã¿ãŒã§ããã®ãçæ³ã§ãããæ¬æ¥ã®æå³ã§ã®è²¡ååæãšãããŸãããããã財å諞衚ããŸããäŒç€Ÿã®çµå¶å€æã®ããã®ã€ã³ãµã€ããåŸãããã®éèŠãªè³æãªã®ã§ãã
ããã§æ±ããããã®ã¯ãåŸæ¥ã®ãããªæäœæ¥ã«ããããŒã¿éèšãè³æäœæã§ã¯ãªãããã€ã§ãå¿ èŠãªãšãã«è²¡ååæãã§ããã¹ããŒãã£ã«ç¥ãããæ å ±ãåŸãããã財åãã§ãã¯ã®ããã®ä»çµã¿ã¥ããã§ãã
æ¬èšäºã§ã¯ã財ååæã®ä»£è¡šç㪠4 ã€ã®ææ³ããåçæ§åæããå®å šæ§åæããçç£æ§åæããæé·æ§åæãã§ãããããšã解説ããããŠãTableau ã§è²¡ååæãè¡ããããžãã¹ã®æææ±ºå®ã«æŽ»çšãããã€ã³ãã«ã€ããŠãã玹ä»ããŸãã
äŒæ¥æé·ãå éããã BI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
ç®æ¬¡
- 財ååæãšã¯?
- 財ååæã®ç®ç
- 財ååæã®ããæ¹
- 財ååæãªã倧åãªã®ã?
- ã©ã®ããã«ããžãã¹æææ±ºå®ã«äœ¿çšãããã®ã?
- ã©ããªã¿ã€ãã®ããŒã¿ã䜿ãããã®ã?
- 財å諞衚ïŒè²¡åäžè¡šïŒã§äœããããïŒ
- 財ååæã«ããã代衚ç㪠4 ã€ã®ææ³
- Tableau ã§å§ãã財ååæã§ãæ°ããªã€ã³ãµã€ããåŸã
- Tableau ã§å®æŠçãªè²¡ååæãè¡ãã
財ååæãšã¯?
財ååæãšã¯äžè¬çã«ãäŒæ¥ã®è²¡åã«é¢ããæ å ±ããçµå¶ç¶æ³ãåæããææ³ãæç¶ããæå³ããŸããäŒæ¥ã®è²¡åã«é¢ããæ å ±ãšã¯ã貞åå¯Ÿç §è¡šãæçèšç®æžãšãã£ããããã財å諞衚ã§ããããã®æ°åè³æã«ããšã¥ããŠãäŒæ¥ã®çµå¶ç¶æ³ãåæããã®ã§ãã
財ååæãããäžã§éèŠãªã®ã¯ãäŒæ¥ã®åçæ§ãå®å šæ§ãçç£æ§ãæé·æ§ã® 4 ã€ã§ããããããæããã«ããåãæ¥çå ã®ä»ç€Ÿãªã©ãšæ¯èŒãããªãããçµå¶ã«é¢ããèªç€Ÿã®çŸç¶ãææ¡ããããšãã§ããŸãã財ååæã¯ãåæãè¡ãäž»äœã瀟å€ã®äººéã瀟å ã®äººéãªã®ãã«ãã£ãŠããå€éšåæããšãå éšåæã2 ã€ã«å€§ããåããããŸããããããã«ã€ããŠèª¬æããŸãã
å€éšåæ
å€éšåæã¯ãäŒæ¥ã®çµå¶è 以å€ã®ç«å Žããè¡ã財ååæã§ãã
äŒæ¥ã¢ããªã¹ããæè³å®¶ããäŒç€Ÿã®åçæ§ãå®å šæ§ãçç£æ§ãæé·æ§ãªã©ãå€å®ããããã«è¡ããŸãããããã¯ãéèæ©é¢ã嵿š©è ãäŒç€Ÿã®ä¿¡çšç¶æ³ãè¿æžèœåãåæããããæ°èŠååŒå ãäŒç€Ÿã®ä¿¡çšç¶æ³ãçµå¶ç¶æ ãåæãããããå Žåãå€éšåæãšããèšèã䜿ãããŸãã
ãŸããå€éšåæãããã«ä¿¡çšåæãšæè³åæã«åããèãæ¹ããããŸããä¿¡çšåæã¯äŒæ¥ã®æ¯æãèœåãåæãããã®ãæè³åæã¯äŒæ¥ãæè³ã«å€ãã䟡å€ãæã€ãã©ãããåæãããã®ã§ãã
å€éšåæã«ã¯è²¡å諞衚ã«å ããŠããã°ãã°éèæ©é¢ãå°éçãªãµãŒãã¹ãæäŸããäžä¿¡èª¿æ»äŒç€Ÿã®ããŒã¿ïŒãè©ç¹ããªã©ãšåŒã°ããŸãïŒã䜿çšãããŸãã
å éšåæ
å éšåæã¯ãäŒæ¥ãèªç€Ÿã®çµå¶ç¶æ³ãææ¡ããããã«è¡ã財ååæã§ãã
éåžžãçµå¶è ã®æç€ºã®ããšãçµå¶ç®¡çãçµçãå¶æ¥çµ±æ¬ãšãã£ãéšéãåæãããŸããåŸãããåæçµæã¯ãä»åŸã®çµå¶èšç»ã®çå®ãæææ±ºå®ãçµå¶å€æãªã©ã®ããã«æŽ»çšãããŸããããã財æ¿ç¶æ ãªã©ã«äœããã®åé¡ç¹ãèŠã€ãã£ããšãã«ã¯ãæ©æ¥ã«å¯Ÿçãè¬ããããšãã§ããã§ãããã
ãŸãçµå¶è ãçµå¶é£ã«ãšã£ãŠã ãã§ã¯ãªããå éšåæã®çµæã¯åŸæ¥å¡ã«ãšã£ãŠãèªç€Ÿã®çµå¶ç¶æ³ã®å¥å šæ§ãç¥ãããã«åœ¹ç«ã¡ãŸããããã«ãåŽåçµåãåŽåç°å¢ã®æ¹åèŠæãè³é亀æžã®éã®åèè³æãšããŠå éšåæçµæã䜿çšããããšããããŸãã
ãããã«ãããå éšåæã¯äŒç€Ÿã®çµå¶ç¶æ³ã財æ¿ç¶æ ãç¥ãããã«éåžžã«æå¹ãªææ®µã§ãããªã¹ã¯ã«ã€ãªããå åããã¡æ©ãèŠã€ããããã«ãã宿çã«ãã§ãã¯ããŠããã¹ããã®ãšãããŸãã
å éšåæã«ã¯è²¡å諞衚以å€ã«ããå€éšåæã§ã¯äœ¿çšããã®ãé£ããå éšæ å ±ãæ©å¯æ å ±ãšãã£ãäŒæ¥å éšã®ããŒã¿ãçšããããŸãã
ããŒã¿ãå¯èŠåããŠããžãã¹ãå éïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
財ååæã®ç®ç
財ååæã®ç®çã¯ã誰ãäž»äœãšãªã£ãŠåæãããã®ãã«ãã£ãŠå€ãããŸãã å éšåæã®å Žåã®ç®çã¯ãçµå¶è ãªã©ãäž»äœãšãªããèªç€Ÿã®çµå¶å å®¹ãææ¡ããŠæææ±ºå®ãçµå¶å€æãããããã§ããå€éšåæã®å Žåã¯ãäŸãã°æè³å®¶ãªã©ãäž»äœãšãªã£ãŠã察象ãšãªãäŒç€Ÿã®å°æ¥æ§ã«ã€ããŠäºæž¬ããããã«è²¡ååæãè¡ããŸãã
ãã®ã»ããåæãè¡ãäž»äœå¥ã®è²¡ååæãè¡ãç®çã«ã¯ãäžèšã®ãããªãã®ãæããããŸãã
äž»äœå¥ã»è²¡ååæã®ç®çã®äŸ
äŒæ¥æé·ãå éããã BI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
ãã¡ãã®èšäºãèŠãæ¹ã¯ãäžèšã®ããŒãžã«ãèå³ããæã¡ã§ãã
財ååæã®ããæ¹
財ååæã¯ã倧ããåããŠã宿°åæããšãæ¯çåæãã® 2 ã€ã®ææ³ã§è¡ãã®ãäžè¬çã§ãã
- 宿°åæ
宿°åæã¯ã売äžãçµè²»ãšãã£ãææšã®æ°å€ããå幎å®çžŸãä»ç€Ÿå®çžŸãšæ¯èŒããŠè¡ããŸãã - æ¯çåæ
æ¯çåæã¯ã幎平åæé·çãèªå·±è³æ¬æ¯çãåºå®è³ç£å転çãšãã£ãçã§è¡šãããå€ããåæ§ã«å幎å®çžŸãä»ç€Ÿå®çžŸãšæ¯èŒããŠè¡ããŸãããŸããååå¥å£²äžæ§ææ¯ãšãã£ãããã«ãèªç€Ÿã®å®çžŸ (ãã®å Žåã売äž) ã®æ§ææ¯çãåæããããšãããã°ãã°è¡ãããŸãã
ã©ã¡ãã®åæãããå®çžŸããŒã¿ã®èç©ããææšå®çŸ©ãšå®åŒåããèŠè§£åããšãã£ãæµãã§è¡ãããŸããããã«ãåæå€ã¯ãå¥é 説æãã KPI ãšéãªãããšãå€ãããã®ãã PDCA ãšãæ·±ãçµã³ã€ãããããŸãã
ããŒã¿ãå¯èŠåããŠããžãã¹ãå éïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
財ååæãªã倧åãªã®ã?
財ååæã¯ã1960 幎代ã«ç±³åœã§å§ãŸããŸãããäŒæ¥ã®å©çã¯ãã å€ããã°ããã®ã§ã¯ãããŸãããåçšåºŠã®å©çãèšäžããŠããŠããããã«ã¯ããæè³ã«é©ããäœããã®ç¹åŸŽãããã®ã§ã¯ãªãããšãåœæã®ã¢ããªã¹ããæ°ã¥ãããšèšãããŠããŸãã
äžæ¹ãæ¥æ¬ã§ã¯é·ã財åãããçšåã®èгç¹ããåæãè¡ãããŠããŸãããäžèšã§ããã°ãã©ã®ã¿ã¡æ³äººçšãçŽããã«ããŠããæ£ç¢ºãªéé¡ã§ããããšã¯åœç¶ãšããŠãç¡é§ãªã (ã§ããã ãå°ãªã) çšé¡ãæããããããã§ã¯ãã©ã¡ãããšããã°ãçµå¶ã®è³ªãäŒæ¥ãçµå¶è ãèªãåããšããããããçšå眲ããæå°ãå ¥ããªãããã«ã決ããããææ¥ãŸã§ã«å£²äžãªã©ã®ããŒã¿ãéããŠå ±åããããšã第 1 ã®ç®çãšãªã£ãŠããŸããã
ãããã1970 幎代åãã®ãªã€ã«ã·ã§ãã¯ã転æ©ã«ãæ¥æ¬ã¯é«åºŠæé·ããäœæé·ã®æä»£ãžç§»ããŸããããšãã°ãé«åºŠæé·æä»£ã«ã¯ãåšåº«ã¯ããã売äžã«å€ããäŒç€Ÿè³ç£ã§ãããå€å°ãå€ãã«åšåº«ãæã£ãŠããŠãåé¡ã«ã¯ãªããããããè©äŸ¡ãããããšããããŸããããšãããäœæé·æä»£ã«ã¯ãç¡é§ãªåšåº«ã¯å©ççãå§è¿«ãããªã¹ã¯ãšãªããŸããããããããšã«ãã¡ã¯ããæ°ã¥ããå€§äŒæ¥ãäžå¿ã«ãæ¥æ¬ã§ãã財ååæã®éèŠæ§ã次第ã«èªèãããããã«ãªã£ãŠããŸããã1980 幎代㮠OA (ãªãã£ã¹ãªãŒãã¡ãŒã·ã§ã³) ã®æ®åãããããã®æéã®ãããåæãå¯èœã«ããŠãããŸããã
ãããŠä»æ¥ã§ã¯ã財å諞衚ãå ¬è¡šããäŒæ¥æè³å®¶ã«ãå人æè³å®¶ã«ããã®èª¬æè²¬ä»»ãæããããšããäžå ŽäŒæ¥ã§ã¯åœç¶ã®ããã«ãªã£ãŠããŸãã
äŒæ¥æé·ãå éããã BI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
財ååæã«ã¯ã©ã®ãããªçš®é¡ããããã©ã®ããã«ããžãã¹æææ±ºå®ã«äœ¿çšãããã®ã?
äžè¬ã«ãéèŠåºŠã®é«ã財ååæã®è§åºŠãšææšã«ã¯ 20 ãã 30 çš®é¡ããããšèšãããŠããŸããäžè¡šã¯ãçè ãç¹ã«éèŠãšèããŠãã 22 ã®è²¡ååæææšãšçšéããŸãšãããã®ã§ãã
ã | 財ååæè«žè¡š | èšç®åŒ | ããžãã¹æææ±ºå®äžã®äž»ãªçšé |
1 | ROA ( ç·è³æ¬å©çç ) | åœæçŽå©ç ÷ ç·è³ç£ | (1) åçæ§è©äŸ¡ |
2 | ROE ( èªå·±è³æ¬å©çç ) | åœæçŽå©ç ÷ èªå·±è³æ¬ | |
3 | 財åã¬ãã¬ããž | ç·è³æ¬ ÷ èªå·±è³æ¬ | |
4 | ç·è³ç£å転ç | 売äžé« ÷ ç·è³ç£ | |
5 | æçåå²ç¹ | åºå®è²» ÷ (1 - å€åæ¯ç) | |
6 | 売äžé«å©çç | åœæçŽå©ç ÷ 売äžé« | |
7 | çŸé éæåæ¯ç | çŸé é ÷ å¹³åæå | (2) å®å šæ§è©äŸ¡ |
8 | åºå®é·æé©åç | åºå®è³ç£ ÷ (èªå·±è³æ¬ + åºå®è² åµ) | |
9 | åºå®æ¯ç | åºå®è³ç£ ÷ èªå·±è³æ¬ | |
10 | èªå·±è³æ¬æ¯ç | èªå·±è³æ¬ ÷ ç·è³æ¬ | |
11 | åœåº§æ¯ç | åœåº§è³ç£ ÷ æµåè² åµ | |
12 | æå©åè² åµæåæ¯ç | æå©åè² åµ Ã· å¹³åæå | |
13 | æµåæ¯ç | æµåè³ç£ ÷ æµåè² åµ | |
14 | ã€ã³ã¿ã¬ã¹ãã«ãã¬ããžã¬ã·ãª | (å¶æ¥å©ç + åå婿¯ + ååé åœé) ÷ (æ¯æå©æ¯ + å²åŒæ) | (3) è³éç¹°ãè©äŸ¡ |
15 | åšåº«å転æé | æ£åžè³ç£ ÷ (売äžå䟡 ÷ 12) | |
16 | 売äžåµæš©å転æé | (売æé + ååæåœ¢) ÷ (売äžé« ÷ 12) | |
17 | EPS (1æ ªãããå©ç) | åœæçŽå©ç ÷ çºè¡æžæ ªåŒç·æ° | (4) ãã®ä»ã®è©äŸ¡ |
18 | PBR (æ ªäŸ¡çŽè³ç£åç) | æ ªäŸ¡ ÷ 1 æ ªåœããã®çŽè³ç£ | |
19 | PER (æ ªäŸ¡åçç) | æ ªäŸ¡ ÷ 1 æ ªãããå©ç | |
20 | åšåº«å転ç | 売äžå䟡 ÷ æ£åžè³ç£ | |
21 | é åœæ§å | é åœé ÷ åœæçŽå©ç | |
22 | 売äžåµæš©å転ç | 売äžé« ÷ (売æé + ååæåœ¢) |
衚äžã®ãããžãã¹æææ±ºå®äžã®äž»ãªçšéãã«ã€ããŠç°¡åã«èª¬æãããšã
ã(1) åçæ§è©äŸ¡ãã¯ãäŒæ¥ãå²ãã£ãŠãããã©ãããèŠãããšã§ãã
ã(2) å®å šæ§è©äŸ¡ãã¯ãäŒæ¥ã®çµå¶ã«ãªã¹ã¯ãããã/ãªãããèŠãããšã§ãã
ã(3) è³éç¹°ãè©äŸ¡ãã¯ãåçæ§ãå®å šæ§ã«ãé¢ãã£ãŠããã®ã§ãããäŒç¥šäžã§å£²äžãç«ã€ããšãšãã£ãã·ã¥ãã㌠(å®éã®å ¥é) ã®éã«ã¯ããã°ãã°æéå·®ããããŸãããã®è©äŸ¡ãè¡ã£ãŠããŸãã
ã(4) ãã®ä»ã®è©äŸ¡ãã¯ã䞻㫠(1) ãã (3) ãšã¯å¥ã®çšéã§çšãããããã®ã§ãè¡šã«æãã以å€ã«ããäŒæ¥ãæ¥çš®ãåžå Žããšã«ãããŸããŸãªçšéãšåæææšãååšããŸãã
ãªããããã§æ³šç®ãããã®ãããã¹ãŠã®èšç®åŒã§ããããã©ã¡ãŒã¿ãŒãå¥ã®ãã©ã¡ãŒã¿ãŒã§å²ãèšç®ãè¡ãããŠããããšã§ãã ãã®ããã«ã財ååæã§ã¯ãã©ã®ããã«è¡ãããã®ã?ãã®é ã§è¿°ã¹ãããã«ããŸãå€ãéããã®ã¯ãã¡ãããããã«å ããŠãå²ãç® (= æ¯ç)ããªãã¡ãæ¯çåæããè¡ãããšã極ããŠéèŠãªæå³ãæã£ãŠããŸãã
èªåã®ããŒã¿ãã䟡å€ããæ å ±ãåŒãåºããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ã§ããŒã¿ã®äŸ¡å€ãæå€§åããŸãããïŒ Tableau ã®ç¡æãã©ã€ã¢ã«ãä»ããã詊ããã ããã
ç¡æãã©ã€ã¢ã«ãããŠã³ããŒãã©ããªã¿ã€ãã®ããŒã¿ã䜿ãããã®ã?
äžè¡šã¯ãåé ã§ç޹ä»ãã衚ã®ãèšç®åŒãã§ 2 å以äžçšããããŠãããã©ã¡ãŒã¿ãŒã䜿çšåæ°é ã«ç€ºãããã®ã§ãã
ã | ãã©ã¡ãŒã¿ãŒ | 衚äžã®äœ¿çšåæ° |
1 | èªå·±è³æ¬ | 5 |
2 | åœæçŽå©ç | 5 |
3 | 売äžé« | 4 |
4 | æ£åžè³ç£ | 2 |
5 | 売æé | 2 |
6 | åºå®è³ç£ | 2 |
7 | 売äžå䟡 | 2 |
8 | æ ªäŸ¡ | 2 |
9 | å¹³åæå | 2 |
10 | ååæåœ¢ | 2 |
11 | æµåè² åµ | 2 |
12 | ç·è³æ¬ | 2 |
13 | ç·è³ç£ | 2 |
ã | å°èš | 34 |
ãããã®å€ã¯ããªãã¡ãäŒæ¥ãçµå¶è ãå©å®³é¢ä¿è ãæè³å®¶ãšãã£ã財ååæãèŠã人ã«ãšã£ãŠéèŠãã€åºç€çãªããŒã¿ãšãªããŸãããã£ãŠããããã¯å¿ ãäŒæ¥å ã®ã©ããã«ååšããŸãããããŠã²ãšã€ã²ãšã€ã®å€ã¯åºç€çãªãã®ã§ããããããå¹çããéããèšç®ããPDCA ã«ã€ãªãã圹å²ããçŸä»£ã®è²¡ååæã«æ±ããããŠãããšãããŸãã
äŒæ¥æé·ãå éããã BI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
財å諞衚ïŒè²¡åäžè¡šïŒã§äœããããïŒ
äž»ã«ã財ååæã«äœ¿çšããã財å諞衚ãšã¯ã決ç®ãŸã§ã® 1 幎éã®äŒç€Ÿã®è²¡æ¿ç¶æ ãçµå¶æçžŸãèšããèšç®æžã®ããšã§ããããç°¡åã«æ±ºç®æžãšåŒã°ããããšããããŸããéèååååŒæ³ã§ã¯ã財å諞衚ã¯ãã¹ãŠã®äžå ŽäŒæ¥ãååŒæãšéèåºãä»ããŠãå é£ç·ç倧è£ãžæåºãããã矩åã¥ããããŠããŸãã
å ·äœçãªè²¡å諞衚ãšããŠã¯ããè³åå¯Ÿç §è¡šããæçèšç®æžãããã£ãã·ã¥ãããŒèšç®æžããå©çéåŠåèšç®æžããéå±æçŽ°è¡šããªã©ãæããããŸããäžã§ã貞åå¯Ÿç §è¡šãæçèšç®æžããã£ãã·ã¥ãããŒèšç®æžã® 3 ã€ã¯ã財åäžè¡šãšåŒã°ããŠããŸããã§ã¯ããã®è²¡åäžè¡šãåæããããšã§ãäœããããã®ã§ããããã
財åäžè¡šã®é¢ä¿å³
貞åå¯Ÿç §è¡šïŒè³ç£ãšè² åµã®ãã©ã³ã¹ãäŒç€Ÿã®è²¡åç¶æ³ãããã
貞åå¯Ÿç §è¡šã¯ãæ±ºç®æïŒãŸãã¯äžæç¹ïŒã«ãããè³ç£ãè² åµãçŽè³ç£ã®é¡ã«ãã£ãŠäŒç€Ÿã®è²¡æ¿ç¶æ³ãç€ºãæžé¡ã§ãã衚ã®å·ŠåŽã«è³ç£ããããå³åŽã«ã¯è² åµãšçŽè³ç£ãèšèŒãããŠããŸãããè³ç£ããšãè² åµïŒçŽè³ç£ããæçµçã«é£ãåãããšããããã©ã³ã¹ã·ãŒãããšåŒã°ããç¥ãå Žåã®è¡šèšã¯ãB/Sãã§ãã
貞åå¯Ÿç §è¡šãèŠãã°ãäŒç€Ÿãã©ã®ããã«ããŠè³éã調éããã©ã®ããã«éçšããŠããã®ããçŸç¶ã©ã®ãããè³ç£ãããã®ããããããŸããäŸãã°ãè³ç£ã«å¯ŸããçŽè³ç£ã®æ¯çã§ãããèªå·±è³æ¬æ¯çããé«ãã»ã©ããã®äŒç€Ÿã®è²¡æ¿äœè³ªã¯å¥å šã§ãããšèªã¿åãããšãå¯èœã§ãã
ãŸããè³ç£ã®ãã¡ãæµåè³ç£ïŒ1 幎以å ã«çŸéåã§ããè³ç£ïŒãå€ãã»ã©çµå¶ã¯å®å®ããŠãããšã¿ãªãããšãã§ããŸãããããã¯ãæµåè² åµïŒ1 幎以å ã«è¿æžæéãæ¥ãè² åµïŒã«å¯Ÿããæµåè³ç£ã®æ¯çã瀺ããæµåæ¯çããäœããšãååãªè¿æžè³éãæºåãããŠããªãç¶æ ã«ãããããããªè³éç¹°ãã®æªåã§ãåç£ãã確çãé«ããšå€æã§ããã®ã§ãã
æçèšç®æžïŒäŒç€Ÿã®å©çãã©ãã»ã©ããã®ããããã
æçèšç®æžã¯ãåçããè²»çšãå·®ãåŒããå©çãç€ºãæžé¡ã§ããè±èªã® Profit and Loss Statement ãç¥ããŠãP/LããšãåŒã°ããŸãã1 幎éã®çµå¶æçžŸã衚ããã®ã§ãäŒç€Ÿã®å£²äžãã©ãã ããããäœã«è²»çšã䜿ã£ãŠããããå²ãã£ãã®ãïŒæ®ã£ãŠããã®ãïŒãããããŸãã
æçèšç®è¡šã«ãããå©çã«ã¯ãã売äžç·å©çããå¶æ¥å©çããçµåžžå©çããçšåŒååœæçŽå©çããåœæçŽå©çãã® 5 ã€ããããŸããç°¡åã«ãããšã売äžç·å©çã¯ç²å©ãå¶æ¥å©çã¯æ¬æ¥ã®å²ããçµåžžå©çã¯æ¬æ¥ä»¥å€ãå«ããå²ãã§ãããããŠãçšåŒååœæçŽå©çã¯ãã®æã«çŽããã¹ãçšéãæ¯æãåã®å©çé¡ãåœæçŽå©çã¯æ±ºç®æã®æçµçãªå©çã瀺ããŸãã
æçèšç®æžãèŠããšãã¯ããŸãã¯çµåžžå©çããã§ãã¯ããã®ãåºæ¬ã§ãã çµåžžå©çã¯æ¬æ¥ä»¥å€ã®éšåã®å©çãå«ãããäŒç€Ÿãäºæ¥å šäœã§åŸãå©çãæå³ããŸããããã«å¯ŸããçšåŒååœæçŽå©çãåœæçŽå©çã«ã¯ãåºå®è³ç£å£²åŽçãæè³æäŸ¡èšŒåžå£²åŽçãªã©ããã®æã«ã ãçºçããèšæçãªå©çïŒç¹å¥å©çïŒãå«ãŸããŸãããã®ãããåœæçŽå©çããã©ã¹ã§ãããã®æ°åãå®éã®çµå¶ç¶æ³ãåæ ããŠãããšã¯éããŸããã
ãŸããå¶æ¥å©çã倧ãããã°æ¬æ¥ãããŸããã£ãŠããããšãæå³ããããããããããžãã£ãã«è©äŸ¡ããããšãã§ããŸãã
ãã£ãã·ã¥ãããŒèšç®æžïŒäŒç€Ÿã®è³éã®æµããããã
ãã£ãã·ã¥ãããŒèšç®æžã¯ãè³éã®æµããææ¡ããæžé¡ã§ããC/Fããšç¥ãããŸããäŒç€ŸãæéŠããã©ã®ããã«ãéãåŸãŠã©ã®ããã«äœ¿ããææ«ã«ãããæ®ã£ãã®ããèšç®ããŠç€ºããŸãã
ãã£ãã·ã¥ãããŒèšç®æžã§ã¯ã幎床åäœãªã©ã®ããäžäŒèšæéã«ããããã£ãã·ã¥ã®å€åãããå¶æ¥æŽ»åã«ãããã£ãã·ã¥ãããŒããæè³æŽ»åã«ãããã£ãã·ã¥ãããŒããè²¡åæŽ»åã«ãããã£ãã·ã¥ãããŒãã® 3 ã€ã®æŽ»åå¥ã«åããŠè¡šç€ºãå¶æ¥æŽ»åã«ãããã£ãã·ã¥ãããŒã¯æ¬æ¥ã®å¶æ¥æŽ»åã«ãããã£ãã·ã¥ã®å¢æžããæè³æŽ»åã«ãããã£ãã·ã¥ãããŒã瀺ããŠããã®ã¯è³ééçšã«ãããã£ãã·ã¥ã®å¢æžã§ãããããŠãè²¡åæŽ»åã«ãããã£ãã·ã¥ãããŒã¯è³é調éãªã©è²¡å掻åã«ããããã£ãã·ã¥ã®å¢æžã瀺ããŸãã
äºæ¥ãçµå¶ããäžã§ã®ãéã®åããææ¡ããã°ãå©çãåºãŠããã®ã«ãã£ãã·ã¥ããªããªããšãã£ãç¶æ³ã«é¥ãããšãé²ãããšãå¯èœã§ããäŒç€Ÿçµå¶ã§ã¯æéå·®ãªã©ã®èŠå ã§ãå©çãšçŸéãé éãšã®ããã ã«ãããçããããšããããŸãããã£ãã·ã¥ãããŒèšç®æžãåç §ããªããåžžã«çµå¶ç¶æ³ãåæããŠããã°ãè³éã·ã§ãŒãã®é²æ¢ãéèæ©é¢ãªã©ããã®è³é調éã®åæ»åã«åœ¹ç«ãŠãããšãå¯èœã§ãã
ãªãã貞åå¯Ÿç §è¡šãšæçèšç®æžããã£ãã·ã¥ãããŒèšç®æžã¯äºãã«é£åãããã®ã§ããã3 ã€ãæ¯èŒããããšã§ãã詳现ãªè²¡ååæãå¯èœã«ãªããŸãã
äŒæ¥æé·ãå éããã BI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
財ååæã«ããã代衚ç㪠4 ã€ã®ææ³
ç·åçãªæå³ã§ã®è²¡ååæã¯ããã®ç®çã«ãã£ãŠãåçæ§åæããå®å šæ§åæããçç£æ§åæããæé·æ§åæãã® 4 çš®é¡ã«åé¡ã§ããŸããããããã©ã®ãããªåæãªã®ãã解説ããŸãã
åçæ§åæ
åçæ§åæãšã¯ãäŒç€Ÿãã©ãã ãå©çãäžããŠããã®ããèŠãåæææ³ã§ãã åçæ§ãé«ãã»ã©å©çãçã¿åºãåã匷ãããšã瀺ããŸãããéã®é¡ã倧äºã§ãããåçæ§åæã§ã¯ãããã«å¹çè¯ãå©çãäžããŠãããã«æ³šç®ããŠå€æãããŸããåçæ§åæã§ããçšããããã®ã¯ãã売äžé«ç·å©ççããã売äžé«å¶æ¥å©ççããšãã£ãææšã§ã
- 売äžé«ç·å©çç
売äžé«ç·å©ççã¯ç²å©çãšãåŒã°ããéåžžã«ãã䜿ãããŸãã売äžé«ãã売äžå䟡ãå·®ãåŒãããã®ã売äžç·å©çïŒç²å©ïŒã§ããã売äžé«ã«å¯Ÿãã売äžç·å©çã®æ¯çã売äžé«ç·å©ççã§ããèšç®åŒã¯æ¬¡ã®ãšããã§ãã
売äžé«ç·å©ççïŒïŒ ïŒïŒå£²äžç·å©ç÷売äžé«Ã100
æ°ãã€ãããã®ã¯ã売äžé«ç·å©ççã¯æ¥çš®ã«ãã£ãŠå€§ããå·®ãããããšãããã¯ãæ¥çš®ããšã«å£²äžå䟡ã®å²åãç°ãªãããã§ãããã®ããã売äžé«ç·å©ççãæ¯ã¹ããšãã¯ãåãæ¥çš®å士ã§èŠãã®ãäžè¬çã§ãã
- 売äžé«å¶æ¥å©ç
ç売äžé«å¶æ¥å©ççã¯ã売äžé«ã«å¯Ÿããå¶æ¥å©çã®æ¯çã衚ããŸããå¶æ¥å©çã¯äŒç€Ÿã®æ¬æ¥ã«ãã£ãŠåŸãå©çãªã®ã§ããã®æ°å€ãè¯ããã°ãæ¬æ¥ã§ã©ããããå¹ççã«å²ããŠããããããããŸããèšç®åŒã¯æ¬¡ã®ãšããã§ãã
売äžé«å¶æ¥å©ççïŒïŒ ïŒïŒå¶æ¥å©ç÷売äžé«Ã100
売äžé«å¶æ¥å©ççãã忥ä»ç€Ÿã§æ¯èŒããŠèŠãã¹ãææšã§ãã
å®å šæ§åæ
å®å šæ§åæã¯ãäŒç€Ÿã®çµå¶ã財åçã«å®å šãªã®ããèŠãåæææ³ã§ãã å®å šæ§ãšã¯ãåç£ãªã¹ã¯ãäœãä¿ãããŠããããšããããšã§ããããã®ããã«ã©ãã ããéã®æ¯æèœåãããããåæããŸãã
å®å šæ§åæã«ã¯ããŸããŸãªææšãçšããããŸãããããã§ã¯ãæµåæ¯çããšãèªå·±è³æ¬æ¯çãã«ã€ããŠã説æããŸãã
- æµåæ¯ç
æµåæ¯çã¯ãæµåè² åµã«å¯Ÿããæµåè³ç£ã®æ¯çã衚ããŸããæµåè² åµã¯ååãšããŠã1 幎以å ã«è¿æžããªããã°ãªããªãåµåã®ããšã§ããè²·æéãæªæéãæ¯ææåœ¢ãªã©ã該åœããŸãã äžæ¹ã®æµåè³ç£ã¯ã1 幎以å ã«çŸéåããããšãå¯èœãªè³ç£ã§ããçŸéé éãååæåœ¢ã売æéãªã©ã該åœããŸããèšç®åŒã¯æ¬¡ã®ãšããã§ãã
æµåæ¯çïŒïŒ ïŒïŒæµåè³ç£Ã·æµåè² åµÃ100
æµåè³ç£ã®é¡ãæµåè² åµã®é¡ãäžåã£ãŠããã°ãæµåæ¯ç㯠100ïŒ ãè¶ ããŸãããã®ãããåºæ¬çã«æµåæ¯çã 100ïŒ ä»¥äžã§ããã°ããã®äŒç€Ÿã¯å®å šãšããããšã«ãªããŸãã
- èªå·±è³æ¬æ¯ç
èªå·±è³æ¬æ¯çã¯ãè¿æžã®å¿ èŠããªãèªå·±è³æ¬ããç·è³æ¬ïŒèªå·±è³æ¬ïŒä»äººè³æ¬ïŒã«å¯ŸããŠã©ããããã®æ¯çãªã®ãã衚ããŸããèšç®åŒã¯æ¬¡ã®ãšããã§ãã
èªå·±è³æ¬æ¯çïŒïŒ ïŒïŒèªå·±è³æ¬Ã·ç·è³æ¬ïŒèªå·±è³æ¬ïŒä»äººè³æ¬ïŒÃ100
äžè¬çã«ãèªå·±è³æ¬æ¯çãé«ãã»ã©éèæ©é¢ãªã©ããã®èè³ãå°ãªãããšãæå³ããã®ã§ãçµå¶ãå®å®ããŠãããšå€æã§ããŸãã
çç£æ§åæ
çç£æ§åæã¯ãäŒæ¥ãä¿æããçµå¶è³æºïŒããã»ã¢ãã»ã«ãïŒãã©ãã ãå¹çè¯ã掻çšããŠããããèŠãææ³ã§ãã
çç£æ§ã¯ãæå ¥éãšç£åºéã®é¢ä¿æ§ã«ãã£ãŠæ±ºãŸããŸããäŸãã°ããã補åãäœãã®ã«ããããã¢ããã«ããã©ãã ã广çã«äœ¿ãããã®ãããçç£æ§ã®è¯ãæªããæ±ºãããã€ã³ãã§ãã ãŸããçç£æ§åæã§ã¯ãä»å 䟡å€ãšããèšèããã䜿ãããŸããä»å 䟡å€ãšã¯ãäŸãã°å€éšããä»å ¥ããåææã«ãäŒæ¥ç¬èªã®ç¹æ®æè¡ã«ããå å·¥ãªã©ãäœããä»å ããããšã§äŸ¡å€ãé«ããŠè²©å£²ããå©çãäžããããšãæããŸãã
çç£æ§åæã¯ãäž»ã«èªç€Ÿã®çµå¶ç¶æ ãææ¡ããããã«çšããããŸããããç¥ãããŠããææšãšããŠã¯ããç©ççç£æ§ããšãä»å 䟡å€çç£æ§ãããããŸãã
- ç©ççç£æ§
ç©ççç£æ§ã¯ãçç£ããéã倧ãããéããªã©ã®ç©ççã«èšæž¬å¯èœãªãã®ãææç©ãšããŠèšç®ããææšã§ããåŽåè 1 人ãããã®ç©ççç£æ§ãšã1 æéãããã®ç©ççç£æ§ã¯ã次ã®èšç®åŒã§æ±ããŸãã
1 人ãããã®ç©ççç£æ§ïŒçç£é÷åŽåè æ°
1 æéãããã®ç©ççç£æ§ïŒçç£é÷ïŒåŽåè æ°ÃåŽåæéïŒ
- ä»å 䟡å€åŽåçç£æ§
ä»å 䟡å€åŽåçç£æ§ã¯ãä»å 䟡å€ãææç©ãšããŠèšç®ããææšã§ããåŽåè 1 人ãããã®ä»å 䟡å€çç£æ§ãš 1 æéãããã®ä»å 䟡å€çç£æ§ã¯ã次ã®èšç®åŒã§æ±ããŸãã
1 人ãããã®ä»å 䟡å€çç£æ§ïŒä»å 䟡å€é¡Ã·åŽåè æ°
1 æéãããã®ä»å 䟡å€çç£æ§ïŒä»å 䟡å€é¡Ã·ïŒåŽåè æ°ÃåŽåæéïŒ
æé·æ§åæ
æé·æ§åæã¯ãäŒç€ŸããããŸã§ã©ã®ããã«æé·ããŠããã®ããèŠãææ³ã§ãã äŒç€Ÿã®æé·ãšã¯ã売äžé«ãå©çãæéã®çµéãšãšãã«é 調ã«äŒžã³ãŠãããã©ãããšããããšã«å ããåŸãããå©çãããšã«æ°ããªååéçºãèšåå°å ¥ããããã®æè³ã«ãã£ãŠããã«å£²äžé«ãå©çã䌞ã°ãããšãæããŸããæé·æ§åæã§ã¯ããã®ãããªãµã€ã¯ã«ãäœãããŠãããã©ãããçç®ç¹ãšãªããŸãã ãã䜿ãããææšã¯ããå¢åçïŒå£²äžé«äŒžã³çïŒããšãå¢ççïŒçµåžžå©ç䌞ã³çïŒãã§ãã
- å¢åçïŒå£²äžé«äŒžã³çïŒ
å¢åçã¯ãåæãšæ¯ã¹ãŠåœæã®å£²äžé«ãã©ãã ã䌞ã³ãã®ããç€ºãææšã§ããèšç®åŒã¯æ¬¡ã®ãšããã§ãã
å¢åçïŒïŒ ïŒïŒïŒåœæå£²äžé«ïŒåæå£²äžé«ïŒÃ·åæå£²äžé«Ã100
- å¢ççïŒçµåžžå©ç䌞ã³çïŒ
å¢ççã¯ãåæãšæ¯ã¹ãŠåœæã®çµåžžå©çãã©ãã ã䌞ã³ãã®ããç€ºãææšã§ããèšç®åŒã¯æ¬¡ã®ãšããã§ãã
å¢ççïŒïŒ ïŒïŒïŒåœæçµåžžå©çïŒåæçµåžžå©çïŒÃ·åæçµåžžå©çÃ100
ããŒã¿ãå¯èŠåããŠããžãã¹ãå éïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
Tableau ã§å§ãã財ååæã§ãæ°ããªã€ã³ãµã€ããåŸã
財å諞衚ã¯å é£ç·ç倧è£ãžã®æåºã矩åã¥ããããŠããããäœæãããã®ã§ã¯ãªããæ¬æ¥ã¯äŒç€Ÿã®çµå¶å€æã«åœ¹ç«ã€éèŠãªæ å ±ãåŸãããã®è³æã§ãã
BI ãã©ãããã©ãŒã ã§ãã Tableau ã䜿ããšã財ååæã«ãã£ãŠæ¬æ¥ã®ç®çã«æ²¿ã£ãã€ã³ãµã€ããåŸãããããã«ãªããŸããäŸãã°ã財åäžè¡šã®è²žåå¯Ÿç §è¡šãæçèšç®æžããã£ãã·ã¥ãããŒèšç®æžãã垳祚ã§ã¯ãªã Tableau ã®ããã·ã¥ããŒãã§èŠãããã«ããã°ãç°ãªã軞ã§éèšããããè€æ°ã®ããŒã¿ãœãŒã¹ããæ°åãåŸãããæ°ã«ãªãæ°åãããªã«ããŠã³ïŒå€§ãŸããªéèšãããã詳现ãªéèšãžãšæãäžããããšïŒããããšãã£ãæäœããæå ã§ç°¡åã«è¡ããªããããŒã¿ã確èªããããšãã§ããŸãã Tableau ã®ããã·ã¥ããŒãã§å¯èŠåããã財ååæã«ããã衚ããã§ã¯èªã¿åãã«ããã£ãçµå¶ç¶æ³ãææ¡ããæ°ããªã€ã³ãµã€ããåŸãããå¯èœæ§ãåºããã®ã§ãã
ãŸãã財ååæã§ã¯ãæ¬èšäºã§ãµãããã®ä»¥å€ã«ããããŸããŸãªçš®é¡ã®ææšãååšããŸããããžãã¹ã®æææ±ºå®ã«äœ¿çšããããã®ãšããŠã¯ãäŸãã°æ¬¡ã®ãããªææšãæããããŸãã
財ååæã«å©çšãããææšã®äŸ
- ROAïŒç·è³ç£å©ççïŒïŒåœæçŽå©ç÷ç·è³ç£
- ROEïŒèªå·±è³æ¬å©ççïŒïŒåœæçŽå©ç÷èªå·±è³æ¬
- 財åã¬ãã¬ããžïŒç·è³æ¬Ã·èªå·±è³æ¬
- ç·è³ç£å転çïŒå£²äžé«Ã·ç·è³ç£
- æçåå²ç¹ïŒåºå®è²»Ã·éçå©çç
- 売äžé«å©ççïŒåœæçŽå©ç÷売äžé«
- EPSïŒ1 æ ªãããå©çïŒïŒåœæçŽå©ç÷çºè¡æžæ ªåŒç·æ°
- PBRïŒæ ªäŸ¡çŽè³ç£åçïŒïŒæ ªäŸ¡Ã·1 æ ªãããã®çŽè³ç£
- PERïŒæ ªäŸ¡åççïŒïŒæ ªäŸ¡Ã·1 æ ªãããã®å©ç
ãããã®èšç®åŒã¯ããã¹ãŠç¹å®ã®ãã©ã¡ãŒã¿ãŒãå¥ã®ãã©ã¡ãŒã¿ãŒã§å²ãããšã§æç«ããŠããŸãããããã£ãŠãå¿ èŠãªãã©ã¡ãŒã¿ãŒãåžžã«ããŒã¿ãšã㊠Tableau ã«ååŸããä»çµã¿ãæŽããŠããã°ããã€ã§ã奜ããªã¿ã€ãã³ã°ã§æ¯çåæãè¡ãããã®çµæã Tableau ã®ããã·ã¥ããŒãã§èŠãããšãã§ããã®ã§ãã
ããŒã¿ãå¯èŠåããŠããžãã¹ãå éïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
Tableau ã§å®æŠçãªè²¡ååæãè¡ãã
äŒæ¥ã®çµå¶ç¶æ ãåé¡ç¹ãå ·äœçã«ææ¡ããããã«ã財ååæã®éèŠæ§ã¯ä»¥åããã倧ããªãã®ã«ãªã£ãŠããŸãã
äŒç€Ÿã®è³ç£ãè² åµãæçããã£ãã·ã¥ãããŒãªã©ã®ç¶æ³ãå¿ èŠãªãšãã«ããã«ç¢ºèªããããšããããããŸããŸãªè§åºŠããåæããŒã¿ãåç §ããããšãæ±ããããŸãã
Tableau ãæŽ»çšããã°ãå¿ èŠãªããŒã¿ãçŽ æ©ãåã蟌ã¿ãã°ã©ããªã©ã®ããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ã«ãã£ãŠè²¡ååæçµæãå¯èŠåã財ååæãä»ããããã£ãšèº«è¿ãªãã®ãšããŠåãæ±ããããŸããŸãªã·ãŒã³ã§æŽ»çšããããšãå¯èœã«ãªãã§ãããã
Tableau ã¯ãåœå å€ã®å€ãã®äŒæ¥ã«å°å ¥ããã倿§ãªããžãã¹ã«æŽ»çšãããŠãã BI ãã©ãããã©ãŒã ã§ãããŸããç¡æãã©ã€ã¢ã«ããã¹ã¿ãŒããããæ¹ã¯ããã¡ããã詳现ãã確èªãã ããã
ããŒã¿ãå¯èŠåããŠããžãã¹ãå éïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«