KPI Dashboard

Completed Posted 4 years ago Paid on delivery
Completed 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.

Excel Data Processing Data Mining Database Development Power BI

Project ID: #22369232

About the project

73 proposals Remote project Active 4 years ago

Awarded to:

aimefx

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, interact More

$250 USD in 3 days
(109 Reviews)
6.3

73 freelancers are bidding on average $486 for this job

schoudhary1553

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. Pl More

$500 USD in 7 days
(409 Reviews)
8.2
P0L

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
(454 Reviews)
7.8
paris2785

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 s More

$350 USD in 5 days
(305 Reviews)
7.8
elqueabandona

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 More

$450 USD in 7 days
(295 Reviews)
7.2
antoinepal

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 More

$611 USD in 5 days
(78 Reviews)
7.0
suyashdhoot

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 com More

$750 USD in 7 days
(94 Reviews)
6.9
razvancotofana

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
(19 Reviews)
6.0
afenache

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 dash More

$350 USD in 4 days
(23 Reviews)
5.7
SergioAlfaroV

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- More

$600 USD in 7 days
(14 Reviews)
5.6
bdrudra

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, mig More

$600 USD in 3 days
(13 Reviews)
5.7
rutvikparmar

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 Tabl More

$360 USD in 3 days
(29 Reviews)
5.1
paulodayto08

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. More

$250 USD in 3 days
(58 Reviews)
5.0
Servicehour24

"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 fre More

$500 USD in 5 days
(6 Reviews)
4.6
GopalJp

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 accounta More

$700 USD in 5 days
(15 Reviews)
4.7
hayteekeys

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 More

$250 USD in 1 day
(12 Reviews)
4.4
chraheelbhatti

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 More

$300 USD in 7 days
(17 Reviews)
4.7
poldialcalay

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 p More

$555 USD in 10 days
(11 Reviews)
4.0
adampohp79

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 More

$500 USD in 7 days
(4 Reviews)
3.7
Kartheekreddyn

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 visu More

$600 USD in 7 days
(7 Reviews)
3.7
jiteshparwal93

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 fil More

$333 USD in 7 days
(4 Reviews)
3.7