ioVote Analytics Dashboards

PostgreSQL · Python · matplotlib

Updated: Sep 2025

Role: Independent Analyst · Time: 2025 · Stack: Python • SQL • PostgreSQL • matplotlib · Output: session dashboards for non-technical stakeholders

Context

ioVote produces session results (options, turnout, activity over time). Stakeholders needed fast, visual summaries without manual spreadsheet work.

Data

• PostgreSQL tables: sessions, votes, options
• Fields: timestamps, voter (ID/anonymous), option IDs, session IDs

Method

• SQL views for turnout, option-level results, and time-series activity (CTEs + window functions).
• Python (pandas/matplotlib) scripts to render bar, pie, and line charts.
• Exported images for the app and a lightweight HTML report.

Results

• Reduced manual reporting time by ~30%.
• Clear visuals for non-technical users; decisions within minutes after session close.

Examples

Representative SQL

WITH votes_per_option AS (
  SELECT v.session_id, v.option_id, COUNT(*) AS votes
  FROM votes v
  GROUP BY v.session_id, v.option_id
)
SELECT o.option_text, vpo.votes
FROM votes_per_option vpo
JOIN options o ON o.id = vpo.option_id
WHERE vpo.session_id = :session_id
ORDER BY vpo.votes DESC;

← Back to portfolio