Objective

The objective of this project is to leverage data analytics to provide actionable insights for an EdTech startup aiming to expand its recorded lecture offerings. The analysis focuses on identifying trends in course types across categories, evaluating viewer engagement based on views and language preferences, and aligning course content with market demands. By examining the relationship between subtitles, course duration, skills variety, and engagement, this project aims to enable data-driven decision-making. Additionally, identifying top-rated instructors allows for strategic partnerships to enhance content quality. These insights are presented through a dynamic and user-friendly Power BI dashboard to guide the startup’s growth strategy effectively.

Data Analysis Process :

Data Cleaning : Removed duplicates, handled missing values, and standardized formats.
Data Transformation : Processed data to aggregate metrics like views, ratings, and skills distribution.
Visualization : Built dynamic and static dashboards in Power BI to visualize insights.

Key Insights from the Dashboard :

• The analysis uncovered significant insights that can drive strategic decisions for the EdTech startup. Categories and subcategories were analyzed to identify popular course types, revealing trends that can guide targeted course launches. Viewer engagement patterns showed the average views for categories, subcategories, and languages, helping to pinpoint areas with the highest audience interest.
• Trending skills within each category were identified, ensuring course content aligns with the current job market. The analysis of language distribution highlighted the most frequently used languages in courses, while viewer preferences in the top five categories emphasized the need for specific language offerings. Additionally, courses with subtitles were found to have significantly higher engagement, suggesting the importance of accessibility features.
• Top-rated instructors were identified in each category and subcategory, providing the startup with potential collaborators for creating high-quality content. Lastly, the relationship between course duration and views was analyzed, offering insights into optimal course lengths and schedules to maximize viewer interest and satisfaction. Together, these insights equip the startup with the knowledge to improve its offerings and meet learner expectations effectively.

Power BI Dashboard Features :

Dynamic Visuals : Interactive charts for drilling down by category, subcategory, and language.
Static Reports : Highlighted top instructors and detailed course trends.
User-Centric Design : Easy navigation and actionable insights tailored for decision-making.

Value Addition for EdTech Startup :

• Strategic insights into course offerings and market trends.
  
• Enhanced understanding of viewer preferences and engagement patterns.
  
• Data-driven decisions for content development and instructor collaborations.
  

Conclusion

This Power BI project successfully delivers a comprehensive analysis of the EdTech data, providing the startup with clear and actionable insights to optimize its offerings. The dashboard reveals valuable trends, such as the popularity of specific categories, viewer preferences for language and subtitles, and the importance of course duration and skill diversity in driving engagement. By highlighting top-performing instructors and aligning course content with market demands, the project empowers the startup to make informed, strategic decisions for growth. The visually appealing and interactive dashboard makes these insights easily accessible, showcasing the power of data analytics in shaping business strategies.

Code link :

Click here to access the code