Betalt ved levering
The data received from Vivino wine rating IT department comprises three data files: [login to view URL],
[login to view URL] and Region.xml. The [login to view URL] file records the information of wine list across the
world which detailed information about their ratings is recorded in [login to view URL] and [login to view URL]
records the country of each wine region.
You are asked to:
1 Import all the data from the other files into the Excel file. Write Excel formulas to fill the last
three empty columns in the [login to view URL] file with appropriate information provided from the
2 Assess the data and correct it if necessary. You are also required to use Excel functions to
automate the correction.
3 Investigate the data distribution of wine price by drawing its histogram and boxplot and
providing your insight.
4 The company wants to collaborate with the favourite wineries to expand its market. To
support managers’ decision making, you are required to:
a) Propose a ranking with at least 2 criteria to rank the wineries for the company to
choose for their next collaboration. Provide your justification.
b) Create a pivot table to show the best five wineries based on your ranking. Provide a
filter to allow users to narrow the result to a specific country that they are
interested. Display the list of the wineries in the descending order of your proposed
criteria, i.e. the best one first. Design the pivot tables to make it comprehensive
(having meaningful titles, column headers, applying appropriate data format,
applying conditional formatting, etc.)
[login to view URL]
Projekt ID: #36676518
27 freelancere byder i gennemsnit ₹7722 timen for dette job
Hi! Pleased to meet you on this platform. I just read through the job details and I'm available for this project. Let's discuss more on chat about your requirements and budget. Warm Regards. Bc
I am an advanced excel user with over 12 years analytical experience in data analytics. From data normalisation, macros pivots and some VBA I will be able to provide the desired outcome rapidly
¡Hola! Leí su proyecto y me ha interesado. Buen manejo de Office, entrada de datos, analista qa, frontend, procesamiento de datos. Puedo comenzar de inmediato
Hlo sir/mam i am aditya i am here for your work and i have 2 year experience in this line and your work is my responsibility i do my work very honestly and if you give me this work so this is a big opportunity for me .
Hello, I am working in Amazon as catalog Associate for Poland and Netherlands. Expert In Excel feeds Expert In Handling Voluminous data. Expert In creating Automations and Macros.
I am a dedicated, organized and hardworking person. I have good interpersonal skills. I know very well excel and word and data entry work. I will give you the project perfectly and as soon as possible.