🗳️ Indian Election Analysis - Power BI Project

This repository contains an interactive Power BI dashboard project analyzing the Indian Election results.
It provides insights into national, state, and constituency-level performance of political parties and alliances using clean data modeling and DAX measures.

---

📌 Project Overview

The Indian Election Analysis Dashboard enables stakeholders, researchers, and citizens to explore election results across multiple levels:

• 🟢 National overview of NDA, INDIA, and Others performance
• 🗺️ State-level political landscape and demographics
• 🏛️ Constituency-level drill-downs for candidates and parties
• 📊 Vote share, seat distribution, and winning margins
• 🔎 Detailed tabular data for validation and reporting

---

🖥️ Dashboards Included

1. Landing Page

Acts as the entry point of the project with navigation to all dashboards and a professional introduction.

---

2. Overview Analysis

Provides a high-level summary of the elections:

• Alliance-wise seat distribution (NDA, INDIA, Others)
• National vote share
• KPIs for overall results

---

3. State Demographic Analysis

Shows state-level demographics and trends:

• Voter distribution by state
• Regional population patterns
• Demographics linked with results

---

4. Political Landscape by State

Highlights the state-wise political distribution:

• Party and alliance dominance
• Seat comparisons across states
• Regional performance breakdown

---

5. Constituency Analysis

Provides granular analysis at constituency level:

• Candidate performance
• Winning vote margins
• Drill-down by party, alliance, and region

---

6. Details Grid

A tabular view of the dataset:

• Constituency, party, alliance, and candidate details
• Cleaned and structured election dataset
• Useful for detailed reporting and verification

---

🗂️ Data Model

The project uses a relational data model connecting the following tables:

• constituencywise_details
• constituencywise_results
• partywise_results
• states
• statewise_results

Relationships

• constituencywise_results → constituencywise_details (Constituency ID)
• constituencywise_results → partywise_results (Party ID)
• statewise_results → states (State ID)
• constituencywise_results → statewise_results (Parliament Constituency)

---

⭐ How to Access

1. Open the .pbix file in Power BI Desktop.
2. Ensure all datasets are loaded correctly.
3. Use filters and slicers to interact with the dashboards.
4. Navigate through dashboards using the Landing Page

---

🧑‍💻 Author

• Aanshi Gupta
• 📧 aanshi.gupta2004@gmail.com