
Combining multiple Excel datasets to create a master dataset
- or -
Post a project like this987
£350(approx. $484)
- Posted:
- Proposals: 33
- Remote
- #3918697
- OPPORTUNITY
- Awarded
Digital Solutions|Designer & Developer|Shopify|App Development|WordPress|Data Scraping|Lead Generation|Animation

WordPress Expert | Web & App Developer | SEO Specialist | Content Writer | Blockchain | Python | OpenAI | Machine Learning

Data Scraper| Data Collection| Data Entry| Web Research| Lead Generation | Product Listing
HR and Project Management Consultant, Forecaster, Proofreader, Image Solutioner
Python | Data Analyst | Pandas | Seaborn | Matplotlib | Web Scraping | Automation

755738438114783409867315100583416909239190552962286443647122586634423438734912792067
Description
Experience Level: Expert
We are an analyst company providing market intelligence and forecasts on the global Mobile messaging market (SMS messaging, WhatsApp, facebook messenger etc). Our forecast data includes multiple types of messaging traffic, and total global and country spend for each of those traffic types.
In our forecasts we split out our data by 200 countries. Then we split each individual country data out by mobile network operator (MNO) data. The number of mobile operators we include varies by country, but our data covers a total of 653 mobile operators across all 200 countries.
To the above major dataset, we now need to apply the following additional layers of granularity, to create a complete master dataset - on which we will base our next set of market forecasts. It is this task we are looking to outsource. We currently have the following as separate datasets:
- Market vertical data (19 types) applicable to all 200 markets/every Mobile Operator
- use cases (4 types) which will need to be applied to country data / plus country/MNO data, and also to all market vertical data in country + country/MNO.
- opt-in data for around 100 markets - to be applied to the above in 50% of markets.
In total, we estimate the scope of the finished master dataset would be around 6 million individual data points, once the relevant data is brought together.
Attached is a sample of the scope of data we provide for just one country. This is the output of our forecasts, and what we send to our end users. It will give an outline of the categories of data we work with.
We can give you more insight under NDA, if this is a project you would be interested in working on. We need someone who is extremely proficient in excel, and can demonstrate similar work completed to a high level of skill.
Timing: project to commence ASAP and be completed within 2 weeks (or sooner if possible).
In our forecasts we split out our data by 200 countries. Then we split each individual country data out by mobile network operator (MNO) data. The number of mobile operators we include varies by country, but our data covers a total of 653 mobile operators across all 200 countries.
To the above major dataset, we now need to apply the following additional layers of granularity, to create a complete master dataset - on which we will base our next set of market forecasts. It is this task we are looking to outsource. We currently have the following as separate datasets:
- Market vertical data (19 types) applicable to all 200 markets/every Mobile Operator
- use cases (4 types) which will need to be applied to country data / plus country/MNO data, and also to all market vertical data in country + country/MNO.
- opt-in data for around 100 markets - to be applied to the above in 50% of markets.
In total, we estimate the scope of the finished master dataset would be around 6 million individual data points, once the relevant data is brought together.
Attached is a sample of the scope of data we provide for just one country. This is the output of our forecasts, and what we send to our end users. It will give an outline of the categories of data we work with.
We can give you more insight under NDA, if this is a project you would be interested in working on. We need someone who is extremely proficient in excel, and can demonstrate similar work completed to a high level of skill.
Timing: project to commence ASAP and be completed within 2 weeks (or sooner if possible).
Jo L.
100% (7)Projects Completed
6
Freelancers worked with
6
Projects awarded
24%
Last project
15 Jun 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies