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.

27 classes have spots left

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

Managing SQL Business Intelligence Operations

ONLC Training Centers @ Two Mid America Plaza, 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!

Data Analysis: Moving from Excel to SQL

General Assembly @ 150 N Wacker, Chicago, IL

Are you using Excel for analysis? Spreadsheets are useful for analyzing and visualizing data, but become cumbersome and unwieldy with large datasets. Relational databases address many of Excel's limitations by simplify repetitive tasks and enabling analysis over much larger datasets. The only catch is that you need to know SQL to fully harness the power of these technologies. This class will introduce students to the world of databases and analysis...

(2637) Intermediate 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

Intermediate SQL Bootcamp

General Assembly @ 150 N Wacker, Chicago, IL

This workshop will build upon the skills developed in the SQL Bootcamp. The program uses a combination of lecture and in-class exercises to ensure that students leave with a working grasp of the SQL skills covered in class. Students will immediately be able to apply their skills at work. The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19...

(2637) Intermediate 18 and older

Intermediate SQL Bootcamp Remote (Online)

General Assembly

Enabling analysts to broaden their SQL skills to retrieve and manipulate data from multiple sources into timely, cohesive, informative analysis. Takeaways: We will be going over the following: JOIN and UNION with Aliasing Primary and Foreign Keys Aggregation and Functions Complex JOINs with multiple tables NULL values and related SQL functions GROUP BY combined with HAVING CASE and COALESCE Preparation: This course will occur...

(2637) Intermediate 18 and older

SQL for Beginners

General Assembly @ 150 N Wacker, Chicago, IL

Looking to learn some basic SQL skills to filter, aggregate or produce reports from a database? Exporting data and using Excel instead of taking advantage of functionality your database already gives you? This class will give you the skills required to perform both basic and complex data manipulations with ease. This class will introduce students to SQL queries for data gathering and data analysis. We will cover enough query syntax and examples...

(2637) Beginner 18 and older

Excel 2003 - Level 3

New Horizons Computer Learning @ 462 Seventh Ave, New York, NY

In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. ​This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import...

(8) Advanced 18 and older
No upcoming schedules
$275
Gift it!

Excel 2010 - Part 3

New Horizons Computer Learning @ 525 W Van Buren St, Illinois City, IL

The students will learn about some of the more advanced features of Excel including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications. Who Should Attend This course is intended for students who are experienced Excel 2010 users who have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will...

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

Excel 2010 - Part 2

New Horizons Computer Learning @ 525 W Van Buren St, Illinois City, IL

This course builds upon the foundational Microsoft® Office Excel® 2010 knowledge and skills you’ve already acquired and sets you on the road to creating advanced workbooks and worksheets that will deepen your firm’s business intelligence. Who Should Attend This course is designed for students who already have foundational knowledge and skills in Excel 2010 and who wish to begin taking advantage of some of the higher-level functionality in...

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

Excel 2013 - Part 2

New Horizons Computer Learning @ 525 W Van Buren St, Illinois City, IL

Students will build upon the foundational Microsoft® Office Excel® 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering. Who Should Attend This course is designed for students who already have foundational knowledge and skills in Excel 2013 and who wish to begin taking advantage of some of the higher-level functionality...

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

SQL Server 2017 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 2017 (SSRS) utility. All reports are developed utilizing SQL Server Data Tools (SSDT), however Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing...

(7) Intermediate 18 and older
No upcoming schedules

Analyzing Data with SQL Server Reporting Services

ONLC Training Centers

This five-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions. Audience profile The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities...

(7) Intermediate 18 and older
No upcoming schedules

Intermediate SQL Bootcamp

General Assembly

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation very carefully and are adjusting delivery of our programs. 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...

(2637) Intermediate 18 and older

Data Warehousing on AWS

ExitCertified @ 230 W Monroe St, Chicago, IL

Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis Firehose, and Amazon S3. Additionally, this course demonstrates how to use business...

(2) All levels 18 and older
No upcoming schedules
$2,025

3 sessions

Gift it!

Design Your Data: Tableau Bootcamp

General Assembly

Tableau is an incredibly powerful tool for exploring and visualizing your data. This day long bootcamp will allow people with no experience in Tableau to re-create all of its major charts and turn them into a functional, interactive dashboard by the end of the day. Once people understand the power of Tableau they can quickly perform vital business analysis that would take 3-5x times as long with other software tools. When you are finished you’ll...

(2637) All levels 18 and older

Data Science and Big Data Analytics

Global Knowledge

Discover how to use big data and the Data Analytics Lifecycle to address your business challenges. In this course, you will gain practical foundation level training that enables immediate and effective participation in big data and other analytics projects. You will cover basic and advanced analytic methods and big data analytics technology and tools, including MapReduce and Hadoop. The extensive labs throughout the course provide you with the opportunity...

(12) Beginner 18 and older
No upcoming schedules

Relational Database Design Concepts

Hands On Technology Transfer, Inc. @ 1701 E Woodfield Rd, Schaumburg, IL

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  This relational database design class develops relational database design skills and techniques. Practical methodologies such as E-R diagrams and normalization forms are emphasized. Attention is placed on designing for data integrity and efficiency at the same time. Students Will Learn:  Design normalized table structures for relational...

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

3 sessions

Gift it!

Excel BI Tools: DAX Formulas for Dynamic Tables

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

This course is for individuals responsible for taking data and turning it into powerful reports. With DAX you can create reusable formulas the allow you to rapidly iterate and answer questions across multiple data tables and across different sources for complex reporting requirement. This course covers essential information needed for DAX-related reporting requirements. Specifically, it leverages the DAX language, teaching how to build models that...

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

2 sessions

Gift it!

Splunk Fundamentals: Level 1

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Unlock the power of Splunk and gain invaluable insights into your data with this comprehensive course. Learn how to navigate the interface, bring in data, search and report, create alerts and dashboards, and analyze trends to optimize your business operations. Take your operational intelligence to new heights with Splunk.

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

2 sessions

Gift it!

Database Fundamentals

ONLC Training Centers

Students who are beginning studies in technology need a strong foundation in the basics before moving on to more advanced technology courses and certification programs. The Microsoft Technology Associate (MTA) is an innovative certification track designed to provide a pathway for future success in technology courses and careers. The MTA program curriculum helps teach and validate fundamental technology knowledge. Database Administration Fundamentals...

(7) Intermediate 18 and older
No upcoming schedules
Reset all filters.

No results found

Try removing some filters.

Data Analyst Training in Chicago are rated 4.3 stars based on 2,673 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...