fbpx
Search
Close this search box.

Prep Course: Data Analyst Bootcamp

dabc PREP COURSE

Congratulations on enrolling in my DATA ANALYST BOOTCAMP. You must complete this prep-course (takes 3 hours) before attending the bootcamp. This course will give you the foundation concepts of,

  • Excel
  • Power BI

Software Requirements

Make sure you have the below software on your computer to get best results out of the bootcamp.

 

Prep-Course - Module 0

Complete this module if you are new to Excel. You can skip this if you are familiar with Excel.

Duration: 30 minutes.

Download Sample data file 

Module 1: Excel Intermediate Level Concepts

You must complete this video and practice the concepts before the bootcamp.

  • Duration: 45 minutes viewing + 45 minutes practice
  • Blank data file (perfect for following along) – Download
  • Completed workbook – Download

Module 2: Power BI Basics

Please watch this basics module to understand Power BI. The UI might be slightly different but focus on the concepts. You can skip this video if you are familiar with Power BI.

  • Duration: 20 minutes
  • Blank Data File: Use this sample data file to practice the concepts covered in the video. Download.
  • Completed workbook: Download this if you need to cross-check.  

Module 3: SQL Basics

Watch this video to understand the SQL basics explained with everyday objects. Skip this video if you are familiar with the basics.

Duration: 10 minutes

Module 4: Data.World Account Setup

To practice SQL during the bootcamp, we are going to use data.world platform. Please watch this video and set up an account before the bootcamp.