BI STRATEGY FRAMEWORK

BI STRATEGY

FRAMEWORK

Organizations have been investing and building their information

infrastructure and thereby accounting to massive amount of data. Now with the advent of Smart Phones, Social Media, RFID, NFT, IOT and other technologies, the amount, variety and frequency of data that is being captured has grown in gamut propositions.

There is new found sense of Deja vu of the massive Data not actually aiding into insightful business decision.

It is not about massive data alone, it is also about departmentalization of data and tools that has resulted in silos of information. This is causing difficulty in reconciliation, complex to comprehend, and limited in their ability to provide the needed insight.

Overview

In SMEs, executives and business users often Internal IT/MIS teams need external help to meet only have a very limited, static view of BI that is the ever changing & growing business

a set of reports that are produced from the requirements for cutting edge technology support data warehouse by the BI team. They are often for better insights. The other manifold challenge not aware of the information hidden in the is related to leveraging the existing investments in data warehouse and their data warehouses do terms of Hardware, Software & Applications.

not accommodate internal analog data.

Utilizing new features while assuring existing baseline At ITC Infotech we have defined the BI maturity functionality makes such re-architecture a fairly of a company in 4 steps and they are governed complex task for internal IT teams to achieve. In by 4 A’s namely Aware, Analyze, Adept and general, migration and upgrade is governed by re- Avant-garde – which are the Information architecture incorporating performance

maturity levels. Most organizations today find optimization and business requirement pipeline.

themselves at the Strategic level where they

The other challenge is about who owns the data have BI giving those actionable insights into

and governing the data in terms of quality;

data. However, to sustain and grow in the long

ownership becomes critical as the Software run becomes a challenge. The companies often

applications grow beyond manageable do not know how to transition from Strategic

propositions.

to Visionary state. Some companies are not even aware of new trends and they tend to lag behind their competitors in terms of implementing the same. In today’s new age decision making, there is a lot of 3rd party information, supplier, vendors, government data, online data,

economic trends, analyst trends, surveys, industry body sponsored reports that companies try to analyze to derive insights.

Outside-In perspective

Fundamental

! Spreadsheets and SQL Queries

! Manual retrieval &

Reconciliation issues

! Long Processing time &

lack of adaptability to change quickly

Tactical

! Improved BI adoption

! Departmentalized BI adoption

! No Strategic BI vision

! Reactive reporting and basic

Dashboards

Strategic

! Business Outcome based BI

! Enterprise Data Warehouse

! SvoC & Master data

! Dashboards/Reports

& Alerts

! Prediction &

Forecasting, What-if analysis

Visionary

! Integration with Semi/Un Structured data

! Real time decisions

! Enable Outcome based decision

! Statistical Analytics &

Model (Prescriptive Analytics)

Aiding better business decisions

Aware

Analyze

Adept

Avant-garde

High

With increasing competition, the time to market for products has become shorter. Higher demand for more integrated and timelier reporting of Sales, Customer information across brand, Channel and market has become the norm of the day. There are many questions that departments have to answer for various stakeholders.

Simple KPI’s for real-time integration and streaming analytics requires technical impact.

With massive amount of data and silos of knowledge, deriving insights at an organization level becomes a tough task. Every organization tries to find the right balance between Business Process, Tool & Data.

! Unified BI solutions

! Collaboration between departments

! Reduction in BI shelf ware

! Leverage existing solutions

! Reduce Operational Cost and Improve ROI For any organization to implement enterprise-wide BI properly and cost-effectively, it needs to follow a

BI strategy. The strategy documents the long-term plan of choices to achieve its goals, taking the anticipated environment into account. It covers how to make effective use of BI technology and best practices to improve BI implementation, in order to support the business strategy and goals and to provide the required information for decision-makers a tall levels of the organization.

How do I increase my Customer sentiment

and intern reduce my churn?

Different definitions used

across the business

What is the overall status of the company ?

Are there any unknown facts that are likely to

be causing an issue?

How to derive insight from Unstructured

data?

Reliance on Excel and manual

processes to produce data

Data does not reconcile. How good is my data?

How do we realize the ROI for the tools invested?

Consolidation Optimization

Adoption

Optimal Balance

Process

BICC Governance Re-engineering No real-time

insights from the dashboard?

Are we using the right tools to stay competitive in

the market place?

Cost Optimization

Performance Improvement

Quality Consolidation

Integration

Tools

Data

The relative measure of value of the respective The BI Strategy in an Organization evolves as BI BI initiatives comes from actual usage statistics: matures over a period of time. The Framework will the number of users, their positions and actual help organizations in defining their BI Roadmap information usage (number of accesses, and their implementation timelines, to accomplish amount of data reported, and number of Best Practices and Guiding Principles based reports actually used and how frequently). Information Model that can enable current and

future business models – The Right Way Forward On the BI and analytics journey, it is important

“BI Strategy”.

to define an overarching strategy that can help

deliver BI capabilities that align and support ITC Infotech teams ensure well planned execution the implementation of the business decisions. of reverse knowledge transition to client IT teams

for ongoing support.

The ITC Infotech BI Strategy Framework addresses infrastructure for the whole data warehouse environment, as well as the tool sets for data integration and ETL, data discovery, reporting, dashboards and various types of analytics, data quality & metadata management, and more.

ITC Infotech Framework

Strong Sponsor

Data Capture

& Storage

Data Information

& Accuracy

Software &

Hardware utilization BI adoption

& usage Alignment to

Corporate Strategy Data Model

& KPI’s Definitions Current IM

& Gaps Data Governance

Integration for source

systems

Key

Considerations

The framework proposes to use the following 4 step approach to define a BI road map that would ensure that information is accessible and consumable by the business. This framework has can be scalable in case of critical success factors not met, by reverse engineering the required artefacts required for defining a roadmap.

include governance & policies, systems and

Benefits:

processes, support organization.

! Detailed BI roadmap for stakeholder buy-in

! Resource roles and responsibilities and to enable quick business value and to

make better informed decisions ! Risks & Assumptions

! Focus on Initiatives that drive greater ! Process Definition Methodology business value

! Tool Rationalization/Recommendations and

! Provide Architecture decisions that enable Benefits analytical capabilities and scalable to adapt

! Existing BI reports & Dashboard inventory and newer technologies

Rationalization plan

! Leveraging existing infrastructure to

! Multi year roadmap with clear demarcation of determine the scalability and performance

short and long term goals & Objectives against real-world usage scenarios and loads

! Information Governance Framework Covering

! Evaluating and validating the right tool

Implementation methodology, Data Quality, selection for quicker decision and ROI

Master Data, Common Meta data

Deliverables:

! Presentation of findings and sign-off

! Current assessment, Challenges and Gaps

! Clear road map for short and longer term tasks to be undertaken by Client in implementing the strategy; which may

Listen Study Identify Define

Data Quality, Data Governance & Change Management

Client Project Sponsor

Client Business &

IT teams ITC Infotech Consulting team

Client Business &

IT teams ITC Infotech Consulting team

ITC Infotech Consulting team

Client Project Sponsor

Client Business &

IT teams ITC Infotech Consulting team

1.0 Workshop

1.1 Business Overview

1.2 IT Overview

2.0 Study Business

Process

2.1 Study the data 2.2 Study the Reports/

Dashboard/

Analytical models 2.3 Evaluate

the tool Utilization

3.1 Identify

Gaps

3.2 Best Practice mapping

4.1 Define Roadmap

4.2 Benefits

& ROI

! Business & IT Workshop

! Current Architecture overview by the business on existing systems

& reports

! Understand system / technology platform

! Understand Integration points , channels, reporting landscape & Data quality

! Evaluate the Current State – Process &

Systems against the Desired State

! Map the current state against Best

Practices

! Assess the value opportunities to address gaps

! Prioritize the opportunities

! Define a BI roadmap

Check Check Final Presentation

Deliverables

! Data Strategy and BI Roadmap – Benefits, Governance & Data Strategy, Tool & Report Optimization, Implementation timeline and approx. cost

! Business Process Re-engineering

Our Technology Strategy & Architecture This spectrum of technology skills enables us to practice comprising of architect from Big 5 and deliver a breadth of consulting services including Tier 1 consulting firms have an average 14 BI roadmap and strategy development,

years industry experience, possesses the depth Infrastructure planning and consolidation, of talent, breadth of experience and innovative technology solution development, knowledge of current and emerging business and technology architecture planning technology to assist CIOs innovatively embrace and design. We act as an extended arm of the change while maintaining overall operational customer to evaluate, audit & review 3rd party BI

stability and security strategy.

Why ITC Infotech

Our Consulting services include:

Governance Model Business Participation

! A formal Governance process needs to be ! Participation and time commitment from instituted for the project .The Governance functional teams for understanding to-be Model would include Executive Sponsorship, processes, as-is systems and data for legacy Executive Coordinator/Owner, Business data loads, usage pattern etc. is crucial to Participation Council/Team building a business focused BI Strategy

! This governance model will ensure

IT Participation

participation from business users to enable

! Client IT team participation is crucial to building successful engagement

a comprehensive strategy

! Client to identify and make available the key

! Access to the required applications to carry out stakeholder/subject matter experts for

study, analysis and validation activities clarifications, providing inputs and sign-off

during the workshop ! All necessary documents, KPIs, metrics, manuals, etc. relevant to the success of this

! The executive team representatives who will

project to the ITC Infotech team champion the initiative, help define the

business alignment strategy through

Operational System implementation

prioritization, and create the performance

issues & delays

management culture

! Ensure that the infrastructure is available to the team and major downtime/outage will impact the timeline of this project

Critical Success factors:

BI Vision and Roadmap

Solution Architecture Recommendation Use Case Identification &

Big Data Adoption

Metadata Management

Performance Optimization

Proof of Value(PoV)

Migration / Upgrade Report/Dashboard

Rationalization

Data Profiling

& Quality

System Architecture Re-Engineering

Performance Optimization

SVoC & Master data Proof of

Concepts (PoC) Enterprise Data

Architecture – Traditional & New Age

Information(Data) Governance Strategies

Standards, Best Practices

Agile Consulting

Asset Inventory and Enterprise Portfolio Rationalization BI Consulting

Architectural Consulting

Solution Management &

Governance Consulting

Building CoE/BICC

Product / Tool Evaluation &

Recommendation

Some Reference:

! BI & Data Governance Strategy for a leading Hospitality chain based out of Canada

! Single View of Customer strategy for Leading Retail chain in South Africa& UK

! BI Application health check for Multi National bank based out of Middle east

! BIDW implementation feasibility with tool recommendation and Technical approach for a leading transportation company from Hong Kong

! Integrated BI Roadmap and strategy for a South African retailer and Financial services

About ITC Infotech

ITC Infotech, a fully owned subsidiary of USD 7 billion ITC Ltd, provides IT services and solutions to leading global customers. The company has carved a niche for itself by addressing customer challenges through innovative IT solutions.

ITC Infotech is focused on servicing the BFSI (Banking, Financial Services & Insurance), CPG&R (Consumer Packaged Goods & Retail), Life Sciences, Manufacturing & Engineering Services, THT (Travel, Hospitality and Transportation) and Media & Entertainment industries.

For more information, please visit http://www.itcinfotech.com | Or write to: [email protected] Kishan Venkat Narasiah, Consulting

Lead – DWBI & Analytics, ITC Infotech 14 years of Industry Experience, currently working in the capacity of Senior

Technical Architect level - Advising clients on BI road map, Information Strategy, Value realization, Data Governance as well as managing and delivering DWBI projects. Perform advisory role on complex Business Intelligence projects and act as subject matter expert in defining requirements of most complex business initiatives.

Author

Viros Sharma, Vice President & Global Practice Head – DWBI & Analytics, ITC Infotech More than 20 Years in the DW/BI Consulting and Practice-Building space. Worked for Multinational IT companies like Bearing Point and iGATE in India and USA. AMP from IIMB.

Double Masters in Mathematics and Computer Applications

Co-Author