Web-Based Hotel Market Database & Reporting Tool
Only freelancers located in the U.S. may apply.U.S. located freelancers only
I am looking for a developer to build a simple web-based database and reporting tool to replace an existing Microsoft Access database with a lot of history. The current database tracks monthly hotel market performance for 100+ hotels over approximately 10-15 years (3 data metrics for each hotel on a monthly basis). Currently, each hotel has a profile with fields such as: - Hotel name / ID - Submarket - Room count - Price point Each hotel submits monthly performance records, including: 1. Month / year 2. Rooms available 3. Rooms occupied 4. Room revenue The system calculates: - Occupancy (#3 / #4) - ADR (#4 / #3) - RevPAR (#4 / #2) - All of the above monthly and YTD ** I need a secure, web-based database built that allows me to: - Maintain hotel profiles - Add or edit monthly hotel performance data - Import monthly data from Excel or CSV - Run pre-formatted reports to include the full market, filtered by hotel characteristics, including submarket, price point, and hotel size - Export reports to Excel and/or PDF - Preserve historical data - Support future duplication for other markets Reports should summarize monthly, year-to-date, and historical performance for: - Total market - Selected submarkets - Selected price points - Selected hotel size categories This does not need to be a large SaaS platform. I am looking for a clean, practical web-based database with simple data entry, import, filtering, reporting, and export functionality. The first version should be simple and functional. More advanced features can be added later. Please respond if you have experience with: - Web-based database development - Microsoft Access database migration - SQL database design - Admin dashboards - CSV/Excel imports - Report generation - Basic data visualization - Secure/confidential data handling Please include examples of similar small database/reporting tools you have built. ** CURRENT REPORT/OUTPUT IS ATTACHED (lots of room for improvement)
$600.00
Fixed-price- IntermediateExperience Level
- Remote Job
- Ongoing projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Last viewed by client:last week
- Interviewing:1
- Invites sent:0
- Unanswered invites:0
About the client
- USAWinchester4:32 AM
- $150 total spent1 hire, 0 active
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by