The Power of Community

Funny Boy Thomas, VP of AACUW

Hello reader,

My name is Thomas Khoo. I started Applied Analytics with Nick not only for his reasons stated before but also because of the power data has to bridge things together. After reading the articles posted on our Facebook page, it is clear that data plays an underlying role in many things. And the best thing: anyone can learn it.

The resources to learn visualization software, like Tableau and Power BI, and programming languages such as Python and SQL, are available at our website (aacuw.org). Under the Resources tab you’ll find links to languages and programs that can teach you how to use them. Applied Analytics provides the opportunity for individuals to enable themselves with the data analytics and machine learning skills employers are seeking.

You may ask at this point, what does that have to do with community? The community aspects are derived from the accessibility and availability. There are no financial barriers to consider, no discrimination or bias, no ambiguity about what you know. You have the skills they want. Period. Not many disciplines bear all three.

On top of the individuals benefit, many analytics require the specific understanding of the data’s nature. Data takes on any form. Data can predict how a protein will develop without having to wait months while on the other side data can predict when a woman is pregnant. Data give you incredible power. Understanding data’s cohesive nature will create synergy that will elevate everyone to higher levels and brighter skies.

Join us in our endeavor to lift the community!

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

Recap 10/16/2019: Marketing with Data Guest Speaker: Stewart Pearson

For this week’s guest lecture, we had Stewart Pearson coming over to talk about what he has discovered working as a marketing specialist for years in different countries. The topics include agencies, advertising and brands in the golden age and a case study of Coca-Cola…

Covered in Guest Lecture:

  • How advertising agencies evolved
  • Advertising, brands and culture in the golden age
  • Impact of competing emotionally
  • Why Pepsi failed and why Coca-Cola continues
  • The functions of advertising in our culture and commerce
  • Advertising Today
  • Most Effective Advertising: Long-Term
  • Agencies Today
  • Challenges Today

Guest Lecture Slide

Our Blog’s Purpose

“It is a capital mistake to theorize before one has data.”

Sherlock Holmes

Fictional character quote aside, data is utterly important, both then and now. Those with the data and the knowledge to interpret it have a significant advantage over those without. Today’s top companies, top executives, and top job candidates understand that a current data aptitude is required to excel today and to survive in the future.

This blog is an extension of the content curated and created by the Applied Analytics Club at UW (AACUW). AACUW was founded in the fall of 2018 to offer a broad exposure of data science and analytics to the University of Washington community. The purpose of this blog is to extend our mission further into the online space to make data education even more accessible. We will post original content including step-by-step tutorials, club updates, and opinion posts discussing data from university students’ lenses. Finally, we will re-post significant content from our other online outlets such as our YouTube page, Linkedin page, Instagram page, and Facebook page (all content including event details are posted on FB… we recommend you follow/like us).

Finally, we encourage data-passionate individuals to contribute by becoming writers on this blog! Contact uwappliedanalytics@gmail.com if you are interested in contributing; we welcome students and professionals alike.

Let’s build an online data community where students and professionals can collaborate and share ideas together!


Nick Stoner, President of AACUW