ANALYST BOOTCAMP

16-Week Part-Time Virtual

In just 16 weeks, journey through a comprehensive accelerated curriculum and gain the skills needed to understand, analyze and visualize data. Through our proven training strategy, participants understand what it means to be data literate – the ability to read, understand and think critically about data. Throughout the bootcamp, participants work in a collaborative environment, learning to proficiently collect, clean, analyze, and visualize data using SQL, Excel and Tableau.

 

Practice your skills on bi-weekly projects using real world data sets to design a final visualization to communicate insight. Take full advantage of this unique bootcamp by taking the Tableau Desktop Specialist Certification exam. Upon completion of the bootcamp, participants will have the foundation of a hybrid analyst – a business analyst with data analytical skills.

Also, part-time evening classes allows participants to fit #MAD’s Virtual Analyst Bootcamp into any schedule.

*A laptop with a camera and mic is required for this event. 

checklist (3).png

DETAILS

Upcoming Cohorts    

#MAD6 Fall 2021 Professional Cohort

(Instructor: Chantilly Jaggernauth) 

#MAD6 Fall 2021 Student Cohort

(Instructor: Eric Balash)

Location                       

Virtual Instructor Led Sessions using  Zoom

Prerequisites               

 There are no prerequisites for the course

Tuition                           

$1795 (free for students accepted through the application process)

WHO IS THE ANALYST BOOTCAMP FOR?

tick (3).png

Business professionals working in an environment where understanding data is of importance.

tick (3).png

Students who wish to learn data skills not covered by the school’s curriculum.

tick (3).png

Analysts who want to learn new technical skills.

tick (3).png

Individuals interested in learning to visualize and communicate better with data.

tick (3).png

Individuals who seek to enter a new field and want to have data skills as a way in.

BOOTCAMP OUTLINE

Cover 8 units in just 16-weeks and receive a solid foundation in the topics discussed. Each unit consists of trainings, exercises, assessments, and business case studies. Also, participants will have a minimum of 7 visualizations/dashboards to showcase the skills learned in each unit.

database (3).png

Unit 1. 

Data Fundamentals & Gathering Requirements

spreadsheet-column.png

Unit 5.

Clean, Calculate & Aggregate Data using  Tableau

sql-file-format-symbol.png

Unit 2. 

Intro to Databases & Retrieve Data Using SQL

analysis (3).png

Unit 6.

Analyze & Explore Data Using Statistics

shuffle.png

Unit 3. 

Combine & Transform Data Using SQL & Tableau

analytics (9).png

Unit 7.

Visualize & Communicate Results

spreadsheet-column.png

Unit 4.

Clean, Calculate & Aggregate Data using SQL

file (3).png

Unit 8.

Boot Camp Recap & Certification Prep

CURRICULUM DETAILS

study (3).png

Data Literacy & Data Fundamentals

Unit 1

  • Solid overview of data fundamentals and data analytics workflow.

    • Explore the value of data.

    • Learn about the various data types and formats.

  • Apply and understand data analytics workflow to business cases.

  • Understand how to transform business questions into analytical questions.

    • Change business questions into analytical questions.

    • Discover how to answer business questions from an analytical view.

analysis (3).png

Data Analysis & Exploration Using Tableau & Excel 

Units 3-6

  • Learn the foundation and technical aspects of Tableau.

    • Combine data using joins, unions and blends.

    • Create basic and intermediate calculations in Tableau.

    • Clean, manipulate, explore and analyze data using Tableau.

  • Explore data using statistics in Excel and Tableau.

    • Learn measures of central tendency, measures of position and measures of spread.

    • Calculate linear regression equations, percentiles, standard deviation, variance, quartiles, interquartile range, correlation, and r-squared.

sql-file-format-symbol.png

Manage Data Using SQL

Units 2-5

  • Learn how SQL is used within relational databases and the overall foundation of databases​.

  • Retrieve, combine, filter and aggregate data using SQL.

    • Retrieve data using SELECT, FROM

    • Combine data using LEFT JOIN, INNER JOIN, RIGHT JOIN, UNION

    • Filter data using WHERE, ORDER BY LIMIT

    • Aggregate data using GROUP BY, SUM, AVERAGE, COUNT

analytics (9).png

Visualize & Communicate Results Using Tableau

Unit 7

  • Clearly visualize and communicate data using Tableau’s interactive dashboard feature.

    • Design interactive dashboards using visual best practices.

    • Learn how to effectively use color and layout a dashboard.

  • Create a shareable online portfolio that showcases each visualization created.

    • Identify ways to design visualizations so they inform without misleading.

    • Effectively use chart types to answer specific questions.

    • Learn design secrets to take visualizations to the next level.

HOW YOU'LL BENEFIT

tick (3).png

Ability to understand, retrieve, combine, clean, analyze and visualize data.

tick (3).png

Ability to use statistical techniques to further explore and analyze data.

tick (3).png

Opportunity to take (paid for by #MAD) and successfully pass the Tableau Desktop Specialist Certification Exam.

tick (3).png

Online portfolio to showcase project work that can be shared and viewed by others.

tick (3).png

Ability to be more employable by highly sought - after employers.

tick (3).png

Ability to gather requirements for key stakeholders in order to add business value based on data analysis.

tick (3).png

Ability to be effectively read and interpret charts and various visualizations.

tick (3).png

Access to the #MAD community and introduction to the Tableau community from Tableau Zen Master, Chantilly Jaggernauth.

tick (3).png

Opportunity to write blogs for #MAD to discuss your journey and skills learned.

#MAD BOOTCAMP DIFFERENTIATORS

rate-star-button.png

Exclusive comprehensive curriculum developed from scratch.

rate-star-button.png

Weekly evaluations provided to participants to track their performance.

rate-star-button.png

Combination of data literacy training, SQL training, technical Tableau training, data storytelling training and design concepts.

rate-star-button.png

Experienced instructors who have each been trained individually by Chantilly Jaggernauth. 

rate-star-button.png

Personal feedback for projects completed during the bootcamp.

rate-star-button.png

Over 50 hands-on exercises and 7 business case study projects with personal feedback.

rate-star-button.png

Opportunity to earn a Tableau Certification in 16-weeks. 

UPCOMING COHORTS

 

#MAD6 Fall Virtual Dates TBD