Build a sales history database

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

Objective:

Utilize our CRM field history to recreate sales history for each year. Showing year to date year over year where necessary

Why?

Users need to be able to select the period of time they want to see sales figures. So we can see how we are doing year to date

How?

Queries need to be created in our SQL. I will supply an anonymised data set in CSV which can be imported into your platform to create the proof of Concept. There are circa 20 tracked fields which help generate our figures. They will need a

Skills?

Very comfortable designing and building SQL database structures and complex dependent queries referencing multiple tables, variables and parameters

Deliverables?

Working SQL queries and database structure so I can replicate this in our SQL platform

NOTE: Complex SQL query experience essential

Database Administration Database Development Excel MySQL SQL

Project ID: #13483928

About the project

5 proposals Remote project Active 7 years ago

Awarded to:

harrisoneggers

Hello, One of my most recent projects involved creating SQL queries for a manufacturing facility to track their year-to-date performance on various datasets (machine uptime, products delivered vs delivery goals, etc More

£200 GBP in 7 days
(3 Reviews)
4.0

5 freelancers are bidding on average £219 for this job

WaheedGondal1

Hello, Hope you are fine. I have read the job description, I am willing to work with you as per your requirements. I have already done similar work and get great feedback. Please open chat with me so we can dis More

£220 GBP in 7 days
(3 Reviews)
4.2