RAW 데이터 구조화
- 시우 이
- 2023년 4월 1일
- 2분 분량
1. 미관리 RAW 데이터 파일 전수 정리
기준없이 상황마다 제작한 RAW 데이터 파일 전수 점검 및 담당자 인터뷰, 필요한 주요 지표 정의 및 데이터 트리 기획
2. RAW DB 테이블 정리 및 시각화 대시보드 구현
불필요한 중복 데이터 제거 및 필수 주요 지표 정의, 휴먼 에러 및 리소스 과다 투입 방지를 위한 혼합 소스 구현
/*! elementor - v3.18.0 - 20-12-2023 */ .elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img<src$ .svg=".svg"></src$>{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}
시각화 대시보드 구현 (일부)
<관련 포스팅>
.elementor-84451 .elementor-element.elementor-element-d5b0262 > .elementor-container{min-height:130px;}.elementor-84451 .elementor-element.elementor-element-d5b0262 > .elementor-container > .elementor-column > .elementor-widget-wrap{align-content:flex-start;align-items:flex-start;}.elementor-84451 .elementor-element.elementor-element-d5b0262{border-style:solid;border-width:0px 0px 1px 0px;border-color:var( --e-global-color-d22eb49 );transition:background 0.3s, border 0.3s, border-radius 0.3s, box-shadow 0.3s;padding:20px 10px 20px 10px;}.elementor-84451 .elementor-element.elementor-element-d5b0262 > .elementor-background-overlay{transition:background 0.3s, border-radius 0.3s, opacity 0.3s;}.elementor-bc-flex-widget .elementor-84451 .elementor-element.elementor-element-f131262.elementor-column .elementor-widget-wrap{align-items:center;}.elementor-84451 .elementor-element.elementor-element-f131262.elementor-column.elementor-element<data-element_type column="column"></data-element_type> > .elementor-widget-wrap.elementor-element-populated{align-content:center;align-items:center;}.elementor-84451 .elementor-element.elementor-element-f131262.elementor-column > .elementor-widget-wrap{justify-content:flex-start;}.elementor-84451 .elementor-element.elementor-element-ef5e507 img{width:120px;max-width:120px;height:120px;object-fit:cover;object-position:center center;}.elementor-84451 .elementor-element.elementor-element-ef5e507{width:auto;max-width:auto;top:5px;}body:not(.rtl) .elementor-84451 .elementor-element.elementor-element-ef5e507{left:20px;}body.rtl .elementor-84451 .elementor-element.elementor-element-ef5e507{right:20px;}.elementor-84451 .elementor-element.elementor-element-7867502{--spacer-size:10px;width:var( --container-widget-width, 137px );max-width:137px;--container-widget-width:137px;--container-widget-flex-grow:0;}.elementor-84451 .elementor-element.elementor-element-3d22483 .jet-listing-dynamic-terms{text-align:left;}.elementor-84451 .elementor-element.elementor-element-3d22483 .jet-listing-dynamic-terms__link{font-size:13px;font-weight:500;line-height:1em;letter-spacing:-0.2px;background-color:var( --e-global-color-a2103d7 );color:var( --e-global-color-44833865 );padding:5px 5px 5px 5px;border-radius:3px 3px 3px 3px;}.elementor-84451 .elementor-element.elementor-element-3d22483 .jet-listing-dynamic-terms__delimiter{font-size:15px;margin-left:0px;margin-right:4px;}.elementor-84451 .elementor-element.elementor-element-3d22483 > .elementor-widget-container{margin:0px 5px 3px 0px;padding:0px 0px 0px 20px;}.elementor-84451 .elementor-element.elementor-element-3d22483{width:auto;max-width:auto;}.elementor-84451 .elementor-element.elementor-element-77fb91e .jet-listing-dynamic-terms{text-align:left;}.elementor-84451 .elementor-element.elementor-element-77fb91e .jet-listing-dynamic-terms__link{font-size:13px;font-weight:500;line-height:1em;letter-spacing:-0.2px;background-color:var( --e-global-color-primary );color:#FFFFFF;padding:5px 5px 5px 5px;border-radius:3px 3px 3px 3px;}.elementor-84451 .elementor-element.elementor-element-77fb91e .jet-listing-dynamic-terms__delimiter{font-size:15px;margin-left:0px;margin-right:4px;}.elementor-84451 .elementor-element.elementor-element-77fb91e > .elementor-widget-container{margin:0px 5px 3px 0px;padding:0px 0px 0px 0px;}.elementor-84451 .elementor-element.elementor-element-77fb91e{width:auto;max-width:auto;}.elementor-84451 .elementor-element.elementor-element-0fd8c45 .jet-listing-dynamic-terms{text-align:left;}.elementor-84451 .elementor-element.elementor-element-0fd8c45 .jet-listing-dynamic-terms__link{font-size:13px;font-weight:500;line-height:1em;letter-spacing:-0.2px;background-color:var( --e-global-color-a2103d7 );color:var( --e-global-color-44833865 );padding:5px 5px 5px 5px;border-radius:3px 3px 3px 3px;}.elementor-84451 .elementor-element.elementor-element-0fd8c45 .jet-listing-dynamic-terms__delimiter{font-size:15px;margin-left:0px;margin-right:4px;}.elementor-84451 .elementor-element.elementor-element-0fd8c45 > .elementor-widget-container{margin:0px 5px 3px 0px;padding:0px 0px 0px 20px;}.elementor-84451 .elementor-element.elementor-element-0fd8c45{width:auto;max-width:auto;}.elementor-84451 .elementor-element.elementor-element-01fa633 .jet-listing-dynamic-terms{text-align:left;}.elementor-84451 .elementor-element.elementor-element-01fa633 .jet-listing-dynamic-terms__link{font-size:13px;font-weight:500;line-height:1em;letter-spacing:-0.2px;background-color:var( --e-global-color-primary );color:var( --e-global-color-44833865 );padding:5px 5px 5px 5px;border-radius:3px 3px 3px 3px;}.elementor-84451 .elementor-element.elementor-element-01fa633 .jet-listing-dynamic-terms__delimiter{font-size:15px;margin-left:0px;margin-right:4px;}.elementor-84451 .elementor-element.elementor-element-01fa633 > .elementor-widget-container{margin:0px 5px 3px 0px;padding:0px 0px 0px 0px;}.elementor-84451 .elementor-element.elementor-element-01fa633{width:auto;max-width:auto;}.elementor-84451 .elementor-element.elementor-element-9bb614d .elementor-heading-title{color:var( --e-global-color-primary );font-size:20px;font-weight:700;line-height:1.4em;letter-spacing:-1px;}.elementor-84451 .elementor-element.elementor-element-9bb614d > .elementor-widget-container{margin:7px 0px 3px 156px;}.elementor-84451 .elementor-element.elementor-element-bffa956 .elementor-heading-title{color:var( --e-global-color-text );font-size:16px;font-weight:300;line-height:1.2em;letter-spacing:-1px;}.elementor-84451 .elementor-element.elementor-element-bffa956 > .elementor-widget-container{margin:0px 0px 0px 156px;}.elementor-84451 .elementor-element.elementor-element-4ab11e5{--spacer-size:10px;}.jet-listing-item.single-jet-engine.elementor-page-84451 > .elementor{width:600px;margin-left:auto;margin-right:auto;}@media(max-width:767px){.elementor-84451 .elementor-element.elementor-element-d5b0262 > .elementor-container{min-height:111px;}.elementor-84451 .elementor-element.elementor-element-d5b0262{border-width:0px 0px 1px 0px;padding:8px 5px 8px 5px;}.elementor-84451 .elementor-element.elementor-element-ef5e507 img{width:90px;max-width:90px;height:90px;border-radius:0px 0px 0px 0px;}body:not(.rtl) .elementor-84451 .elementor-element.elementor-element-ef5e507{left:0px;}body.rtl .elementor-84451 .elementor-element.elementor-element-ef5e507{right:0px;}.elementor-84451 .elementor-element.elementor-element-ef5e507{top:12px;}.elementor-84451 .elementor-element.elementor-element-7867502{--spacer-size:10px;--container-widget-width:104px;--container-widget-flex-grow:0;width:var( --container-widget-width, 104px );max-width:104px;}.elementor-84451 .elementor-element.elementor-element-3d22483 .jet-listing-dynamic-terms__link{font-size:11px;letter-spacing:-0.1px;border-radius:3px 3px 3px 3px;}.elementor-84451 .elementor-element.elementor-element-3d22483 .jet-listing-dynamic-terms__delimiter{font-size:15px;}.elementor-84451 .elementor-element.elementor-element-3d22483 > .elementor-widget-container{margin:10px 0px 0px 5px;padding:0px 0px 6px 0px;}.elementor-84451 .elementor-element.elementor-element-77fb91e .jet-listing-dynamic-terms__link{font-size:11px;letter-spacing:-0.1px;border-radius:3px 3px 3px 3px;}.elementor-84451 .elementor-element.elementor-element-77fb91e .jet-listing-dynamic-terms__delimiter{font-size:15px;}.elementor-84451 .elementor-element.elementor-element-77fb91e > .elementor-widget-container{margin:10px 0px 0px 5px;padding:0px 0px 6px 0px;}.elementor-84451 .elementor-element.elementor-element-0fd8c45 .jet-listing-dynamic-terms__link{font-size:11px;letter-spacing:-0.1px;border-radius:3px 3px 3px 3px;}.elementor-84451 .elementor-element.elementor-element-0fd8c45 .jet-listing-dynamic-terms__delimiter{font-size:15px;}.elementor-84451 .elementor-element.elementor-element-0fd8c45 > .elementor-widget-container{margin:10px 0px 0px 5px;padding:0px 0px 6px 0px;}.elementor-84451 .elementor-element.elementor-element-01fa633 .jet-listing-dynamic-terms__link{font-size:11px;letter-spacing:-0.1px;border-radius:3px 3px 3px 3px;}.elementor-84451 .elementor-element.elementor-element-01fa633 .jet-listing-dynamic-terms__delimiter{font-size:15px;}.elementor-84451 .elementor-element.elementor-element-01fa633 > .elementor-widget-container{margin:10px 0px 0px 5px;padding:0px 0px 6px 0px;}.elementor-84451 .elementor-element.elementor-element-9bb614d .elementor-heading-title{font-size:13.5px;line-height:1.35em;letter-spacing:-1px;}.elementor-84451 .elementor-element.elementor-element-9bb614d > .elementor-widget-container{margin:0px 10px 5px 109px;}.elementor-84451 .elementor-element.elementor-element-bffa956 .elementor-heading-title{font-size:12px;line-height:1.4em;letter-spacing:-1px;}.elementor-84451 .elementor-element.elementor-element-bffa956 > .elementor-widget-container{margin:0px 10px 0px 109px;}}
/*! elementor - v3.18.0 - 20-12-2023 */ .elementor-column .elementor-spacer-inner{height:var(--spacer-size)}.e-con{--container-widget-width:100%}.e-con-inner>.elementor-widget-spacer,.e-con>.elementor-widget-spacer{width:var(--container-widget-width,var(--spacer-size));--align-self:var(--container-widget-align-self,initial);--flex-shrink:0}.e-con-inner>.elementor-widget-spacer>.elementor-widget-container,.e-con>.elementor-widget-spacer>.elementor-widget-container{height:100%;width:100%}.e-con-inner>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer,.e-con>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer{height:100%}.e-con-inner>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer>.elementor-spacer-inner,.e-con>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer>.elementor-spacer-inner{height:var(--container-widget-height,var(--spacer-size))}.e-con-inner>.elementor-widget-spacer.elementor-widget-empty,.e-con>.elementor-widget-spacer.elementor-widget-empty{position:relative;min-height:22px;min-width:22px}.e-con-inner>.elementor-widget-spacer.elementor-widget-empty .elementor-widget-empty-icon,.e-con>.elementor-widget-spacer.elementor-widget-empty .elementor-widget-empty-icon{position:absolute;top:0;bottom:0;left:0;right:0;margin:auto;padding:0;width:22px;height:22px}
댓글