Onsite Data Analytics Training

Learn the fundamentals of SQL (Structured Query Language) and relational databases, so you can start writing SQL queries to extract and understand the information stored in databases.

Build on your knowledge of SQL fundamentals and enhance your skills to filter, group, and analyze data in this intermediate SQL course.

Take your SQL skills to the next level in this advanced course. You’ll learn about subqueries, views, variables, functions, stored procedures, and more.

Learn to extract info from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You’ll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL

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.

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.

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. 

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.

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.

Learn Visual Basic for Applications to accelerate your workflow and reduce errors in Excel. This bootcamp course includes Excel VBA Macros Levels 1 and 2. By the end of this course, you'll be able to develop a macro, create automated event processes, and use automation to manage unforeseen errors. 

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.

Take a step beyond normal programming, into using algorithms that can independently learn patterns and make decisions. Machine learning skills are in high demand, as these algorithms now run the majority of trading on Wall Street and the product recommendations at big companies like Amazon, Spotify, and Netflix.

This Python course is designed for students to learn to code from scratch and become comfortable with programming in Python. Students will learn the syntax, principles, and thought processes that programming entails.

Learn Python to extract data from websites. Along the way, you’ll learn how to write loops so that your web scraping code can process a large number of pages.