{"id":1648,"date":"2025-02-04T09:47:50","date_gmt":"2025-02-04T09:47:50","guid":{"rendered":"https:\/\/www.cmsgalaxy.com\/blog\/?p=1648"},"modified":"2025-02-04T09:47:52","modified_gmt":"2025-02-04T09:47:52","slug":"how-to-set-up-and-manage-open-edx-analytics-and-reports","status":"publish","type":"post","link":"https:\/\/www.cmsgalaxy.com\/blog\/how-to-set-up-and-manage-open-edx-analytics-and-reports\/","title":{"rendered":"How to set up and manage Open edX analytics and reports?"},"content":{"rendered":"\n

Setting Up and Managing Open edX Analytics and Reports<\/strong><\/h3>\n\n\n\n

Open edX provides powerful analytics tools to track learner engagement, course performance, and student progress. Below is a step-by-step guide on setting up and managing analytics and reports<\/strong> in Open edX.<\/p>\n\n\n\n

\n\n\n\n

1. Enable Open edX Insights (Analytics Service)<\/strong><\/h2>\n\n\n\n

Open edX includes Insights<\/strong>, a dedicated analytics service that provides course performance data.<\/p>\n\n\n\n

Steps to Enable Insights<\/strong><\/h3>\n\n\n\n
    \n
  1. Ensure Open edX Insights is Installed<\/strong>\n
      \n
    • If not installed, deploy it using the official Open edX Analytics Pipeline (edx-analytics-pipeline<\/code>).<\/li>\n<\/ul>\n<\/li>\n\n\n\n
    • Configure Insights in LMS (lms.env.json<\/code>)<\/strong>\n
        \n
      • Add the following: \"ENABLE_EDX_INSIGHTS\": true, \"INSIGHTS_URL\": \"http:\/\/your-insights-server\"<\/code><\/li>\n\n\n\n
      • Restart Open edX: sudo \/edx\/bin\/supervisorctl restart all<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n
      • Access Open edX Insights<\/strong>\n
          \n
        • Visit http:\/\/your-insights-server<\/code> and log in.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n
          \n\n\n\n

          2. Use the Instructor Dashboard for Reports<\/strong><\/h2>\n\n\n\n

          Instructors can download reports<\/strong> directly from the Instructor Dashboard<\/strong> in the LMS.<\/p>\n\n\n\n

          Steps to Download Reports<\/strong><\/h3>\n\n\n\n
            \n
          1. Go to Instructor Dashboard \u2192 Data Download.<\/strong><\/li>\n\n\n\n
          2. Available reports:\n
              \n
            • Enrollment Report<\/strong> (student registration details).<\/li>\n\n\n\n
            • Grade Report<\/strong> (student scores and completions).<\/li>\n\n\n\n
            • Activity Report<\/strong> (login frequency, course interactions).<\/li>\n\n\n\n
            • Discussion Report<\/strong> (forum engagement data).<\/li>\n<\/ul>\n<\/li>\n\n\n\n
            • Click “Download Report”<\/strong> to generate the CSV file.<\/li>\n<\/ol>\n\n\n\n
              \n\n\n\n

              3. Track Learner Progress via API<\/strong><\/h2>\n\n\n\n

              Use Open edX APIs to retrieve real-time analytics<\/strong>.<\/p>\n\n\n\n

              Example: Fetching Student Progress<\/strong><\/h3>\n\n\n\n
              curl -X GET \"https:\/\/your-openedx-instance\/api\/grades\/v1\/course_grade\/course-v1:edX+DemoX+2023\" \\\n-H \"Authorization: Bearer YOUR_ACCESS_TOKEN\"\n<\/code><\/pre>\n\n\n\n
              This API returns student grades and progress.<\/p>\n\n\n\n
              \n\n\n\n
              4. Enable Google Analytics or Matomo for Deeper Tracking<\/strong><\/h2>\n\n\n\n
              To monitor real-time user behavior<\/strong>, integrate Open edX with Google Analytics<\/strong>.<\/p>\n\n\n\n
              Steps to Enable Google Analytics<\/strong><\/h3>\n\n\n\n
                \n
              1. Edit LMS Configuration (lms.env.json<\/code>)<\/strong>: \"GA_TRACKING_ID\": \"UA-XXXXXXXXX-X\"<\/code><\/li>\n\n\n\n
              2. Restart Open edX: sudo \/edx\/bin\/supervisorctl restart all<\/code><\/li>\n\n\n\n
              3. Access real-time reports in Google Analytics<\/strong>.<\/li>\n<\/ol>\n\n\n\n
                \n\n\n\n
                5. Use External BI Tools (Power BI, Tableau, etc.)<\/strong><\/h2>\n\n\n\n
                If you need advanced reporting, connect Open edX to Tableau, Power BI, or Metabase<\/strong>.<\/p>\n\n\n\n
                Steps to Connect Power BI to Open edX Database<\/strong><\/h3>\n\n\n\n
                  \n
                1. Install PostgreSQL Connector in Power BI.<\/strong><\/li>\n\n\n\n
                2. Connect to Open edX database<\/strong>:\n
                    \n
                  • Database: edxapp<\/code><\/li>\n\n\n\n
                  • Host: your-openedx-server<\/code><\/li>\n\n\n\n
                  • User: edxapp<\/code><\/li>\n\n\n\n
                  • Password: yourpassword<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n
                  • Query Data for Reports<\/strong>.<\/li>\n<\/ol>\n\n\n\n
                    \n\n\n\n
                    6. Automate Report Generation<\/strong><\/h2>\n\n\n\n
                    Use cron jobs<\/strong> to auto-generate reports<\/strong>.<\/p>\n\n\n\n
                    Example: Auto-Download Enrollment Reports<\/strong><\/h3>\n\n\n\n
                      \n
                    1. Open crontab<\/code>: crontab -e<\/code><\/li>\n\n\n\n
                    2. Add: 0 2 * * * curl -o \/reports\/enrollment.csv \"https:\/\/your-openedx-instance\/api\/enrollment\/v1\/enrollment\" --header \"Authorization: Bearer YOUR_ACCESS_TOKEN\"<\/code><\/li>\n\n\n\n
                    3. This runs daily at 2 AM<\/strong> and saves reports.<\/li>\n<\/ol>\n\n\n\n
                      \n\n\n\n
                      7. Enable Real-Time Dashboards for Admins<\/strong><\/h2>\n\n\n\n
                        \n
                      1. Install Grafana<\/strong> and connect it to Open edX logs.<\/li>\n\n\n\n
                      2. Set up real-time dashboards<\/strong> for:\n
                          \n
                        • Course completion rates<\/strong><\/li>\n\n\n\n
                        • User engagement heatmaps<\/strong><\/li>\n\n\n\n
                        • Dropout analysis<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n
                          \n\n\n\n
                          Conclusion<\/strong><\/h3>\n\n\n\n
                          By combining Insights, API-based tracking, Google Analytics, and BI tools<\/strong>, Open edX enables powerful learner analytics<\/strong>. \ud83d\ude80<\/p>\n\n\n\n
                          <\/p>\n","protected":false},"excerpt":{"rendered":"
                          Setting Up and Managing Open edX Analytics and Reports Open edX provides powerful analytics tools to track learner engagement, course<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1648","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.cmsgalaxy.com\/blog\/wp-json\/wp\/v2\/posts\/1648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cmsgalaxy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cmsgalaxy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cmsgalaxy.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cmsgalaxy.com\/blog\/wp-json\/wp\/v2\/comments?post=1648"}],"version-history":[{"count":1,"href":"https:\/\/www.cmsgalaxy.com\/blog\/wp-json\/wp\/v2\/posts\/1648\/revisions"}],"predecessor-version":[{"id":1649,"href":"https:\/\/www.cmsgalaxy.com\/blog\/wp-json\/wp\/v2\/posts\/1648\/revisions\/1649"}],"wp:attachment":[{"href":"https:\/\/www.cmsgalaxy.com\/blog\/wp-json\/wp\/v2\/media?parent=1648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cmsgalaxy.com\/blog\/wp-json\/wp\/v2\/categories?post=1648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cmsgalaxy.com\/blog\/wp-json\/wp\/v2\/tags?post=1648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}