Name: Data Analytics Technologies Bootcamp (Live Online)
Price: 1949 USD

Data Analytics Technologies Bootcamp (Live Online)

Overview

Master the industry-standard tools and programming languages used by Data Analysts, including Excel, SQL, and Tableau, in this comprehensive classroom training program. Gain hands-on experience working on real-world projects and learn to organize, analyze, summarize, and visualize data to present actionable insights.

Syllabus

Excel Level I: Fundamentals

Learn how to use functions to speed up your workflow
Add formatting and other visual effects
Turn data into visual charts, including line, column, and pie charts
Learn tips and tricks for easy workbook management

Excel Level II: Intermediate

Learn to split and join text, add data validation, and named ranges
Use database functions and logical statements
Create Pivot Tables to quickly summarize large databases
Create advanced combo charts from multiple charts

Excel Level III: Advanced

Cell management including cell locking, auditing, and hot keys
Special formatting for calculating dates
Use advanced functions and advanced analytical tools
Record macros and relative reference macros for ad hoc reporting

SQL Level 1

Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of SQL Server Management Studio (Microsoft’s free database app)
Write SQL queries to retrieve data from tables in a database
Primary SQL clauses including SELECT and FROM
Filtering the results using WHERE, AND/OR, IN, and NOT
Wildcard filters as well as mathematical comparisons like equals, greater than, less than, etc.
Combine information from multiple tables with inner JOINs

SQL Level 2

Learn to use Outer Joins and find NULL data
Group data and perform common statistical calculations using Aggregate Functions
Filter grouped data with HAVING
Use CAST to make a data type fit your query’s needs
Work with dates and time

SQL Level 3

Use Subqueries to grab data from anywhere in a database and use that result in another query
Query from Views instead of tables
Add If-Else logic to queries using CASE
Learn how to use Functions, and execute reusable Stored Procedures
Use String Functions to get just the part of text you need