top of page
Consulting

BI & DW Consulting

BI refers to the processes, applications, and technologies that transform raw, enterprise-wide data into actionable intelligence. By collecting, storing, and analyzing information, BI provides the critical insights necessary to support faster and more accurate business decision-making

​

The latest trend in BI is toward more advanced systems with enhanced capabilities, including:

  • Speed and Scale: Incorporating real-time analytics and In-Memory technology to rapidly analyze massive datasets.

  • Expanded Data Sources: Moving beyond the traditional analysis of internal, structured data to integrate external and unstructured Big Data.

  • Advanced Capabilities: Enabling high-level functions such as predictive business management and detailed root cause analysis

Openmade Consulting BI & DW Consulting
BI_DW_eng.png

Defining the construction area

Data I/F

  • A series of processes to extract/refin/convert/transfer/load the raw data required for analysis/utilization perspectives, building I/F through parallel application of CDC/ETL/EAI

RDW

  • Load real-time analysis/utilization-based data into the RDW area to generate breaking news metrics and support tracking/detection activities for real-time marketing events.

  • Support for immediate response to customer/site changes through provision of real-time information

ADW

  • It consists of a source data collection area (SOR) that serves as the basis for analyzing the warrior information and a source integration area that integrates process-oriented source data from an analysis/utilization perspective.

DM

  • Composition of primary aggregate information (Dimension, Fact) that is easy to expand the analysis perspective centered on the business entity

  • Support for specialized purpose marts by level/function based on primary aggregate information

BI Portal

  • Classify analysis/utilization requirements by user level (management/administrator/field worker/advanced analyst, etc.) and provide optimized content accordingly.

  • Apply the optimal BI utilization tool according to the user's work characteristics and usage behavior.

  • Providing Advanced BI based on Big Data to existing BI

Appliance for Big Data

  • Securing a foundation for collection/processing/analysis of structured/semi-structured/unstructured data through introduction of a Big Data standard platform

  • Expanding the scope of analysis possible through Big Data compared to existing ones (e.g., deriving approval/rejection factor analysis from simple result-centered, supporting VOC analysis)

  • Support for building Advanced BI for strengthening Big Data-based marketing, improving advanced analysis, and predictive management

BI advancement trend

Building a One Source, One BI System for Warriors

  • Integrated management of enterprise BI-related data and content management with DW Appliance (↑ scalability, ETL/query performance, ↓ TCO, simplification of internal I/F, simplification of operational management)

Expand to real-time analysis / utilization-based BI

  • Obtaining the foundational information for real-time breaking news and real-time marketing support

  • Immediate detection and response to customer/market/site changes based on accumulated real-time information

  • Mobile BI Support

Providing differentiated DM information considering hierarchical / functional analysis / utilization needs

  • Strengthening of Data Mart specialized for analysis/utilization purposes, functions, and user groups

  • Build a model that facilitates flexible link analysis and intelligent cause analysis between summary information and source information

  • Building a DM that is easy to develop analysis/utilization content

  • Diversification of analysis/utilization content

Diversification of analysis / utilization content

  • Expanding the scope of analysis/utilization through Big Data linkage

  • Support for new business creation through expansion of data analysis/utilization areas to include Big Data

Improve information utilization by providing customized information to each user through BI Portal

  • Providing differentiated information tailored to the needs of each level/department

  • Strengthening multidimensional analysis capabilities, early detection and response to risks through future prediction/simulation

  • Linked inquiry of summary and detailed information for each KPI item of the company and department

Establishing a permanent governance management system

  • Providing governance-based enterprise-wide standard information/data/content/security management functions and strengthening the management system (monitoring)

  • Ensure up-to-dateness and consistency of BI-related data and content through continuous governance management

  • Standardization and constant updating of divisional and divisional cadastral information

  • 100% utilization of registration reports through LifeCycle management

bottom of page