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.
- Understand relational databases
- Start querying in SQL
- Join and aggregate data
- Work across multiple tables with joins
- Write subqueries for simpler code
- Advanced functions, math, and logic with SQL
Learn more about Data Analytics Technologies Bootcamp at NYIM Training.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.
Also available in-person in NYC