Share
Embed
Anaconda Fusion
Leveraging Jupyter to build an Excel-Python bridge, JupyterCON 2017
Christine Doig
August 24, 2017
Transcript
27 slides
-
© 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 -
© 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 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!