Recap 1/15/2020: Basics of Data Science Workshop

For this week’s workshop, we went over the data science realm in general and talked about various tools leveraged by data scientists and analysts. Please see below for a summary of the workshop and link to the slides!

Covered in Workshop:

  • Debuted a sleek new look for our slides and logo!
  • Discussed our club’s purpose
  • Overview of various aggregated resources
  • The data science profession and their toolset
  • Overview of data visualization
  • Shared student projects (links on slides)
  • Discussed machine setup steps
  • Went over basic R syntax & Dplyr package

Workshop Slides

Recap 11/13/2019: Predictive Analytics Introduction Workshop

For this week’s workshop, we covered the basics of predictive analytics by introducing the concepts of explanatory analysis, linear regression, decision tree and random forest. The students during the workshop were able to learn how to explore a dataset in R and build a linear model to predict the future. Please see below for a summary of the workshop and link to the slides!

Covered in Workshop:

  • Went over basic R syntax & dplyr package
  • Real-world examples of predictive analytics
  • Importance & methods of cleaning data
  • Introduction of linear regression
  • Evaluation & interpretation of linear regression
  • Introduction of classification
    • Decision Trees
    • Random Forest
  • Books and classes recommendation to study data science

Workshop Slide

RECAP 11/6/2019: Tableau Workshop

Tableau is a popular request from our members, so we try to hold at least one workshop using Tableau per quarter. This quarter, we introduced the concepts of Tableau using crash data. We collaborated with UW Actuarial Club for this workshop! Please see below for a summary of this workshop and download links for the slides.

Covered in Workshop:

  • Installing Tableau for Free
  • Loading Data
  • Creating & Manipulating Basic Visualizations
  • Publishing Dashboards
  • Map Demo
  • Demo by UW Actuarial Club

    Workshop Slides

RECAP 10/23/19: SQL Workshop

In this fall quarter workshop, we introduced SQL and some of its main syntax, as well as how to download MySQL. About 30 members attended, but for those who missed it, here is a brief overview of what we discussed. For your reference, we have also included links to MySQL and the complete slides from the workshop.

Covered in Workshop:

  • Database Management System Overview
    • Hierarchical vs. relational
  • Syntax (Insert, Update, Select, etc.)
  • Joining Techniques
  • Keys, Composite Keys, Foreign Keys

MySQL Download,   Workshop Slides