Cisco - Ben Torgesen and Sudharshan Seerapu

Download Report

Transcript Cisco - Ben Torgesen and Sudharshan Seerapu

Leveraging the Strengths of IT and Business for Rapid Tableau Adoption at Cisco

Cisco Systems

PRESENTED BY

Ben Torgesen & Sudharshan Seerapu

2012 Tableau Customer Conference in San Diego

Tableau had been an enterprise tool for six months. Twenty groups were using the enterprise environment.

Cisco Confidential 2

• Business teams were purchasing their own BI software • Gaps identified in our BI strategy 1.

Advanced Analytics & Visualizations Rapid BI Prototyping Self-Service BI • Business teams could no longer wait for large-scale IT engagements to deliver dashboards and analytics 1.

They needed to play with the data They needed to play with visualizations They needed to be able to act on a hunch They needed to be able to react to rapidly changing conditions © 2010 Cisco and/or its affiliates. All rights reserved.

Cisco Confidential 3

• Business 1.

Know their Data Asking the Right Questions Collaborating with Other Groups Get the Job Done • IT 1.

Cisco Confidential 4

• Business teams access enterprise data, departmental data, third party data, custom data, and frequently are combining the different data elements.

• Business teams ask the right questions.

• Business gets the job done!

• Business collaborates through the Tableau Center-of-Excellence.

Cisco Confidential 5

• While IT helps facilitate the COE, the business provides content for monthly meetings, discussion forums, training tools, and best practices.

Cisco Confidential 6

• A centrally-managed enterprise Tableau server 1.

Server administration 24/7 monitoring, maintenance, upgrades, patches, and case resolution Integration with other IT tools and processes (SSO, Kintana for lifecycle management, scheduling, backups, DR, OnRamp, etc …) Vendor management Performance tuning Operational statistics • Training, support, and consulting (in conjunction with Tableau Center-of-Excellence) • Streamlined engagement and governance © 2010 Cisco and/or its affiliates. All rights reserved.

Cisco Confidential 7

Tableau Server Tableau Server Tableau Server

Production Stage Development

Cisco Confidential 8

Teradata Oracle Essbase

Enterprise

SQL Server, MySQL, etc… Excel, Flat Files, other…

Departmental Data Data Worker1

Web App

Worker2

VizQL

Worker3

Web App

Worker4

VizQL

Report Spec

Tableau Desktop

Report Consumer (Web based) Data Server Data Engine (2) Background Background Repository (2) Shared NAS (1 TB) HTML5 - Mobile

Completed Report

Cisco Confidential 9

• Regularly scheduled and communicated upgrades • External 24/7 monitoring system integrated with Tableau (paging me day or night ) • Integration with external scheduling platform, Tidal, allows for event based extract refreshes and failure alerts • Single sign-on integration custom built using trusted tickets • Automated system backups • Future – Web-based UI for image generation • Future – Integration with OnRamp for automatic user creation © 2010 Cisco and/or its affiliates. All rights reserved.

Cisco Confidential 10

• “Two weeks and two meetings” Engage with our team via email to our email alias Initial 30 min. meeting to evaluate use case and technology choice Fill out engagement questionnaire (14 questions) Identify approver for functional area from governance team for review Final 30 min. meeting with governance team to review data sources and possible overlap with other reporting applications With approval, create site on Tableau servers Update WebEx Social Tableau Server Engagement pages © 2010 Cisco and/or its affiliates. All rights reserved.

Cisco Confidential 11

Cisco Confidential 12

• Unobtrusive Governance (Post vs. Pre) No gatekeepers Proactively reach out to groups when best practices are not met • Business Governance Quarterly (and ad-hoc) review of groups and data sources Visibility into dashboards and workbooks Ongoing discussion for enhancing enterprise tools and migrating data to enterprise databases (where appropriate) • IT Governance Monthly review of usage, performance, operational metrics, and other internal IT-focused areas Make site administrators responsible Supply usage/performance metrics © 2010 Cisco and/or its affiliates. All rights reserved.

Cisco Confidential 13

Cisco Confidential 14

Cisco Confidential 15

• “Operating at the pace of business” •

“Best thing to come from IT in years”

• “Have retired almost all spreadsheet reports” • “Replaces a lot of manual work” •

“Once users saw the prototype dashboards the new requirements came in quickly”

Cisco Confidential 16

Cisco Confidential 17

Cisco Confidential 18

Cisco Confidential 19 19

Visualization

Capture, Store, Refine Big Data

Cisco Confidential 20

Application Layer Dashboard Graphs Reports Scores / Benchmarks

Tableau

Hadoop Processing Engine

Hive Tables Rules Filter Transform

TP & ACR

Analytics Correlation Event Statistics By Organization By Individual By Functional groups By Technology Endpoints

Jabber Data Ingress: ETL WxS Post WebEx Meetings

Org Hierarchy Data

IP Video

User Data

IP Audio Cisco Confidential 21 21

Cisco Confidential 23

Cisco Confidential 25

• Measuring Collaboration remains elusive • Little to no collaboration data • Lack of reference points for “good usage” • Unaware of what is actually getting used (and how) • Difficult to understand what internal customers want (or need) • Not using collaboration data to diagnose business problems • Difficult to be prescriptive about collaboration solutions for business outcomes Poor Fair Good Better Collaboration Best

Lack of measurement leads to under-investment

Cisco Confidential 26

Inbound Link to more data

Outbound

Asymmetry in collaboration styles with lines of business.

Outbound Inbound Cisco Confidential 27

volume

• Most functional areas spend 50%+ time collaborating internally • Highest levels of collaboration from (your strategic partners): IT • Finance • HR • Highest levels of Collaboration into IT is from (view IT as a strategic partner): • • Sales Customer Advocacy • Finance © 2010 Cisco and/or its affiliates. All rights reserved.

Cisco Confidential 28

Cisco Confidential 29

Cisco Confidential 30