Find Jobs
Hire Freelancers

Building a Data Analytics Dashboard with Weekly Refresh

$750-1500 AUD

Closed
Posted over 6 years ago

$750-1500 AUD

Paid on delivery
Hi there, I have a small merchandising business where my staff goes to various retail stores and sets up products on stands, for them to be sold. I can arrange two databases on a weekly basis: - First : Database with merchandiser name, store name, no of hours spent at store that week, travel kms for each merchandiser and store that week, time spent in store by merchandiser that week, money paid for time of merchandiser and money paid for travel. - Second: Store Sales for each store - number of units, number of dollars I want a dashboard where I can see, for time period selected by me - number of hours spent by a merchandiser, money paid to the merchandiser for time, money paid for travel, store-wise sales for that period, ratio of spend to store sales etc I should ideally be able to play around with time period, filer per store, filter per merchandiser. I should have an option to upload data files each week and look at the dashboard. One Business Intelligence Tools I have in mind is Tableau but I'm open to how this can be done in the most cost-effective way. Interested freelancers, please pitch in with: - Questions - Quotes
Project ID: 16075751

About the project

40 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
40 freelancers are bidding on average $1,083 AUD for this job
User Avatar
We are a team of designers and developers with expertise and experience in Photoshop, HTML5, CSS3, PHP, AJAX, JQuery, XML, Wordpress, Bootstrap, CodeIgniter, Laravel, Google Map API and MySql. We have designed and coded many custom sites and applications of varied extents and complexity. We have coded custom dashboards for easy understanding and efficient management of business operations. We are not familiar with tableau but can study and determine if it will be better and can integrate. Else we can code custom dashboard. I have read the overview and am confident of delivering as required. It will help if you can share samples of the two databases that you will upload/ import to the application (we have coded PHP scripts to import data from csv/ excel files). It will enable us to suggest changes and also commit to the dashboard with the functionalities that you need. It will also help to assess scope of work precisely. I will revise / confirm my bid accordingly. Detailed specifications and inputs will also help me to make an informed commitment and deliver as required. I ensure a very thorough job and also support if you need changes / enhancements in future. I look forward to hearing from you and working on the project.
$1,500 AUD in 15 days
4.9 (824 reviews)
8.9
8.9
User Avatar
Hi, I have more than 11 years of experience in Reporting and Dashboards. I would also like to go for Tableau for this. I am suggesting to for Bar charts for the time based metrics and Pie charts for Dollar based metrics. Also, table reports for top 10-50 report for all the details. I would like to have discussion on the exact requirements before final bid. Thanks, Nalla
$1,110 AUD in 5 days
5.0 (87 reviews)
7.6
7.6
User Avatar
Greeting, I have understood your Building a Data Analytics Dashboard with Weekly Refresh task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Business Intelligence, Data Analytics, Database Programming, MySQL, Software Architecture
$1,250 AUD in 10 days
4.9 (143 reviews)
7.3
7.3
User Avatar
Hi, may I see the database schema with a subset of data. The range of options for transforming numbers to visual elements is so wide. But after seeing the schema and the kind of database, I'll give you my advise and show you our past works Thanks Felice,
$944 AUD in 20 days
5.0 (22 reviews)
6.7
6.7
User Avatar
Hi, Hope you are doing good. I have expert knowledge in Tableau, Qlik and Power BI designing and development. I have created many dashboards using this tools. Any one of the above tools works for your requirement. please message me for sample work and further discussion.
$833 AUD in 10 days
5.0 (12 reviews)
6.6
6.6
User Avatar
Hello, I read your whole proposal, and thanks for your post on my good experience. This is very good job for me. So I think I can do this in high quality. My releavant skill is: Business Intelligence, Data Analytics, Database Programming, MySQL, Software Architecture I want to further discuss with you. I look forward to working together in partnership on your project and into the future. Best Regards.
$1,250 AUD in 20 days
5.0 (27 reviews)
6.2
6.2
User Avatar
INTRODUCTION I am a database reporting analyst responsible for creating reports from the advanced databases; advanced in the area of data staging and mining, and the creation of interactive reports and dashboards. SHOWCASE I can start working on your project today. You only pay 30% milestone on 50% job completion. I have 100% project completion history. SKILLS Analyze requirements and create reports Create interactive dashboards, on-demand reports, and visualizations Business Intelligence technology Integrate SQL with Tableau, Hyperion and SSRS
$800 AUD in 20 days
4.9 (30 reviews)
6.4
6.4
User Avatar
Hello, sir I saw your project and analyze your requirements. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before. I am senior Access/SQL/VB /Excel developer since 1997 and I can write for you a user-friendly program using MS Access . You can look into my portfolio here for my software screens for my previous work. Do revert me back if you feel like I am a suitable candidate for this Job and discuss further details. Thank You and Regards, Zura
$1,250 AUD in 20 days
4.7 (27 reviews)
5.7
5.7
User Avatar
I have worked on Predictive Analytics,data mining, Object Detection and Object Recognition problems like counting the different number of vehicle type like cars , scooters, buses etc. Some of the skills I possess are - 1) Python 2) Tableau 3) Machine Learning - Deep Learning, Sentiment Analysis , RNN 4) Chatbot integrations for Skype, Skype for business, Skype, Facebook 5) Backend - AWS, Google cloud Let me know if you need anything else.
$1,250 AUD in 20 days
5.0 (14 reviews)
4.6
4.6
User Avatar
Hello, I am interested in your offer and I am ready to cooperate. I have experience writing programs for information processing. I have experience in writing macros VBA for Excel .
$750 AUD in 20 days
4.9 (11 reviews)
3.9
3.9
User Avatar
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
$1,200 AUD in 3 days
5.0 (4 reviews)
3.7
3.7
User Avatar
I propose we use Power BI, as I am an experienced developer with that tool. I'll create a solid, good looking and simple dashboard, You will not regret working with me. So far I have no questions, I need more details and then maybe I'll have. Cheers.
$750 AUD in 5 days
5.0 (2 reviews)
3.5
3.5
User Avatar
I have Tableau in my system so you don't have to pay for licence. We could discuss options of multiple Dashboard to finalise one and then improve further. I can also give insights and recommendations based on the analysis done. Mentioned a monthly charge of doing the work as per requirement. Post Graduate in Business Analytics & Business Intelligence from Premier B school, Great lakes Institute of Management, India's Top Analytics course certified by Illinois Institute of Technology, Chicago, USA. I am a working professional since 9 years.
$833 AUD in 30 days
5.0 (1 review)
3.5
3.5
User Avatar
A proposal has not yet been provided
$1,000 AUD in 21 days
4.4 (7 reviews)
3.6
3.6
User Avatar
I have been working as a BI specialist for more than 6 years. I have experience in Power BI, Qlikview, Tableau, OBIEE, SAP BO. I can handle with your requirements.
$750 AUD in 10 days
5.0 (6 reviews)
3.1
3.1
User Avatar
Hello sir, setting up dashboard related thing is what i have experienced . I could able to do in ssrs reporting side, please let me know for questions ,
$1,111 AUD in 20 days
4.7 (8 reviews)
3.5
3.5
User Avatar
Hi There! My recommendation would be to use Power BI to deliver this project. If you already use Microsoft Office 365, it can be used for free! Power BI lets you create reports and dashboards and can be scheduled to refresh. The cheapest option would be an excel workbook using Power Query/ Power Pivots to make it as easy to refresh as possible. Thanks for your consideration.
$1,000 AUD in 10 days
5.0 (1 review)
2.7
2.7
User Avatar
I have 5 years of experience in Tableau. I have developed different visualizations to analyze the data in Excel.I have strong understanding of business requirements and create the reports accordingly. As I have good experience in retail sector, I can effectively make the dashboard with needed functionalities.
$750 AUD in 20 days
5.0 (3 reviews)
2.4
2.4
User Avatar
Hi, I've 11 years of experience in Data warehousing and Business Intelligence field using Tableau, MicroStrategy as visualization tools along with Excel, CSV, MySQL, Oracle, DB2 etc databases. I've developed various types of visualizations which are simple yet powerful tools for getting the insight of the business through data. These data come either from a single data source or multiple data sources. I would like to go ahead by showing you some samples of my work based on your requirement. Please do visit my Profile/Portfolio to get a feel of my developed dashboards in Tableau. (https://www.freelancer.com/u/ashueureka.html) Please let me know if you need further details. I can definitely propose the cost-effective way in which Tableau and MicroStrategy can be used. Please let me know if we can talk and discuss the same. Thanks! Ashish
$1,250 AUD in 10 days
5.0 (3 reviews)
2.5
2.5
User Avatar
Nice to meet you, I have gone through your project details, that I hope you are doing well and understand that you are looking to develop Dashboard analysis system. For me, i can work through Cognos Insights because it is perfect to do small/mid level of business. I have 14+ years of experience in Cognos BI. For More clarification, please let me know. Regards, Saravanan.
$1,666 AUD in 20 days
5.0 (1 review)
1.6
1.6

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Jan 14, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.