Free course · by Debugshala, Indore
Data Analytics and BI Tutorial
5 free lessons, in the order we teach them in class: start at lesson 1 and work down. Every lesson has an analogy, a diagram, code you can run or copy, a quick quiz and an FAQ.
- 5Lessons
- 2Modules
- ~1 hReading time
- FreeAlways
01Data Analytics Foundations
- What Does a Data Analyst Do? Daily Work, Tools and ExamplesSee what a data analyst does each day, the four types of analytics, the tools used (Excel, SQL, Python, Power BI) and a runnable sales case study.
- Data Cleaning with Pandas: A Step-by-Step Guide for BeginnersClean messy data in pandas step by step: duplicates, wrong types, inconsistent text, missing values and outliers, with runnable code on a real-looking sheet.
- Pandas GroupBy and Pivot Tables: Summarise Sales Data FastMaster pandas groupby, agg, transform, pivot_table and crosstab on a sales dataset, with a clear mapping from Excel pivot tables to pandas code.
02Dashboards and Career
- Dashboard Design in Power BI: KPI Layout, Charts and SlicersDesign KPI dashboards that people use: choosing KPIs, layout, chart choice and colour, plus Power BI data models, measures and slicers explained simply.
- Data Analyst Roadmap: How to Become a Data Analyst from ScratchA step-by-step data analyst roadmap: skills to learn, a six-month timeline, portfolio projects, interview prep and how classroom training in Indore helps.