Super UserState Assembly Elections Analysis
Report Highlights 📝:
🔷 Constituency wise data was imported from Election Commission of India and then appended all tables into single table.
🔷 District wise data was imported from Wikipedia.
🔷 Power Query used for cleaning and transforming data.
🔷 Star schema was used to create relationship between the tables.
🔷 Created custom and quick measures for key metrics and requirements.
🔷 Created different kind visuals for various types of data, such as bar chart, pie chart, and matrix visuals.
🔷 Used page navigation, sync slicers and filters to create best user experience.
📊 📈 Insights:
🔷 Glance tab/page provided to understand the entire election numbers.
🔷 Using filters on home tab/page to get constituency wise and district wise details.
🔷 Party wise vote share of top 10 parties and constituencies/seats won are given.