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

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
22. You can remove Stopwords by Filter as well
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
48. Combine Values by Giving the Same Name
50. Edit Display Name - Repeat By
53. • Edit Display Name • Enhancements for Pivot Table • Custom Calculation • Histogram - Cumulative Sum / Cumulative Ratio • Horizontal Bar / Error Bar Chart
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!
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
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
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
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
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
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