Tools and Techniques for Data Analysis

Washington, D.C. campuses

GA D.C., 1776
1133 15th Street NW, 8th Floor
Washington D.C. 20005

GA D.C. (Northern Virginia)
2231 Crystal Drive #1000
Arlington VA 22202

Past Locations for this Workshop

Tools and Techniques for Data Analysis

Washington, D.C.

Washington, D.C. campuses

GA D.C., 1776
1133 15th Street NW, 8th Floor
Washington D.C. 20005

GA D.C. (Northern Virginia)
2231 Crystal Drive #1000
Arlington VA 22202

Past Locations for this Workshop

About this workshop

‘Big Data’ seems to be everywhere, and with seamless access to large public databases it is easy to get into ‘Data Overload’. Data is the ‘new oil’, meaning it can become a very valuable asset but only if you are able to wrangle this data into meaningful analysis. This class is designed to teach you just how to do that.

It is important to remember a ‘Model’ is simply using a tool to build a representation of a real world situation.

How you will benefit:

  • Extract the most meaningful results from large and small data sets and multiple data types
  • Become familiar with basic text analysis tools and gain insights from unstructured text data (Voyant)
  • Use advanced analysis functions in Excel and open source tools

What You Will Cover:

  • Wrangling, cleansing, and shaping data
  • Data scrapping
  • Using Refine (formerly Google Refine)

Takeaways

Takeaways:

  • Framing and Asking the right business questions
  • Clearly articulate your findings
  • Knowledge of several valuable tools for data analysis

Prereqs & Preparation

As long as you have a basic understanding of spreadsheets, you will learn how to manipulate complex data sets so you can gain insights that are not possible with common business intelligence techniques.

Laptop with Excel (preferably 2013 or later), 10-key function if possible

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.