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

Seminar #48 - Introduction to Exploratory v6.6

Seminar #48 - Introduction to Exploratory v6.6

We have released Exploratory v6.6 just the other day. In this seminar, Kan has introduced some of the exciting new features including the following items.

* Summary View - Correlation Mode
* Analytics - Factor Analysis
* Analytics - Text Analysis
* Data Source - Salesforce
* R 4.1 Upgrade

Subscribe ↓

Twitter ↓

UI Tool: Exploratory(https://exploratory.io/)
Exploratory Online Seminar: https://exploratory.io/online-seminar


Kan Nishida

June 16, 2021


  1. EXPLORATORY Online Seminar #48 Exploratory v6.6

  2. Kan Nishida CEO/co-founder Exploratory Summary In Spring 2016, launched Exploratory,

    Inc. to democratize Data Science. Prior to Exploratory, Kan was a director of product development at Oracle leading teams to build 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
  3. 3 Data Science is not just for Engineers and Statisticians.

    Exploratory makes it possible for Everyone to do Data Science. The Third Wave
  4. 4 Questions Communication Data Access Data Wrangling Visualization Analytics (Statistics

    / Machine Learning) Data Science Workflow
  5. 5 Questions Communication (Dashboard, Note, Slides) Data Access Data Wrangling

    Visualization Analytics (Statistics / Machine Learning) ExploratoryɹModern & Simple UI
  6. EXPLORATORY Online Seminar #48 Exploratory v6.6

  7. None
  8. UI SQL 2 Modes

  9. UI

  10. None
  11. None
  12. UI SQL 2 Modes

  13. SQL (SOQL)

  14. None
  15. None
  16. • Salesforce • SQL Data Import Dialog: Table Search Support

    Data Source
  17. None
  18. Summary View

  19. • Correlation ModeɿVisualization Updates • Correlation ModeɿMachine Learning Models •

    Data Export Summary View
  20. None
  21. None
  22. You can turn on the Prediction to show the predicted

  23. You can switch between the algorithms for the prediction.

  24. When the target variable is Logical it will show the

    logistic curve.
  25. You can export the data you see in the Summary

  26. None
  27. You can export the data you see in the Correlation

    Mode as well!
  28. None
  29. Analytics Text Analysis Factor Analysis

  30. None
  31. None
  32. None
  33. None
  34. None
  35. None
  36. None
  37. None
  38. • Error Bar (Summarized Data) • Search for Table •

    Export to Google Sheet Chart
  39. Error Bar can be used to visualize ‘uncertainty’ or Confidence

  40. It expects the data to be ‘non aggregated’.

  41. But, if the data is already aggregated…

  42. This is when you want to use the new Error

    Bar (Summarized Data) type.
  43. You can assign a column for Numerator and a column

    for Denominator. Numerator Denominator Bounces Sessions Bounce Rate =
  44. None
  45. None
  46. Calendar Widget

  47. R 4.1 Upgrade

  48. None
  49. Performance - M1 Mac (Apple Silicon) CSV File Import 2x

    αϚϦɾϏϡʔ - ϕʔγοΫ αϚϦɾϏϡʔ - ૬ؔϞʔυ 2.5x 1.5x
  50. 2x 2.5x 1.5x Faster! 🚀 R 4.0 (Intel) vs. R4.1

    for M1 Mac (Apple Silicon)
  51. None
  52. That’s it for today!

  53. Next Seminar

  54. EXPLORATORY Online Seminar #49 6/23/2021 (Wed) 11AM PT Introduction to

  55. None
  56. Information Email kan@exploratory.io Website https://exploratory.io Twitter @ExploratoryData Seminar https://exploratory.io/online-seminar

  57. Q & A 57