Closed

Excel dashboard tune up and data retrieval.

Evening,

Looking for someone to help me retrieve data either from and an SQL database backup or from Point Of Sales system generated excel files.

Need to make retrieval of information automatic either by macros or with 3rd party software.

This information is then transfered into our excel dashboard that shows us specific sales figure, monthly spending etc etc

Thank you

To remove some of the confusion, I have attached some pictures of my current dashboard environment that i have created.
The problem i have is i have to manually process information from my POS (Point of sales system) http://www.kronoskonnect.com.au
I pay a monthly subscription to use there software and the database is controlled from there side. I dont have the sql passsword or username to access the database but the software can generate excel report for alot of the information i require.
So what i need is someone to help me either

1. get into the database to continually gather data for my dashboard
or
2. auto generate the reports from the POS software and again automatically move from those sheets to my dashboard

3. you may have a much easier way to do it which would be great!


Thanks again & please contact me if you can help...

Skills: Data Entry, Data Processing, Excel

See more: tune up, sales dashboard, data entry SQL , Dashboard, backup excel sql, data dashboard sql, data dashboard, dashboard macros, point excel, tune software, retrieval, use excel data microstrategy dashboard, database backup sql server excel, automatic data entry software, sql database backup excel, sales entry excel, need excel macros, automatic excel, monthly database excel, dashboard monthly, backup database sql excel, dashboard excel macros, macros database, sql dashboard excel, information retrieval excel

About the Employer:
( 2 reviews ) Perth, Australia

Project ID: #5084917

16 freelancers are bidding on average $11/hour for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$15 AUD / hour
(150 Reviews)
6.5
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi More

$13 AUD / hour
(69 Reviews)
5.4
satsin7

Sounds like an interesting project. Please check out my sample work and my profile speaks for its self. [url removed, login to view] I can work with the excel files. Look More

$12 AUD / hour
(18 Reviews)
4.6
microk

Dear Howaa1, Expert here.. Please share details.. Regards, Microk [url removed, login to view]

$10 AUD / hour
(28 Reviews)
4.5
Edison1983

************I've done Similar but much Advanced Projects******* Please refer the Survey Dashboard in my Portfolio. Good Day!... I'm an Expert in Excel VBA Automation. Have developed & designed various excel based p More

$15 AUD / hour
(11 Reviews)
3.7
dviruki

Hi, I can help you with the project. I have 12 years of extensive Excel experience. Could you please show how POS generated files look like to confim my initial thoughts.

$10 AUD / hour
(13 Reviews)
3.5
Aldo21

Hi, I can do it with VBA MAcros, its simple cheap and very efficient. -----------------------------------------

$8 AUD / hour
(8 Reviews)
2.9
MasterExcel

I am Data Entry ,MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high More

$12 AUD / hour
(6 Reviews)
2.7
logoDS761

hello, i had highly experience 10 years in vb6 + vba macros in all MS. office soft, OpenOffice Calc 3.5 and 4.0 i did later this month successfully "Created at run-time by macros code 500 Check-boxes and a spreadshe More

$10 AUD / hour
(2 Reviews)
2.1
kundanbhati

Hi, I see that you want to import data from excel sheet or sql server to your dashboard. I can do this using VBA or C#, whichever suits you best. we can create one form in C# where you would be able to specify excel s More

$12 AUD / hour
(1 Review)
1.8
kaumochan

A proposal has not yet been provided

$13 AUD / hour
(1 Review)
1.0
pranav59

Hello, I can take of your job comfortably. Kindly let me know in case you need more details. Thanks

$11 AUD / hour
(0 Reviews)
0.0
fazlanfairooz

Hello sir, M fazlan fairooz from sri lanka and m an student, doing BSC in software side i have only classes in sunday's and now im planing to do some online jobs so if u think that m the person who can do sir please g More

$12 AUD / hour
(0 Reviews)
0.0
chronrus

I am an expert with Microsoft Excel and have utilize SQL databases. My degree is in Business Information Systems and there is not a better system the Microsoft Office suite.

$12 AUD / hour
(0 Reviews)
0.0
Charuka1122

Hi !. I Can type 35wpm typing speed. So I am interesting in your project. If you give your project to me. I will finish and handover correctly and quickly. Thank you.

$8 AUD / hour
(0 Reviews)
0.0
OST2013

If you have a local database (MS Access should be perfectly fine I believe) you can set up a database connection through the vba, pull the data you need by a simple sql select statement, create pivot tables, set the da More

$10 AUD / hour
(0 Reviews)
0.0