Data Analytics Technologies Bootcamp (Live Online)

Overview

Master industry-recognized platforms for information evaluation and visual representation in practical, engaging instruction. Develop proficiency in Excel, SQL, and Tableau.

Command the market's leading data platforms: Excel, SQL, and Tableau. Structure, examine, compare, and visualize information to convey meaningful insights and drive outcomes.

This extensive and reasonably priced hands-on program delivers training through real-world business scenarios in Excel, SQL, and Tableau.

Master Excel and Tableau for information analysis and presentation, and leverage SQL to interact with information housed in relational systems. Progress from foundational to expert-level in Excel through our Excel Bootcamp; achieve SQL mastery for data management with our SQL Bootcamp; and build Tableau expertise in our Tableau Bootcamp.

Program Modules:

Excel for Business Fundamentals
Excel for Business: Intermediate Skills
Excel for Business: Advanced Techniques
SQL: Level I Essentials
SQL: Level II Advanced Methods
SQL: Level III Specialized Applications
Tableau: Level I Foundation
Tableau: Level II Advanced Skills

Program Details:

Combine and aggregate information in Excel, leveraging equations and automated calculations
Create visual representations in Excel through PivotTables
Build visual representations and tables to examine data in Excel
Apply SQL to organize, narrow, and aggregate datasets from expanded information systems
Learn complex database operations and stored procedures
Handle, organize, and interpret datasets in Tableau
Generate interactive visualizations and construct business intelligence tools and narratives

Excel, Tableau, and SQL Training

Excel for Business Bootcamp

During this segment, you will build starting capabilities in data evaluation with the widely used data platform, Microsoft Excel. In just three days of focused instruction, advance from novice to proficiency level in Excel. You will learn techniques you may not have known existed and develop into a capable and streamlined Excel expert. Master data organization, build graphical representations, design summary tables, build automated scripts, and much more with Excel.

Import, organize, and style information in Excel
Generate visual displays and data tables from information sets
Master phrase manipulation functions to separate, combine, and manage language content
Learn lookup and data retrieval tools like VLOOKUP, HLOOKUP, and INDEX-MATCH
Summarize information through Pivot Tables and comprehensive charting
Build scenario analysis capabilities and apply goal-seeking functions to achieve goals
Explore sophisticated functions and time-saving Excel techniques
Create automated sequences with macro functionality

Tableau Bootcamp

Gain Tableau capabilities in just two days through hands-on training to perform evaluation and design captivating data representations with Tableau. Tableau is a leading information visualization system enabling teams to interact with information, refine data, and construct sophisticated visual displays, surpassing traditional spreadsheet tools. You will acquire the ability to link to information, refine it, and develop multiple display styles in Tableau.

Transfer information into Tableau
Refine information and build computations
Arrange, narrow, and restructure your information
Build displays and business dashboards
Release and launch your visualization
Build place-based information and specialized displays in Tableau

SQL Level 1 & 2

Learn SQL, the standard method for working with structured information. Comprehend database system architecture and begin developing database queries. Progress to sophisticated questioning strategies that let you retrieve, modify, and combine information from numerous data sources. SQL provides straightforward tools for working with information systems and forms a cornerstone skill for a business professional.