In Progress

Build Database Architecture and Write Complex MySQL Queries

I want to basically make an app that takes most of the following data and stores it in a database that can then be assembled on queries similar to what you wrote so that it can be analyzed for trends. The purpose of the software is to provide a high-level statistical overview of a user's online sales and transactions. The software enables a user's site to accept webhook POST requests and record them to a local database.

Once the data is recorded, the software will present the data in such a way that it "answers questions" that are posed in the user interface. Here is a general overview of the types of questions that I, as the seller, think should be answered by analyzing the dataset.

- How much money did I make today/this week/month/year? How does this compare (numbers or percentage-wise) to a week ago today/last week/month/year?

- Which of my products are selling the best? How many of each did I sell today/this week/month/year?

- How's my soccer ball product selling? How many soccer balls have I sold today/this week/month/year? Which is the most popular variation - large or small? How much money has the soccer ball made me?

- Which countries am I selling the most in? Which products are most popular in each country? What areas of a particular country am I selling the most in? How much money have I earned from transactions in the UK this week?

- How have my sales been affected by the Site Maintenance event? Could this explain why sales were down last Friday?

- How many refunds have I had to process? How much have I had to spend on shipping these products? How does this affect the amount of money I've made over the past month?

These are just examples. I'll expect you to be opinionated and know how the database should best be structured without getting too out of control and focusing only on the parts that are relevant to making assumptions about product, location, and date/timing trends. Prove to me that you are able to answer these types of questions. I have a start on some of the queries that I can share as a base, but you'll need to write most of the queries and present to me the dataset so that I can use it to populate my templates.

Here is an example of the request data available to be recorded to the database: [url removed, login to view]

A full list of variables can be found at [url removed, login to view]

Note: we will not capture any data from the transaction that can personally identify the customer. (do not capture the customer's name, email address)

I did my best to describe what it is that I am looking for, but I may not be completely on point with the best technical solution to this project. I'm leaving that up to you, because you're smarter than I am and can take the reigns and make decisions for the best software architecture and user experience.

You should feel comfortable and have experience with the problems of performance, EAV and architecture, how to write efficient queries, and how to organize the results into comprehensive datasets. I have taken time to write this post, so to be sure that you've read and understand the requirements and are willing to take it on, please do not leave a generic message simply saying this will get done. Make me feel confident that you understand what I'm trying to achieve and try to provide evidence of being capable of my project, perhaps by sharing a past experience that you may have had with a similar project. This will only help us both work best together and give you a better chance at getting the job.

Skills: Database Administration, MySQL, PHP, Software Architecture, SQL

See more: write up templates, write online content for money, write for money online uk, write content uk, write and get money, write about soccer, why do you want to work in sales, why do you want to work here answers, why do you want to work here answer, why do you want to work for us answer, why do you want this job answer, what to write on my overview, what is my paypal address answers, what does php developer's do, uk email database, uk email address database, sql get date, sql developer online, sql developer job online, software developer overview, software developer make money, software developer looking for sales, software developer job uk, software architecture job, prove it questions answers

About the Employer:
( 2 reviews ) Chicago, United States

Project ID: #4849371

19 freelancers are bidding on average $31/hour for this job

krishdts

Hello ,we have gone through your project named Build Database Architecture and Write Complex MySQL Queries and we like to convey that we have already done similar kind of projects before also. We can address any concer More

$25 USD / hour
(82 Reviews)
8.3
SovDyn

Hello, I have extensive experience in the technologies you listed including more then 50 projects done on this site and some direct hire projects. I am happy to help you building this. Please see PMB for details. Than More

$32 USD / hour
(51 Reviews)
7.7
pan09

Please check message board

$26 USD / hour
(206 Reviews)
7.6
leomedina01

I'm very experienced in writing complex MySQL queries, or even stored procedures and triggers. This also includes get the best queries performance by adding needed indices to the tables, In fact I have worked with als More

$26 USD / hour
(91 Reviews)
6.4
ielkfarna

Database Professional Freelancer.

$39 USD / hour
(58 Reviews)
6.3
Ajcm623

hello i have gone through your requirement CAN WE DISCUSS IN FURTHER DETAIL?? thank you

$38 USD / hour
(48 Reviews)
6.2
aparajayahtech

Hi, We're ready to start the work. Kindly check your PMB for more information.

$27 USD / hour
(6 Reviews)
6.1
phpdeveloper100

We are ready to start the project please check PMB.

$26 USD / hour
(34 Reviews)
6.0
techvolcano

We can do this.

$25 USD / hour
(112 Reviews)
6.0
evaxsoftvw

Hi, i made similar things before, my last large project was about handling publisher database, make lot of report about sales/distribution, statistics on products/customers etc. So i think i know what you want, please More

$25 USD / hour
(21 Reviews)
5.6
elboukharimu

I can help you please check your Inbox.

$42 USD / hour
(42 Reviews)
5.6
AliSafder

Hi, I can work on this project for you. Please review my expertise in private message.

$25 USD / hour
(4 Reviews)
2.3
naoufalzeroual

Hello, I have 7 years experience in web development and administration of database (PHP, MYSQL, ORACLE, AJAX, JQUERY, JQUERY MOBILE), I can bring beaucup help, thank you contact me

$25 USD / hour
(2 Reviews)
1.5
bhadresh22

It'll be pleasure to work with you. Allow me to do this task for you. Thanks

$25 USD / hour
(2 Reviews)
0.0
sc0101

Hi. I recently designed a project for a furniture company that is very similar to this one. If you want, I can show you an example of it. If you like it, you can hire me. If not, I understand.

$38 USD / hour
(0 Reviews)
0.0
force10idea

What makes me to bid this project? Sanjiv Verma, MBA from Educatis University Switzerland & ex-SEARS (3rd largest US retailer) with 15 years of global experience in technology implementation has been helping FORTUNE 5 More

$41 USD / hour
(0 Reviews)
0.0
nojnish

please refer PMB for details

$25 USD / hour
(0 Reviews)
0.0
avlasceanu

The solutions for your project are in your PMB :) Regards, Alexandra.

$33 USD / hour
(0 Reviews)
0.0
rusben

Hello mr. davekiss, This is what I understood, please tell me if I'm wrong. If I understood well you already have a website, which is producing the structured data you link to [http://pastebin.com/VpiYEmRd - Pay More

$36 USD / hour
(1 Review)
0.0
brijesh1012

Hi , I had understood your requirements clearly.Please check your PMB (Private mail box) for the details.

$30 USD / hour
(0 Reviews)
0.0