CREATE DABASE AND REPORTS
€250-500 EUR
货到付款
Create a database (My SQL for example) based on multiple tables: the goal is to monitor the performances of hotels in Tripadvisor in different cities in the world, and generate very impactful reports.
The SQL database should be placed on an existing cloud server (AZURE MICORSOFT).
This particular project is the starting point. There will be additional developments and creations of additional tables.
Create a table called “HotelInfo”
This table is made of imported excel files, which are subsequent extractions from Tripadvisor for a particular city on a particular day (example : London Hotels on 2 Oct 2016 => [login to view URL]).
Import several data files in this table : on a regular basis, updated extractions will be generated and should be imported in this table.
Generate a report (xls) of all hotels ranked by position in Tripadvisor, calculate evolution in ranking between two pre-set dates (see model RANKING) of all hotels in a city, or of a certain category of hotels (Luxury, mid-range …) or of of a certain group of competing hotels
Generate the same reports but ranked by best evolution
Optimize the design of all reports : it should be very attractive
Create a table of readers of these reports. The table will define who receives which reports, when…
Send automatically these reports to an emailing list. The report should be downloadable through a link. It should be possible to check when the report has been downloaded and by whom.
项目ID: #12198453
关于项目
有18名威客正在参与此工作的竞标,均价€457/小时
If your data will not be very huge why not consolidate all data in an Excel workbook? (or an Access database?) It will be much easier to create nice reports. Lets discuss the possibilities. Thanks..
I am interested to do this project... Can start now.......................................Lets start
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y 更多
hi i believe you're looking for some data repository, where you can maintain all your hotels' performance data. Reports can be generated through the designed datawarehouse. I suggest to have a cloud-based MS databas 更多
Hi, I have great experience working with web and server technologies. I know Html, Js, Php, Python, Perl, Mysql , PostgreSQL . I have vast experience on Python and Javascript generator.. Thanks
Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you
Hi, Experienced VB.Net with SQL and MySQL Programmer. Expertise in critical programming, developing system for management and creating reports in crystal report. I have read your instructions carefully. I h 更多
hey - I've a lot of experience with this type of project. I work with Azure databases on a daily basis, have a huge amount of SQL, BI and ETL experience and I'm also proficient with writing analytical reports in line w 更多
Hi, I am new to this website but I work as a freelancer on another site and have experience in similar projects. Hope it will not be problem for you that I am new and I will get the chance. Hope to hear from you 更多