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

  • Establishing an interface through the parallel application of CDC, ETL, and EAI as a series of processes for extracting, cleaning, transforming, transmitting, and loading source data required for analysis and utilization.

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 (SOR) area that serves as the basis for enterprise information analysis, and a Source Integration area that integrates process-centric source data from an analysis and 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

Establishing a company-wide One Source, One BI system

  • Integrated management of enterprise-wide BI-related data and content through a DW Appliance (increased scalability, improved ETL/query performance, reduced TCO, simplified internal interface, and streamlined 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 analysis and utilization needs by hierarchy and function

  • Secure enhanced Data Marts specialized by analysis/utilization purpose, function, and user layer

  • Building a model that facilitates flexible linkage analysis between summary information and source information, and intelligent cause analysis.

  • Building a DM that facilitates the development of 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

Improving information utilization by providing user-specific information through the BI Portal

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

  • Enhanced multidimensional analysis capabilities, early detection and response to risks through future forecasting/simulation

  • Linked inquiry of summaries and details for each KPI item across the entire company and by 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