Visual Analytics with Tableau & Couchbase
Couchbase Connect 2015Tableau SoftwareJune 3rd, 2015
Introduction
Jeff FengProduct Manager – Big Data
@jtfeng
Clara SiegelProduct Manager
@clara_siegel
Our Viz-dentials
A few things we’d like to share with you all today…
Visual Analytics
What’s New With Tableau
Couchbase + Tableau: Together We Drive
Insight
Demo: N1QL ODBC Driver by Simba
Q&A
Help people see and understand their data
The human visual system is powerfulHow many 9s are there?
The human visual system is powerfulHow many 9s are there?
This is how an Accountant views data
This is how Tableau represents data
The Cycle of Visual Analysis
So what’s Tableau beenup to?
Tableau is a fundamental break from the past
Traditional BI Solutions
Tableau’s Products
Tableau DesktopFor anyone Tableau Online
For organizations
Tableau Server Tableau PublicFor public websites
Smart Meets Fast
Visual analytics• Ad-hoc calculations• New Calculation Editor• Auto-complete for calculations• Level of detail expressions• Drag-and-drop analytics• Instant Analytics• Lasso and radial selection• Geographic search• New pan-and-zoom experience• Demographic data layers
Tableau Server• Vizportal - New Server &
improved interface • Infinite scrolling• Universal search• Improved Permissions
management• High Availability Improvements • REST APIs for provisioning and
content management• Tabcmd Improvements• New Admin Views
Performance• Parallel queries • Data Engine Vectorization• Parallel aggregation• Temp table support on Data
Server• Saved Query Caching• Query Fusion• Query Batch Ordering• Shadow Extracts
User Experience• Redesigned Start and Connect
Experience• Enhanced Story Points
Formatting• Responsive Marks• Fast Tooltips• Thumbnail Previews in Desktop• Reset button in continuous
Quick Filters
Data Preparation• Excel Clean-up• Pivot• Data Split • REGEX• Metadata grid• Data Extract API for Mac OS• Publish and append in the TDE
API• Access files from SPSS, SAS and
R• Improved Salesforce connector
Mobile• Redesigned App Experience• Create and Edit calculations in
Mobile Authoring
Broad access to Big Data platformsVisual analytics without coding
Hybrid data architecture
Data blending across data sourcesPlatform query performance
Consistent interface to visualizing data
Tableau plays a fundamental role in Big Data analysis
Couchbase + Tableau:Together we drive insight.
Couchbase provides a complete data management system
Key-value store
Document
database
Embedded database
Sync management
Multi-purpose capabilities support a broad range of apps and use cases
High availability
cache
Couchbase + Tableau: Visual Analytics on All Data
N1QL
Application
Tableau users can connect to Couchbase through an ODBC interface
ODBC Driver
OD
BC
Inte
rface
Dri
ver
Imp
lem
enta
tion
SQL-92 N1QL
Data
Tableau users can connect to Couchbase through an ODBC interface
ODBC Driver
OD
BC
Inte
rface
Dri
ver
Imp
lem
enta
tion
SQL-92 SQL orN1QL
Simba Couchbase ODBC Driver Allows users to infer or define
schemas on schema-less JSON data
Converts JSON data to relational data
Based on ODBC 3.80 Standard Full 64-bit and 32-bit support Full SQL & N1QL support Comprehensive unicode support
Try it out! Download the beta
http://tinyurl.com/couch-n1ql
Tableau + Couchbase Demo:Simba Driver
What landmark should we visit near Santa Clara, CA?
Summary
+ Couchbase Server addresses a key need for storing enterprise web, mobile & sensor data that relational databases can’t fill
+ Tableau is leading a new wave of self-service visual analytics for ALL users
+ N1QL plus the Simba ODBC Driver enables visual analytic tools to run dynamic queries against JSON
+ Couchbase + Tableau together enables smart and fast visual analytics on NoSQL data
Thank you!
Jeff Feng | Product Manager
@jtfeng
Clara Siegel | Product Manager
@clara_siegel
Introduction
Introduction
Viz
Dark blue divider
Light blue divider
Orange divider