Data Analytics Classes New Haven, CT

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 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 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.

Excel for Data Analytics covers intermediate and advanced Excel skills that turn the application into a powerful tool for data analysis and visualization. In this course, you'll learn how to use formulas, database functions, and simple macros to sort, filter, group, and visualize data.

This 1-day Excel course is crafted to introduce beginners to the fundamentals of Excel in order to enable them to feel comfortable working with spreadsheets. This course covers the basics of spreadsheets, the layout of Excel, entering data, using common formulas and functions, and a variety of other helpful tips and tricks.

This 1-day Excel course is designed for individuals familiar with Excel but who are looking to bolster their knowledge of building professional looking charts. This course covers a lot of broad chart-related content, including creating and working with charts, incorporating various styles and themes, using print options, and best practices around using excel data in other office applications, like Word or PowerPoint.

This 1-day Excel course is designed for individuals familiar with Excel but who are looking to bolster their knowledge of the various database and PivotTables features. This course covers a variety of PivotTable essentials, such as using lists, table features, working with data, making and enhancing PivotTables, and much more.

This 2-day Excel course is designed for individuals with a strong background using Excel but want to refresh their skills and learn some of the newest features to enhance your Excel mastery. This course moves at a fast pace and covers many of the most widely used and popular Excel techniques that will make students faster, more dynamic, and less error prone when working with spreadsheets. Some of the topics include short-cuts, formatting charts and graphs, database features, PivotTables, Formulas, Macros, and more.

This 4-day Tableau Desktop course is designed for students who have no prior knowledge of Tableau but are interested in learning common techniques to create great visualizations and dashboards. This course will help students get started with tableau and covers the basics of working with data, visualization best practices, plus a variety of ad hoc and table calculations. This course also covers dashboard design, advanced analytics like clustering and forecasting, data cleansing, storytelling with data, and more.