Corporate Data Analytics Training

In this beginner Excel workshop, you'll learn calculations, basic functions, graphs, formatting, printing - with a comprehensive course review at the end of the class. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.

In this intermediate Excel class, you'll learn functions such as VLOOKUP and SUMIFs; summarize data with Pivot Tables; Sort & Filter databases; and split and join text.

In this advanced Excel training, you'll learn advanced database functions such as INDEX and MATCH; create basic macros; and use What-If Analysis for Goal Seek and Data Tables.

Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results so you can turn data into actionable insights.

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

In this course, you will be introduced to the field of data visualization and the various tools Tableau Public offers. Through hands-on 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.

Learn how to easily create measures to find SUM, COUNT, MAX, and more with a click of a button. Make the best use of the mysterious filter context and use Power BI’s DAX language to power your data visualizations. You’ll also get tips on which Power BI experts to follow to gain the knowledge that will transform you into an expert at your workplace.

Pick up Python fundamentals and quickly transition into analyzing real-world datasets. You will learn to how to clean and combine data, as well as generate useful statistics and visualizations. The final sessions will be focused on using linear regression to extrapolate from data and make predictions.

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.

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.