Website Sales & E-learning Dashboard

• Real-time online course revenue tracking

• Analyze student enrollment and conversion from visitors

• Calculate course completion rate and average progress

• Track engagement metrics: video views, quiz scores, time spent

• Dashboard for bestselling courses and revenue by category

• Analyze student behavior: active vs inactive learners

• Track instructor performance and course ratings

• Trend charts for enrollments and completions by month

• Multi-dimensional pivot tables by course, student segment, channel

• Export Excel reports with detailed e-learning metrics

• Course Enrollment: Number of students enrolled in course

• Completion Rate: Completion rate = Completed / Enrolled × 100%

• Average Progress: Average student progress in course

• Engagement Rate: Active students / Total enrolled ratio

• Video Completion Rate: Rate of videos watched completely

• Quiz Pass Rate: Quiz pass rate / Total attempts

• Time to Complete: Average time to complete course

• Revenue Per Student: Average revenue per student

• Course Rating: Average course rating

• Churn Rate: Rate of students dropping out mid-course

1. Go to Spreadsheet > Dashboards, click Create

2. Select "E-learning Sales Analysis" template or create from scratch

3. Add Pivot Table: Insert > Pivot, select Sales Orders (courses)

4. Configure Pivot: Rows = Course, Columns = Month, Values = Revenue

5. Add 2nd Pivot: Slide Channels, Values = Enrollments, Completions

6. Create charts: Insert > Chart, revenue and completion trends

7. Add KPI cards: Total revenue, Enrollments, Completion rate, Avg rating

8. Set up filters: Date range, Course category, Instructor

9. Add formulas: Completion rate, Revenue per student, Engagement rate

10. Save dashboard and share with education team

• Line Chart: Enrollment and completion trends by month

• Funnel Chart: Student journey from visitor to course completion

• Bar Chart: Compare revenue by course category or instructor

• Stacked Bar: Enrolled vs Completed students by course

• Pie Chart: Revenue distribution by course category

• Combo Chart: Enrollments (bars) and Completion rate (line)

• Heatmap: Student activity by day of week and hour

• Gauge Chart: Average completion rate vs target

• Total Course Revenue: Total revenue from course sales

• Total Enrollments: Total course enrollments

• Active Students: Number of students active in last 30 days

• Completion Rate: (Completed / Enrolled) × 100%

• Average Course Rating: Average rating of all courses

• Revenue Per Student: Total Revenue / Total Students

• Engagement Rate: Active Students / Total Enrolled × 100%

• Video Completion Rate: Videos watched completely / Total views

• Quiz Pass Rate: Passed quizzes / Total attempts × 100%

• Churn Rate: Students inactive >60 days / Total enrolled

• Online academy: Track 100+ courses, 5000+ students, $50K/month revenue

• Corporate training: Analyze completion rates and employee engagement

• University: Dashboard per department with enrollment trends

• Course marketplace: Track bestselling courses and instructor performance

• Education Manager: Identify courses with low completion and improve content

• Instructor: Monitor student progress and engagement with course materials

• Marketing: Analyze conversion from free trials to paid enrollments

• CEO: Monthly report with key e-learning business metrics

• Stage 1 - Website Visitors: Total visitors to course pages

• Stage 2 - Course Preview: Number viewing preview videos/content

• Stage 3 - Add to Cart: Number adding course to cart

• Stage 4 - Enrollment: Number completing payment

• Stage 5 - Active Learning: Number of students starting to learn

• Stage 6 - Completion: Number of students completing course

• Drop-off analysis: Identify which stage loses most students

• Retention strategies: Email reminders, gamification, certificates

• Multiple data sources: Sales Orders, Slide Channels, Student Progress

• Calculated fields: Completion Rate = Completed / Enrolled × 100%

• Conditional formatting: Green for >70% completion, Red for <30%

• Drill-down: Click course to view detailed student list and progress

• Grouping: Group by course category, instructor, difficulty level

• Sorting: Sort by revenue or completion rate descending

• Filters: Filter by date, course type, student segment, price range

• Subtotals: Display totals by category and instructor

• =ODOO.PIVOT("Sales Orders", "Revenue", "Course", "Month")

• =ODOO.PIVOT("Slide Channels", "Enrollments", "Course", "Date")

• =Completed / Enrolled × 100 - Calculate Completion Rate

• =Revenue / Enrollments - Calculate Revenue Per Student

• =Active_Students / Total_Enrolled × 100 - Engagement Rate

• =Videos_Completed / Total_Videos × 100 - Video Completion Rate

• =IF(Completion_Rate < 30, "Low", "OK") - Low completion alert

• =AVERAGE(Course_Ratings) - Calculate average rating

• Website: Get traffic data and course page views

• Sales: Connect with course purchases and revenue data

• Slides (E-learning): Track enrollments, progress, completions

• Survey: Collect student feedback and course ratings

• Certification: Track certificates issued and completion badges

• Forum: Analyze student discussions and community engagement

• Email Marketing: Track campaign performance for course promotions

• CRM: Manage leads from free courses to paid upgrades

• Content quality: Improve videos, quizzes, and materials based on feedback

• Course structure: Optimize lesson order and difficulty progression

• Engagement tactics: Gamification, badges, leaderboards, certificates

• Pricing strategy: A/B test pricing, bundles, subscriptions

• Marketing optimization: Better course descriptions, preview videos, testimonials

• Student support: Live Q&A sessions, discussion forums, instructor feedback

• Mobile optimization: Ensure courses work well on mobile devices

• Completion incentives: Certificates, job placement, continuing education credits

• Weekly monitoring: Review dashboard to track enrollment and completion trends

• Set benchmarks: Establish target completion rates for each course type

• Cohort analysis: Track student performance by enrollment cohorts

• Instructor feedback: Share metrics with instructors to improve courses

• Student surveys: Combine quantitative metrics with qualitative feedback

• Content updates: Regularly refresh course materials based on performance

• Early intervention: Identify at-risk students and send reminders

• Success stories: Highlight high-performing courses and replicate strategies

• Competitive analysis: Benchmark metrics with industry standards

• Cross-functional review: Monthly meetings with education, marketing, product teams

• Enrollment data not updating: Check Slides module integration

• Low completion rate: Review course difficulty and student feedback

• Revenue doesn't match: Verify refunds and cancellations included

• Wrong progress tracking: Check slide completion tracking configuration

• Slow pivot table: Reduce date range or aggregate student data

• Chart not displaying: Check data has values and not null

• Export error: Verify formulas and student data permissions

• Rating issues: Check survey responses linked correctly to courses

• Spreadsheet Dashboard module must be installed

• Website and E-commerce modules must be activated

• Slides (E-learning) module must be configured

• Sales module must be set up for course sales

• Access rights: User (view), Education Manager (edit), Admin (configure)

• Browser: Latest Chrome, Firefox, Safari versions