Implementation of Business Intelligence Tool

1
Implementation of BI Tool

• BI Tool SAS Visual Analytics
• Implementation By Binary Semantics Ltd.

2
Content

• About Our Client
• Challenge
• Solution
• Implementation Approach
• Results
• Benefits
• Screen Layouts

3
About Client

• Our Client is one of Indias largest automotive
  integrated component manufacturing company, with
  a diverse portfolio of operations.
• Consolidated Production Capacity 1 mn tonne per
  year
• Annual Revenue US1.3 billion.
• 60 world-class facilities across Asia, North
  America, Europe and South America.
• Our Client has listed corporate entities.

PORTFOLIO OF OPERATIONS
Forging
Iron Casting
Aluminum Casting
Integrated Machining
Sub-Assemblies
4
Challenges

• Our client wanted to manage Big Business Data for
  
• Implementation of Business Intelligence Reporting
  solution.
• Data Preparation, Data Cleansing and Data Staging
  to deliver reporting solution specified by our
  client.
• Identify Actionable Insights for Senior
  Executives to make Critical Strategic Decisions .

PHASE 1 PHASE 2
Sales Production
Finance Accounting
USING FLAT MS Excel FILES COMPLETED WITH SAP INTEGRATION IN-PROCESS
See your Data in a New Way
BIG DATA?
5
Solution SAS Visual Analytics 6.2 , SAS EG 9.3

• Our Team suggested more feasible mapping that
  helped significantly in migrating the business
  data from MS Excel to SAS for their SAS VA
  Implementation.
• Improved Consolidation Better Reporting
• Our Client leveraged SAS High-Performance
  In-Memory Analytics through our sophisticated
  approach in deployment of SAS Visual Analytics
• Our Client is able to forecast, spot trends and
  compute large data in short span of time which
  was earlier time consuming.

Solution
6
Implementation Approach

• We delivered a prototype to the client to
  showcase data visualization at initial start.

Data Preparation Mapping Exploration Data Visualization
3 STAGE PROCESS FOLLOWED
7
Implementation Approach

• Depending on the Clients Spread mart and the
  available variables and labels, our team
  developed dimensions, categories, groups,
  hierarchies to visualize data in an effective
  manner and suggested the most feasible way to
  leverage SAS In-Memory analytics capability.
• The Data staging, data cleansing, ETL process
  resulted the clients data to seamlessly
  integrate into SAS VA Application in a uniform
  format.

Understand Variables
Establish Hierarchies
Data Staging, Cleansing
Integrate into SAS VA
8
Results

• Our Client now perform critical business analysis
  with ease such as
• Sales Analysis
• Profit and Loss Analysis
• Credit Analysis
• Inter Unit Transactions tracking
• Business trends Forecasting
• Our team delivered end to end SAS Visual
  Analytics Business Intelligence Reporting
  solution.

9
Benefits

• Significant reduction in manual effort in
  generating reports to be consumed by senior
  executives.
• Senior management can access, analyze and consume
  time literally anytime and anywhere in the world.
• Ease in Process and Time Saving
• Flexibility to access the reports on the iPads,
  iPhones, tablet devices and other Android devices
  with a single secured sign on anywhere in the
  world.

10
Sample Screenshots

• BI Tool SAS Visual Analytics
• Implementation By Binary Semantics Ltd.

11
Sample Dashboard
12
Trend Analysis
13
Actionable Insights
14
Geographical Data
15
About Binary Semantics

• BI Tool SAS Visual Analytics
• Implementation By Binary Semantics Ltd.

16
About Binary Semantics

• Gurgaon, India based technology firm having
  presence in Mumbai, Bangalore, Chennai, Hyderabad
  and NJ (USA)
• 500 technology professionals
• ISO 90012008 certified processes
• Technological Expertise- Microsoft, Oracle, Open
  Source, JAVA.
• Proven track record of 28 yrs. for successful
  Project deliveries.

Software Services
Consulting Services
KPO BPO
Professional Services
Data Analytics Group (DAG)
17
DAG Group

• Binary Semantics has been instrumental in
  providing Data Analysis solutions in various
  areas such as
• Business Intelligence Tools
• Statistical Modelling Analysis
• Risk Analysis Simulation
• Optimization
• Econometrics
• Quality Improvement Projects - Six Sigma, Lean
  CMMI
• Enterprise Project Portfolio Management
• Mathematical Modelling

18
Thanks!!

• Binary Semantics Ltd.