Find Jobs
Hire Freelancers

Building an excel database to report dispensing data

$300-1000 AUD

Selesai
Dibuat lebih dari 8 tahun yang lalu

$300-1000 AUD

Dibayar ketika dikirim
I am a pharmacy that dispenses medicines for large pharmaceutical companies nationally and I need to be able to provide a report that provides a dashboard and specific data that I will explain. The data file provided provides de-identified patient data for a medicine that is dispensed which may have multiple strengths in this case 10mg & 25mg. I need to be able to dump the attached data file that will provide a rolling 12 month data that provides the following:- 1. Actual numbers of TESTDRUG strengths dispensed individually & combined across all states. 2. Actual numbers of NEW PATIENTS on TESTDRUG strengths individually & combined across all states. 3. Source of patients by STATES in AUSTRALIA. 4. Source of patients by POSTCODE in AUSTRALIA. 5. Prescribers - How many patients in TOTAL. 6. Prescribers - How many new patients by MONTH. 7. Prescribers - How many patients in total and new patients per month/last 12 months. 8. Dashboard that summarises (I) Total Number of Patients by State & Total, (ii) Total number of Patients by TESTDRUG strength, (iii) Total number of PATIENTS by Prescriber 9. Anything else that you can think of to make this file more interesting and well presented. 10. I would like to ensure that when data is dumped if a particular MOLECULE has 2 strengths, when I run it for another company that may have 4 strengths it automatically picks it up.
ID Proyek: 9089263

Tentang proyek

18 proposal
Proyek remot
Aktif 8 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$475 AUD dalam 10 hari
5,0 (59 ulasan)
5,7
5,7
18 freelancers are bidding on average $495 AUD for this job
Avatar Pengguna
A proposal has not yet been provided
$500 AUD dalam 7 hari
5,0 (220 ulasan)
7,1
7,1
Avatar Pengguna
Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Please contact with further details if interested. Regards CA Raghav Bansal
$421 AUD dalam 4 hari
4,9 (68 ulasan)
6,1
6,1
Avatar Pengguna
Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Virtual Assistance, Web research, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Social media marketing, lead generation, etc. Also i can type as fast as 75WPM with 100% accuracy. Certified in Intuit Quickbooks and handling bookkeeping for 5 Australian & 2 US clients. Expert in VBA, VB, .NET, SQL, MS office, which includes formatting, powerpoint presentation, mail merge, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Assuring you of our best services. Thanks and looking forward to hear from you soon. Have a great day!!!
$315 AUD dalam 3 hari
4,9 (49 ulasan)
5,3
5,3
Avatar Pengguna
Hi, I'm good with data analysis and Dashboard in Excel. I performed a project for ShowCase jeweller, a big company in Australia. I analysed their sales and made a dashboard for their sales performance and suppliers performance. Please contact me for further details of your project. Thanks!
$333 AUD dalam 3 hari
4,7 (9 ulasan)
3,7
3,7
Avatar Pengguna
A proposal has not yet been provided
$684 AUD dalam 5 hari
5,0 (3 ulasan)
2,0
2,0
Avatar Pengguna
Hello Sir, I am writing in response to your advertisement for a Building an excel database. After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I also perform administrative duties including copying, web research, copy typing, copy past. I feel that I can add professionalism and accuracy to your current of team of professionals. With extensive experience supporting all levels of a department and working directly with external vendors, I take direction well and can complete a heavy workloads and complete projects under minimal supervision. If you feel there is a mutual interest, I would welcome the opportunity to meet with you to learn more about your company, the requirements of the position, and how my qualifications would be a good fit. Thank you in advance for your time and consideration. I look forward to Hiring from you soon. Dinushka.
$300 AUD dalam 1 hari
4,6 (2 ulasan)
0,9
0,9
Avatar Pengguna
I am Expert >> Data Entry (Word, Excel, PDF) > >Web Research > >Virtual Assistant >> Administrative Support >> Spreadsheet / Excel related job >> Create Mailing List >> Data Mining / Data analysis >> All kinds of Data Conversation (Example- PDF/JPG to Word/Excel) >> Word Possessing / Ms Word >> Typing >> Creating Fill-able PDF Form >> Email Support >> Email Response >> Copy and Paste Text or Data >> Accounting / Bookkeeping >> PDF Handling >> Forum posting >> Form Filling >> Social Media related Job >>Wordpress >>Adobe Photoshop>>>>>>Product listing. I can do this job perfectly. If you give me the job i can proved it. Thanks.
$300 AUD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hello, I would create the dashboard and system as per your initial specification and description after discussion. I guaranty you good work. Do not go over my small profile I have good records off the records. With Regards Anuj
$600 AUD dalam 15 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
We are Team of Highly Qualified Professionals who can handle your project in an efficient way and make sure its complete on given time frame with your Full satisfaction
$555 AUD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
i am new to this online freelance work. earlier i have done many freelance work which i have uploaded in my account . i believe i can present your job before time and with ultimate satisfaction
$333 AUD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A new freelancer who just venture into this website. Hope to gain more experience and knowledge from this website so that i can prove myself here. I need guidance and clear instructions from employer to produce best results. Thank you.
$388 AUD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I am an expert in Microsoft Office Word, Excel, PowerPoint, VBA, Outlook and Access with 9+ years of experience. I have done MCA (Master in Computer Application) & Microsoft Certified. I have worked for Office Tiger, JP Morgan, WNS Global Services (Booz & Company). I possess proficiency in Microsoft Office programs & Windows Operating System. Prepares complex presentations in final form from rough drafts, adhering to highly structured corporate templates and graphic standards.
$888 AUD dalam 7 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I have previously worked on an hospital management system which did include pharmaceutical management as well, so I would love to assist you on this.
$555 AUD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$944 AUD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi, I have extensive work experience with excel and macros and am confident I can get the work done efficiently and without any error within the scheduled time. I already have the code for the type of dashboard you are looking for and will get back to you with an update at the end of each day of the project period so that you can keep track of the progress.
$300 AUD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera AUSTRALIA
East Gosford, Australia
5,0
1
Memverifikasi Metode pembayaran
Anggota sejak Des 10, 2015

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.