Learn how to extract, analyze, and visualize data with our Beginner Data Analytics Bootcamp!
This Bootcamp is live and instructor led
Price $249
What the heck is data analytics?
Think about all of the data that a company collects and has access to. Ever wonder how that data gets used? With the use of SQL, analysts are able to extract this data and analyze it in every way possible. The analysis, derived from data using SQL, can help drive strategic business decisions. To add another layer to the analysis, you can visualize your data with charts and graphs that can explain complex data points in simple data visuals, using tools such as Power BI.
About the Bootcamp
This Bootcamp is best for those with little to no data analytics experience and would like to prep for a role as an entry level or junior analyst using skills from SQL and different data visualization tools (i.e. Tableau, Power BI, Qlikview, etc.). All students will have three hours of prerequisite material provided prior to the start of class to help prep them for the first day of the Bootcamp. In this Bootcamp, we will use Oracle MySQL Server for SQL and Power BI for our data visualization tool.
Course Schedule
Course Dates: Week 1: April 26th - April 28th; Week 2: May 3rd - May 5th
Days of the week: Weeknights (Monday - Wednesday)
Time (EST): 600p - 900p EST
Part 1: Extracting Data via SQL
In the first portion of the Bootcamp, you will utilize SQL to extract data from a database.
Course 1: Extracting, Sorting, and Filtering
Monday, April 26th | 6:00p - 9:00p
- Review of databases, data types, and table files
- Sorting data
- Retrieve Data from a Single Table
Course 2: Calculating, Aggregating, and Grouping
Tuesday, April 27th | 6:00p - 9:00p
- Calculate formulas using mathematical operations and aggregate functions
- Summarizing data using GROUP BY function
Course 3: Retrieving Data from Multiple Tables
Wednesday, April 28th | 6:00p - 9:00p
- Extract data from multiple tables at once using joins
Part 2: Visualizing Data in Tableau
In the second portion of the Bootcamp, you will visualize data in Tableau. Tableau brings your data to life with dynamic charts and graphs that can be used to visually tell a story.
Course 1: Charts, Graphs, Filters, and Dashboards
Monday, May 3rd | 6:00p - 9:00p
- Understand Tableau and its components
- Import multiple data sets via Excel and text files
- Creation of visualizations using different charts and graphs
- Filter data in visualizations
- Top/bottom
- Advanced filtering
- Pages
- Compile all visuals into a dashboard
Course 2: Maps, BANs, and Calculations
Tuesday, May 4th | 6:00p - 9:00p
- BANs (Big Numbers)
- Geographic visuals
- Usage of built in data functions and calculations
Course 3: Join Types
Wednesday, May 5th | 6:00p - 9:00p
- Overview of various join types in Tableau
- Right, left, full, inner
- Create relationships between multiple data sets
What's Included:
Portfolio
We will create a portfolio of your completed projects and assignments of all coursework from class as well as provide an instruction guide on how to add the portfolio to your LinkedIn account. Portfolios come in great handy when interviewing for roles that require the technical skills in which you will learn in class.
Certificate of Completion
You will receive a certificate of completion upon individual completion and submission of all homework assignments and portfolio by the specified deadline.
Refund Policy: No refunds and/or transfers