Skip to content

Microsoft Power Bi is known as one of the most powerful data visualization and modeling tools available in the data industry,using which I have analyzed the Lok sabha Election Results-2024 and created an insightful dashboard. This process involved several stages including data preprocessing, data cleaning, and data visualization.

Notifications You must be signed in to change notification settings

codewithsanaa/Loksabha_Elections_Result_Analysis_2024

Repository files navigation

Loksabha_Elections_Result_Analysis_2024(Interactive dashboard creation using Power BI)

Project Objective

The Party members of Election Commission wants to create an lok-sabha elections result of 2024.So that the Party members will analyse and improve their statergy for the upcoming elections in next 5 years.

Insights

1. Overall Election Results Overview:

  • Created a pie chart showing the distribution of seats among the leading parties.

2. Geographical Vote Distribution:

  • Used a map visualization to display the geographical distribution of leading parties across states, using latitude and longitude for accuracy.

3. Top Constituencies by Margin:

  • Developed a bar chart highlighting the top 10 constituencies with the highest winning margins.

4. Close Contests Analysis:

  • Created a line chart to show the constituencies with the narrowest winning margins, focusing on the competitive nature of the elections.

5. Leading vs. Trailing Candidates:

  • Presented a scatter plot comparing the winning margins of leading and trailing candidates across different constituencies.

6. State-wise Winning Party Analysis:

  • Designed a stacked bar chart to show the number of seats won by each party in different states.

7. Detailed Constituency Analysis:

  • Used a table visualization to list all constituencies along with their leading and trailing candidates, parties, and winning margins.

8. Map of Election Results:

  • Created a filled map that visually represents which party won in each constituency using color coding.

9. Regional Leading Candidates:

  • Showed a bubble map with bubbles sized according to the winning margin, overlaid on the geographical map of constituencies.

10. Margin Distribution:

- Used a histogram to display the distribution of winning margins across all constituencies.

11. Top Parties by State:

- Created a heat map to show which parties are most dominant in different states.

12. Leading Candidate Analysis:

- Developed a bar chart showing the number of constituencies won by the top 5 leading candidates.

13. Trailing Party Performance:

- Used a line graph to show the performance of trailing parties in terms of margin lost in each state.

14. Constituency Performance Comparison:

- Designed a dual-axis chart comparing the leading and trailing candidates' vote margins in key constituencies.

15. State-Wise Detailed Results:

- Develop a drill-down report that allows users to click on a state and see detailed election results for all constituencies within that state.

Final Result

Dashboard interaction

View dashboard

About

Microsoft Power Bi is known as one of the most powerful data visualization and modeling tools available in the data industry,using which I have analyzed the Lok sabha Election Results-2024 and created an insightful dashboard. This process involved several stages including data preprocessing, data cleaning, and data visualization.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published