
Add This Project to Your Portfolio | EdTech Startup Data Analysis using PowerBI | CampusX
Dataset - www.kaggle.com/datasets/khaledatef1/online-courses
Problem Statement - docs.google.com/document/d/1Ts4UZ3bapfSJXeGBKhIf0C…
PowerBI file - drive.google.com/file/d/1d_Bmr95AWb3fVNR-qeBoBQTP0…
Free Data Course: learnwith.campusx.in/s/store
📱 Grow with us:
CampusX' LinkedIn: www.linkedin.com/company/campusx-official
Slide into our DMs: www.instagram.com/campusx.official
My LinkedIn: www.linkedin.com/in/nitish-singh-03412789
Discord: discord.gg/PsWu8R87Z8
E-mail us at support@campusx.in
⌚Time Stamps⌚
00:00 - Intro
01:10 - Plan of Action
03:41 - Introduction to Power BI and its importance in data analysis.
05:36 - Analyze and clean data for tech startup decision-making.
09:24 - Overview of course details: language, skills, instructors, ratings, viewers, duration.
11:19 - Loading and preparing data for analysis in Power BI.
14:07 - Overview of basic data transformations in Power BI.
20:13 - Extracting text before a specified delimiter in data analysis.
29:59 - Creating a slicer for dynamic data analysis in Power BI.
31:08 - Analyze course type distribution across categories for business growth.
37:24 - Client requests visual analysis of average views by category and sub-category.
40:25 - Exploring algorithm categories and related data in Power BI.
46:04 - Importance of cloud word visualization in data analysis.
48:50 - Setting up a Power BI account for analysis.
51:50 - Creating a skills cloud visual using selected categories.
1:00:04 - Analyzing language distribution for online courses in Power BI.
1:06:07 - Client requires analysis on top five learning categories.
1:10:51 - Using Conditional Logic for displaying average metrics.
1:16:15 - Analyzing subtitle impact on viewer engagement in EdTech courses.
1:33:30 - Identifying top instructors from ratings in categories.
1:50:06 - Analyzing instructor ratings to identify top performers.
1:57:20 - Average ratings analysis for teacher selection in EdTech.
2:00:20 - Standardizing course duration data for analysis.
2:27:30 - Presenting insights to clients using Power BI.
2:30:54 - Publishing Power BI dashboards for easy sharing
コメント