Đã hoàn thành

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.

Kĩ năng: Xử lí dữ liệu, Lập trình cơ sở dữ liệu, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 3 nhận xét ) Perth, Australia

ID dự án: #16994818

Được trao cho:

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 Thêm

$155 AUD trong 3 ngày
(0 Đánh Giá)
0.0

7 freelancer đang chào giá trung bình $141 cho công việc này

$155 AUD trong 3 ngày
(2 Nhận xét)
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 Thêm

$100 AUD trong 3 ngày
(2 Nhận xét)
2.2
$155 AUD trong 3 ngày
(0 Nhận xét)
0.0
$30 AUD trong 3 ngày
(0 Nhận xét)
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 Thêm

$155 AUD trong 3 ngày
(0 Nhận xét)
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 Thêm

$240 AUD trong 6 ngày
(0 Nhận xét)
0.0