www olap co kr OLAP SW Package q
- Slides: 43
올랩컨설팅 www. olap. co. kr
주요 사업 분야 OLAP S/W와 Package 판매/ 기술지원 q. OLAP(DW/DM)부문 : Comshare Decision, Decision. Web, Essbase, SQL Server 2000 Analysis Services 등 q예산/재무/손익관리 부문 : MPC(Management Planning & Control), FDC(Financial Data Consolidation), Budget Plus 등 q MPC(Management Planning&Control) System 컨설팅 및 구축 컨설팅/ 기술지원 q OLAP Consulting Service, Data Warehouse 및 Data Mart 구축 q Specialized & Packaged Application Solution 제공 (DSS, EIS, 정원관리, EVA(경제적 투자가치 분석), BSC(Balanced Score Card)관리, 성과측정관리, OLAP/ 제품교육 q 상설 교육, On-Site 교육 q Workshop, 정기 Seminar 실시
급격한 환경의 변화 “In a time of turbulence and change it is more clear than ever that knowledge is power. ” John F. Kennedy
정보 처리? u Not data as it is !! u Informational Processing? u Turning data into information u Turning information into decision/strategy 경쟁력 있는 비즈니스 의사결정은 정보와 그 정 보를 비즈니스 문제점에 적용할 수 있는 지식 이 있을 때 가능
프로젝트 조직 Project Manager Steering Committee 현업(2명) IT-SM(5명) IT-SI(2명) Consulting(2명)
시스템 구성도 SQL Server OLTP Facts Dimensions DSA Analysis Services Cube Excel DTS Decision App Server Decision Desktop ERP Server EIS Server Client • • • 200 Mhz이상 • Windows 98/2000 HP 9000/K 260 UNIX Oracle 7. 3. 3 BPCS 6. 0. 04 Compaq Proliant ML 570 R XN/700 Windows 2000 Server SQL Server 2000 Decision App Server • Decision Desktop
추진경과 TASK ’ 00. 11 ’ 01. 03 ’ 00. 05 ’ 01. 07 q D/W Planning q D/W 설계 q D/W 구축 및 Test q Olap 설계 ERP Open q Olap 구축 및 Test q 통합 테스트 q 사용자 교육/Open ’ 01. 09
시스템 구성도 Legacy 시스템 Data Warehouse Server (COMPAQ ML 5700) End Users DW Server UNIX 4. 2. 3 ORACLE 7. 2. 3 Windows 2000 SQL Server 2000 Analysis Services i. Transform 데이터 추출 ERP시스템 Comshare Decision § 다차원 분석 Comshare Application Server Cube의 생성 및 관리 Enterprise Server (COMPAQ ML 5700) Windows 2000 SQL Server (HAL) Enterprise Server Windows 2000 SQL Server 2000 Data Interface Web. Server Allocation Consolidation Insight § CEO용 리포팅 툴
- Sas olap cube studio
- Olap security
- Dss warehouse
- Oltp and olap in sql
- Perbedaan oltp dan olap
- Goal of olap
- Data warehouse and olap technology
- Olap kocka
- Olap in data mining
- Oltp cube
- Microsoft azure olap
- Olap
- Oltp vs olap
- Olap in mis
- An overview of data warehousing and olap technology
- Olap operations example
- Apa itu olap
- Olap
- Olap applications
- Olap
- Olap stand for
- Budget vs forecast
- Snowflake oltp or olap
- Olap x oltp
- Olap business objects
- Holap in data warehouse
- An overview of data warehousing and olap technology
- Molap vs rolap
- Data warehousing and online analytical processing
- Olap functions
- Crm data warehouse models
- Olap
- Dss data warehouse
- Business objects olap
- Dmql
- Data warehouse and olap technology
- Olap facts and dimensions
- Olap pentaho
- Olap vs oltp in data mining
- Dw olap
- Is olap dead
- Banco de dados olap
- Characteristics of olap
- Oltp dw