Diagnostic Learning Analytics

40 min → 20 minEstimated time to insight
Descriptive → diagnosticReporting capability
11 → 5 stagesCore reporting workflow
Role
Product Designer
Timeline
12 Weeks
Skills
Data VisualizationEdTechAnalyticsDesign Systems

I redesigned an LMS reporting experience to help administrators move from static report exports toward in-product investigation. The proposed workflow brought guided setup, live validation, filtering, sorting, and summary signals into the LMS, reducing a fragmented and repetitive process across internal and external tools.

This reduced the modelled reporting journey from 11 stages to 5 and the estimated time to insight from 40 minutes to 20. The redesign advanced reporting from descriptive output toward diagnostic capability, helping administrators move more quickly from stakeholder questions to actionable insights.

Organizations use learning management systems to support employee performance. Courses, curriculum, reminders, compliance paths, and assessments are configured so employees can build skills, complete required training, and meet organizational standards.

Reporting is the feedback layer of that system. It helps learning teams understand whether training is working, where employees may be falling behind, and where managers, instructors, HR, or L&D teams may need to intervene.

The existing reporting experience supported basic historical reporting. LMS admins could select a data source, choose fields, configure filters, schedule reports, and export results. This was useful for answering “what happened,” but it did not sufficiently help users understand why performance gaps were happening or what they should investigate next.

The broader product ambition was to move LMS reporting up the analytics maturity curve. The long-term goal was to support more mature insights and eventual recommendations, but the immediate opportunity was to strengthen the diagnostic layer: helping users investigate performance gaps instead of only exporting historical data.

The redesign focused on establishing the diagnostic layer of analytics maturity – moving reporting beyond what happened toward understanding why it happened.
The redesign focused on establishing the diagnostic layer of analytics maturity – moving reporting beyond what happened toward understanding why it happened.

The existing reporting workflow treated reports primarily as outputs. Admins configured a report, generated or exported it, then moved into spreadsheets or other tools to understand what the data meant. This created extra work and made follow-up questions harder to answer quickly.

This was especially limiting because reporting often began with an open-ended stakeholder question, not a clearly defined report request:

  • Why is completion low?
  • Which department is falling behind?
  • Are learners aware of the deadline?
  • Is the course relevant to their role?
  • Is there a configuration issue with reminders or due dates?
  • The reporting experience needed to support this investigative process. Instead of assuming that admins already knew the exact report they needed, the product needed to help them start from a question, shape the right data view, identify patterns, and share findings.

    Opportunity question:

    How might we help training administrators investigate gaps in employee learning without relying on static report exports?

    Analytics maturity had to happen in stages because more advanced insights depend on a reliable reporting foundation.

    Prescriptive analytics requires several layers beneath it: clean report creation, understandable data fields, reliable filters and sorting, usable templates, trustworthy previews, and summary signals that users can trace back to the underlying data. Without those foundations, recommendations would feel opaque or unreliable.

    Several constraints shaped the work.

    First, the redesign had to work within existing reporting architecture. Data sources, fields, filters, sort rules, scheduling, templates, and exports already existed. The work needed to improve the experience without breaking core reporting behavior.

    Second, the primary users were not data analysts. LMS admins often managed courses, curriculum, learner support, compliance, and reporting at the same time. They needed reporting tools that were guided, visual, and forgiving.

    Third, reporting workflows extended beyond the LMS. Admins often used spreadsheets to consolidate exports, compare data, clean up views, and prepare findings for stakeholders. The product could not replace every spreadsheet workflow at once, but it could reduce unnecessary handoffs by bringing more validation and diagnosis into the LMS.

    Finally, the work needed to be released in stages. This phase focused on the next realistic step: moving from descriptive reporting toward diagnostic reporting.

    Discovery included LMS admin interviews, analysis of reporting workarounds, and review of complex spreadsheets that admins used to organize and interpret exported data outside the LMS.

    These artifacts showed that reporting was not a single in-product task. It was a workflow that moved across requests, clarification, report configuration, exports, spreadsheet analysis, and stakeholder communication.

    The swimlane diagram helped map this workflow across overlapping platforms and roles. A requester or manager might identify a performance problem and ask for a report. The LMS admin would then clarify the request, decide which report or data source to use, configure fields and filters, export results, analyze the data in Excel, and share findings back to the requester.

    This revealed that the LMS supported only part of the job. The most important diagnostic work often happened around the product, not inside it.

    The primary user was the LMS Reporting Admin. This user could also be an LMS admin, instructional designer, HR partner, or learning operations owner. Their responsibilities included building and updating courses, managing day-to-day LMS operations, and responding to reporting requests from leadership or instructors.

    They were often non-technical, relied on templates or visual tools, and did not always know which fields mapped to which metrics. Reporting was only one part of their job, so they needed to answer data questions quickly and confidently.

    A representative scenario centered on low training completion. A manager notices that completion is low for the Sales team. Rory, the LMS admin, pulls a completion report. Leadership then asks why completion is low. Rory may need to drill down by department, course, time period, region, cohort, reminders, or engagement signals.

    Rory’s role was not just to pull reports. She translated open-ended stakeholder questions into evidence-backed insights that helped leadership understand where support was needed and what action to take next. The platform needed to better support this strategic work, instead of treating reporting as a static export task.

    Rory’s role was not simply to pull reports, but to translate open-ended stakeholder questions into evidence-backed findings that others could act on.
    Rory’s role was not simply to pull reports, but to translate open-ended stakeholder questions into evidence-backed findings that others could act on.
    Much of the diagnostic work happened around the product rather than inside it.
    Much of the diagnostic work happened around the product rather than inside it.

    LMS admins were not just building reports. They were translating messy performance questions into data views that other people could act on.

    A manager might ask, “Why is completion low?” But the admin has to translate that question into report logic:

  • Which data source should I use?
  • Which fields indicate completion?
  • Should I filter by department, course, date, or cohort?
  • What comparison would reveal the issue?
  • What format will help managers understand the finding?
  • The old workflow assumed users knew exactly what report they needed before they started. In reality, admins often figured out the right report while building it.

    This created the key design shift:

    The new mental model moved non-technical users beyond data export and guided them toward actionable insight.
    The new mental model moved non-technical users beyond data export and guided them toward actionable insight.

    The redesign focused on creating the next layer of analytics maturity: a reporting workflow that could support diagnosis.

    Rather than treating reporting as a final export, the new direction helped users start from a stakeholder question, choose a useful reporting path, configure the right data, preview results, identify patterns, and share findings.

    Before — The original reporting workflow Report creation began with a dense configuration screen, requiring admins to choose data sources, fields, filters, and outputs before they could judge whether the report answered the request.

    1. Template-guided report creation

    Discovery showed that many admins were non-technical and relied on visual context to understand whether a report would answer the request. Since stakeholder questions were often open-ended, admins still had to translate them into the right data source, fields, and filters.

    Templates gave admins a structured starting point for common reporting needs, such as course completion, learner progress, assessment performance, and compliance tracking. Instead of starting from a blank configuration flow, admins could begin with a familiar report pattern and adjust from there.

    A key improvement was previewing report data while users chose or applied a template. Seeing the data in context helped admins judge whether the template was appropriate before committing to it, rather than discovering after export that it lacked the fields or context needed to answer the request.

    For example, if a stakeholder asked why completion was low, the admin could start from a course completion template, preview the data, then refine the report by adding fields such as department, status, due date, completion date, or course.

    Why this mattered

    Templates reduced the burden of knowing the correct report structure upfront. The tradeoff was that templates could not answer every stakeholder question on their own, so they needed to work as flexible starting points rather than fixed reports. Previewing data earlier made that flexibility useful: admins could choose with more confidence, then refine the report around the specific answer they needed.

    2. Report configuration with live feedback

    The redesigned workflow brought report configuration closer to the data itself. Instead of configuring a report separately from its output, admins could add or remove columns, apply filters, sort results, and see how those choices affected the report output.

    This helped users validate whether the report was answering the right question before saving, exporting, or sharing it.

    Why this mattered:

    Previously, admins had to configure a report, export it, inspect the spreadsheet, and return to the LMS if something was wrong. The new workflow shortened that feedback loop and made report creation feel more testable.

    3. Guided field selection

    Field selection was a major pain point because users were often unsure which fields corresponded to the metrics they needed.

    To support non-technical admins, field selection needed to be organized around relevance rather than exposing every available field equally. Recommended fields could help users start with the data most likely to answer the report question, while still allowing advanced customization.

    For a course completion report, recommended fields might include:

    • Learner name
    • Department
    • Course
    • Status
    • Completion date
    • Score
    • Access date

    Why this mattered:

    Choosing the wrong field could lead to inaccurate reports, wasted time, or misleading findings. Clearer field selection helped build confidence in the report.

    4. Diagnostic filtering and sorting

    After deciding which information to include in the report, filters and sorting helped admins turn that data into findings.

    Admins could narrow results by department, course, learner group, status, due date, completion date, or time period to investigate where a performance issue was concentrated. Rather than scanning large datasets, they could progressively reduce the scope of the report and compare different segments of the data.

    For example, if completion was low, an admin could filter by department, sort by overdue status, and compare results across teams or courses to determine where the issue was occurring.

    Before — Filtering was buried inside a long configuration page. 

Filters were configured separately from the report output, making it harder to judge whether each condition was producing a useful result.
    Before — Filtering was buried inside a long configuration page. Filters were configured separately from the report output, making it harder to judge whether each condition was producing a useful result.

    Why this mattered

    Field selection helped admins decide what information was relevant. Filters and sorting helped them investigate it. Together, they supported a more diagnostic workflow by helping users move beyond “What happened?” and toward “Where is it happening?” and “What pattern explains it?”

    5. Summary signals

    The report summary introduced a lightweight diagnostic layer above the table. Instead of expecting admins to manually scan every row, the product could surface patterns that helped explain why a metric was changing.

    Examples of summary signals:

    • Completion rate dropped compared to last month
    • Service department has the highest overdue rate
    • Most overdue learners are assigned to Course X
    • A group of learners has not accessed the course since assignment

    Why this mattered

    This represented one of the clearest shifts from descriptive to diagnostic analytics. Rather than relying entirely on the admin to uncover every insight, the system could begin highlighting relationships within the data and directing attention toward potential causes. This created the foundation for more advanced analytics capabilities in the future.

    Templates, guided fields, filters, and sorting helped admins investigate report data more effectively. Summary signals took the next step by proactively surfacing patterns, trends, and anomalies that could explain a performance issue.

    6. Reusable reporting outputs

    The workflow also needed to support what happened after analysis. Admins often shared reports with managers, instructors, HR, or L&D teams. Some reports also became recurring operational references.

    The experience could support several output paths:

    • Save report
    • Export report
    • Schedule report
    • Save as reusable template
    • Send findings to a requester or manager

    Why this mattered:

    The admin’s job did not end when the report was generated. The report needed to function as both a data artifact and a communication tool.

    Administrators follow a guided path based on their reporting question, use the live report to explore the data more easily, and reach insights faster. This recreated experience preserves the product’s core workflow while using fictional content to protect confidential information.

    The redesign established the diagnostic foundation needed to advance reporting along the analytics maturity curve toward prescriptive insights. By bringing report setup, validation, investigation, and pattern identification into the LMS, it reduced the modelled workflow from 11 stages to 5 and the projected time to actionable insight from 40 minutes to 20.

    To evolve from diagnostic to prescriptive analytics, the product first needed reliable data structures, trusted reporting logic, and clear relationships between performance gaps and their likely causes. Once these foundations were established and validated, the system could begin recommending appropriate actions with greater accuracy, transparency, and user trust.

    Metric breakdown

    Time to actionable insight

    Workflow activityBeforeRedesigned
    Report selection and setup10 min5 min
    Data preparation and refinement10 min7 min
    Analysis and pattern identification15 min5 min
    Preparing and sharing findings5 min3 min
    Total40 min20 min

    Core reporting workflow

    Before — 11 stagesRedesigned — 5 stages
    1. Clarify the stakeholder question1. Choose a template or reporting path
    2. Select a report or data source2. Configure relevant fields and filters
    3. Choose the required fields3. Preview and refine the report live
    4. Configure filters and sorting4. Identify patterns and summary signals
    5. Generate the report5. Save, schedule, export, or share findings
    6. Export the report
    7. Open the spreadsheet
    8. Clean and restructure the data
    9. Analyze and compare results
    10. Revise and re-export when needed
    11. Prepare and share findings
    Ascend