Running courses on a subscription platform generates a lot of numbers and almost no reporting. The billing system knows revenue, the platform knows watch time, and the person who has to present both at the monthly review ends up rebuilding the same pivot tables from scratch. The Online Learning Platforms Dashboard in Google Sheets is the finished version of that rebuild: six tabs, 15 native slicers, 16 KPI cards, and 500 sample enrollment rows across 23 columns that you swap for your own export.Online Learning Platforms Dashboard in Google Sheets
Everything below describes what is actually in the file. The sample figures quoted – $786,607 of subscription revenue, 2,903 active learners, 500 enrollments, 58.0% average completion – are the demo dataset that ships with it, not a claim about your business.
Key Features of the Online Learning Platforms Dashboard
- Six tabs – Overview, Courses, Learners and Revenue do the analysis; Search looks up a single enrollment; Instructions explains the mechanics.Online Learning Platforms Dashboard in Google Sheets
- 15 slicers – three on Overview, four on each of the other analysis pages. They are per page, so filtering Revenue does not disturb Learners.Online Learning Platforms Dashboard in Google Sheets
- Pivot-driven charts with no helper columns. Each chart reads a pivot table parked to the right of its own page. Scroll past the wide spacer column and you can inspect the numbers behind any visual.
- Deliberately unfiltered KPI cards. The four cards on each page, and the At a Glance list in the sidebar, use SUMIFS and COUNTIFS against the Data sheet, so they always show totals. The charts, pivots and Top 5 panel are the slicer-aware half.Online Learning Platforms Dashboard in Google Sheets
- Wired to 1,000 rows out of the box, with instructions for going further by raising DATA_ROWS in the bundled Apps Script.Online Learning Platforms Dashboard in Google Sheets
- One-place re-skin. The shipped theme is Burgundy and Sand; the palette sits at the top of the script.Online Learning Platforms Dashboard in Google Sheets
Dashboard Pages Explanation
Overview – platform-wide performance
Slicers: Month, Subject Category, Subscription Plan. The KPI strip carries Subscription Revenue, Active Learners, Enrollments and Avg Completion. Active Learners vs Subscription Revenue by Month puts headcount and money on one combo chart, a treemap breaks Learners by Subject Category, and a scatter plots Course Price vs Completion Rate – useful for checking whether your expensive courses actually get finished. The sidebar adds a Performance Snapshot, a 12-month revenue trend, Top 5 Courses by Revenue and an Enrollment Status Mix that splits Active, Completed, Cancelled and Expired.Online Learning Platforms Dashboard in Google Sheets
Courses – catalogue, level, price and watch time
Slicers: Subject Category, Course Level, Instructor, Platform. Catalogue metrics report Courses Offered, Avg Course Price, Completed Courses and Total Watch Hours. Below them sit Enrollments by Subject Category, Enrollments by Course Level, Course Price Distribution, Monthly Enrollments and Revenue by Instructor. The sidebar’s Course Level Share panel is where a catalogue skew shows up fastest – on the sample data Beginner and Intermediate carry roughly two-thirds of enrollments.Online Learning Platforms Dashboard in Google Sheets
Learners – age, device, region and engagement
Slicers: Region, Device Type, Age Band, Subscription Plan. Learner metrics cover Total Learners, Unique Accounts, Mobile Share and Avg Watch Hours. Learners by Age Band, Enrollments by Device Type and five gauges showing Avg Completion % by Plan sit above Monthly Active Learners, Monthly Watch Hours and Learners by Region and Plan. The sidebar carries Top 5 Regions by Learners and a Device Mix breakdown.Online Learning Platforms Dashboard in Google Sheets
Revenue – plans, platforms, payments and refunds
Slicers: Subscription Plan, Platform, Payment Method, Status. Revenue metrics show Subscription Revenue, Premium Revenue, Avg Revenue per Sub and Refund Rate. A waterfall builds revenue by subject category, a column chart tracks Monthly Subscription Revenue, a donut splits Revenue by Payment Method, and Plan Revenue vs Enrollments compares money earned against enrollment count – the chart that shows a plan carrying most of the revenue on a minority of sign-ups. Top 5 Platforms by Revenue and Plan Revenue Share complete the sidebar.
Search – one enrollment, all its fields
Type an Enrollment ID and the page reads back all 18 fields of that record: date, platform, subject category, course title, learner name, plan, revenue, seats, course price, completion percentage, watch hours, instructor, device, region, level, payment method, status and month.
Instructions – how the workbook is put together
Ten numbered points cover the pivot-and-slicer architecture, clearing a slicer with Select all, why the KPI cards stay unfiltered, what each page is for, replacing the sample rows, the 1,000-row capacity and how to re-theme.
Online Learning Platforms Dashboard vs. an Excel Build vs. a Paid BI Suite
| This Google Sheets dashboard | Building it yourself in Excel | A paid BI suite (per-seat licence) | |
|---|---|---|---|
| Cost | One payment | Free tooling, your own hours | Recurring per user, per month |
| Platform | Google Sheets, browser | Excel desktop | Desktop plus service |
| Setup time | Paste your export, minutes | Days of layout and formula work | Data model plus report build |
| Real-time team collaboration | Yes, native Sheets | Only via a shared drive | Yes, on the paid service |
| Mobile access | Sheets mobile app | Limited | Vendor app |
| Customizable fields | Edit columns, re-run the script | Fully, if you build it | Fully, with modelling skills |
| Share with link | Yes | No | Licensed viewers only |
| Year-1 cost at 5 users | The purchase price, once | Your build time | Five recurring seats |
| Enrollment-level record lookup | Built in | You would add it | Drillthrough page |
| Live connection to your LMS | No – paste an export | No | With a connector and setup |
A learning management system belongs in a different column entirely, which is why it is not in the table. An LMS hosts the courses, tracks enrollments and issues certificates. This workbook does none of that – it reports on the export those systems already produce. Comparing the two on price would be comparing a report with the thing being reported on.
Who Should Use This Template
It suits a small or mid-sized course business that already exports enrollments to CSV: catalogue managers deciding what to commission, finance leads who need a revenue page for the board, support teams who have to answer a question about one enrollment, and founders who want a monthly review pack without buying BI seats for everybody.
It will not suit you if you need a live feed from your platform – the file is static and connects to nothing. It is not an LMS, not an LRS or xAPI store, and not a student record system. It does not model outcomes, forecast churn or renewals, and it is not a tool for judging whether a course “works”. If your enrollment log runs to hundreds of thousands of rows, a database and a real BI tool are the honest answer.
Real-World Use Cases
A catalogue review. Filter Courses to one subject, read Enrollments by Course Level and Revenue by Instructor together, and you can see whether the demand sits where the production budget is going.
A pricing question. The Course Price vs Completion Rate scatter on Overview is the fastest way to ask whether higher-priced courses finish at a different rate. It is a description of what happened, not evidence of cause.
A refund conversation. A learner queries a charge; support types the enrollment ID into Search and reads the plan, price, payment method and status without opening the billing console.
Advantages of the Online Learning Platforms Dashboard
- No helper columns behind the charts, so the file stays quick as the log grows.
- Everything runs in the browser and shares with a link – no installs, no licences per viewer.
- Chart types chosen for the question rather than for decoration: a waterfall for revenue build, gauges for completion by plan, a treemap for subject mix.
- A record-level lookup page, which most spreadsheet dashboards skip.
- One palette variable re-skins the whole workbook.
Opportunities for Improvement
- The KPI cards ignore the slicers. That is documented and intentional, but it surprises people the first time. Read them as totals.
- 1,000 rows is the shipped ceiling. Going further means editing the Apps Script – straightforward, but it is a script edit.
- No live connection. Refreshing means pasting a fresh export.
- The sample data is fictional, including the platform names and the instructor names. Clear it out before anyone mistakes it for a benchmark.
Best Practices
Replace learner names with an internal code
The Data sheet has a Learner Name column, and it is populated in the sample. Alongside it sit Completion %, Watch Hours, Device Type, Region and Age Band. Once your real export goes in, those columns together describe how identifiable individuals behaved – what they watched, for how long, from which device and how far they got. That is behavioural data about people, not just business volume.
The safer default is to paste an internal learner code instead of a name, keep the name-to-code mapping somewhere access-controlled, and share the workbook with the smallest group that needs it. If any of your learners may be under 18, treat the file with more care again. Nothing in the template enforces any of this – it is a spreadsheet, it will hold whatever you paste – and no claim is made here about any particular data-protection regime. Your own policies and the law where you operate decide what is acceptable.
Keep the headers exactly as they are
Every pivot, slicer and formula is bound to the 23 column headers. Rename one and the charts that depend on it stop resolving. Add new columns to the right of the existing block instead.
Learn the slicer, then the pivot
If a number looks wrong, scroll right past the spacer column on that page and read the pivot the chart is drawn from. Google’s own documentation on pivot tables in Google Sheets covers the mechanics if you want to extend them.
Explore Relevant Templates
- Online Learning Platforms Dashboard in Power BI
- Online Learning Platforms Dashboard in Excel
- Online Learning Platforms KPI Dashboard in Excel – a KPI scorecard, a different product from this analytical dashboard
- EdTech Dashboard in Google Sheets
- School Admin Dashboard in Google Sheets
Related Templates
More related walkthroughs on this blog: Music School Dashboard in Google Sheets, School Admin Dashboard in Google Sheets and Driving School Dashboard in Google Sheets. Each is a separate template with its own layout and sample data.
Frequently Asked Questions
Does it sync with my learning platform?
No. It is a static Google Sheets file. You export from your platform or billing system and paste into the Data sheet.Online Learning Platforms Dashboard in Google Sheets
What learner information does the file hold?
One row per enrollment, including a learner name column, plus completion percentage, watch hours, device type, region and age band. Treat those as personal behavioural data once real records replace the sample, and prefer an internal code to a name.
Does it claim anything about learning outcomes?
No. It reports enrollments, revenue, watch time and completion as recorded. It does not measure whether learning happened, predict who will finish or churn, or validate any experiment.Online Learning Platforms Dashboard in Google Sheets
Is it an LMS?
No, and it is not an LRS, an xAPI store or a student record system either. It is a business reporting template that sits downstream of those tools.
How many enrollments can it handle?
1,000 rows as shipped. Raise DATA_ROWS in the bundled Apps Script and re-run main() for more.Online Learning Platforms Dashboard in Google Sheets
Why do the KPI cards not change when I click a slicer?
By design – they use SUMIFS and COUNTIFS on the Data sheet and always show unfiltered totals. The charts, pivots and the Top 5 panel respond to slicers.
Can I recolour it?
Yes. Edit the palette at the top of the Apps Script and the entire workbook changes theme.Online Learning Platforms Dashboard in Google Sheets
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.Online Learning Platforms Dashboard in Google Sheets
Conclusion
If your course numbers currently live in a monthly ritual of exports and improvised pivot tables, this workbook replaces the ritual with a file: four analysis pages, a lookup page and an instruction page, all reading from one Data sheet you control. It will not connect to your platform, and it will not tell you whether your teaching works – but it will tell you, quickly and repeatably, what enrolled, what got watched, what got paid for and what got refunded.Online Learning Platforms Dashboard in Google Sheets
Get the Online Learning Platforms Dashboard in Google Sheets, and for walkthroughs of this and the rest of the Google Sheets line, subscribe at youtube.com/@NeoTechNavigators.Online Learning Platforms Dashboard in Google Sheets
