Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Introduction to Exploratory v5.5 New Features

Introduction to Exploratory v5.5 New Features

Introduces some of the key new features of Exploratory v5.5.

- New Text Data Wrangling UIs
- Drag-and-drop support for Pivot Table
- Dashboard - Long format, Custom Viz, Comment with Markdown
- Chart - Horizontal Bar/Error Bar with Repeat By, Edit Display Name, Cumulative Ratio for Histogram
- Prophet - Variable Importance, Effects by Variables

19fc8f6113c5c3d86e6176362ff29479?s=128

Kan Nishida
PRO

February 19, 2020
Tweet

Transcript

  1. Exploratory Seminar #24 Exploratory v5.5

  2. EXPLORATORY

  3. Kan Nishida CEO/co-founder Exploratory Summary Beginning of 2016, launched Exploratory,

    Inc. to democratize Data Science. Prior to Exploratory, Kan was a director of product development at Oracle leading teams for building various Data Science products in areas including Machine Learning, BI, Data Visualization, Mobile Analytics, Big Data, etc. While at Oracle, Kan also provided training and consulting services to help organizations transform with data. @KanAugust Speaker
  4. Mission Democratize Data Science

  5. Data Science is not just for Engineers and Statisticians. Exploratory

    makes it possible for Everyone to do Data Science. The Third Wave
  6. First Wave Second Wave Third Wave Proprietary Open Source UI

    & Programming Programming 2016 2000 1976 Monetization Commoditization Democratization Statisticians Data Scientists Democratization of Data Science Algorithms Experience Tools Open Source UI & Automation Business Users Theme Users
  7. Questions Communication Data Access Data Wrangling Visualization Analytics (Statistics /

    Machine Learning) Data Analysis Data Science Workflow
  8. Questions Communication (Dashboard, Note, Slides) Data Access Data Wrangling Visualization

    Analytics (Statistics / Machine Learning) Data Analysis ExploratoryɹModern & Simple UI
  9. Exploratory Seminar #24 Exploratory v5.5

  10. Questions Communication Data Access Data Wrangling Visualization Analytics (Statistics /

    Machine Learning) Data Analysis
  11. Questions Communication Data Access Data Wrangling Visualization Analytics (Statistics /

    Machine Learning) Data Analysis
  12. Data Wrangling

  13. • Tokenizing Text: Stop Words Dictionary Update • Text Data

    Wrangling • Enhancements in Summarize / Pivot UIs • Floating Dialog Data Wrangling
  14. • Tokenize: Stop Words Dictionary Update • Text Data Wrangling

    • Enhancements in Summarize / Pivot UIs • Floating Dialog
  15. None
  16. None
  17. None
  18. None
  19. None
  20. None
  21. None
  22. You can remove Stopwords by Filter as well

  23. None
  24. None
  25. • Tokenize: Stop Words Dictionary Update • Text Data Wrangling

    • Enhancements in Summarize / Pivot UIs • Floating Dialog
  26. Text Wrangling

  27. Remove

  28. Remove

  29. Replace

  30. Extract

  31. Convert - UPPER / lower / Title Case

  32. Convert - Country

  33. Convert - IP Address to Country

  34. • Tokenize: Stop Words Dictionary Update • Text Data Wrangling

    • Enhancements in Summarize / Pivot UIs • Floating Dialog
  35. Change the order by Drag-and-Drop

  36. ྻ໊ͷมߋ

  37. • Tokenize: Stop Words Dictionary Update • Text Data Wrangling

    • Enhancements in Summarize / Pivot UIs • Floating Dialog
  38. Want to move the dialog to see the data behind

    it…
  39. Now You Can!

  40. Chart

  41. • Edit Display Name • Enhancements for Pivot Table •

    Custom Calculation • Histogram - Cumulative Sum / Cumulative Ratio • Horizontal Bar / Error Bar Chart
  42. • Edit Display Name • Enhancements for Pivot Table •

    Custom Calculation • Histogram - Cumulative Sum / Cumulative Ratio • Horizontal Bar / Error Bar Chart
  43. Edit Display Name - X-Axis

  44. None
  45. None
  46. None
  47. None
  48. Combine Values by Giving the Same Name

  49. None
  50. Edit Display Name - Repeat By

  51. None
  52. None
  53. • Edit Display Name • Enhancements for Pivot Table •

    Custom Calculation • Histogram - Cumulative Sum / Cumulative Ratio • Horizontal Bar / Error Bar Chart
  54. None
  55. • Edit Display Name • Enhancements for Pivot Table •

    Custom Calculation • Histogram - Cumulative Sum / Cumulative Ratio • Horizontal Bar / Error Bar Chart
  56. Want to divide Monthly Income by 1,000.

  57. Use Custom Calculation!

  58. None
  59. None
  60. Average Income of those whose Age is less than 30.

  61. • Edit Display Name • Enhancements for Pivot Table •

    Custom Calculation • Histogram - Cumulative Sum / Cumulative Ratio • Horizontal Bar / Error Bar Chart
  62. Want to know the cumulative sum of the employees by

    Age
  63. None
  64. Cumulative Sum

  65. Cumulative Sum Ratio

  66. • Edit Display Name • Enhancements for Pivot Table •

    Custom Calculation • Histogram - Cumulative Sum / Cumulative Ratio • Horizontal Bar / Error Bar Chart
  67. None
  68. None
  69. None
  70. Horizontal Error Bar

  71. Analytics

  72. • Extract Date / Time Information as Predictors • Categorize

    Numeric (Binning) • Time Series Forecasting with ProphetɿVariable Importance, Effects • Effects by Variables - Dropdown Analytics
  73. • Extract Date / Time Information as Predictors • Categorize

    Numeric (Binning) • Time Series Forecasting with ProphetɿVariable Importance, Effects • Effects by Variables - Dropdown Analytics
  74. None
  75. None
  76. None
  77. • Extract Date / Time Information as Predictors • Categorize

    Numeric (Binning) • Time Series Forecasting with ProphetɿVariable Importance, Effects • Effects by Variables - Dropdown Analytics
  78. Categorize Numeric - Binning

  79. Categorize Numeric - Binning

  80. None
  81. You can customize how you ‘bin’.

  82. You can ‘bin’ for Color and Repeat By, too!

  83. And now, you can do the same thing for Analytics!

  84. Categorize Numeric (Binning) - Repeat By

  85. Categorize Numeric (Binning) - Color By

  86. Categorize Numeric (Binning) - Color & Repeat By

  87. • Extract Date / Time Information as Predictors • Categorize

    Numeric (Binning) • Time Series Forecasting with ProphetɿVariable Importance, Effects • Effects by Variables - Dropdown Analytics
  88. None
  89. External Predictors (Extra Regressors)

  90. Effects by Variable

  91. Variable Importance

  92. • Extract Date / Time Information as Predictors • Categorize

    Numeric (Binning) • Time Series Forecasting with ProphetɿVariable Importance, Effects • Effects by Variables - Dropdown Analytics
  93. Select ‘Repeat By’ Group

  94. Select the number of charts to show per row

  95. • Long Dashboard • Comment with Markdown Format • Custom

    Charts with RMarkdown Dashboard
  96. • Long Dashboard • Comment with Markdown Format • Custom

    Charts with RMarkdown Dashboard
  97. Long Dashboard

  98. Uncheck ‘Fit to Screen’ to have Long Dashboard.

  99. • Long Dashboard • Comment with Markdown Format • Custom

    Charts with RMarkdown Dashboard
  100. Add Text Box

  101. Enter Comments Format Text with Markdown!

  102. • Header (H1, H2, etc.) • Bold, Italic • URL

    Link • Bullet Points • Image
  103. • Long Dashboard • Comment with Markdown Format • Custom

    Charts with RMarkdown Dashboard
  104. Custom R Script

  105. Custom Visualization

  106. One more thing…

  107. Thumbnail Images

  108. Table & Pivot Table

  109. Dashboard

  110. Q & A

  111. Information Email kan@exploratory.io Website https://exploratory.io Exploratory Collaboration Server https://exploratory.io/collaboration-server Twitter

    @KanAugust
  112. EXPLORATORY