Data Management & Dashboard Design crash course, Online BBA, Semester 6:
This subject covers how organisations store and organise data, from relational and NoSQL databases and data lakes to data warehouses built with ETL, OLAP and…
- 11 video lessons
- 1h 40m
- Study notes
- 55 quiz questions
- Assignment
11 lessons in Data Management & Dashboard Design
Each lesson pairs one topic with a hand-picked video, trimmed to the part that teaches it.
About this subject
This subject covers how organisations store and organise data, from relational and NoSQL databases and data lakes to data warehouses built with ETL, OLAP and star or snowflake schemas. You will also learn to build interactive Tableau or Power BI dashboards with calculated fields, parameters and well-designed KPIs, and to present insights clearly to executives.
- 1
Relational vs NoSQL Databases
Module 1, Structured & Unstructured Data: Relational vs NoSQL databases
SQL vs NoSQL: Which One Should You Use?· Gate Smashers· 6 min
Study notes 5 quiz questionsWatch lesson - 2
What Is a Data Lake?
Module 1, Structured & Unstructured Data: Data lakes
What is a Data Lake?· IBM Technology· 5 min
Study notes 5 quiz questionsWatch lesson - 3
ETL Process Explained
Module 2, Data Warehousing: ETL
Lec - 3: ETL (Extract, Transform, Load) | Data 📊Aggregation | Data Warehouse🏭 & Mining ⛏️· Gate Smashers· 7 min
Study notes 5 quiz questionsWatch lesson - 4
OLAP and OLAP Operations
Module 2, Data Warehousing: OLAP
Lec - 13 : OLAP operations with real life example | Data Warehouse· Gate Smashers· 8 min
Study notes 5 quiz questionsWatch lesson - 5
Star Schema vs Snowflake Schema
Module 2, Data Warehousing: Star and snowflake schema
Lec -15 : Star vs Snowflake Schema | Data Warehouse· Gate Smashers· 9 min
Study notes 5 quiz questionsWatch lesson - 6
Calculated Fields in Tableau and Power BI
Module 3, Tableau / Power BI Advanced: Calculated fields
Intro to Tableau Calculations & Calculated Fields | #Tableau Course #77· Data with Baraa· 11 min
Study notes 5 quiz questionsWatch lesson - 7
Using Parameters in Tableau and Power BI
Module 3, Tableau / Power BI Advanced: Parameters
Power BI Field Parameters - Why & how to use them?· Chandoo· 6 min
Study notes 5 quiz questionsWatch lesson - 8
Building Interactive Dashboards
Module 3, Tableau / Power BI Advanced: Interactive dashboards
Learn Tableau in 15 minutes and create your first report (FREE Sample Files)· Chandoo· 7 min
Study notes 5 quiz questionsWatch lesson - 9
Designing Executive Dashboards
Module 4, Data Storytelling: Executive dashboards
Best Dashboard Design Tips to Impress Anyone!· Kenji Explains· 18 min
Study notes 5 quiz questionsWatch lesson - 10
KPI Design for Dashboards
Module 4, Data Storytelling: KPI design
What is KPI | KPI Dashboard | Quality Objectives | How to make KPI Monitoring Sheet(Hindi)|AYT India· AYT India Academy· 15 min
Study notes 5 quiz questionsWatch lesson - 11
Presenting Data Insights
Module 4, Data Storytelling: Presenting insights
7 Effective Tips for Presenting Data at Work!· Jeff Su· 8 min
Study notes 5 quiz questionsWatch lesson
Assignment
From Raw Data to Executive Dashboard: A Retail Analytics Mini-Project
Less scrolling. More passing.
- Free
Hand-picked video lessons
11 short lessons, each with the best YouTube explanation we could find, trimmed to the part that matters.
- Free login
Study notes
11 lessons come with a summary, key points, key terms and takeaways for quick revision.
- Free login
Quizzes
55 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 BBA live chat. Study together, live.
A live chat right beside the video, shared by everyone studying Online BBA. Ask a Data Management & Dashboard Design doubt mid-lesson, share a shortcut, celebrate a finished semester.
- Live chat beside every lesson
- One live chat for all of Online BBA
- Members-only stickers & GIFs
- One ₹19 pass opens every live chat
Online BBA live chat
Anyone else finding Data Management & Dashboard Design tricky? 😅
Lesson 2 cleared it up for me. Watch it before the quiz
Doing it now, thanks!
Starting Customer Relationship Management tonight if anyone wants to go together
More from Online BBA Semester 6
All subjects- Sem 6
Customer Relationship Management
Building and retaining profitable customer relationships.
- 4 lessons
- 1h 18m
- Notes
- Quiz
- Sem 6
Digital Marketing
Online channels, branding and campaign management.
- 5 lessons
- 1h 29m
- Notes
- Quiz
- Sem 6
Final Project
Six-month specialisation project from synopsis to final report.
- 1 lesson
- 9 min
- Notes
- Quiz
- Sem 6General Mgmt
Technology Management
Managing technology for competitive advantage.
- 7 lessons
- 1h 20m
- Notes
- Quiz
- Sem 6General Mgmt
Management Development and Skills
Management process and core managerial skills.
- 7 lessons
- 2h 43m
- Notes
- Quiz
- Sem 6General Mgmt · Intl Business
Role of International Financial Management
Global finance, forex and international financial institutions.
- 11 lessons
- 4h 18m
- Notes
- Quiz
Data Management & Dashboard Design: common questions
This subject covers how organisations store and organise data, from relational and NoSQL databases and data lakes to data warehouses built with ETL, OLAP and star or snowflake schemas. You will also learn to build interactive Tableau or Power BI dashboards with calculated fields, parameters and well-designed KPIs, and to present insights clearly to executives. It's the Data Management & Dashboard Design subject of Online BBA, Semester 6, in 11 lessons: Relational vs NoSQL Databases; What Is a Data Lake?; ETL Process Explained; OLAP and OLAP Operations; Star Schema vs Snowflake Schema; Calculated Fields in Tableau and Power BI; Using Parameters in Tableau and Power BI; Building Interactive Dashboards; Designing Executive Dashboards; KPI Design for Dashboards; Presenting Data Insights.
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 1h 40m of video across 11 lessons, plus time for notes and quizzes. Go at your own pace; your place is saved.
Yes: “From Raw Data to Executive Dashboard: A Retail Analytics Mini-Project”. 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 BBA, 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.