"Bantuan Kasih Johor" Dashboard Development
Budget: $30 – $250 USD
Project Title:
Development of Online Dashboard for "Bantuan Kasih Johor" (270K+ Records, Role-Based Access)
Project Description:
I am looking for an experienced developer to build an online dashboard system (Power BI / Web App / other suitable solution) using my existing Excel dataset.
The system must be scalable, user-friendly, and easily maintainable, as the dataset currently contains 270,000+ records and will continue to grow over time.
Core Requirements:
1. Data Source
Existing data in Excel (270K+ records)
Preferably connected to:
Google Sheets (Google Drive) OR
Cloud database (recommended for performance)
Admin must be able to:
Add new data
Edit existing records
Delete data if needed
Upload new Excel files (additional data) and merge into existing dataset
Auto-update reflected in dashboard (real-time or near real-time)
2. User Roles (Login System Required)
A. ADMIN USER (Multiple Accounts)
Full access to all data
Manage users (create/delete DUN users)
Edit/add/delete recipient data
B. DUN USER (Multiple Accounts)
Restricted access
Can ONLY view data for their assigned DUN
3. Dashboard Features
ADMIN Dashboard (Main Page)
Total number of recipients (overall)
Total recipients by Jenis Bantuan (Aid Category)
Total recipients by DUN
DUN Dashboard (Main Page)
Total recipients within their DUN
Total recipients by Jenis Bantuan (within their DUN only)
4. Interactive Features
Click on Jenis Bantuan → display full list of recipients under that category
Click on DUN → display full list of recipients under that DUN
Each record should display relevant details (name, address, phone, etc. including additional fields if needed)
5. UI/UX Requirement
Clean, modern, and professional dashboard design
Easy navigation
Mobile-friendly is a bonus
6. Performance Requirement
Must handle large dataset (270K+ rows) efficiently
Fast loading and filtering
Scalable for future expansion
7. Urgency
This project is URGENT.
Please include in your proposal:
Suggested solution/tech stack (Power BI, Web App, etc.)
Timeline to complete (preferably within 24–72 hours if possible)
Total cost for full system delivery
Bonus (Optional but Preferred):
Experience with large datasets
Previous dashboard or analytics projects
Suggestions for best architecture (performance + cost efficiency)
Development of Online Dashboard for "Bantuan Kasih Johor" (270K+ Records, Role-Based Access)
Project Description:
I am looking for an experienced developer to build an online dashboard system (Power BI / Web App / other suitable solution) using my existing Excel dataset.
The system must be scalable, user-friendly, and easily maintainable, as the dataset currently contains 270,000+ records and will continue to grow over time.
Core Requirements:
1. Data Source
Existing data in Excel (270K+ records)
Preferably connected to:
Google Sheets (Google Drive) OR
Cloud database (recommended for performance)
Admin must be able to:
Add new data
Edit existing records
Delete data if needed
Upload new Excel files (additional data) and merge into existing dataset
Auto-update reflected in dashboard (real-time or near real-time)
2. User Roles (Login System Required)
A. ADMIN USER (Multiple Accounts)
Full access to all data
Manage users (create/delete DUN users)
Edit/add/delete recipient data
B. DUN USER (Multiple Accounts)
Restricted access
Can ONLY view data for their assigned DUN
3. Dashboard Features
ADMIN Dashboard (Main Page)
Total number of recipients (overall)
Total recipients by Jenis Bantuan (Aid Category)
Total recipients by DUN
DUN Dashboard (Main Page)
Total recipients within their DUN
Total recipients by Jenis Bantuan (within their DUN only)
4. Interactive Features
Click on Jenis Bantuan → display full list of recipients under that category
Click on DUN → display full list of recipients under that DUN
Each record should display relevant details (name, address, phone, etc. including additional fields if needed)
5. UI/UX Requirement
Clean, modern, and professional dashboard design
Easy navigation
Mobile-friendly is a bonus
6. Performance Requirement
Must handle large dataset (270K+ rows) efficiently
Fast loading and filtering
Scalable for future expansion
7. Urgency
This project is URGENT.
Please include in your proposal:
Suggested solution/tech stack (Power BI, Web App, etc.)
Timeline to complete (preferably within 24–72 hours if possible)
Total cost for full system delivery
Bonus (Optional but Preferred):
Experience with large datasets
Previous dashboard or analytics projects
Suggestions for best architecture (performance + cost efficiency)