Learning path and lesson completion metrics graph

Problem

The completion rate is one of the most useful metrics to me as a course manager. This metric indicates if learners are empowered and motivated to complete a course. We can currently easily view this for individual courses, which is useful, but specific and more useful pieces of information require manual work to extract:

1. Completion rate by course within a learning path
2. Completion rate by lesson with a course
   1. This sort of exists, but you can only see lesson views, not completion rates
3. Completion rate by lesson by course within a learning path

These visualizations/tables built into the Dashboard Analytics would significantly reduce manual effort.

Potential Solutions

I've attached an Excel workbook with mockups of what I'm picturing. The data is fake. The third option (lessons in courses in a path) presents a pretty overwhelming chart so that it might be better presented as a table. Or perhaps a table with sparklines.

I can get all this data from the Analytics section, but putting it together in this format requires manual work.

My preferred route to get to these would be:

• Dashboard > Analytics & Reports > Reports > Paths > click a path in the list
  • That currently goes to a page of path enrollments. Perhaps you could copy the behavior that happens if you click a course from the Courses report. That takes you to a tabbed view of Enrollments and Lessons. In this case, for paths, it would take you to a tabbed view of Enrollments and Courses. Then the Courses page would have the course completion rates within the path as a table and chart.
• Dashboard Analytics & Reports > Reports > Paths > click a path in the list
  • Same path as above. Again, adding it as a tab on the specific course analytics page would work. Add a tab called Lessons and show a table and chart of the completion rate for all lessons in all courses in a path, in order.

If you think of this more as "analytics" rather than "reports," I could see an argument for adding a Path entry to the Analytics section in Analytics & Reports instead. But I think the pages would end up being pretty similar. You could even do both. If you do that, you might also need to do the same for courses. In that case, I'd just add completion rate as a column on the existing course analytics page.

These proposed pages are similar to the existing view you get if you click a course on the Course page in Analytics. However, that page only shows lessons within a course, and I would also greatly prefer it to show the lesson completion rate rather than the lesson views or time. We use quizzes on every page to gate completion and "prove" the student engaged with that page. But I think the location of this page in the Dashboard and the general layout of the page could be cribbed for these charts.