1218 Third Ave Seattle , WA 98101 , Seattle, WA
*This is a Paid Workshop. Please register using the link below*DEEP DIVE INTO DATA ANALTYICS - PART 3: TOOLS AND TECHNIQUES
About This Workshop Series
This is PART THREE of a three-part Data Analytics class series. This is PART TWO of a three-part Data Analytics workshop series.
Part 1: Telling the Story With Data
Part 2: Data Models
Part 3: Tools and Techniques for Data Analysis
Big Data is 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 it into a meaningful analysis. This class is designed to teach you how to do that.
What We Will Cover:
Wrangling, cleansing, and shaping data
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
Framing and Asking the right business questions
Clearly articulate your findings
Knowledge of several valuable tools for data analysis
Prereqs & Preparation
A basic understanding of Excel’s capabilities and common Excel functions.
Laptop with Excel (preferably 2013 or later), 10-key function if possible
Have "Developer" Tab loaded onto Excel Ribbon (Instructions: http://www.techonthenet.com/excel/questions/developer_tab2013.php)
Have "Solver" loaded in Excel; under Data Tab on Excel Ribbon (Instructions: https://support.office.com/en-us/article/Load-the-Solver-Add-in-ec994cd0-a396-4bf3-a5dd-feda369cef37)
Have "Data Analysis" loaded in Excel; under Data Tab on Excel Ribbon (Instructions: https://support.office.com/en-us/article/Load-the-Analysis-ToolPak-305c260e-224f-4739-9777-2d86f1a5bd89)