Data Analytics & Visualisation Tools crash course, Online MBA, Semester 3:
This subject covers practical data handling in Excel, basic Python and R for data wrangling, data visualisation with Tableau and Power BI, and writing SQL…
- 12 video lessons
- 3h
- Study notes
- 60 quiz questions
- Assignment
12 lessons in Data Analytics & Visualisation Tools
Each lesson pairs one topic with a hand-picked video, trimmed to the part that teaches it.
About this subject
This subject covers practical data handling in Excel, basic Python and R for data wrangling, data visualisation with Tableau and Power BI, and writing SQL queries. By the end you will be able to clean data and build pivot tables and lookups, choose the right chart for a dataset, design dashboards, and write SQL queries using JOIN and GROUP BY.
- 1
Excel Pivot Tables
Module 1, Data Handling in Excel: Pivot tables
Learn Excel Pivot Tables in 10 Minutes - A complete beginner's tutorial· Chandoo· 10 min
Study notes 5 quiz questionsWatch lesson - 2
VLOOKUP and XLOOKUP in Excel
Module 1, Data Handling in Excel: Lookups
The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more)· Kenji Explains· 12 min
Study notes 5 quiz questionsWatch lesson - 3
Data Cleaning with Power Query
Module 1, Data Handling in Excel: Power Query, Data cleaning
Data Cleaning With Power Query (Better than Excel)· Kenji Explains· 12 min
Study notes 5 quiz questionsWatch lesson - 4
Python and R Data Types
Module 2, Python / R Basics: Data types
Data Types in Python | Python Tutorial in Hindi 5· Rishabh Mishra· 20 min
Study notes 5 quiz questionsWatch lesson - 5
Pandas for Data Wrangling
Module 2, Python / R Basics: Pandas, Data wrangling
Learning Pandas for Data Analysis? Start Here.· Rob Mulla· 22 min
Study notes 5 quiz questionsWatch lesson - 6
How to Choose the Right Chart
Module 3, Data Visualisation: Chart selection
How to Choose the Best Chart for Your Data Visualization: Ask Yourself These 3 Key Questions· Maven Analytics· 5 min
Study notes 5 quiz questionsWatch lesson - 7
Tableau vs Power BI Dashboards
Module 3, Data Visualisation: Tableau / Power BI dashboards
Power BI vs Tableau - Best BI Tool· Luke Barousse· 17 min
Study notes 5 quiz questionsWatch lesson - 8
Storytelling with Data
Module 3, Data Visualisation: Storytelling with data
How to turn data into stories· storytelling with data· 33 min
Study notes 5 quiz questionsWatch lesson - 9
Database Basics for Beginners
Module 4, SQL: Database basics
What Is SQL ? | Database in SQL | SQL Introduction | SQL Tutorial In Hindi 1· Rishabh Mishra· 7 min
Study notes 5 quiz questionsWatch lesson - 10
SQL SELECT and WHERE
Module 4, SQL: SELECT, WHERE
Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3· Adam Finer - Learn BI· 6 min
Study notes 5 quiz questionsWatch lesson - 11
SQL JOIN Types Explained
Module 4, SQL: JOINs
Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11· Rishabh Mishra· 20 min
Study notes 5 quiz questionsWatch lesson - 12
SQL GROUP BY and Aggregation
Module 4, SQL: GROUP BY
MySQL GROUP BY & HAVING: Advanced SQL Filtering Techniques· Engineering Digest· 16 min
Study notes 5 quiz questionsWatch lesson
Assignment
End-to-End Sales Analysis: Excel, Python, SQL and a Data Story
Less scrolling. More passing.
- Free
Hand-picked video lessons
12 short lessons, each with the best YouTube explanation we could find, trimmed to the part that matters.
- Free login
Study notes
12 lessons come with a summary, key points, key terms and takeaways for quick revision.
- Free login
Quizzes
60 questions across the course, with the right answer and why, the moment you pick.
- Free login
Assignments
1 subject assignments with clear tasks, so you practise what each subject actually asks of you.
- Free login
Notebook
Write notes beside the video, stamped with the exact time, and jump back to that moment later.
- Free login
Progress that follows you
Completed lessons, quiz scores and where you stopped, saved to your account on every device.
- Live chat pass
Live chat
A members-only live chat beside every lesson: doubts, tips, stickers and GIFs with your batch. One ₹19 pass opens every live chat.
The Online MBA live chat. Study together, live.
A live chat right beside the video, shared by everyone studying Online MBA. Ask a Data Analytics & Visualisation Tools doubt mid-lesson, share a shortcut, celebrate a finished semester.
- Live chat beside every lesson
- One live chat for all of Online MBA
- Members-only stickers & GIFs
- One ₹19 pass opens every live chat
Online MBA live chat
Anyone else finding Data Analytics & Visualisation Tools tricky? 😅
Lesson 2 cleared it up for me. Watch it before the quiz
Doing it now, thanks!
Starting Database Management Systems tonight if anyone wants to go together
More from Online MBA Semester 3
All subjects- Sem 3E-Commerce
ECM4302
Database Management Systems
This subject covers how database management systems are structured, how relational databases and ER models are designed, the integrity rules and relational…
- 18 lessons
- 4h
- Notes
- Quiz
- Sem 3E-Commerce
ECM4307
Dynamic Web Design & Development
This subject covers building web pages with HTML and CSS, then writing server-side PHP programs using variables, loops, functions, strings, arrays, forms,…
- 21 lessons
- 9h 48m
- Notes
- Quiz
- Sem 3Finance
FIN4302
Business Valuation
This subject covers how companies and their shares are valued using discounted cash flow models and relative valuation multiples, including the special cases…
- 13 lessons
- 5h 55m
- Notes
- Quiz
- Sem 3Finance
FIN4306
Financial Modeling with MS-Excel
This subject teaches you to build financial models in MS-Excel, from core Excel features, database and finance functions to simulation, capital budgeting,…
- 15 lessons
- 6h 30m
- Notes
- Quiz
- Sem 3HR
HRM4305
Training and Development
This subject covers how organisations run training: assessing training needs, designing programmes, choosing training methods, evaluating results including…
- 12 lessons
- 2h 57m
- Notes
- Quiz
- Sem 3Marketing
MKT4308
Consumer Behaviour
This subject explains how consumers think, feel and decide when buying, covering individual factors like motivation, perception and attitude, social influences…
- 19 lessons
- 7h 21m
- Notes
- Quiz
Data Analytics & Visualisation Tools: common questions
This subject covers practical data handling in Excel, basic Python and R for data wrangling, data visualisation with Tableau and Power BI, and writing SQL queries. By the end you will be able to clean data and build pivot tables and lookups, choose the right chart for a dataset, design dashboards, and write SQL queries using JOIN and GROUP BY. It's the Data Analytics & Visualisation Tools subject of Online MBA, Semester 3, in 12 lessons: Excel Pivot Tables; VLOOKUP and XLOOKUP in Excel; Data Cleaning with Power Query; Python and R Data Types; Pandas for Data Wrangling; How to Choose the Right Chart; Tableau vs Power BI Dashboards; Storytelling with Data; Database Basics for Beginners; SQL SELECT and WHERE; SQL JOIN Types Explained; SQL GROUP BY and Aggregation.
Yes. Every video lesson is free to watch without an account. A free login unlocks study notes, quizzes, the assignment, a notebook and progress that syncs across devices.
About 3h of video across 12 lessons, plus time for notes and quizzes. Go at your own pace; your place is saved.
Yes: “End-to-End Sales Analysis: Excel, Python, SQL and a Data Story”. It comes after the last lesson, with a brief, clear tasks and how the work is judged.
A members-only live chat beside the video, shared by everyone studying Online MBA, where learners ask doubts, share tips and react with stickers and GIFs. One ₹19 pass, paid once from your InsideEdge wallet, opens the live chat for every degree.
No. It's a crash course to help you understand and revise the subject quickly. Use it alongside your official study material and assignments.