# Analytics Everywhere

> Free data analytics education by Shubhrajit Basu, a Business Data Analyst with 10+ years of experience. Free SQL, Power BI, Excel and Python tutorials, plus a free 90-day data analytics bootcamp with weekly lessons, weekly assessments and a public leaderboard. Content is in English and aimed at beginners, students, career switchers and working professionals in India and worldwide.

## Main pages

- [Home](https://analyticseverywhere.in/): overview of Analytics Everywhere, the instructor, latest tutorials and free resources.
- [Free 90-Day Data Analytics Bootcamp](https://analyticseverywhere.in/learning/): week-by-week free lessons (SQL first), weekly assessments, FAQ.
- [Bootcamp leaderboard](https://analyticseverywhere.in/leaderboard/): learner rankings by assessment points.
- [Free resources](https://analyticseverywhere.in/resources/): Data Analyst Starter Kit, SQL roadmap and practice datasets.
- [Free SQL roadmap](https://analyticseverywhere.in/sql-roadmap/): a 2 to 4 week path from SQL beginner to job-ready data analyst.

## Bootcamp lessons so far

### Week 1: SQL Basics

- [DATA ANALYTICS IS Changing | Here is what you should know!](https://www.youtube.com/watch?v=sOPWJtHmajc)
- [The First Video of the SQL Series Is Finally Here!](https://www.youtube.com/watch?v=nd-7NMsO1qs)
- [How SQL Commands Actually Work: A Complete Breakdown](https://www.youtube.com/watch?v=iULofahoFd0)
- [Don't Start SQL Until You Learn These 4 Commands](https://www.youtube.com/watch?v=OaMvYJ4OPTo)
- [Stop Guessing: Learn SQL the Right Way (Session 3)](https://www.youtube.com/watch?v=4ROAKtO5dAY)
- [SQL WHERE Clause in Databricks | Learn to Filter Data with Business Problem Solving](https://www.youtube.com/watch?v=rz2ge_J2peQ)
- Weekly assessment: Week 1 Assessment – SQL Basics

### Week 2: Aggregations, GROUP BY & CASE

- [Aggregate Functions vs. Group By: What You Need to Know](https://www.youtube.com/watch?v=YZOUUzbYOOg)
- [Learn Problem Solving Using SQL | 90-Day Data Analytics Bootcamp](https://www.youtube.com/watch?v=S3zVK8st7Aw)
- [Learn Everything About SQL CASE Statements (With Business Problem Solving)](https://www.youtube.com/watch?v=n00M6qyEGDE)
- Weekly assessment: Week 2 Assessment – Aggregations, GROUP BY & CASE

## About the instructor

Shubhrajit Basu is a Business Data Analyst with 10+ years of experience in SQL, Power BI, Excel, Python and data science.

- YouTube: https://www.youtube.com/@analyticseverywhere
- LinkedIn: https://www.linkedin.com/in/shubhrajit-basu/
- Instagram: https://www.instagram.com/analyticseverywhere/