Project Overview

Lafayette Group's Election Security & Resilience (ESR) team is facing problems in handling various datasets stored in Excel sheets and in complex formats.

Our solution of creating dashboards will consolidate data from multiple Excel sheets into a single, easy-to-use interface, eliminating the need to manually search through different files.

By using visualizations and real-time data updates, the dashboards will enable the Lafayette group to quickly identify trends and make informed decisions, ultimately improving their overall efficiency and productivity

Our project aims to deliver a comprehensive user-focused dashboard that meets the needs of various stakeholders.

The final deliverable will be a fully functional dashboard with an intuitive user interface and associated data visualizations that provide meaningful insights.

Overall, the project will help Lafayette Group to make informed decisions and streamline operations, and it will provide the student team with practical experience in user-centered design and dashboard development.

Our Sponsors from LGI

Alyssa Suhm

Project Manager @ LGI

Jack Ward

Project Manager @ LGI

Meet Team Technospark

Ankit Shankhala

Data Analyst & BI Developer

Renuka Dixit

Product Manager & UX Researcher

Siddhi Korad

Product Manager & UX Researcher

Srishti Dubey

Data Analyst & BI Developer

Target Stakeholders

Lafayette Group Inc (LGI) Election Security Resilience Staff

The primary users are LGI's internal team. Priorities for LGI's team include ease of use and navigation, consolidation of all team data into one place, and the ability to quickly generate different reports. Data includes:
- Metrics and details on all engagements, trainings, conferences, events, etc.
- Metrics on all products, resources, and guides developed for clients and stakeholders
- Publicly available data including key election dates, timelines, and processes

Our primary stakeholders are:

Internal Project Managers

External Consultants (who are SMEs)

Our Actions & Approach

Our team worked closely with Lafayette Group to develop an approach for building the dashboard or portal, taking into consideration the data sources provided by Lafayette Group.
We developed the dashboard and associated data visualization creation, testing, and refining the design until it meets the project requirements.
We devised a 2-step plan:
- Phase I - Planning & Setup
  - Gain domain knowledge - Learn more about US elections
  - Gather requirements - Stakeholder interviews
  - Transform data - Clean and wrangle data to make it appropriate for dashboards
- Phase II - Execution
  - Build dashboards - 4 PowerBI dashboards, designed for good usability
  - Gather feedback - Usability testing with stakeholders
  - Revise & finalize - Iterate based on feedback for final approval

Stakeholder Interview

Dataset Cleaning and Preparation:

Here are a few of the dashboards that we created:

Data that LGI is using:

Unpivoted Data after running the Python Script:

We Take Pride in the Impacts and Benefits that we bring to LGI

Reduced Time & Efforts

Our Dashboards reduced the time required to complete specific tasks from 30 minutes to less than a minute!

Data-driven Decision Making

Data -> Actionable Insights
Easier to understand trends over time

Better Client Services

LGI can communicate more effectively with clients and other stakeholders about Decision-Making

Gain Competitive Advantage

Analyze opportunities for improvement in engagements and gain insights into which products are doing well.

Home