Looking for corporate training?
We offer custom onsite training and discounted class vouchers.
nyc@careercenters.com212 • 684 • 5151
Data Analytics Bootcamp in NYC or Live Online
Excel, SQL, & Tableau Courses for Data Analysts
- $2330 $1949
- 60 Hours
-
PC provided
We provide computers to use during class. This course is available on PC only.
- Small in-person class
-
Free retake
Students may retake the course once within six months if there is an available seat.
- 185 Madison Avenue, NYC
- Also available live online
The Leading Data Analytics Bootcamp in NYC
Take a deep dive into the top data analytics tools: Excel, SQL, & Tableau. This 8-day intensive bootcamp covers everything you need to know about summarizing, analyzing, and charting data to obtain actionable insights. After taking this bootcamp, you'll have a versatile skillset and preparation for a data analyst role.
Our data analytics bootcamp trains you through real-world projects in Excel, SQL, and Tableau. By the end of this bootcamp, you will have hands-on experience with each data analytics tool. More importantly, you'll be able to transfer this knowledge to provide insightful data analysis on the job.
Free Retake and Computer Access
Retake your course for free within six months. Students receive free access to PCs and software during each class.
Prerequisites
None; attendees should have basic computer skills and ability to learn advanced concepts. Previous experience with database management tools is helpful.
Class Notes
- Save 15% off Excel, SQL, and Tableau courses when you enroll in the Data Analytics Bootcamp. Select "Custom Schedule" and choose your dates to register (bootcamp consists of 8 one-day courses).
- Recommended: Take Excel courses prior to Tableau and SQL.
212 • 684 • 5151
The Data Analytics Bootcamp Includes
Beginner Microsoft Excel
Get going with the basics of Excel and start working on projects in Excel. Get practice with calculations and formulas, charts and tables, worksheet and workbook formatting, and basic hotkeys to accelerate your workflow.
Intermediate Microsoft Excel
Take your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.
Advanced Microsoft Excel
Become an expert Excel user with this Advanced Excel course. Learn powerful functions like INDEX-MATCH, work with advanced Pivot Table functions, and start recording macros to automate workflows. Prepare yourself for any Excel challenge with this advanced Excel course.
SQL Level I
Learn the basics of relational database management systems and SQL queries, including joins. By the end of this course, you'll be able to write basic SQL queries that retrieve data.
SQL Level II
Dive into the core of SQL. Learn views, functions, subqueries and more. By the end of this course, you'll be able to work with advanced queries, manipulate tables, and index table data.
SQL Level III
Gain mastery in the most complex areas of SQL, including stored procedures and temporary tables. After taking this course, you’ll be able to export data, create triggers, and automate tasks.
Tableau Level I
Learn the art of data visualization in this Tableau course for beginners. No need for prior experience with data or analysis. By the end of this course, you’ll be able to craft compelling stories by importing, computing, and manipulating data to create powerful data visualizations.
Tableau Level II
Master all things charts and maps in this advanced Tableau course for experienced users. You’ll learn how to create maps, make dual axis charts, and use techniques to show changes in data over time. After taking this course, you’ll be able to create a variety of charts and maps for different types of data.