Find Jobs
Hire Freelancers

KPI Dashboard

$250-750 USD

Completed
Posted over 4 years ago

$250-750 USD

Paid on delivery
I am looking for a developer to create a dashboard that rolls-up and aggregates data for approximately 50 data fields that are collected on a weekly basis for 8 different locations. At each location, a manager provides the data via an excel sheet on a weekly basis and is currently uploaded to a shared folder. I have attached the relevant files with instructions on how the data currently is input, how the files and data relate to each other, and what our goal is for creating a BI Dashboard. I am interested in any cost-sensitive, creative approach so that I do not have to manually aggregate these data points each week to report on each location for an enterprise view. Any approach or tool is fine - Office 365/Power BI or any other tool is fine as well. This simple project will be followed-up by several other projects.
Project ID: 22369232

About the project

73 proposals
Remote project
Active 4 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
Awarded to:
User Avatar
Hi, I am an expert in Excel, Access, Powerpoint, VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Time dynamic dashboards, and Reports. I can combine all the data from all the location in the data model and can create a KPI dashboard for you. I have completed a project similar to your project. combining data from 53 locations and creating a dashboard in power bi. you can check some of my previous works here. Auto dashboard: [login to view URL] Agent Target: [login to view URL] Forex Dashboard: [login to view URL] [login to view URL] printing press: [login to view URL] Cargo Dashboard: [login to view URL] [login to view URL] Please send me the files and clear specifications, I'll complete for free and will send you after checking the result you can award me. Thanks
$250 USD in 3 days
4.9 (109 reviews)
6.3
6.3
73 freelancers are bidding on average $486 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$500 USD in 7 days
4.9 (409 reviews)
8.2
8.2
User Avatar
Hello, I’m an Excel/VBA expert and I would like develop your KPI dashboard. Please check my profile and contact me to discuss further details. Regards.
$350 USD in 5 days
4.9 (454 reviews)
7.8
7.8
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will gather data from multiple workbooks located on a shared drive. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $350* and can deliver within five days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 340 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$350 USD in 5 days
4.9 (305 reviews)
7.8
7.8
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. I would like to help you create the Dashboard you need. I can create a tool that allows you to process all the files (from each location) and generate the "Enterprise View" by simply pressing a button and indicating some simple parameters. The tool will be completely reusable every time. Contact me to define the details (you can check my profile by te way). Best regards
$450 USD in 7 days
4.9 (295 reviews)
7.2
7.2
User Avatar
Hello, I can automate this proccess for you and build a dashboard with all the KPIs you want in excel or Power BI as i am an experienced Data Analyst with over 8 years in the field. Please check my portfolio to see my work and the level of my experience. Thanks!
$611 USD in 5 days
4.9 (78 reviews)
7.0
7.0
User Avatar
Hi I am a very experienced statistician, data scientist and business analyst. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, deep learning, AI, NLP, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$750 USD in 7 days
4.7 (94 reviews)
6.9
6.9
User Avatar
Hello, I am interested in your project. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from you, BR, Razvan
$500 USD in 7 days
5.0 (19 reviews)
6.0
6.0
User Avatar
Hi, I can create a dynamic excel dashboard for your data with a VBA script that will import the weekly data and update the dashboard with one click on a button. You can find in my portfolio a sample of a dynamic dashboard that I made in excel. Best regards, Florin Enache
$350 USD in 4 days
5.0 (23 reviews)
5.7
5.7
User Avatar
Hello! I am a Computer Engineer, MBA, and MCSA SQL Server, with 14 years of experience in Data Engineering and Business Intelligence projects and tasks. I am a near-native English speaker, currently available, results-oriented and business-savvy. I have plenty of experience working with several data visualization tools such as Power BI and Qlikview - you can see some of it on my portfolio. I put special detail on data visualization and on code performance. For your requirement, I would suggest building your dashboard with Power BI - we can use the free edition to consolidate your data and create appealing visuals and data grids. We can also use MS Excel + SQL or Qlikview to achieve the same results. All these options will reduce the manual work you are currently doing. In the end, it all depends on the specifics of your requirement. When you explain to me your requirement more thoroughly, I will be able to suggest you the best solution possible, technically-wise. I am located in the American Central Time Zone, which means we share similar office hours. We can discuss details over chat if you need it. Thanks!
$600 USD in 7 days
4.8 (14 reviews)
5.6
5.6
User Avatar
Hello there, Hope you are doing great. We are a small but excellent team of SharePoint developers and designers. We having expertise in every domain of SharePoint like SharePoint customization, custom development, migrations, workflow development, SharePoint branding and themes developments etc. I have 6+ years of experience in SharePoint and .NET technology. Along with that we have extensive experience in Power BI, Power Apps, Flow, teams, Infopath forms, SPFX web part development, SPFX Extension etc. I have completed more than 30 project over freelancer. You can check our client ratings by visiting my profile. My ultimate goal is customer satisfaction and you can see I have highest completion ratio with 5 star reviews. If you will hire us then I am damn sure that you will be fully satisfied with my expertise. I need one small meeting on personal message to discuss the complete requirements and then start the work ASAP. Looking forward for your kind reply. Regards, HINA ** Price and time mention over here are just placeholder. It might be change based on the requirements. Discuss at the finalization of the project
$600 USD in 3 days
4.5 (13 reviews)
5.7
5.7
User Avatar
I am Data Scientist with 4 years of experience in machine learning and statistcal analysis of data. I am very well experienced in using R and Python for data modelling and prediction. Reporting technologies like Tableau and Power BI are very crucial in converting your data into meaningful insists and that’s where my expertise comes into action. With more than 3 years of hands on production level deployment expertise in Tableau and Power BI I can help you understand and create innovative dashboards. Please share your requirements.
$360 USD in 3 days
4.7 (29 reviews)
5.1
5.1
User Avatar
Hi Good Day! A serious freelancer here. I can help you to complete this project. I saw some of your file and I know how to do this. I can make it automated using Excel Formulas and VBA Macro. Please consider my bid. I've done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$250 USD in 3 days
4.9 (58 reviews)
5.0
5.0
User Avatar
"Hi there, I have read your project description carefully and I would like to work with you on this project. I have well experience in data entry work like data copy from the website and make it an excel file. Feel free to ping me so we can discuss further details. I am looking forward to hearing from you. I am ready to do some free sample for you Regards, Data Express"
$500 USD in 5 days
5.0 (6 reviews)
4.6
4.6
User Avatar
Dear Sir, I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part of my daily deliverable. I am a professional accountant graduated with major in Finance and Accounts along with 8 years of experience in Finance, Accounting, Taxation and Auditing. I believe I can do a fantastic work for you if you provide me the opportunity. Sincerely, Gopal
$700 USD in 5 days
5.0 (15 reviews)
4.7
4.7
User Avatar
Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS Office -PowerPointMacros -Automatioin -Automation tools -VBA -Excel and VBA automation - etc. A professional having more than 7 years of experience in financial modeling, VBA macros, MS Office automation with postgraduate degree, Worked in reputed organisations on senior level. I am expert in my field, who knows the value of time, very hard working and always delivers the work on time. I always deliver the work well in advance with continues communication & timely response until satisfactory completion of the project. I only accept the projects which I am sure can be done within the stipulated time frame and budget.. I always deliver 100% Satisfaction to the client. Hope my skill and work can help you with your business. i look forward to have further discussion with you in the chat. Thanks Regards ATEMENU.D
$250 USD in 1 day
4.9 (12 reviews)
4.4
4.4
User Avatar
Hy Sir, I am an expert in Dashboard Designing and Development using, Excel, VBA, BI, Tableau, and other supporting tools, All the info that you need will be displayed on the dashboard. That will dynamic and perfect as per your requirements. I have a working sample. We can discuss details in inbox. Thanks
$300 USD in 7 days
4.6 (17 reviews)
4.7
4.7
User Avatar
Hello. We can organize the past and fixed data files into specific folders and have only the current periods files in other folders, then set up a configuration in Power BI that will refresh the data from the current period, so the refresh process won't take too long. Please let's schedule a meeting so we can begin the project. Thank you
$555 USD in 10 days
5.0 (11 reviews)
4.0
4.0
User Avatar
Hi. thanks for your posting. I'm very happy to have a chance of bidding your project. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a short time. I'm sure I can satisfy for you as you want. Best regards.
$500 USD in 7 days
5.0 (4 reviews)
3.7
3.7
User Avatar
Hi • I have 6.5 years of experience in Business Analytics and Data Architecture. Expertise in building end-to-end BI Infrastructure across industries including developing Data Models, Data Warehouses and creating visualizations using SQL server, MSBI stack, and Power BI • Expertise in Customer Analytics, Sales Analytics, Pricing, Sales & Operations Planning, Digital Analytics domains across Retail, F&B, Entertainment, Fitness, Health Care, Textile and Manufacturing industries • Designed and built multiple executive-level Power BI dashboards for clients across Retail, Food & Beverage, Entertainment, Fitness industries.
$600 USD in 7 days
5.0 (7 reviews)
3.7
3.7
User Avatar
Hello, I am a BI developer having 5 + years of experience and have delivered several projects like this in past. I can automate this whole process just using PowerBI where you will just need to ask managers to put file in a location and you will be able to see KPIs from executive perspective with different set of slicers. Assumptions: 1. File format doesn't change. Message me so that I can give you detailed walkthrough of architecture being planned by me and provide you a demo as well. Thanks, Jitesh
$333 USD in 7 days
5.0 (4 reviews)
3.7
3.7

About the client

Flag of UNITED STATES
Austin, United States
5.0
3
Payment method verified
Member since May 23, 2019

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.