Changes between Version 10 and Version 11 of ComplexReports


Ignore:
Timestamp:
04/14/26 09:08:38 (5 days ago)
Author:
221296
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ComplexReports

    v10 v11  
    11== 1# Annual analysis of course enrollments, completions, and certificates
    2 **(Year, Month, Total_Instructors, Total_Courses, Total_Students, Total_Modules, Total_Lessons, Avg_Course_Price)**
     2**(Year, Total_Students, Total_Enrollments, Completed_Enrollments, Total_Certificates, Completion_Rate_Percentage, Avg_Progress_Percentage)**
    33
    44{{{
    … …  
    5656== 2# Monthly analysis of instructor activity by courses, students, modules, and lessons
    5757
    58 **(Year, Plan_Name, Total_Subscriptions, Total_Users, Total_Payments, Total_Revenue, Avg_Payment_Amount)**
     58**(Year, Month, Total_Instructors, Total_Courses, Total_Students, Total_Modules, Total_Lessons, Avg_Course_Price)**
    5959
    6060{{{
    … …  
    125125== 3# Annual subscription and revenue analysis by subscription plan
    126126
    127 **(Year, Category_Name, Total_Attempts, Total_Students, Avg_Score, Passed_Attempts, Pass_Rate_Percentage)**
     127**(Year, Plan_Name, Total_Subscriptions, Total_Users, Total_Payments, Total_Revenue, Avg_Payment_Amount)**
    128128
    129129{{{
    … …  
    183183== 4# Yearly category analysis by attempts, students, average score, and pass rate
    184184
    185 **(Year, Total_Instructor_Activity, Total_Students, Total_Enrollments, Total_Attempts, Completed_Enrollments, Total_Certificates, Avg_Student_Success_Within_Courses, Avg_Final_Grade_Per_Course, Final_Year_Success)**
     185**(Year, Category_Name, Total_Attempts, Total_Students, Avg_Score, Passed_Attempts, Pass_Rate_Percentage)**
    186186
    187187{{{
    … …  
    287287== 5# Yearly analysis of overall platform activity and student success across enrollments, quiz attempts, completions, certificates, and course performance
    288288
    289 **(Year, Month, Total_Enrollments, Completed_Enrollments, Active_Instructors, Avg_Student_Success, Avg_Course_Success, Final_Month_Success)**
     289**(Year, Total_Instructor_Activity, Total_Students, Total_Enrollments, Total_Attempts, Completed_Enrollments, Total_Certificates, Avg_Student_Success_Within_Courses, Avg_Final_Grade_Per_Course, Final_Year_Success)**
    290290
    291291This SQL query provides a comprehensive yearly analysis of the platform by combining multiple aspects of user activity, instructor engagement, and student performance.
    … …  
    447447
    448448== 6# Monthly analysis of course activity, completions, instructor involvement, and student success within a given year
     449
     450**(Year, Month, Total_Enrollments, Completed_Enrollments, Active_Instructors, Avg_Student_Success, Avg_Course_Success, Final_Month_Success)**
    449451
    450452This SQL query provides a month-by-month analysis of the platform within a selected year, combining course activity data with student performance indicators.