Create a Database and Queries for Filtering Its Data
- or -
Post a project like this2502
$$
- Posted:
- Proposals: 21
- Remote
- #1568586
- Awarded
UK Based SharePoint / O365 development / migration to O365 from SharePoint or File Shares
Long Eaton
Expert Mobile and web - AngularJS, C#.NET, XAMARIN, PHONEGAP, React, VSTO, ASP.NET, WPF, MVC, VB.NET, HTML, jQuery, CSS, Winforms
City of London
3549552200149043942705637552813882412329611089873851
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
General information for the business: Understanding market demand for an automotive product based on cars/bikes registered on the road
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: The actual Database software does not matter to me, so long as I can purchase a licence for it at a reasonable cost - I'm just using a laptop. There is at least 1Gb of data I have (large CSV file) from the website below that lists every car currently registered on the roads in NZ and many details about each one. The database is to be single user access, and I don't need any fancy GUI front end, just a way of getting the raw numbers out of it.
https://www.nzta.govt.nz/resources/new-zealand-motor-vehicle-register-statistics/new-zealand-vehicle-fleet-open-data-sets/
My primary interest is to be able to get histogram style statistics out of it such as:
Number of cars manufactured between 1850 and 1950 on the road? Between 1951-1960? Between 1961-1970?
How many high performance cars (I can provide a list of brands) are on the road? Where are they all located?
How many Ferrari's are on the road? Where are they all located? What is the most popular model type? Engine size?
I'm trying to use these kinds of statistics to estimate demand for some automotive products that are targeted at the classic and high performance road car market. If I know how many cars in total (total market size) what brands of cars and where in the country they are located, I can focus my sales efforts. A full breakdown of required query information can be provided.
Extra notes:
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: The actual Database software does not matter to me, so long as I can purchase a licence for it at a reasonable cost - I'm just using a laptop. There is at least 1Gb of data I have (large CSV file) from the website below that lists every car currently registered on the roads in NZ and many details about each one. The database is to be single user access, and I don't need any fancy GUI front end, just a way of getting the raw numbers out of it.
https://www.nzta.govt.nz/resources/new-zealand-motor-vehicle-register-statistics/new-zealand-vehicle-fleet-open-data-sets/
My primary interest is to be able to get histogram style statistics out of it such as:
Number of cars manufactured between 1850 and 1950 on the road? Between 1951-1960? Between 1961-1970?
How many high performance cars (I can provide a list of brands) are on the road? Where are they all located?
How many Ferrari's are on the road? Where are they all located? What is the most popular model type? Engine size?
I'm trying to use these kinds of statistics to estimate demand for some automotive products that are targeted at the classic and high performance road car market. If I know how many cars in total (total market size) what brands of cars and where in the country they are located, I can focus my sales efforts. A full breakdown of required query information can be provided.
Extra notes:
Mark M.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
75%
Last project
9 Mar 2020
New Zealand
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can you please say what type of queries you require that can not be done by loading the data into an excel spreadsheet and using a data filter.
-
Can you please let me know how rigid is your less than 1 week deadline? Depending upon the number/kind of queries that need to be developed, it may take more time for an individual developer like me and hence the question. Thanks.
415689415630
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