Free notes for learning data analytics: Python, SQL, Excel, Power BI, statistics, machine learning, generative AI, data storytelling, financial analysis and interview prep. Each lesson has the key ideas, worked examples, code and common mistakes, written in plain English.
Useful for IIT Madras BS learners, students and anyone moving into a data analyst role.
| Notes | What you learn | Lessons |
|---|---|---|
| Python for Data Analysis | Write real Python, then wrangle any dataset with pandas and NumPy. | 19 |
| SQL for Analysts | From SELECT to window functions on real business databases. | 11 |
| Excel for Business | XLOOKUP, pivot tables and a 3-statement model, step by step. | 11 |
| Power BI Dashboards for Decision-Makers | Model data, write DAX and publish dashboards people actually use. | 10 |
| Practical Statistics for Data Science | Distributions, hypothesis tests and regression without the fear. | 11 |
| Machine Learning Foundations with scikit-learn | Build, evaluate and explain models for real business problems. | 9 |
| Generative AI for Business Professionals | Prompting, AI workflows and responsible use for everyday work. | 9 |
| Data Storytelling and Visualization | Turn analysis into charts and narratives that change minds. | 8 |
| Financial Statement Analysis and Valuation | Read annual reports, compute ratios and value a company with DCF. | 9 |
| Crack the Data Analyst Interview | SQL, case studies, guesstimates and a portfolio that gets callbacks. | 10 |
- Excel, then SQL: the tools most analyst jobs use every day
- Python for data analysis, then statistics
- Power BI and data storytelling: share what you find
- Machine learning and generative AI
- Interview prep, when you start applying
For a full plan, read the data analyst roadmap for India on BTechi.
- IITM BS qualifier notes: Maths I, Stats I, CT and English I
- IITM BS PYQ topics: the most repeated topics for 44 courses
- Awesome IITM BS: a curated list of IITM BS resources
Open an issue with the file and the lesson.
Made by BTechi. © BTechi. Free to read, share and link to. Please don't copy these notes to other websites, apps or paid courses. See the copyright policy.