Cross Platform Learning Behavior Analysis

Problem Statement

Problem Description An online learning platform wants to understand how different device platforms affect student engagement and learning outcomes across various course categories. These platform-specific insights will enable the company to optimize content delivery formats, design more effective learning experiences, and allocate development resources more efficiently. Task: Analyze student learning behaviors and performance metrics across different platforms (Web, Mobile, Tablet) and course categories to identify platform-specific patterns and recommend optimal content delivery strategies. Metric Definitions student_count: The number of unique students ( student_id ) who accessed a specific course category via a specific platform. avg_session_duration: The average session duration in minutes. Calculated as (Sum of time_spent_hours for the group * 60.0) / Sum of total_sessions for the group . completion_rate: The percentage of enrollments in the group where progress_percentage = 100 .