Data Analytics

at General Assembly - Near North Side

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

Mon, Dec 16, 9:00am - Dec 21, 2:00pm (6 sessions)

Next start dates (1)

Location:
Near North Side, Downtown/Loop
444 N Wabash Ave 5th Fl
Btwn E Illinois & E Hubbard Streets
Illinois City, Illinois 60611
(Map)
Share:
Purchase Options
Description
Class Level: All levels
Age Requirements: 18 and older
Average Class Size: 20

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
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

Start Dates (2)
Start Date Time Teacher # Sessions Price
6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont 18 $3,950
This course consists of multiple sessions, view schedule for sessions.
Wed, Oct 30 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Mon, Nov 04 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Wed, Nov 06 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Wed, Nov 13 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Mon, Nov 18 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Wed, Nov 20 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Mon, Nov 25 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Mon, Dec 02 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Wed, Dec 04 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Mon, Dec 09 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Wed, Dec 11 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Mon, Dec 16 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Wed, Dec 18 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Mon, Jan 06 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Wed, Jan 08 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Mon, Jan 13 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Wed, Jan 15 6:30pm - 8:30pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
9:00am - 5:00pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont 6 $3,950
This course consists of multiple sessions, view schedule for sessions.
Tue, Dec 17 9:00am - 5:00pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Wed, Dec 18 9:00am - 5:00pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Thu, Dec 19 9:00am - 5:00pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Fri, Dec 20 9:00am - 5:00pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont
Sat, Dec 21 9:00am - 2:00pm M.Burton J.Strazzeri N.Van de Bovenkamp V.Srivastava D.Bickham S.Dal Pont

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,129)

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
Taking this class for work? Get exclusive perks & discounts for free.