Data Analytics Classes NYC

This course covers the skills needed to become a Data Analyst or Business Analyst, including data analytics fundamentals, visualization with Tableau, using Python to clean and manipulate data, and how to work with relational databases. One-on-one mentoring is included.

In this program, participants will learn the key skills and tools needed to succeed as a data analyst, including Excel, SQL, and Tableau. Attendees will learn how to use Excel to create graphs, summarize data with PivotTables, and analyze data. In SQL, attendees will learn the essentials of relational databases, queries, functions, and more. Finally, participants will learn Tableau to create visualizations to express their data. The program is open to beginners and has flexible scheduling options. Tuition includes hands-on training, a free retake, and training manuals for each course.

In this comprehensive data science program, individuals will learn a variety of critical skills to become a data scientist. Students will learn to code with Python, create machine learning models, automate tasks like web scraping, and interact with databases using SQL. Topics include data analysis with Python's Numpy and Pandas packages, data visualization, predictive analytics, machine learning, SQL querying, Python automation, and web scraping. Students will learn hands-on by working in Python and SQL and will complete the program with the skills they need to enter the field of data science. This program offers flexible scheduling and provides a free retake for students to refresh the material.

In this 8-day intensive Data Analytics bootcamp, students with little to no background in data analytics will learn how to use Microsoft Excel, SQL, and Tableau to summarize, display, and discover key insights hidden in data sets. By the end of this bootcamp, students will be able to use Excel to aggregate and summarize data, sort data with PivotTables, create charts and tables in Excel, use SQL to filter and sort large data sets, use advanced database queries, create visualizations with Tableau, and much more. Students will also be able to reinforce what they learn through the numerous projects they encounter throughout the course. This course also offers a free retake within six months to allow students to revisit any concepts needing to be refreshed and walk away with a much stronger grasp of the material.

In this data science bootcamp, students will build programming skills and data analysis skills using Python. This course is open to beginners and is meant to get individuals up and running with Python programming and data science to generate insights from data. Topics covered include programming fundamentals, working with data frames, data analysis, data visualization, and statistical analysis. This course offers flexible scheduling options and a free retake for students to refresh the materials.

In this course, students expand their Python programming skills into machine learning and algorithms that can independently learn patterns and make decisions. The course begins with linear and logistic regressions, the most time-tested and reliable tools for approaching a machine learning problem. Students then progress to algorithms with a different theoretical basis, such as k-nearest neighbors, decision trees, and random forest. This will bring important statistical concepts to the forefront, such as bias, variance, and overfitting. Participants also learn how to measure the accuracy of your models, as well as tips for choosing effective features and algorithms.

In this 3-day bootcamp, beginners will be transformed into confident SQL users who can write queries, manipulate tables, and store advanced code. Participants will start by learning about relational databases and SQL fundamentals and will conclude the program having mastered complex retrieval tasks and storing complex code. Topics include composing queries, creating your SQL databases, automating workflow with stored procedures, and step-by-step exercises that will provide an efficient and thorough approach to mastering SQL. Tuition includes hands-on training, a free retake, and a course manual. The course has flexible scheduling options and is available online and in NYC.

In this 18-hour SQL Bootcamp open to beginners, participants will discover the essentials of databases and how to write SQL code to retrieve and analyze data. Through hands-on exercises, participants learn everything from data types to basic queries and advanced topics, including aggregating and joining. Topics include SQL GUI basics, fundamental to advanced querying, table creation, joins, views, functions, and external data connections. The course is taught using PostgreSQL and applies to other relational databases, including SQL Server and MySQL. Participants can retake the course for free within one year.

In this comprehensive 2-day course, participants can become an advanced Tableau user able to work with data to create visualizations and use the various tools Tableau Public has to offer. They will learn to identify datasets to create desired visualizations and then master the Tableau tools on a deeper level to customize their visualizations. By the end of this course, participants will have learned to create maps to represent geographical data, and build actions to control visualizations within sheets and dashboards. Tuition includes hands-on training, a free retake, and a course manual. The course offers flexible scheduling and is available online or in NYC.

This course in data analytics serves as an introduction to data analysis. Professionals who take this course will obtain essential data analysis skills, including the use of Tableau for visualizations. This program offers online and on-campus versions, with instruction by experienced data analysts. Graduates are equipped to solve real-world data problems.

In this class, you'll get an introduction to data analytics and how they are used in today's business world. You'll learn about the different kinds of analytics, algorithms, and statistics that you will need to know as a Data Analyst or Business Analyst.

The Data Science Bootcamp from Flatiron is designed to be a comprehensive data science program for students to start careers in data science. The program runs for 15-weeks and covers the key components for data science, including SQL, Python, statistics, and machine learning. Students will start coding in Python using Jupyter notebooks, learn the statistics behind machine learning, apply machine learning techniques, and work on data science projects in this data science course. In addition to the coursework, students will receive career coaching and job support during the program.

Harness Excel, SQL, and Tableau to drive powerful analysis and insights. Build confidence and credibility to apply this versatile skill set to countless jobs. This course is offered in person and live online, in a remote classroom setting.

In this Python automation course, students will learn to automate tasks using Python for various applications. This course is meant for those with prior Python experience looking to learn automation techniques like scheduling programs, updating spreadsheets, and web scraping. Topics include HTML and CSS basics, web scraping techniques, working with spreadsheets using Python, and scheduling scripts. This course offers flexible scheduling options plus a free retake for students to refresh the material.

In this course, participants will learn the fundamentals of relational databases and begin writing SQL queries to extract data from databases. They will receive essential training in the basics of the three core components of SQL: relational DBMS, SQL, and Microsoft SQL Server. They will work through practical hands-on exercises, writing real SQL code and reinforcing their knowledge of database architecture along the way. Tuition includes hands-on training, a free retake, and a course manual. The course has flexible scheduling options and is available online and in NYC.

In this course, participants will be introduced to the field of data visualization and the various tools Tableau Public offers. They will learn to identify datasets to connect to, explore, analyze, filter and structure data to create desired visualizations. Beginners will learn to understand and manipulate data in Tableau, create their first visualization, distribute and publish their visualization and cover topics such as formatting visualizations, Tableau calculations and creating dashboards and stories. Tuition includes hands-on training, a free retake, and a course manual. The course offers flexible scheduling and is available online or in NYC.

In this comprehensive Excel bootcamp, participants learn beginner to advanced Excel techniques, including formulas & functions, VLOOKUP, macros, and more. Students learn how to work more efficiently, summarize, and analyze data with tables, charts, and PivotTables. By the end of this hands-on course, participants will be ready to use Excel for everyday business tasks. The course has flexible scheduling options and is available live online or in NYC. Tuition includes hands-on training, a free retake, course manual, and supporting video tutorials.

This 3-day SQL Bootcamp consists of three courses (Levels 1-3) and helps students with little to no prior SQL experience go from novice to pro in a couple of days. The first course, SQL Level 1, covers the basics, including an introduction to SQL and relational databases, the graphical user interface (GUI), and some of the coding basics. The second course, SQL Level 2, introduces students to SQL queries and subqueries, using JOINS, math and logic functions, as well as variables and user functions. The third and final course, SQL Level 3, walks students through importing and exporting data, building control structures, temporary tables, and stored procedures. Each course concludes with student labs to help cement the skills students learn in each course.

This 1-day SQL Level 1 course is intended for those who have little to no prior SQL experience looking to learn the basics of relational database management. This course teaches the most important basic concepts to make students feel at ease when working with SQL. There are several topics covered in this course, including a broad introduction to SQL, an overview of the Graphical User Interface (GUI), and a significant focus on code, which teaches students about basic clauses, aggregations, joins, and filters. The course also includes student lab time to review and solidify the major topics covered in the course.

This 1-day SQL course is intended for those with some general SQL experience looking to build up their SQL skills and gain valuable new knowledge about relational database management. This course teaches the many intermediate concepts to increase comfort level when working with SQL. There are several topics covered in this course, including how and when to use various JOINS, how to save queries programmatically, an introduction to subqueries and using subqueries with tables, as well as math functions and other logic statements that are essential for intermediate level SQL users. The course also includes student lab time to help review and solidify the significant topics covered in the course.