graymatter pentaho consulting services

56
© 2017 GrayMatter All Rights Reserved GrayMatter Pentaho Competency Centre Overview

Upload: graymatter

Post on 22-Jan-2018

30 views

Category:

Data & Analytics


1 download

TRANSCRIPT

Page 1: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved

GrayMatter Pentaho Competency Centre Overview

Page 2: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 2

GrayMatter Pentaho Journey

Our Pentaho journey started in the year 2006 coinciding with the birth of both GrayMatter and Pentaho around the same time

• Nearly a decade of successful partnering • Over 100+ companies worldwide have benefited

from GrayMatter's business analytics solutions & Big Data Solutions powered by Pentaho

• Evolved best practices to complex questions on Analytics

Page 3: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 3

Our Performance Dashboard

Page 4: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 4

Geographical Spread

Page 5: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 5

Customer Engagement Metrics

Page 6: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 6

A select few customers

Page 7: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 7

Top Projects Showcase

Next

Hover over the circles for a brief

description

Hover over the circles for a brief description

Page 8: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 8

Top Projects Showcase

Next

Hover over the circles for a brief description

Page 9: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 9

Top Projects Showcase

Next

Hover over the circles for a brief description

Page 10: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 10

Top Projects Showcase

Next

Hover over the circles for a brief description

Page 11: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 11

Top Projects Showcase

Next

Hover over the circles for a brief description

Page 12: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 12

Top Projects Showcase

Next

Hover over the circles for a brief description

Page 13: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 13

Pentaho Consulting

Health Check

• Comprehensive check of system parameters

• Database Connections

• Review of Security Frameworks

• Review of Deployment Architecture

Big Data

• Big data Hadoop distributions : MapR, Cloudera, Hortonworks

• Big data enabled databases : MongoDB, InfiniDB, AWS Redshift

• Big Data Hadoop implementation with Pentaho

• Real-time Analytics with Big data Hadoop-Pentaho

High Availability

• Managed services offering

• Pentaho on clustered environments – High Performance

• Production Migration

• Deployment Architecture consultancy

Page 14: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 14

Pentaho Consulting...cont

Multi Tenancy Architecture

• Architecture Workshops

• Implementation of Multi-tenanted SaaS offering on cloud

• Pentaho extensions and plug-ins for multi-tenancy support

• Data modelling for multi-tenancy

Cloud Environment

• Business Intelligence setup and maintenance in AWS and Rackspace

• Data Warehouse setup and maintenance in AWS and Rackspace

• Content Delivery Network for AWS and Rackspace cloud offering

• Production Monitoring

Stress Performance Testing

• Load Testing

• Stress Testing

• Spike Testing

• Endurance Testing

Page 15: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 15

1. Business Analytics Services

VISUALIZATION AD-HOC ANALYSIS REPORTING DATA MINING DASHBOARDS

Next Service

Click on the tabs to know

more

Page 16: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 16

1. Business Analytics Services

DASHBOARDS VISUALIZATION AD-HOC ANALYSIS DATA MINING

Next Service

REPORTING

Page 17: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 17

1. Business Analytics Services

DASHBOARDS VISUALIZATION AD-HOC ANALYSIS DATA MINING

Next Service

REPORTING

Page 18: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 18

1. Business Analytics Services

DASHBOARDS VISUALIZATION REPORTING DATA MINING

Next Service

AD-HOC ANALYSIS

Page 19: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 19

1. Business Analytics Services

DASHBOARDS VISUALIZATION REPORTING DATA MINING

Next Service

AD-HOC ANALYSIS

Page 20: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 20

1. Business Analytics Services

DASHBOARDS AD-HOC ANALYSIS REPORTING DATA MINING

Next Service

VISUALIZATION

Page 21: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 21

1. Business Analytics Services

DASHBOARDS VISUALIZATION AD-HOC ANALYSIS REPORTING

Next Service

DATA MINING

Page 22: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 22

1. Business Analytics Services

DASHBOARDS VISUALIZATION AD-HOC ANALYSIS REPORTING

Next Service

DATA MINING

Page 23: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 23

2. Data Integration Services

DATA QUALITY DATA

GOVERNANCE ETL

MASTER DATA MANAGEMENT

DATA WAREHOUSE

Next Service

Previous Service

Page 24: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 24

2. Data Integration Services

DATA QUALITY DATA

GOVERNANCE ETL

MASTER DATA MANAGEMENT

DATA WAREHOUSE

Next Service

Previous Service

Page 25: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 25

2. Data Integration Services

DATA WAREHOUSE

DATA QUALITY DATA

GOVERNANCE MASTER DATA

MANAGEMENT ETL

Next Service

Previous Service

Page 26: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 26

2. Data Integration Services

DATA WAREHOUSE

DATA QUALITY DATA

GOVERNANCE MASTER DATA

MANAGEMENT ETL

Next Service

Previous Service

Page 27: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 27

2. Data Integration Services

DATA WAREHOUSE

DATA QUALITY ETL MASTER DATA

MANAGEMENT DATA

GOVERNANCE

Next Service

Previous Service

Page 28: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 28

2. Data Integration Services

DATA WAREHOUSE

DATA GOVERNANCE

ETL MASTER DATA

MANAGEMENT DATA QUALITY

Next Service

Previous Service

Page 29: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 29

2. Data Integration Services

DATA WAREHOUSE

DATA QUALITY DATA

GOVERNANCE ETL

MASTER DATA MANAGEMENT

Next Service

Previous Service

Page 30: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 30

3. Pentaho Big Data Analytics

ANALYTICS DATA INTEGRATION

Next Service

Previous Service

ARCHITECTURE

Page 31: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 31

3. Pentaho Big Data Analytics

ANALYTICS DATA INTEGRATION

Previous Service

ANALYTICS

Next Service

Page 32: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 32

3. Pentaho Big Data Analytics

DATA INTEGRATION ANALYTICS

Previous Service

ARCHITECTURE

Next Service

Page 33: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 33

3. Pentaho Big Data Analytics

ANALYTICS DATA INTEGRATION

Previous Service

ARCHITECTURE

Next Service

Page 34: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 34

4. Pentaho Migration Services

WHY MIGRATE CHALLENGES THE MIGRATION PROCES

Next Service

Previous Service

Page 35: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 35

4. Pentaho Migration Services

WHY MIGRATE CHALLENGES THE MIGRATION PROCESS

Next Service

Previous Service

Page 36: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 36

4. Pentaho Migration Services

WHY MIGRATE CHALLENGES THE MIGRATION PROCESS

Next Service

Previous Service

Page 37: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 37

4. Pentaho Migration Services

WHY MIGRATE CHALLENGES THE BIG DATA ADVANTAGE

Next Service

Previous Service

Page 38: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 38

4. Pentaho Migration Services

WHY MIGRATE CHALLENGES THE BIG DATA ADVANTAGE

Next Service

Previous Service

Page 39: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 39

5. Embed Pentaho Services

PENTAHO RE-BRANDING VISUALIZATION PLUGINS MULTI TENANCY SECURITY

Next Service

Previous Service

Page 40: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 40

5. Embed Pentaho Services

PENTAHO RE-BRANDING VISUALIZATION PLUGINS MULTI TENANCY SECURITY

Next Service

Previous Service

Page 41: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 41

5. Embed Pentaho Services

PENTAHO RE-BRANDING VISUALIZATION PLUGINS MULTI TENANCY SECURITY

Next Service

Previous Service

Page 42: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 42

5. Embed Pentaho Services

PENTAHO RE-BRANDING VISUALIZATION PLUGINS MULTI TENANCY SECURITY

Next Service

Previous Service

Page 43: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 43

MULTI TENANCY

5. Embed Pentaho Services

PENTAHO RE-BRANDING VISUALIZATION PLUGINS SECURITY

Next Service

Previous Service

Page 44: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 44

5. Embed Pentaho Services

PENTAHO RE-BRANDING VISUALIZATION PLUGINS MULTI TENANCY SECURITY

Next Service

Previous Service

Page 45: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 45

6. Pentaho Support and Services

Previous Service

Page 46: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved

Our Project Experience

Page 47: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 47

A leading Insurance provider

Page 48: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 48

Global specialist in energy management

Page 49: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 49

A large retailer based out of Middle East

Page 50: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 50

A leading German Airport

Page 51: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved

Stream Global (Convergys) CASE STUDY

Page 52: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 52

STREAM GLOBAL – Case Study

GrayMatter implemented highly scalable Enterprise Data Warehouse built on MSSQL server using Pentaho Data Integration, integrating around 12 source systems including Oracle HRMS, SAP, Salesforce etc.

• Based on business need GrayMatter integrated data from 28 switches (Nortel, Dell, Avaya etc) with approximately around 20 million records per hour.

• High volume data marts with Client, QA &Employee data was created. • Customized Pentaho BI platform for all their analytics and reporting needs for

Operations, Sales, Management & Executive Teams. • Custom built LDAP security authentication to authenticate and authorize

against Stream’s multiple LDAP servers. The success of the project was vindicated by the customer appointing GrayMatter as their strategic analytics partner year-on-year for nearly 5 years till date.

"Our organization and I have been engaged with GrayMatter for the last four years and we are extremely pleased with their services and resources. With their expertise and global experience, we were able to rollout BI and Analytical solution worldwide for 10K users successfully.” Narayanan Palissery - (Sr. Manager, Information Security Architecture) Convergys (Formerly Stream Global)

Page 53: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 53

Stream Global – Data Integration Workflow

SYSTEMS

OF

RECORD

(SOR)

OLAP CUBE

FLAT FILE

EXTRACTS

BI

Data Movement

Synch/ Replication

DATA PREPARATION DATA FRANCHISING

Data Integration

Transformation &

Cleaning

Data transformed

Into enterprise

dimensional model

Data transformed into Business specific information and

structured for analytical tools and databases

BUSINESS

INTELLIGENCE

EDW

Integration

Schema

STAGING

SYSTEMS

OF

ANALYTICS

(SOA)

EDW

BI Distribution

Schema

Data Mart

Data Mart

Data Mart

Page 54: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 54

GrayMatter Design Process

Page 55: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 55

Implementation Life Cycle

Page 56: GrayMatter Pentaho Consulting Services

© 2017 GrayMatter All Rights Reserved 56

Thank You

Contact Us