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.CurriculumExcel for Business FundamentalsIntermediate Excel for BusinessAdvanced Excel for BusinessSQL Level ISQL Level IISQL Level IIITableau Level ITableau Level IICourse OverviewAggregate and summarize your data in Excel with formulas & functionsVisualize data in Excel with Pivot TablesCreate charts and tables to interpret data in ExcelUse SQL to sort, filter and summarize data from larger databasesLearn advanced database queries and proceduresManipulate, format and understand data in TableauPresent visualizations and create dashboards and storiesExcel, Tableau, & SQLExcel for Business BootcampIn 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 ExcelCreate charts and tables from datasetsWork with text functions to split, join, and do more with textLearn database functions like VLOOKUP, HLOOKUP, and INDEX-MATCHAnalyze data using Pivot Tables and advanced chartsPerform what-if analyses and use goal seek to find the desired outcomeLearn advanced functions and Excel tricks to speed up your workAutomate workflows with macrosTableau BootcampMaster 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 TableauManipulate data and perform calculationsSort, filter, and pivot your dataCreate visualizations and dashboardsShare and publish your visualizationCreate data maps and custom charts in TableauSQL Level 1 & 2Learn 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 databasesStart querying in SQLJoin and aggregate dataWork across multiple tables with joinsWrite subqueries for simpler codeAdvanced functions, math, and logic with SQLLearn more about Data Analytics Technologies Bootcamp at NYIM Training.