1. using a dataset on cab travel - try to determine as many facts about it as possible: check what the dataset contains
the dataset, evaluate the quality of this data, and draw information and conclusions from this data.
2. using access to the dataset in Google Bigquery on airplane flights
conduct an analogous analysis as in task 1, but this time, in addition to the results and
conclusions, include your SQL queries in the solution.
https://bigquery.cloud.google.com/table/bigquery-samples:airline_ontime_data.flights
3. using SQL, add an additional column to this table with the previous qty number for the
previous order of a given customer.
4. what is the problem in the following SQL query?
SELECT customer_id,
AVG(revenue)
FROM x
WHERE AVG(revenue) > 75
GROUP BY customer_id
Simple and quick tasks for the analyst. time - until the end of Saturday (02.07)
Adding products on Subiekt GT - Prestashop - Allegro - Ceneo
Regular order
We need to make a database for 55000 products
I need a quote for 100 products - when divided into stages let's assume 10x100 products in the first throw.
Allegro auctions creation from csv file. Auctions will be created by Easy Uploader program. Everything is described here-> https://www.easyuploader.pl/forum/viewtopic.php?t=654
Simple simple auction with photo and parameters.
We ask for estimate for adding 10 auctions.
We are looking for a person to prepare a B2B database for us according to the following criteria:
Segment:
- construction
- transport
Decision makers:
- owner
- president
Company size:
- SME companies i.e. small and medium sized companies
Update of the database:
- the database to be prepared at the time of acceptance of the order. We do not want databases created several years ago.
Required data:
Company name
Website
First name Surname
Position
Email
Phone
Industry
Tax Identification Number (if available)
The assignment is to create a tool to measure cashflow in a company.
You need to collect all data in one place.
Fixed costs
Variable costs
Costs resulting from defects.
In addition, we need to improve the functionality of the current Excel, which counts the consumption of utilities in properties. The main problem is the change of the meter and the lack of continuity in the consumption of utilities, and the proper representation of overpayments for utilities.
The idea is to build a framework that can be expanded.
I would like to do some research on job boards such as nofluffjobs and compare their features, price lists and functionality. Experience in similar projects or HR industry is welcome.
Please provide a price for 10 hours of research and a description of your experience in the offer
Three bases from the British market are needed immediately
1. the company operating the trade show
Customer type: Small and medium enterprises
Location of companies in the database: United Kingdom
Customer industry:
*wedding industry
*startups
*IT/new technologies
* gyms and fitness clubs (modern in big cities)
2. law firm
Client type: Small and medium enterprises
Location of companies in the database: United Kingdom
Industry Clients:
*investment funds: angel investors and venture capital (not listed)
*investor groups
* startup networking groups
*IT/software houses
*coowrking spaces
*developer training schools
*HR firms that specialize in recruiting IT workers
3. maintenance and space arrangement company
Client type: Small and medium enterprises
Location of companies in the database: United Kingdom
Customer industry:
*silver fitness clubs (not chain clubs in major cities)
Hello,
I have a ready-made excel file with a list of companies and I need a person who will filter this database according to the guidelines and create a target document.
Please give me an estimated offer for such a database. The final document will contain 50 records. Each record has 74 columns.
This website uses cookies to provide everything you need. You give us a chance to offer a better service by using the site without changing any setting in your browser.
More information