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.

Master the SQL programming language in this three-day bootcamp. Write queries, learn relational database fundamentals, and conquer advanced techniques such as stored procedures.

In this SQL Bootcamp, you’ll learn everything from foundational concepts such as data types and basic queries to more advanced topics like aggregating and joining.

This Level I course covers SQL fundamentals including relational database management systems (RDBMSs), Microsoft SQL Server, and the SQL programming language. Through this course, you'll gain an understanding of how data is stored and you'll learn how to write queries to make sense of complex data. 

Build upon SQL basics to achieve easier and more targeted data analytics. You'll learn how to use views, subqueries, math functions, and logic statements to find data that meet specific search criteria. You'll also learn how to increase report readability by using data conversion functions to format data.

SQL III students learn how to build and maintain a highly efficient database that incorporates best practices in database management, including exporting external data, creating temporary tables, protecting data integrity, and maximizing procedural efficacy. With these advanced skills in your repertoire, you'll be prepared to launch a career in database management! 

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.

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.