Looking for corporate training?
We offer custom onsite training and discounted class vouchers.
nyc@careercenters.com(212) 684-5151
Download Syllabus
We are open! Classes are running in-person (socially distanced) and live online. Secure your seat today
Data Analytics is the process of manipulating and analyzing data to understand and uncover insights that can influence business decisions. Learn the essential data analytics tools including Excel, SQL, and Tableau in hands-on classes.
Jun 6–Jul 28
Weeknights
60 Hours
NYC or Live Online
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 know the tools you need for a modern 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.
Retake your course for free within a year. Students receive free access to PCs and software during each class.
None; attendees should have basic computer skills and ability to learn advanced concepts. Previous experience with database management tools is helpful.
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on
Learn the concepts and skills covered in this true or your tuition is on us. See details and terms & conditions.
Learn with real-world projects
Step-by-step instruction to boost retention
The Career Centers instructors are highly skilled communicators who really know their craft. They are wonderful about explaining and re-explaining when necessary and I never felt rushed or foolish for asking a question.
—Diane Speros
Gain industry knowledge from professionals
Retake the course for free within one year
Course times are listed in Eastern Time.
As one of our smaller courses, tuition for this course is due in full before the start date.
There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.
However, if you plan to take the course live online, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.
This program is a discounted package of classes that is 15–25% off the individual class prices.
185 Madison Avenue, NYC
Get face-to-face interaction with an instructor and other students when you learn at our NYC campus. Courses are hands-on with a computer and software provided.
Remote, from anywhere
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
This is the recommended order, but some courses may be taken in a different order.
Master the core Microsoft Excel functions in this one-day course. Automate calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets while learning tricks to accelerate your workflow.
Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Use tools and formulas to format text. Manipulate data visuals with advanced charting skills. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of intermediate Excel, you'll unlock powerful techniques that will help you complete tasks more quickly.
Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros. Utilize Excel's most important tools with training in core database functions. If you have a strong working knowledge in Excel and want to save even more time with custom shortcuts and advanced features, this is the perfect course for you.
Learn how SQL is used within relational database management systems. Connect to SQL Server and write queries with conditions. Use functions to calculate and format data before it’s presented on screen. In SQL Level 1, you’ll learn everything you need to write SQL queries on your own.
Master views, subqueries, logic statements, and data conversions in SQL Level 2. Combine advanced SQL functions with fundamentals like inner and outer joins to proof your work. Develop your skills in SQL by writing advanced functions to gain more control in your relational DBMS (Database Management System).
Master advanced SQL processes and controls. Create stored procedures and temporary tables. Connect to external data sources like Microsoft Applications applications and manipulate data with constraints, indexes, and triggers. In SQL 3, you’ll gain the skills to begin a career in database management.
In this course, you will be introduced to the field of data visualization and the various tools Tableau Public offers. Through concepts and exercises, you will learn to identify datasets to connect to, explore, analyze, filter and structure your data to create your desired visualizations.
In this course, you dive further into Tableau tools and customization of your visualizations. You will learn to create a variety of maps to represent your geographic data, and build actions to control your visualizations within your sheets and dashboards. This course requires to have completed level I in Tableau.
Unit 1 7 Hours
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.
Unit 2 7 Hours
The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard shortcuts, and navigation techniques.
Unit 3 7 Hours
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.
Unit 4 8 Hours
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.
Unit 5 8 Hours
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.
Unit 6 8 Hours
Master advanced SQL processes and controls. Create stored procedures and temporary tables. Connect to external data sources like Microsoft Applications applications and manipulate data with constraints, indexes, and triggers. In SQL 3, you’ll gain the skills to begin a career in database management.
Unit 7 7 Hours
Learn the art of data visualization in this Tableau course for beginners. 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.
Unit 8 7 Hours
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.
Students must be comfortable using a computer. No other prior knowledge is required.
This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
Select up to two courses and tap Compare selected courses to view a side-by-side comparison of Data Analytics Technologies Bootcamp with your selected courses.
Go from novice to expert in our three-day comprehensive Excel Bootcamp. You’ll learn advanced database functions, calculations, and formulas, shortcuts, Pivot Tables and scripts, and macros for automating tasks with ease.
Delve into all SQL has to offer—queries, subqueries, views, tables, indexes and stored procedures in a three-day SQL Bootcamp. Go from novice to guru in just 24 hours of training.
Launch your career in data by diving into data visualization and Tableau in our Tableau Bootcamp. In this two-day, 14-hour bootcamp you’ll go from learning about data to creating your own visualizations, constructing maps, and building interactive dashboards that you can share with your team.
Discover Python and data science with no prior coding or math experience required. You'll learn the fundamentals of Python and libraries, including pandas and scikit-learn. By the end of the Python for Data Science bootcamp, you'll be able to manipulate and analyze data with Python and create beautiful data visualizations.
Learn the skills you'll need to become a Data Analyst or Business Analyst, including data analysis, visualization, statistical analysis, and how to work with relational databases. Build a portfolio of projects and prepare for a career.
We offer custom onsite training and discounted class vouchers.
nyc@careercenters.com