Data Analytics

at General Assembly - Online

(2556)
Course Details
Price:
$3,950 8 seats
Start Date:

Mon, Aug 31, 11:00am - Sep 05, 7:00pm Central Time (6 sessions)

Next start dates (6)

Location:
Purchase Options
Description
Class Level: All levels
Age Requirements: 18 and older
Average Class Size: 20

Flexible Reschedule Policy: This provider has flexible, free rescheduling for any-in person workshop. Please see the cancellation policy for more details

What you'll learn in this data analyst training:

This is a 10-week part-time or 1-week accelerated course.

This 10-week course will teach you how to use large datasets to make critical decisions.

The Big Picture: Confidently make—and defend—critical decisions using the results of your data analysis.

Skills, Tools, & Strategies: Use Excel, SQL, and Tableau to spot trends and drive business decisions with real-world data.

Analytics in Practice: Share your insights and tell compelling stories using data visualizations and dashboards. 

What You'll Learn:


Unit 1: Data in Excel 

The Value of Data 

  • Explain the value of data
  • Describe the analytics workflow
  • Use mean, median, mode to describe data and find outliers
Prepare Data in Excel 
  • Describe best practices in data cleaning and collection to ensure the best results from data analysis
  • Use complex nested logical functions [IF, OR, and AND] to further manipulate data sets
  • Manipulate data formats to gain insights on how to analyze data
Clean Data in Excel 
  • Clean a large messy datasets by removing duplicate rows and performing text manipulations
  • Transform and rearrange columns and rows to structure data for analysis
  • Manipulate data formats to gain insights on how to analyze data
Dynamic Data Referencing 
  • Use data functions [VLOOKUP and HLOOKUP] to manipulate data sets
  • Use data functions [INDEX and MATCH] to look up values in other tables
  • Reconcile data values by joining and matching
Dynamic Data Aggregation 
  • Summarize data using the pivot tables Use excel aggregation commands [‘Min’, ‘Max’, ‘Sum’, ‘Average’, ‘Count’, ‘Frequency’ to accomplish “count distinct” ] and their conditional variants [‘COUNTIF’, ‘COUNTUNIQUE’, ‘COUNTA’, ‘COUNTIFS’, ‘COUNTBLANKS’] to summarize data sets
Conditionally Formatting and Aggregations 
  • Derive insights from data by highlighting cells based on conditionals using the following excel functions ['Greater Than', 'Less Than', 'Between', 'Equal To', 'Text That Contains']
  • Create clear charts that improve clarity, avoid unnecessary embellishment, provide quick take aways and facilitate secondary understanding from closer look at chart.
  • Select appropriate chart combinations in the context of problem
  • Describe color theory and how it applies to data visualization
Unit 2: Data in SQL

The Value of Databases and SQL 
  • Use database schema to design appropriate queries
  • Explain differences between relational databases (tabular data storage) and document-based databases(key-value pairs)
  • Collect data using standard sql commands [Create, Update, Delete, Truncate, Drop] Collect data using standard sql commands [Select, From]
Query Large Databases 
  • Use advanced SQL commands [where, groupby, having, orderby, limit] to filter data
  • Use joins to create relationships between tables to obtain data
  • Use SQL boolean operators [AND and OR] and SQL conditional operators [=,!=,>,<,IN and BETWEEN] to obtain filtered data
Data Aggregation in SQL 
  • Create relationships between tables and data points including has_many and many_to_many with join tables using Joins [‘full’, and ‘union’] Use sql conditional operators [=,!=,>,<,IN and BETWEEN] and Null functions[‘is Null’, ‘ is not Null’ and ‘NVL’ ] to create boolean statements
  • Use sql mathematical functions [ABS, SIGN, MOD, FLOOR, CEILING, ROUND, SQRT] to clean data
More Data Aggregation in SQL 
  • Use aggregation commands [‘Min’, ‘Max’, ‘Sum’, ‘Average’, ‘Count’, ‘Count Distinct’] to summarize data sets
  • Use aggregation methods to determine trends from data
Efficient and Dynamic Queries 
  • Use CASE statements to structure data and create new attributes Use \"\"WITH AS (\"\" to combine subqueries into one query
  • Present analysis results and describe stakeholder implications and insights
Present Analysis Results 
  • Provide appropriate context for datasets
  • Appropriately describe analysis techniques
  • Present and describe stakeholder implications and insights
Unit 3: Communication and Dashboard Design

Statistics to Validate Analysis 
  • Describe the value of descriptive and summary statistics in understanding a dataset
  • Create basic statistical measures to better understand the range, average, and variance within a dataset
  • Present the most salient statistics in order to provide context to your audience
  • Explain the importance of segmentation
Statistics to Validate Analysis II 
  • Describe the value of inferential statistics and predictive analysis
  • Review linear regression and Ordinary Least Squares (OLS)
  • Use sample data to make predictions about a larger population
Dashboard Design 
  • Use scatter plots and bar graphs to visualize data
  • Apply the best practices to build a dashboard
  • Demonstrate good visual design without overloading their dashboard with complexity
Track Metrics with Dashboards 
  • Use bubble graphs to visualize data
  • Apply the best practices to build a dashboard
  • Contextualize data analysis by creating Tableau dashboards [includes charts + conditional formatting] with supporting information specific to the dataset
Effective Presentation with Data 
  • Display geocoded information in Tableau
  • Provide real-world context for basis of analysis
  • Provide localized context for implications of findings
  • Deliver short, effective presentations
Flexible Session 
  • Focus on a topic selected by the instructor/class in order to provide deeper insight into a specific area of data analysis
Flexible Session 
  • Focus on a topic selected by the instructor/class in order to provide deeper insight into a specific area of data analysis
Final Presentations 
  • Gain feedback from peers, instructor, and guest panelists that will identify strengths and areas for improvement

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

School Notes:
For students enrolling in 12 week part time and immersive classes, it is not recommended that you book more than one class simultaneously.

Still have questions? Ask the community.

Refund Policy
If you can't make it to a class/workshop, please email us at [email protected] at least 7 days before the scheduled event date. No refunds will be given after this timeframe.

Map

Google Map

General Assembly

All classes at this location

1) Download Zoom, our video conferencing appZoom Desktop is the video conferencing tool we will use. It works a lot like Google Hangouts or Skype. You will need to create an account in order to join the call. 

2) Sign-in to Slack and create an account. Slack is a written chat tool that your instructor may use to post photos, links, resources, polls, and threads. It also gives you and your classmates an opportunity to ask questions and collaborate!
- Download the Slack desktop app for ease of use
- Join the GA Chicago Workshop’ workspace

Start Dates (7)
Start Date Time Teacher # Sessions Price
11:00am - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli 6 $3,950
This course consists of multiple sessions, view schedule for sessions.
Tue, Sep 01 11:00am - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Sep 02 11:00am - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Thu, Sep 03 11:00am - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Fri, Sep 04 11:00am - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Sat, Sep 05 11:00am - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli 20 $3,950
This course consists of multiple sessions, view schedule for sessions.
Wed, Sep 02 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Sep 09 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Sep 14 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Sep 16 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Sep 21 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Sep 23 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Sep 28 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Sep 30 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 05 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 07 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 12 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 14 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 19 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 21 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 26 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 28 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Nov 02 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Nov 04 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Nov 09 8:00pm - 10:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli 6 $3,950
This course consists of multiple sessions, view schedule for sessions.
Tue, Sep 15 9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Sep 16 9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Thu, Sep 17 9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Fri, Sep 18 9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Sat, Sep 19 9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli 20 $3,950
This course consists of multiple sessions, view schedule for sessions.
Wed, Sep 16 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Sep 21 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Sep 23 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Sep 28 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Sep 30 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 05 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 07 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 12 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 14 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 19 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 21 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 26 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 28 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Nov 02 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Nov 04 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Nov 09 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Nov 16 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Nov 18 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Nov 23 5:00pm - 7:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli 20 $3,950
This course consists of multiple sessions, view schedule for sessions.
Thu, Sep 24 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Tue, Sep 29 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Thu, Oct 01 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Tue, Oct 06 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Thu, Oct 08 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Tue, Oct 13 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Thu, Oct 15 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Tue, Oct 20 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Thu, Oct 22 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Tue, Oct 27 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Thu, Oct 29 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Tue, Nov 03 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Thu, Nov 05 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Tue, Nov 10 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Thu, Nov 12 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Tue, Nov 17 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Thu, Nov 19 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Tue, Nov 24 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Tue, Dec 01 8:30pm - 10:30pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Start Date Time Teacher # Sessions Price
9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli 6 $3,950
This course consists of multiple sessions, view schedule for sessions.
Sat, Oct 03 9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Sat, Oct 10 9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Sat, Oct 17 9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Sat, Oct 24 9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Sat, Oct 31 9:00am - 5:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli 20 $3,950
This course consists of multiple sessions, view schedule for sessions.
Wed, Sep 30 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 05 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 07 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 12 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 14 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 19 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 21 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Oct 26 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Oct 28 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Nov 02 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Nov 04 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Nov 09 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Nov 16 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Nov 18 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Nov 23 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Nov 30 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Dec 02 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Mon, Dec 07 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli
Wed, Dec 09 7:00pm - 9:00pm Central Time Alexandra Sanne, Gus Lopez & David Napoli

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 39500 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at General Assembly (2,541)

Similar Classes

School: General Assembly

General Assembly

General Assembly is a pioneer in education and career transformation, specializing in today’s most in-demand skills. The leading source for training, staffing, and career transitions, we foster a flourishing community of professionals pursuing careers they love.

What began as a co-working space in...

Read more about General Assembly

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

Ready to take this class?
BOOK NOW
Booking this class for a group? Find great private group events here