Download - GrayMatter Pentaho Consulting Services
![Page 1: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/1.jpg)
© 2017 GrayMatter All Rights Reserved
GrayMatter Pentaho Competency Centre Overview
![Page 2: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/2.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/3.jpg)
© 2017 GrayMatter All Rights Reserved 3
Our Performance Dashboard
![Page 4: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/4.jpg)
© 2017 GrayMatter All Rights Reserved 4
Geographical Spread
![Page 5: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/5.jpg)
© 2017 GrayMatter All Rights Reserved 5
Customer Engagement Metrics
![Page 6: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/6.jpg)
© 2017 GrayMatter All Rights Reserved 6
A select few customers
![Page 7: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/7.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/8.jpg)
© 2017 GrayMatter All Rights Reserved 8
Top Projects Showcase
Next
Hover over the circles for a brief description
![Page 9: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/9.jpg)
© 2017 GrayMatter All Rights Reserved 9
Top Projects Showcase
Next
Hover over the circles for a brief description
![Page 10: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/10.jpg)
© 2017 GrayMatter All Rights Reserved 10
Top Projects Showcase
Next
Hover over the circles for a brief description
![Page 11: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/11.jpg)
© 2017 GrayMatter All Rights Reserved 11
Top Projects Showcase
Next
Hover over the circles for a brief description
![Page 12: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/12.jpg)
© 2017 GrayMatter All Rights Reserved 12
Top Projects Showcase
Next
Hover over the circles for a brief description
![Page 13: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/13.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/14.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/15.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/16.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/17.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/18.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/19.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/20.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/21.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/22.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/23.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/24.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/25.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/26.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/27.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/28.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/29.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/30.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/31.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/32.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/33.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/34.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/35.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/36.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/37.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/38.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/39.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/40.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/41.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/42.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/43.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/44.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/45.jpg)
© 2017 GrayMatter All Rights Reserved 45
6. Pentaho Support and Services
Previous Service
![Page 46: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/46.jpg)
© 2017 GrayMatter All Rights Reserved
Our Project Experience
![Page 47: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/47.jpg)
© 2017 GrayMatter All Rights Reserved 47
A leading Insurance provider
![Page 48: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/48.jpg)
© 2017 GrayMatter All Rights Reserved 48
Global specialist in energy management
![Page 49: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/49.jpg)
© 2017 GrayMatter All Rights Reserved 49
A large retailer based out of Middle East
![Page 50: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/50.jpg)
© 2017 GrayMatter All Rights Reserved 50
A leading German Airport
![Page 51: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/51.jpg)
© 2017 GrayMatter All Rights Reserved
Stream Global (Convergys) CASE STUDY
![Page 52: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/52.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/53.jpg)
© 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](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/54.jpg)
© 2017 GrayMatter All Rights Reserved 54
GrayMatter Design Process
![Page 55: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/55.jpg)
© 2017 GrayMatter All Rights Reserved 55
Implementation Life Cycle
![Page 56: GrayMatter Pentaho Consulting Services](https://reader034.vdocuments.us/reader034/viewer/2022051710/5a65b7fa7f8b9aa4758b60d3/html5/thumbnails/56.jpg)
© 2017 GrayMatter All Rights Reserved 56
Thank You
Contact Us