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

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.

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.

Learn all the basics to use Excel as your primary data processing tool. Create charts and tables, get started with formulas and functions, and format and print your output. 

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow.

Become an Excel guru in this hands-on advanced training. You'll make functions more flexible, take Pivot Tables to the next level, automate tasks with macros, and learn advanced analytical tools.

Learn the fundamentals of VBA, Excel's programming language, in project-based training. This VBA course concentrates on the automation of repetitious Excel tasks and reports.

Learn the fundamentals of Python and object-oriented programming in this 5-day intensive course.  You'll gain a solid understanding of Python, with a strong emphasis on using libraries and frameworks for data science.

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.