Discover Classes. Earn 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.

29 classes have spots left

Microsoft Excel Intermediate Level Data Analysis

Discovery Center @ 4318 N Elston Ave, Chicago, IL

Become an Excel Whiz! Pivot Tables, Macros, introduction to Excel VBA and more. Become a more powerful user of Excel. This is an Intermediate Level class for people already familiar with basic data entry in Excel Pre-requisites: MS Excel for Windows. $40 Materials Fee will be collected at the time of the class

(279) Intermediate 16 and older
No upcoming schedules

Excel 2013 Exam Prep - Expert Course

ONLC Training Centers @ 233 S Wacker Dr, Chicago, IL

This Class is for Individuals Seeking Excel Certification This live, instructor-led course is delivered by having the class complete a series of practice exams which mirror the format that you will see when taking the actual exams. Instructor-Guided Exam Review Although the Excel concepts tested on the exam will be reviewed in this class, those concepts will not be "taught" as in the traditional classes. In this Excel Exam Prep Class will be focusing...

(7) Advanced 18 and older
No upcoming schedules
$345
Gift it!

Excel 2007 Advanced Course

ONLC Training Centers @ 233 S Wacker Dr, Chicago, IL

Prerequisites Excel 2007 Intermediate or equivalent skills. Must be able to work with multiple worksheets, use named ranges, and work with functions. Working with Advanced Functions Working with Functions Using the IF Function Nesting Functions Using Multiple Conditions with the IF Function Using Table Lookup Functions (HLookup and VLookup) Using Text Functions Analyzing Data Using Automatic Outlining Consolidating Information by...

(7) Advanced 18 and older
No upcoming schedules
$295
Gift it!
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

Excel 2013 Advanced

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

One of the most important Excel features is Pivot Tables. This course covers creating Pivot Tables as well as using calculated fields and filters. You will learn to connect to external data sources such as Access and web queries. You will learn to use lookup functions and data tables to allow more sophisticated data conversion functions.  This course will also show how to record and execute simple macros. This course is designed for students...

(7) Advanced 18 and older
No upcoming schedules
$295
Gift it!

Excel 2010 Intermediate

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Prerequisites Excel 2010 Introduction or equivalent skills. Must be able to create, open, save, format and print a worksheet. Should be able to use formulas and the SUM function. The ability to copy, move and delete values and formulas is required. Working with Worksheets Viewing, Renaming, and Color-coding Worksheets Editing a Group Manipulating Worksheets Creating Linked Formulas Using 3-D References Working with Functions Using Absolute...

(7) Intermediate 18 and older
No upcoming schedules
$295
Gift it!

Excel 2013 Intermediate

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Go further with Excel by learning to create charts and tables as well as learning time saving formatting and validation features. In this course, you will work Microsoft Office Excel 2013 create charts and tables. You will learn handy formatting and tools for error checking. You will create formulas to that use built-in functions to do advanced analysis. You will also learn to create shared workbooks and to track changes in shared workbooks. This...

(7) Intermediate 18 and older
No upcoming schedules
$295
Gift it!

Excel 2010 Advanced

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

One of the most important Excel features is Pivot Tables. This course covers creating Pivot Tables as well as using calculated fields and filters. You will learn to connect to external data sources such as Access and web queries. You will learn to use lookup functions and data tables to allow more sophisticated data conversion functions.  This course will also show how to record and execute simple macros. This course is designed for students...

(7) Advanced 18 and older
No upcoming schedules
$295
Gift it!

SQL Bootcamp Remote (Online)

General Assembly @ Online Class Livestream, Chicago, IL

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy. SQL provides powerful but reasonably simple tools for data analysis and handling. This Bootcamp will take absolute...

(2637) Beginner 18 and older

2-Day SQL Bootcamp Series

General Assembly @ 444 N Wabash Ave, Chicago, IL

Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one. Registered students will be notified 24 hours in advance of this program with information on how to log in to the Zoom Meeting Room and other tools you’ll need for the session. Registration for this class will close 2 hours prior to the session start in order to allow all students ample opportunity to have...

(2637) Beginner 18 and older
$375

2 sessions

Gift it!

Excel 2010 - Part 1

New Horizons Computer Learning

In this course, students will use Microsoft® Office Excel® 2010 to create spreadsheets and workbooks that they can use to store, manipulate, and share data. Who Should Attend This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2010 that is necessary to create and work with electronic spreadsheets. Upon successful completion of this course, students will be able to:  create a basic...

(8) Beginner 18 and older
No upcoming schedules

SQL Server 2014 Reporting Services

Hands On Technology Transfer, Inc.

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  This course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility. It begins with a discussion of the Reporting Services architecture and how to set up Reporting Services servers. Students will install and configure Reporting Services, and perform hands-on exercises where they create various types of reports, including basic...

(7) All levels 18 and older
No upcoming schedules

Microsoft SQL Server 2017 Administration

Hands On Technology Transfer, Inc.

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2017. You will also learn how to create, manage, back up, and restore individual databases, transfer and replicate data,...

(7) Beginner 18 and older
No upcoming schedules

Microsoft Transact-SQL Programming

Hands On Technology Transfer, Inc.

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course also covers Microsoft-specific T-SQL programming constructs,...

(7) Beginner 18 and older
No upcoming schedules

Mastering Excel - Intermediate

Chicago Computer Classes @ 300 N LaSalle St, Chicago, IL

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great refresher!

(2) Intermediate 18 and older
No upcoming schedules
$179.98
Gift it!

UCCE-A v11.5 - Cisco® Unified Contact Center Enterprise

ONLC Training Centers

Cisco Unified Contact Center Enterprise Administration (UCCE-A) is a 5-day instructor-led course that helps prepare learners to administer the Cisco Unified CCE v11.5 solution. This course will provide the student with the basic knowledge to understand the Cisco Unified CCE deployment solution and requirements for basic ACD and IVR configurations to include using ICM Configuration Manager and associated utilities, setting up agents, providing for...

(7) All levels 18 and older
No upcoming schedules

Oracle Database 11g: SQL Fundamentals Course

ONLC Training Centers

This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features...

(7) Beginner 18 and older
No upcoming schedules

Oracle Database 12c: SQL Fundamentals Course

ONLC Training Centers

Learning the SQL language is one of the most basic tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional. This course introduces the basics of the SQL language and the Oracle Relational Database Management System (RDBMS). One will become acquainted with the differences in the working environment between a traditional on-premise...

(7) Beginner 18 and older
No upcoming schedules

Oracle Database 11g: PL/SQL Fundamentals Course

ONLC Training Centers

The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/SQL program units within an Oracle database. Target Audience Target audience for this course...

(7) Beginner 18 and older
No upcoming schedules

Oracle Database 12c: PL/SQL Fundamentals Course

ONLC Training Centers

This course introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. PL/SQL may be considered...

(7) Beginner 18 and older
No upcoming schedules

Managing SQL Business Intelligence Operations

ONLC Training Centers @ 1363 Shermer Rd, Chicago, IL

This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources. Audience profile The primary audience for this course are business intelligence professionals. The secondary...

(7) Beginner 18 and older
No upcoming schedules
$695

2 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,940 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...