Find Jobs
Hire Freelancers

Run Reports from Cafe POS pgdump file

$30-250 AUD

Tamamlandı
İlan edilme: neredeyse 6 yıl önce

$30-250 AUD

Teslimde ödenir
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.
Proje No: 16994818

Proje hakkında

6 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 6 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
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 software, so I will use it to pull the saved data by defining the required parameters and later transferring the required results where I will do an in-depth manipulation and presentation. Am looking forward to hear from you and work together on this project.
$155 AUD 3 gün içinde
4,9 (6 değerlendirme)
3,9
3,9
6 freelancer bu proje için ortalama $139 AUD teklif veriyor
Kullanıcı Avatarı
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 communicate
$100 AUD 3 gün içinde
5,0 (4 değerlendirme)
3,1
3,1
Kullanıcı Avatarı
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 to complete the job. Other than that, my experience in SQL is an added advantage. If you wish to know more, feel free to visit my profile and contact me on Freelancer. I look forward to working with you. Thank you and have a nice day! Best regards, Keanyit
$155 AUD 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 allow you to create reports that analyse the preceding 12 months ending in previous months. I am a computer programmer who has specialised in data processing. I am a master with Microsoft Excel (data entry, formulas, formatting, conditional formatting, etc.) and with VBA programming (simple macros and complex programs) to process and format data imported or exported to/from files or directories of files in many different formats (Office, PDF, flat ASCII, CSV, SPSS, databases, etc.) to populate spreadsheets, documents, and PowerPoint templates. Often, I use Excel side-by-side with SQL, SPSS, or Unix/DOS/perl/Vim scripting languages. I worked the last 18 years in market research doing survey programming and crunching the resulting data. I have also used my skills for import/wholesale business and supporting engineering departments in a government transportation department. I believe that communication is very important to greatly reduce the chance of disappointment or the need to rework the deliverables. I will try to make sure that this is the case with your projects. Often I will add value to projects by doing more than the contracted work. When time permits, I will include extra features that I feel will be useful and save time for you when using my work
$240 AUD 6 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   AUSTRALIA bayrağı
Joondalup, Australia
5,0
4
Ödeme yöntemi onaylandı
Eyl 19, 2014 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.