Want to become a Fortune 500 or startup analyst but need to know how to properly analyze data? Then, this is the Bootcamp for you! This is a very detailed analysis Bootcamp in which you will work on completing a real life analysis project for a local company. Students will learn how to extract, analyze, and visualize data using SQL, Excel and Power BI.

Key Takeaways:

  • Extract hundreds of thousands of rows of data from a database via SQL
  • Analyze, perform, and utilize proper mathematical operations and intermediate Excel formulas and functions in order to identify key drivers via Microsoft Excel
  • Create, utilize, and select the best visualization aids and dashboards to help identify top trends in data via Power BI
  • Summarize and present analysis findings to upper level managers of receiving company

Course I: Retrieving Data

  • Overview of relational databases and data flow
  • Database, Schema, and Tables Overview
  • Retrieve Data from a Single Table
  • Conversion and explanation of various data types

Course II: Filtering, Sorting, and Aggregating Data

  • Utilize conditional operators to filter data
  • Sorting data
  • Aggregate data using aggregate functions (MIN, MAX, SUM, AVERAGE, COUNT)

Course III: Summarizing the Data

  • Summarizing data using GROUP BY function
  • Overview of previously learned functions
  • Perform mathematical operations on multiple fields

Course IV: Performing Mathematical Operations

  • Calculate formulas using mathematical operations and aggregate function
  • Filter aggregated data with HAVING statement

Course V: Retrieving Data from Multiple Tables

  • Retrieve data from at least 3 tables using Inner Joins

*Excel assessment will be required to be taken by all students to assess skill level within the program. Any students who score less than 70% on the assessment will be required to take a Beginner’s Basics Course prior to the start of the Excel portion of the Data Analytics Bootcamp.

Course VI: Basic Operations

  • Basic Mathematical Operations
  • Order of Operation
  • Cell References
  • Named Ranges

Course VII: VLOOKUP

  • Cell References
  • Named Ranges
  • VLOOKUP

Course VIII: Aggregate IF Statements

  • SUMIF, AVERAGEIF, and COUNTIF statements

Course IX: Excel Review


Course X: Power BI Basics

  • Different Visualization Options
  • Data Analytical Insights
  • Trend Analysis
  • Dashboard Creation

Have more questions? 
PC Laptops Required