Hot, Hotter, Hyper - Tableau Conference 2018

Transcription

#TC18Hot, Hotter, HyperHow to Handle Big DataMarius KaiserErwin van LaarSolution ConsultantTeam Lead, Product ConsultancyTableauTableau

Session Overview

#TC18Hot, Hotter, HyperHow to Handle Big DataMarius KaiserErwin van LaarSolution ConsultantTeam Lead, Product ConsultingTableauTableau

#TC18Hot, Hotter, HyperHow to Handle Big DataMarius KaiserErwin van LaarSolution ConsultantTeam Lead, Product ConsultingTableauTableau

Introduction

Marius KaiserErwin van LaarSolution Consultant, TableauTeam Lead, Product Consultancy, Tableau

What is Big Data anyway?VolumeVelocityVariety

What is Big Data?

What is Big Data?

People

Agenda Tableau’s Big Data Focus Hyper Big Data Framework Practical Example Summary

Tableau’s Big Data Focus

Big Data FocusConnectivityPerformanceDiscoveryAccess to alldataFastinteractionwith all dataFinding theright data

Hybrid Data Strategy A combination of in-memory and live query engines Designed for adaptability and flexibility Unified user experience for full range of data stores

Live Query Engine Supports the world’s largestdatabases Attaches directly to enterprisedata stores Pushes down workload Leverage your Big adoopFastdatabases

In-Memory Engine Extremely fastcomputationalability Fast performancewith large data sets Optionallyaggregate databefore extractingData Extract API& Web Data ConnectorDatawarehousesHadoopFastdatabases

HyperFast analysis on data of all sizes*Hyper replaces TDE in all of our products

ScalabilityHyper’s parallelism fullyutilizes large amounts ofcores ( 120)

HyperKey benefits Up to 5x faster query performance with large or complex datasets Fresher data with up to 3x faster extract creation Support for larger extracts

Caution! It’s not the WIN Button!

Data Strategy Selection of Technology Align Technology to BusinessUse and Data What questions do we wantto answer?

cloud-netflix-original-64442

Big Data FrameworkHot, Warm, Cold

PerformanceData Size

STOREANALYZESPEED UPCONSUME

Let me introduce Air Tableau

Air Tableau New, technology driven airline Data of hundreds of millions of flights and their performanceGoals Analyse the data and identify gaps Monitor Flights performance going forward - Performant Dashboards for everyone!

Cold - Store

Flights Performance Data in the Data LakeAmazonS3

STOREANALYZESPEED UPCONSUMEAmazonS3AnalystData Scientist

The Data LakeSQLFilesHDFS

Hive is too slow for InteractivityFiles

Warm - Analyze

Faster ways to query the Data LakeFiles

Hive is too slow for Interactivity

STOREANALYZEAmazonAthenaAmazonS3SPEED UPCONSUME

Hot - Let’s Speed It Up

STOREANALYZESPEED UPAmazonRedshiftAmazonAthenaAmazonS3CONSUME

Leverage TableauSecret weaponsAggregated ExtractsPrep

SW#1 Aggregated, Optimized ExtractsPre-aggregateOptimizeAdvantage:Same results, vastly es

SW#2: Prep

Human Scale of DataYearYearQuarterQuarterMonthMonthWeekWeekDayRaw Data

Consume

STOREANALYZESPEED IT ngData Science

Leverage TableauSecret weapons:Aggregated ExtractsPrepCross-Datasource ActionsHybrid Data Strategy

Leverage TableauSecret weapons:Aggregated ExtractsPrepCross-Datasource ActionsHybrid Data Strategy

Human Scale of DataYearYearQuarterQuarterMonthMonthWeekWeekDayRaw Data

SW3: Cross-Datasource Raw Data

Questions?

Summary

Summary Big Data needs to be for the peopleTableau enables people to use Big DataTableau is a Leader in Big Data Analytics Tableau’s Hybrid Data Engine is a secret weapon!Tableau enables Big Data agilityUse the Hot, Warm, Cold framework

Over to you! Use the Hot, Warm, Cold framework Remember Tableau’s Secret Weapons Aggregated ExtractsPrepCross-Data Source ActionsHybrid Data Strategy

ConclusionTableau is great for Big DataUse the right technology for the rightuse case

R E L AT E D S E S S I O N SAdvancing your big data strategyDay Time – Time LocationExpedia Big data self-service analyticswith Tableau and AWSDay Time – Time Location

Please complete thesession survey from theSession Details screenin your TC18 app

Thank you!Marius KaiserErwin van Laarmkaiser@tableau.comevanlaar@tableau.com

Tableau #TC18 Erwin van Laar Team Lead, Product Consultancy Tableau. Session Overview. . Hadoop Hadoop Fast databases Data warehou ses Data warehouses. In-Memory Engine . aggregate data before extracting Data Extract API & Web Data Connector Hadoop Fast databases Data warehouses. Hyper F