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
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
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...
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...
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™
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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,...
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!
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...
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...
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...
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...
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...
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...
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.
More in Big Data
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.