Power BI Dashboard for General Election 2024 (KPK Province)

Project Overview

Duration: December 2023 - February 2024

Sponsors: Government of Pakistan, Provincial Government of Khyber Pakhtunkhwa (KPK), and various Law Enforcement Agencies.

This pivotal project aimed to provide a comprehensive, real-time analytical and operational view of the General Election 2024 across the Khyber Pakhtunkhwa province. The primary goal was to enhance decision-making for government officials and law enforcement by offering immediate insights into election progress, security situations, and overall results.

The dashboard facilitated:

• A holistic view of the general election dynamics in KPK.
• Detailed overview and distribution of polling stations.
• In-depth analysis of national and provincial constituencies.
• Real-time election progress tracking and result predictions.
• Granular details for each national and provincial seat.
• A security incident and rapid response system for Law Enforcement Agencies.
• Timely reporting of electoral incidents and efficient dissemination to all stakeholders.

Technologies and Tools Used

• Business Intelligence & Visualization: Microsoft Power BI
• Database: MySQL (backend for real-time vote entry application)
• Data Processing: ETL Processes (Extract, Transform, Load)
• Front-end Application: Developed by K2X Tech Company, Peshawar (for real-time vote entry)
• Data Integration: GeoJSON for mapping

Dashboard Pages Overview

The Power BI dashboard comprised four main interactive pages, each designed to serve specific analytical and operational needs:

1. Polling Stations Dashboard

This page provided a granular view of all polling stations based on their security sensitivity: Normal, Sensitive, Most Sensitive, and Selected Most Sensitive.

• Categorization: Polling stations were systematically grouped by Divisions, Districts, down to National Assembly (NA) and Provincial Khyber (PK) constituencies.
• Geospatial Analysis: All polling stations were geotagged and displayed on a GeoJSON-based map of Khyber Pakhtunkhwa. Users could interact with the map to:
  • Pinpoint the exact location of any polling station.
  • Identify its belonging NA or PK constituency.
  • Determine its security category.
  • View its district and division.
  • Access the area profile, including potential threat assessments.

2. Constituencies Dashboard

Designed to provide insights into electoral divisions and voter demographics.

• Constituency Mapping: A mind map visually depicted which PK constituencies fell under each NA constituency.
• Population & Voter Profile: The right side of the page featured a map showcasing population and voter distribution.
• Key Performance Indicators (KPIs): At the bottom, key metrics were displayed:
  • Number of voters (Male and Female breakdown).
  • Total NA and PK seats in KPK.
  • Overall population of KPK.
• Interactive Filtering: The dashboard offered robust bi-directional filtering capabilities. Clicking on any district on the map would filter all data on the page (including the mind map and KPIs) to that specific district. Similarly, selecting any NA or PK constituency would filter and highlight its respective district on the map.

3. Election Progress (Real-time) Dashboard

This dynamic page displayed election results in real time, with vote counts being continuously updated via a front-end application connected to a MySQL database.

• Candidate Tracking: Showed leading and runner-up candidates for user-selected NA or PK constituencies, along with their party affiliations.
• Party Domination Map: A KPK map highlighted which political party was dominating specific divisions or districts, enabling predictions of election outcomes and potential internal security situations arising from electoral violence. This helped stakeholders assess which parties could be involved in or affected by any disturbances.
• Overall Party Ranking: A chart at the bottom ranked political parties based on the number of NA or PK seats they were currently leading on.

4. Election Overall Results Dashboard

This page was specifically developed by K2X Tech Company in Peshawar to provide a holistic and final view of the election results, utilizing various Power BI visuals.

• Filtering: Users could select NA or PK buttons at the top right to filter the results displayed on the page.
• Winning Party Analysis: The page prominently displayed the winning political parties based on the total number of seats they had secured or were leading on.

Additional Granular Details (Future Enhancements/Comprehensive Data Points)

While the dashboard was extensive, a vast amount of granular detail was collected and could be integrated for even deeper analysis and operational support. This included:

• Comprehensive details of all contesting candidates, including their names, party affiliations, and the NA or PK constituencies they were contesting from.
• Integration of political party symbols for easier visual identification.
• A dedicated "Security Page" designed for law enforcement, featuring:
  • Deployment details of Police and paramilitary forces.
  • Names and contact details of staff at each police station.
  • Contact numbers for officers in charge.
  • District management contact numbers.
  • All linked together to assist in swift response to any terrorist attacks or electoral violence.

Collaboration Credit

The front-end application used for real-time vote entry and the "Election Overall Results" dashboard page were expertly developed by K2X Tech Company, Peshawar. This project was a successful joint venture, leveraging their technical prowess for data capture and comprehensive result visualization.

Demo of the Dashboard

I have demo appl available for each page of this dashboard, which can be provided upon request to showcase the visual design and functionality.