Discover Classes. Earn 10% Rewards.

Data Analyst Training Chicago

Upcoming schedule view

Learn the skills and tools you need to become a data analyst with hands-on classes in big data and data analysis. Gain practical knowledge in Python, SQL, data visualization, and more, and unlock new career opportunities in the growing field of data analysis.

28 classes have spots left

Python Data Analysis with NumPy and Pandas

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

This is a rapid introduction to NumPy, pandas and matplotlib for experienced Python programmers who are new to those libraries. Students will learn to: use NumPy to work with arrays and matrices of numbers; work with pandas to analyze data; and work with matplotlib from within pandas. Audience Students already familiar with Python programming. Prerequisites Basic Python programming experience. In particular, you should be very comfortable with:...

(7) Intermediate 18 and older
No upcoming schedules
$995

2 sessions

Gift it!

Advanced Python 3 Programming

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

In this Python training course, students already familiar with Python programming will learn advanced Python techniques. This advanced Python course is taught using Python 3; however, differences between Python 2 and Python 3 are noted. Goals Learn to work with the Collections module. Learn about mapping and filtering and lambda functions. Learn advanced sorting. Learn to work with regular expressions in Python. Learn to work with databases,...

(7) Advanced 18 and older
No upcoming schedules
$995

2 sessions

Gift it!

Javascript Fundamentals Bootcamp

General Assembly @ 444 N Wabash Ave, Chicago, IL

This one-day bootcamp is geared towards beginners with little or no prior experience and provides a full introduction to programming fundamentals using JavaScript. You will be introduced to some of the tools that will help you approach programming in a systematic way including flow charts and pseudo-code. Building on that foundation we will use JavaScript, the language of the web, to play with all of the basic structures of most modern programming...

(2637) Beginner 18 and older
Discover Classes. Earn Rewards.

Data Analyst Classes Gift Card

Thousands of classes & experiences. No expiration. Gift an experience this holiday season and make it a memorable one. Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Large Language Models (Using Huggingface)

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

In this 3-day developer class on working with Large Language Models, we will show you how to use Transformers in Natural Language Processing and leverage the capabilities available on Huggingface. You'll learn how transformer models work and their limitations, as well as how to fine-tune a pre-trained model using the Trainer API or Keras. We'll cover sharing models and tokenizers on the Hugging Face Hub and how to create your own dataset and perform...

(7) Intermediate 18 and older
No upcoming schedules
$1,495
Gift it!

Python for Beginners

General Assembly

Unlock data-driven insights with code. Explore the intersection of coding and data with General Assembly. During our Python-focused introductory workshop, you’ll learn to harness the power of an essential programming language for data scientists and use it to drive accurate business insights. Working with real-world examples, you’ll: Touch on fundamental Python programming techniques and tools. Discover the history of Python and how...

(2637) Beginner 18 and older

Microsoft Excel Introduction

Training Connection @ 230 W Monroe St, Chicago, IL

On this hands-on class you will learn to create, modify, format and print Excel worksheets. You will learn to use basic formulas and functions and manage large workbooks. Target Audience: This course is ideal for people new to Excel who need to produce reports, budgets, lists and other spreadsheets. Suitable for Excel 2007, 2010 and 2013 users. Detailed Course Outline Getting started in Excel  Opening Excel Using the Recent List Opening...

(158) Beginner 14 and older
No upcoming schedules
$350
Gift it!

Microsoft Excel - Macros & VBA

Training Connection @ 230 W Monroe St, Chicago, IL

This course is designed to give experienced Excel usersproficiency in creating procedures that run in response to specific events, creating user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. Target Audience: This course is aimed at experienced Excel users looking to automate many of the repetitive tasks that are part of spreadsheet development by applying the Visual...

(158) Advanced 14 and older
No upcoming schedules
$450
Gift it!

Microsoft Excel Level 1

Training Connection @ 230 W Monroe St, Chicago, IL

You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course is ideal for people new to Excel who need to produce reports, budgets, lists and other spreadsheets. This hands-on beginner class is suitable for Excel 2010, 2013 and 2016 users....

(158) Beginner 14 and older
No upcoming schedules
$350
Gift it!

Python Programming 101

General Assembly @ 444 N Wabash Ave, Chicago, IL

Unlock data-driven insights with code. During our Python-focused introductory workshop, you’ll learn to harness the power of an essential programming language for data scientists and use it to drive accurate business insights. Working with real-world examples, you’ll: Touch on fundamental Python programming techniques and tools. Discover the history of Python and how it compares to other programming languages. Discuss its applications in...

(2637) Beginner 18 and older

Excel Bootcamp

General Assembly

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your data. Dive into formula writing, combining formulas, creating basic to intermediate charts, and, of...

(2637) Beginner 18 and older

Microsoft Excel Intermediate

Training Connection @ 230 W Monroe St, Chicago, IL

In this hands-on class you will learn to enhance spreadsheets using charts, themes, styles and graphics. The course also covers advanced functions, VLOOKUPS and HLOOKUPS, sorting data, PivotTables and PivotCharts. Target Audience: Participants are recommended to have completed Excel Introduction or have the equivalent experience prior to attending this course. Suitable for Excel 2007/2010/2013 users. Detailed...

(158) Intermediate 14 and older
No upcoming schedules
$350
Gift it!

Microsoft Excel Advanced

Training Connection @ 230 W Monroe St, Chicago, IL

On this hands-on class participants will learn advanced Macros, Scenarios with What If analysis, how to collaborate with others, advanced data analysis, and Power View. Target Audience: Participants are recommended to have completed Excel Intermediate or have the equivalent experience prior to this course. Suitable for Excel 2007/2010/2013 users. Detailed Course Outline Advanced Formulas and Function Tasks...

(158) Advanced 14 and older
No upcoming schedules
$350
Gift it!

Microsoft Excel Level 2

Training Connection @ 230 W Monroe St, Chicago, IL

You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. Prerequisite:  You should have completed our Introduction class or have the equivalent experience prior to attending this course. ...

(158) Intermediate 14 and older
No upcoming schedules
$350
Gift it!

Microsoft Excel Level 3

Training Connection @ 230 W Monroe St, Chicago, IL

This hands-on class is suitable for Excel 2013 and 2016, 2019 & 365 users.  On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture...

(158) Advanced 14 and older
No upcoming schedules
$350
Gift it!

Excel 2007 Programming with VBA Course

ONLC Training Centers

Prerequisite Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required. Getting Started Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro Saving a Macro-Enabled Workbook Running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Closing the Visual Basic Editor Understanding Macro...

(7) Beginner 18 and older
No upcoming schedules

Excel 2013 Programming with VBA Course

ONLC Training Centers

Prerequisite Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required. Getting Started Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro Saving a Macro-Enabled Workbook Running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Closing the Visual Basic Editor Understanding Macro...

(7) Beginner 18 and older
No upcoming schedules

Power View Level 1

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Introduction to Power View Installing Power View Canvas Field List Field Well Filters Area View Area Ribbon Loading Data Report Design Titles Adding Fields Filtering, Formatting and Sizing a Visualization Using Tiles Additional Visualizations Setting the Table Including Images Creating a Matrix Report Creating a Card Report Charting Basics Creating a Chart Chart Components Enhancing a Chart Cart Icons Cart Titles Data...

(7) All levels 18 and older
No upcoming schedules
$995

2 sessions

Gift it!

Excel 2010 Programming with VBA

ONLC Training Centers

Prerequisite Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required. Getting Started Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro Saving a Macro-Enabled Workbook Running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Closing the Visual Basic Editor Understanding Macro...

(7) Beginner 18 and older
No upcoming schedules

Microsoft Analysis Services & Excel PowerPivot

ONLC Training Centers @ Two Mid America Plaza, Chicago, IL

Full Course Name: Data Mining, Predictive Analytics with Microsoft Analysis Services and Excel PowerPivot This three-day instructor-led course will introduce the students to the concepts of data mining, machine learning and predictive analytics utilizing the Microsoft toolsets including SQL Server Analysis Services and Excel with PowerPivot and the Data Mining Add-ins. Audience This course is intended for Power Users, IT Professionals, Report Developers,...

(7) Beginner 18 and older
No upcoming schedules
$1,795

3 sessions

Gift it!

Analyzing Data with Excel

ONLC Training Centers @ 1000 Essington Rd, Chicago, IL

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI. Audience profile: This course is intended for anyone responsible for analyzing data with Excel. The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data....

(7) All levels 18 and older
No upcoming schedules
$1,595

3 sessions

Gift it!
Reset all filters.

No results found

Try removing some filters.

Data Analyst Training in Chicago are rated 4.3 stars based on 2,802 verified reviews from actual CourseHorse.com purchasers.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...