Exploratory-v54-Introduction-en.pdf

Kan is going to introduce some of the key new features of Exploratory v5.4.

- Google Analytics
- Super Table
- Chart: Edit Display Name
- Chart: Error Bar
- Analytics: Dependency Plot
- Data Catalog

etc.

Transcript

1. Exploratory Seminar #22 Exploratory v5.4
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 Make Data Science Available for Everyone
5. Questions Communication Data Access Data Wrangling Visualization Analytics (Statistics / Machine Learning) Data Analysis Data Science Workflow
6. Questions Communication (Dashboard, Note, Slides) Data Access Data Wrangling Visualization Analytics (Statistics / Machine Learning) Data Analysis What you can do with Exploratory
7. Exploratory Seminar #22 Exploratory v5.4
8. Questions Communication (Dashboard, Note, Slides) Data Access Data Wrangling Visualization Analytics (Statistics / Machine Learning)
9. • Google Analytics • Super Table • ChartɿChanging Legend Label Text, ‘Others’ Group • Chart : Error Bar • Analytics : Effects by Variables, Multicollinearity, Log, Repeat By • Note : New Format • Data Catalog
10. • Google Analytics • Super Table • ChartɿChanging Legend Label Text, ‘Others’ Group • Chart : Error Bar • Analytics : Effects by Variables, Multicollinearity, Log, Repeat By • Note : New Format • Data Catalog
11. Google Analytics
12. Much Better Experience! • Select dimensions & measures • Change the account, the property, and the view • Select a segment from the dropdown • Set the date range
13. Select Dimensions & Measures
14. Search Dimensions & Measures
15. Show Only Selected
16. Show Details for Dimensions & Measures
17. Select Account, Property, and View
18. Select Segment
19. Set Period
20. • Google Analytics • Super Table • ChartɿChanging Legend Label Text, ‘Others’ Group • Chart : Error Bar • Analytics : Effects by Variables, Multicollinearity, Log, Repeat By • Note : New Format • Data Catalog
21. Super Table
22. • Select Columns • Re-order Columns • Configure Each Column - Column header name, Number / Date format, Color, etc. More Visually Intuitive & More Controls
23. Select Columns
24. Reorder Columns
25. • Change Column Header Names • Apply Functions to Data • Setup Sorting Rules • Format Number/Date Data • Create URL Links • Setup Visual Formatting Column Setting
26. Display Names for Column Headers
27. Use Functions numeric character date/POSIXct
28. Set Sort Priority ̍ Priority ̎
29. Number / Date Format
30. Setup URL Link
31. Visual Formatting • Show Bar on Background • Assign Color to Text or Background • Conditional Formatting
32. Show Bar on Background
33. Assign Color to Text or Background
34. Create Conditions for Color Formatting
35. • Google Analytics • Super Table • ChartɿChanging Legend Label Text, ‘Others’ Group • Chart : Error Bar • Analytics : Effects by Variables, Multicollinearity, Log, Repeat By • Note : New Format • Data Catalog
36. Edit Display Name - Legend
37. Give a new name!
38. Group them together by giving a same name!
40. • Google Analytics • Super Table • ChartɿChanging Legend Label Text, ‘Others’ Group • Chart : Error Bar • Analytics : Effects by Variables, Multicollinearity, Log, Repeat By • Note : New Format • Data Catalog
41. When there are too many groups…
42. ‘Others’ Group - Based on Frequency
43. ‘Others’ Group - Keep / Drop
44. • Google Analytics • Super Table • ChartɿChanging Legend Label Text, ‘Others’ Group • Chart : Error Bar • Analytics : Effects by Variables, Multicollinearity, Log, Repeat By • Note : New Format • Data Catalog
45. Error Bar
46. Much Easier to Create! • Calculation Type • Marker • Range Type
47. Calculation Type
48. Marker
49. Range Type
50. • Google Analytics • Super Table • ChartɿChanging Legend Label Text, ‘Others’ Group • Chart : Error Bar • Analytics : Effects by Variables, Multicollinearity, Log, Repeat By • Note : New Format • Data Catalog
51. Analytics • Effects by Variables • Multicollinearity • Base Level • Numeric Functions - Log, Normalize, Integer, etc. • Outliers Removal • Summary Table - Showing Bars with Repeat By
52. Effects by Variables - Linear Regression
53. Effects by Variables - Linear Regression
54. Effects by Variables - Logistic Regression
55. Effects by Variables - Logistic Regression
56. Effects by Variables - Random Forest
57. Detect Multicollinearity
58. Base Level
59. Remove Outliers
60. Before After
61. Numeric Function Support
62. Apply Log to Predictor Variable
63. Before After
64. Model Summary Table Showing Bars with Repeat By
65. • Google Analytics • Super Table • ChartɿChanging Legend Label Text, ‘Others’ Group • Chart : Error Bar • Analytics : Effects by Variables, Multicollinearity, Log, Repeat By • Note : New Format • Data Catalog
66. Much Easier to Read and Write!
67. • Google Analytics • Super Table • ChartɿChanging Legend Label Text, ‘Others’ Group • Chart : Error Bar • Analytics : Effects by Variables, Multicollinearity, Log, Repeat By • Note : New Format • Data Catalog
68. Data Catalog
70. Import Data Directly from Data Catalog
71. Click to Re-import Data from Data Catalog when the shared data has been updated.
72. Demo
73. One more thing…
74. Exploratory Collaboration Server v5.4
75. Exploratory Collaboration Server
76. Exploratory Desktop BI Excel R / Python / JS Exploratory Desktop Scheduled Auto Data & Insight Generation Discover - Data View - Dictionary - API Exploratory Collaboration Server Data Catalog Linux Server / AWS / GCP / Azure / etc. Insight Catalog Discover - Insight View - Dashboard, Note User Management Sharing Management
77. Create Insights & Data Publish Discover Data Insight & Data Management with Collaboration Server Share Extend
78. Create Insights
79. Order Data Summarize Create Segments RFM Scoring Add Country Information Create Data
80. Publish Insights / Data
81. Share Insights / Data
82. Insight Catalog
83. My Insight Page
84. Search Rank Tag Author Discover Insights
85. View Insights - Dashboard
86. Interact - Dashboard
87. View Insights - Note
88. View Insights - Slides
89. Discover Data - Data Catalog
90. View Data Summary Table Metadata
91. Summary
92. Table
93. Metadata
94. Schedule Insights & Data
95. Price • Starts from $2,498 / year. • Up to 3 authors & 10 viewers. • Requires separate subscriptions for Exploratory Desktop, but no minimal subscriptions.
96. Q & A
97. Contact Email kan@exploratory.io Website https://exploratory.io Data Science Booster Training https://exploratory.io/training Twitter @KanAugust
98. EXPLORATORY