Recap 2/26/2020: Accounting & Finance Analytics Special Topic

This week, we covered a wide range of finance and accounting topics including:

  • Foundational Accounting Principles
  • Vertical Statement/”Common-size” Analysis
  • Fraud Detection
  • Importing and Analyzing Stock Data in Rstudio
  • Single Stock & Portfolio Return Calculations in R
  • Technical Analysis vs. Fundamental

We could spend hours covering each one of these topics in depth, please let us know if you’d be interested in that by emailing us.

For those who couldn’t make it, below are the slides and files we went over. The R markdown file has descriptions for each code block so you can follow along.

Slides, R Markdown File, Financial Statement Analysis (DAL)

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-Prep-Blog-1
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