© 2016 Continuum Analytics - Confidential & Proprietary © 2016 Continuum Analytics - Confidential & Proprietary Leveraging Jupyter to build an Excel-Python bridge JupyterCON 2017 Christine Doig, Senior Product Manager & Data Scientist Fabio Pliger, Tech Lead August 24th, 2017

2 Overview & Examples

© 2016 Continuum Analytics - Confidential & Proprietary 3 How to increase by 100x the impact of data science in your organization? Data Scientist Business Analysts Jupyter Users Est. 3-6 million Excel Users Est. 750 Million

© 2016 Continuum Analytics - Confidential & Proprietary 4 Business analysts vs Data scientists Works with: Excel, Tableau, SQL Python, Hadoop, Spark Data: spreadsheets, tables dataframes, arrays Delivers: Reports, dashboards, spreadsheets Notebooks, code, interactive visualizations

© 2016 Continuum Analytics - Confidential & Proprietary 5 Business analysts are being left out of the data science revolution 5 Big Data & ETL Interactive Data Visualizations Machine Learning Statistics and Advanced Analytics

© 2016 Continuum Analytics - Confidential & Proprietary 6 Anaconda Fusion is a bridge between Excel & Python 6 Big Data & ETL Interactive Data Visualizations Machine Learning Statistics and Advanced Analytics

© 2016 Continuum Analytics - Confidential & Proprietary 7 Analysts and Data Scientists can keep using their preferred tools 7

© 2016 Continuum Analytics - Confidential & Proprietary 8 Self-service Big Data analytics Head node Compute nodes Jupyter notebook Interactive Data Visualizations Machine Learning Predictions Extract, transform and query data

© 2016 Continuum Analytics - Confidential & Proprietary 9 “No Code” Data Science Example 1 2 Select Anaconda Fusion Notebook and click “Upload” Select function you wish to run Click “Run” Data is loaded into spreadsheet 3 4

© 2016 Continuum Analytics - Confidential & Proprietary 10 Just change one line of code in your notebook

© 2016 Continuum Analytics - Confidential & Proprietary 11 • Extract data - pull data directly into Excel to perform analysis • Machine Learning – use trained models created by Data Scientists and plug them into your spreadsheet data • Interactive Visualizations – create custom advanced interactive graphs, charts and plots from Excel data • Big Data – analyze, transform, model and query data stored in Hadoop and Spark Figure: Anaconda Fusion on Mac Anaconda Fusion use cases

© 2016 Continuum Analytics - Confidential & Proprietary 12 12 • Run Queries • Run Predictive Models • Running Big Data Text Analytics Examples

© 2016 Continuum Analytics - Confidential & Proprietary 13

© 2016 Continuum Analytics - Confidential & Proprietary 14

© 2016 Continuum Analytics - Confidential & Proprietary 15

16 Features & architecture

© 2016 Continuum Analytics - Confidential & Proprietary 17 Features – Formula bar

© 2016 Continuum Analytics - Confidential & Proprietary 18 Features – Write back to Excel

© 2016 Continuum Analytics - Confidential & Proprietary 19 Features – Interactive visualizations

© 2016 Continuum Analytics - Confidential & Proprietary 20 Features – Save custom advanced visualizations

© 2016 Continuum Analytics - Confidential & Proprietary 21 • OSS – base of most successful modern software • Maturity – long history • Diversity • 100s of projects • 1000s of contributors • Vision • Jupyterlab • Community & Support • Popularity Jupyter as a Platform

© 2016 Continuum Analytics - Confidential & Proprietary 22 • The jupyter ecosystem • https://github.com/jupyter • https://github.com/jupyterlab • https://github.com/phosphorjs • Great community/support • Very pluggable* • Perfect for our use case • I.e.: why can’t excel have ML? • i.e.: why can’t excel do things that numpy/pandas do? • i.e.: we need better graphics (ala bokeh ;) ) for a dashboard of our metrics in excel Jupyter As a Tech Choice

© 2016 Continuum Analytics - Confidential & Proprietary 23 Use Case Excel fusion Fusion Server Notebook kernels

© 2016 Continuum Analytics - Confidential & Proprietary 24 Use case Excel fusion Anaconda Platform Notebooks, Apps, … kernels API Apps

© 2016 Continuum Analytics - Confidential & Proprietary 25 A marketplace for Anaconda Fusion notebooks https://anaconda.org

© 2016 Continuum Analytics - Confidential & Proprietary Christine Doig [email protected] @ch_doig Fabio Pliger [email protected] @b_smoke THANK YOU!

© 2016 Continuum Analytics - Confidential & Proprietary QUESTIONS?