Overview

Learn industry-standard data analysis and visualization tools in hands-on training. Gain advanced skills in Excel, SQL, & Tableau.

Master the top data analytic tools: Excel, SQL, & Tableau. Organize, analyze, summarize, and visualize your data to present actionable insights.

In this comprehensive and affordable classroom training, you'll work on real-world projects in Excel, SQL, and Tableau.

Learn to use Excel and Tableau for data analysis and visualization, and work with SQL to interact with data stored in databases. Go from beginner to advanced in Excel with our Excel Bootcamp, master SQL for databases with our SQL Bootcamp, and become a power Tableau user in our Tableau Bootcamp.

Curriculum

Excel for Business Fundamentals
Intermediate Excel for Business
Advanced Excel for Business
SQL Level I
SQL Level II
SQL Level III
Tableau Level I
Tableau Level II

Course Overview

Aggregate and summarize your data in Excel with formulas & functions
Visualize data in Excel with Pivot Tables
Create charts and tables to interpret data in Excel
Use SQL to sort, filter and summarize data from larger databases
Learn advanced database queries and procedures
Manipulate, format and understand data in Tableau
Present visualizations and create dashboards and stories

Excel, Tableau, & SQL

Excel for Business Bootcamp

In this part of the program, you'll build your foundational analytics skills with the most commonly used analytics tool, Microsoft Excel. You'll go from a beginner to a master of Excel in just 3 days in this intensive Bootcamp. You'll learn to do things you didn't even know were possible in Excel and become a powerful and efficient Excel user. You'll learn to manipulate data, create charts, make Pivot Tables, automate workflows, and a whole lot more in Excel.

Enter, clean, and format data in Excel
Create charts and tables from datasets
Work with text functions to split, join, and do more with text
Learn database functions like VLOOKUP, HLOOKUP, and INDEX-MATCH
Analyze data using Pivot Tables and advanced charts
Perform what-if analyses and use goal seek to find the desired outcome
Learn advanced functions and Excel tricks to speed up your work
Automate workflows with macros

Tableau Bootcamp

Master Tableau in just 2 days in this hands-on training to perform analysis and create amazing visualizations in Tableau. Tableau is a commonly used data visualization tool that allows users to connect to datasets, manipulate data, and easily create advanced visualizations beyond Excel. You'll learn to connect to data, analyze it, and create a variety of visualizations in Tableau.

Import data into Tableau
Manipulate data and perform calculations
Sort, filter, and pivot your data
Create visualizations and dashboards
Share and publish your visualization
Create data maps and custom charts in Tableau

SQL Level 1 & 2

Learn SQL, the most commonly used language for interacting with databases. Understand the fundamentals of relational databases and start querying data from databases. Then, you'll move to more advanced querying techniques so you can easily pull, manipulate, and combine data from multiple databases. SQL is a relatively easy-to-learn language that enables you to work with databases and is crucial for a business analyst.