big data analytics with tableau
TRANSCRIPT
© 2013 Impact Analytix, LLC
q u i c k l y m a k e a p o s i t i v e i m p a c t
Big Data Analytics with TableauJen UnderwoodFounder & Principal ConsultantImpact Analytix, LLC
813.435.5344 [email protected]
© 2013 Impact Analytix, LLC
About the Speaker
o Impact Analytix, LLC is a boutique BI and predictive analytics consulting firm that values projects that truly make a difference
o Jen Underwood, Founder & Principal Consultant
• ~20 years of business intelligence industry experience
• Former Global Microsoft BI and Analytics Technical Product Manager and seasoned BI implementer
• Passionate technology evangelist and volunteer, TDWI, PASS, SharePoint Conference, and Microsoft TechEd
• Bachelor of Business Administration degreeUniversity of Wisconsin Milwaukee
Post Graduate Certificate Computer Science - Data Mining University of California, San Diego
© 2013 Impact Analytix, LLC
“Decision making and the techniques and technologies to support and automate it will be the next competitive battleground for organizations. Those who are using business rules, data mining, analytics and optimization today are the shock troops of this next wave of business innovation.”
- Tom Davenport, Competing on Analytics
© 2013 Impact Analytix, LLC
Tableau DesktopFor Anyone
• Explore and visualize data• Self-service analytics for everyone• Blazing speed against massive data• Author and publish to Server
© 2013 Impact Analytix, LLC
Tableau ServerFor Organizations
• Web dashboards and applications• Secure information management• Enterprise scalability• User defined and deployed
© 2013 Impact Analytix, LLC
Visual Analytics • Based on a visual query language – VizQL • Unifies computer graphics and databases
Live Query Engine• Attaches directly to enterprise data stores• Supports the world’s largest databases• Compatible with data of all formats and sizes
In-Memory Data Engine• Breakthrough in-memory data engine• Column storage, architecture aware• Fast performance with massive data
Core Technology
© 2013 Impact Analytix, LLC
All Data SourcesTransform all types of data into self-service analytics
© 2013 Impact Analytix, LLC
Tableau and Big Data
• Hadoop via Hive • Cloudera Impala• Cassandra• HortonWorks• Hadapt• Karmasphere• Google Analytics and Google BigQuery• Amazon RedShift• SAP HANA• Many other data source types
© 2013 Impact Analytix, LLC
Why Tableau with Big Data?
o 1. Easy, powerful connectiono Connect from Tableau just like any data sourceo No special configuration needed on Hadoop cluster, Hive is requiredo On the fly ETL with Custom SQLo Extended string functions support XML XPATH and custom SQL to manipulate Hadoop data as it
comes in o 2. Tune your analytic workload
o Supports passing native Hadoop functions and programso Functions are packaged as “jar” files o Power of Extracts with Data Server for Batch Processing with Big Data
o 3. Analyze data at the speed of thought o Tableau’s in-memory data engineo 10 – 100x data compression
© 2013 Impact Analytix, LLC
INRIXo THE LEADING PROVIDER OF TRAFFIC
INFORMATION, DIRECTIONS, AND DRIVER SERVICES
• Powering traffic, navigation, and other in‐car connected services for 120+ industry‐leading customers
• Delivering real‐time coverage across 20 countries including 1M+ miles in North America and 1M+ km throughout Europe
• Managing the largest traffic network in the world with real‐time data from 5M+ GPS enabled vehicles and 400+ public & private sources
• Multiple petabytes of data, every minute stores traffic information across millions of segments of road
© 2013 Impact Analytix, LLC
INRIX
© 2013 Impact Analytix, LLC
INRIX Billions of Data Points
© 2013 Impact Analytix, LLC
INRIX Incident Fusion
© 2013 Impact Analytix, LLC
INRIX Directions and Driver Services
© 2013 Impact Analytix, LLC
INRIX Traffic Scorecard with TableauLiterally petabytes of compressed data visualized in the Traffic Scorecard
© 2013 Impact Analytix, LLC
© 2013 Impact Analytix, LLC