Exploratory-v54-Introduction-en.pdf

19fc8f6113c5c3d86e6176362ff29479?s=47 Kan Nishida
December 04, 2019

 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.

19fc8f6113c5c3d86e6176362ff29479?s=128

Kan Nishida

December 04, 2019
Tweet

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!

  39. None
  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

  69. None
  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