Christian Mercado

Christian MercadoChristian MercadoChristian Mercado

Christian Mercado

Christian MercadoChristian MercadoChristian Mercado
  • Home
  • About
  • Resume
  • Work
    • Creovia: Parent Portal
    • Creovia: Data Dashboards
    • RealPage: Centralization
    • Entrata
    • Domo Templates
    • Domo Branding Re-designs
    • The OUT Foundation
  • Contact
  • More
    • Home
    • About
    • Resume
    • Work
      • Creovia: Parent Portal
      • Creovia: Data Dashboards
      • RealPage: Centralization
      • Entrata
      • Domo Templates
      • Domo Branding Re-designs
      • The OUT Foundation
    • Contact
  • Sign In
  • Create Account

  • My Account
  • Signed in as:

  • filler@godaddy.com


  • My Account
  • Sign out

Signed in as:

filler@godaddy.com

  • Home
  • About
  • Resume
  • Work
    • Creovia: Parent Portal
    • Creovia: Data Dashboards
    • RealPage: Centralization
    • Entrata
    • Domo Templates
    • Domo Branding Re-designs
    • The OUT Foundation
  • Contact

Account


  • My Account
  • Sign out


  • Sign In
  • My Account

Our team at Creovia

At Creovia I support our design and development teams in building a comprehensive, all-in-one education platform. Our mission is to empower educators, parents, and students with enhanced educational data and tools. We provide innovative web solutions to over 40 education institutions to deliver impactful, user-centered educational experiences.


Creovia's Connect product suite grows larger by the day, and we now have 7 core products. Creovia differentiates itself from other learning management and student information systems by not forcing itself into either category. Our motto is to "create a way," and we are focused on creating solutions empower educators and parents to navigate school, work and life with efficiency, security, and boundless potential.

Creovia: Transforming Data into Dashboards

Company: Creovia

Role: UX Designer & Project Manager

Responsibilities: UX/UI design, research, user flows, wireframing, prototyping, visual design

Tools: Figma

🔎 Overview

Magnify is a comprehensive student data visualization platform that transforms complex educational data into actionable insights for K-12 schools and districts. In this case study I'll share how we developed a flexible, powerful dashboard system through extensive research and collaboration with educational institutions.

💪 The Challenge

K-12 schools face significant challenges in making sense of their student data:

  • Data scattered across multiple systems and spreadsheets
  • Limited ability to identify at-risk students early
  • Difficulty tracking student progress 
  • Need for customizable risk assessment metrics
  • Time-intensive manual data analysis processes

⚙️ Research Process

Stakeholder Interviews

We conducted extensive interviews with administrators, teachers, and staff across multiple K-12 institutions to understand their data needs and pain points. Key findings revealed that schools needed:

  • Real-time access to student performance metrics
  • Customizable risk factor calculations
  • Easy integration with existing student information systems
  • Visual representations of complex data relationships
  • The ability to track both individual and cohort progress


Data Assessment

We analyzed various data sources schools typically work with:

  • Student Information Systems (SIS)
  • Spreadsheet-based tracking systems
  • Behavioral incident reports
  • Attendance records
  • Academic performance data
  • State testing results
  • Internal assessment scores


Flexible Data Connection

We built Magnify to accommodate multiple data input methods:

  • Direct SIS integration
  • Spreadsheet imports
  • Custom API connections
  • Manual data entry options


Data Processing

We built Magnify to accommodate multiple data input methods:

  • Direct SIS integration
  • Spreadsheet imports
  • Custom API connections
  • Manual data entry options


Custom Risk Indicator

We developed a flexible risk factor calculation system that:

  • Allows schools to define their own risk metrics
  • Weighs different factors based on institutional priorities
  • Updates in real-time as new data is received
  • Provides early warning indicators for at-risk students


Visual Dashboard Design

Our dashboard design prioritizes:

  • Clear data visualization
  • Intuitive navigation
  • Customizable views
  • Drill-down capabilities
  • Export functionality
  • Role-based access controls

🎯 Results & Impact

Key Metrics

Schools using Magnify have reported:

  • 40% reduction in time spent on data analysis
  • Earlier identification of at-risk students
  • Improved intervention response times
  • Better communication between administrators and teachers
  • More informed decision-making processes


User Impact

The platform has enabled schools to:

  • Identify struggling students before grades significantly drop
  • Track the effectiveness of intervention programs
  • Make data-driven decisions about resource allocation
  • Improve communication with parents and stakeholders
  • Streamline reporting processes


Continuous Improvement

We maintain an ongoing feedback loop with users through:

  • Regular check-ins with school administrators
  • User surveys and feedback sessions
  • Usage MS Clarity analytics monitoring
  • Quarterly feature updates
  • Continuous performance optimization


Looking Forward

Future development plans include:

  • Enhanced mobile accessibility
  • Expanded integration capabilities
  • Additional customization and styling options
  • Machine learning and AI powered insights

📋 Conclusion

Magnify demonstrates how thoughtful research, user collaboration, and flexible design can create a powerful tool for educational institutions. By transforming complex data into actionable insights, we're helping schools make more informed decisions and better support their students' success.

Copyright © 2025 Christian Mercado - All Rights Reserved.


Powered by