Dashboard on a website from imported excel sheet.

Job ID: 36150662

Budget: $250 – $750 USD

PROJECT MUST BE COMPLETED IN 48HOURS.
I need dashboards extracted from data in excel showing results in an election. The dashboard is expected to provide interesting graphs to display;

1. Total Votes scored by different Parties aggregated from the smallest unit (polling Unit) to Wards to LGA (Local Government Area) to States and to the country. Total Votes can be filtered by PU, LGA, Wards and States according to the parties.

2. The number of polling units, the number of LGA, the number of wards, the number of states, (depending on the filters chosen) where are a party scored 25% and above shall be counted and recorded to the party. So the X-axis shall be parties and Y-axis shall be number of (PU or LGA, Wards, States) depending on the selected filter of PU, LGA, Wards, States.

3. Card listing of the results from the states in the country shall be displayed according to the major parties selected displaying, Name of Party, Number of Votes, Percentage of Votes

4. Card listing of the Party votes from the LGAs of a selected state

5. Card listing of the Party Votes from the wards of a elected LGA.

6. Another displays that can be harvested from the excel data.

The excel sheet data shall be imported into the dashboard interface and then the dash board will display in response to filters of the State, LGA, Wards and Polling Unit. The country is divided into states and then states into wards and then wards into Polling Units where voting takes place. Voting and counting takes place only at the polling unit. The dashboard is intended to display aggregated votes from polling units to show different intelligent reports in a dashboard format
Related categories: PHP JavaScript MySQL Excel VB Capabilities Power BI