Menu
Prep Course: Data Analyst Bootcamp
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.
- Microsoft Excel (365 preferred, else 2016+)
- Microsoft Power BI Desktop (download free here)
- SQL Server Management Console (download free here)
- Zoom (for attending the meetings)
- Optional: SQL Server Express (download free here)
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.
Module 1: Excel Intermediate Level Concepts
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.
- Duration: 5 minutes
- Website: Data.world
- Shared Dataset: Awesome Chocolates Data.
Get FREE Excel & Power-BI Newsletter
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.
Online Classes
© All rights reserved.