CREATE DABASE AND REPORTS

ปิด

คำอธิบาย

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 => [url removed, login to view]).

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.

ทักษะ: Excel, Microsoft SQL Server

ดูเพิ่มเติม: create world map flash, world cities neighborhoods list, generate crystal reports business objects mind cti, need create website cities, create world warcraft web, create world vbnet, major world cities log lats, world cities coordinates, access generate multiple reports, create world warcraft logo, create world warcraft guild website, create module will generate report, coordinates world cities, finding world cities using coordinates, generate pdf reports online

หมายเลขโปรเจค: #12198453

มอบให้กับ:

sargardon

Hello sir/madam, Thank you for invitation. However, I am new here in freelancer.com I have over 10 years of experience in .Net development. I have developed many applications that work with database and I will be h เพิ่มเติม

€400 EUR ใน 10 วัน
(63 บทวิจารณ์)
5.8

freelancer จำนวน 21 คน กำลังประมูลอยู่ที่ราคาเฉลี่ย €465 สำหรับงานนี้

someka

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..

€588 EUR ใน 7 วัน
(120 บทวิจารณ์)
6.8
bd100m

I am interested to do this project... Can start now.......................................Lets start

€529 EUR ใน 10 วัน
(78 บทวิจารณ์)
6.2
tawakalgeek

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 เพิ่มเติม

€250 EUR ใน 10 วัน
(26 บทวิจารณ์)
6.0
€250 EUR ใน 10 วัน
(61 บทวิจารณ์)
5.8
redouaneaberdin

Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

€450 EUR ใน 10 วัน
(99 บทวิจารณ์)
5.9
MohsanEijaz

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 เพิ่มเติม

€294 EUR ใน 10 วัน
(36 บทวิจารณ์)
4.9
fuentro

A proposal has not yet been provided

€588 EUR ใน 10 วัน
(8 บทวิจารณ์)
5.0
fatimatuzzohura

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

€511 EUR ใน 10 วัน
(63 บทวิจารณ์)
5.3
johnosullivan

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 เพิ่มเติม

€529 EUR ใน 10 วัน
(16 บทวิจารณ์)
4.5
nikmah344

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 7+ years of experience in Web Development. I have worked on below technologie เพิ่มเติม

€411 EUR ใน 10 วัน
(23 บทวิจารณ์)
4.5
bspanovic

Hello You can look and test one of mine application's on this link: http://fellowship-demo.ilri.org/Default Log on as user "CapDev_Officier_test" , paswword is "Password" I'm Microsoft Certified Database Develo เพิ่มเติม

€449 EUR ใน 10 วัน
(10 บทวิจารณ์)
4.9
mdkass

Hello, My solution is totally online, consists of 3 parts (Microsoft Azure db+Google Web app+Google Sheets) Part 1: I'll create the Azure db, with Hotels Info, and this can be sent from Excel or from a Google sheet. เพิ่มเติม

€450 EUR ใน 10 วัน
(11 บทวิจารณ์)
4.0
vsprybhanu

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 เพิ่มเติม

€300 EUR ใน 10 วัน
(31 บทวิจารณ์)
4.2
jssinfosys

I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have extens เพิ่มเติม

€400 EUR ใน 10 วัน
(9 บทวิจารณ์)
3.8
€555 EUR ใน 10 วัน
(4 บทวิจารณ์)
2.8
christopher1215

Hi, sir/madam. I can design and develop the database and make the report for you. We may discuss the details over the chat. Please contact me. Thank you.

€444 EUR ใน 10 วัน
(1 บทวิจารณ์)
2.6
alliedbandna

Dear Sir, Your have recently advertised for website developer . After reading the job description I am confident that I would be a perfect fit for this position as my experience and abilities precisely match your requ เพิ่มเติม

€555 EUR ใน 10 วัน
(0 บทวิจารณ์)
0.0
€555 EUR ใน 10 วัน
(0 บทวิจารณ์)
0.0
khp31

Sr. Software Developer having 7+years experience. Sr. Software Developer having 7+years experience. Sr. Software Developer having 7+years experience. Technology : Windows Application Web Application Mobile App เพิ่มเติม

€555 EUR ใน 30 วัน
(0 บทวิจารณ์)
0.0
khrystynabasali

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 เพิ่มเติม

€555 EUR ใน 10 วัน
(0 บทวิจารณ์)
0.0