Đã 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, 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, run script count lines text file, crystal reports 2008 saving aspx file, run macro extract info files 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