Completed

Run Reports from Cafe POS pgdump file

I have a 160mb backup file (.pgdump) from our point of sale system. I want to only review the last 12 months of data.

I need the following reports drawn from it, broken by category (e.g. All-day menu, Hot drinks, Cold drinks);

Average quantity of sales by day, e.g. Monday-Sunday

Average quantity of sales by day, e.g. Monday-Sunday, but then broken into 1 hour time brackets.

Average quantity of sales by day, e.g. Monday-Sunday, by month, but then broken into 1 hour time brackets.

Average total $ of sales by day, e.g. Monday-Sunday

Average total $ of sales by day, e.g. Monday-Sunday, by month.

The output to be in an excel table, each report on a different sheet.

Skills: Data Processing, Database Programming, SQL

See more: position data entry run reports, run reports osticket, quickbooks script run reports, pg_restore table, pg_dump sequences, pg_dump fc, pg_dump table example, pg_dump gzip, pg_dump examples, pg_dump table structure only, pg_dump select query, ezpower pos ezp file, source code cafe pos, cafe pos, android cafe pos, cafe pos system, pos auto file, export reports floreant pos, run script computers listed csv file, program reports number times word file

About the Employer:
( 3 reviews ) Perth, Australia

Project ID: #16994818

Awarded to:

minorsamwah

Hi, I have over one year experience in data mining using SQL, data processing, analysis and presentation using excel and power BI. I have a background in Economics and Statistics. I am a fan of using TOAD an SQL so More

$155 AUD in 3 days
(0 Reviews)
0.0

7 freelancers are bidding on average $141 for this job

$155 AUD in 3 days
(2 Reviews)
3.1
Salesj23

hi there I am a scraping expert and I have dealt with sorting information like the one you require in this project I have dealt with spreadsheet with vba code and I can deliver within less than 4 days hope we commun More

$100 AUD in 3 days
(2 Reviews)
2.2
$155 AUD in 3 days
(0 Reviews)
0.0
$30 AUD in 3 days
(0 Reviews)
0.0
keanyitooi

Hello there. Thank you for your time to view my proposal. I have gone through your job posting and I am very much interested in the job with the requirements you have set. I believe I have the right set of skills More

$155 AUD in 3 days
(0 Reviews)
0.0
daveroden

NOTE: If awarded this project, I would write an Excel macro that could be rerun at any time on an updated input file to get the latest figures. I could also allow users to select an effective date to run on. This would More

$240 AUD in 6 days
(0 Reviews)
0.0