Beginner Data Analytics Online Bootcamp: SQL + Power BI

Learn how to extract, analyze, and visualize data with our Beginner Data Analytics Bootcamp!

This Bootcamp is live and instructor led

Price $299
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.

Taught by: Juston Bryant, MSIT


Course Schedule
Course Dates: SQL Portion: January 29th - February 19th  Power BI Portion: February 26th - March 5th
Days of the week: Saturdays
Time (EST): 930a - 1200p 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 

Saturday, January 29th | 9:30a - 12:00p

  • Review of databases, data types, and table files
  • Sorting data
  • Retrieve Data from a Single Table

Course 2: Calculating, Aggregating, and Grouping

Saturday, February 5th | 9:30a - 12:00p

  • Calculate formulas using mathematical operations and aggregate functions
  • Summarizing data using GROUP BY function

Course 3: Retrieving Data from Multiple Tables 

Saturday, February 12th | 9:30a - 12:00p

  • Extract data from multiple tables at once using joins

Course 4: More Join Types

Saturday, February 19th | 9:30a - 12:00p

  • Overview of various join types
    • Left
    • Right

Part 2: Visualizing Data in Power BI

In the second portion of the Bootcamp, you will visualize data in Power BI. Power BI brings your data to life with dynamic charts and graphs that can be used to visually tell a story. 

 

Course 1: Importing and Transforming Data

Saturday, February 26th | 9:30a - 12:00p

  • Understand Power BI and its components
  • Import tables from database
  • Transform data
    • Formatting
    • Calculated fields
    • Merge
    • Data types
  • Creation of visualizations using different charts and graphs

Course 2: Filtering and Visualizing Data

Saturday, March 5th | 9:30a - 12:00p

  • Filter data in visualizations
    • Top/bottom
    • Advanced filtering
    • Pages
  • Themes
  • Save options

 

 

What's Included:

Certificate of Completion

Refund Policy: No refunds and/or transfers

 

 

 

 

Course materials (including installation guides), access codes, and reminders will be sent 7 days prior to the start of the first course of the Bootcamp.
$299.00
Out of stock