In Progress

KPI Dashboard

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.

Skills: Excel, Data Processing, Data Mining, Database Development, Power BI

See more: kpi dashboard tableau, kpi dashboard manufacturing, sales kpi dashboard, kpi dashboard excel, best kpi dashboards, kpi dashboard example, kpi dashboard design, simple kpi dashboard excel, example attached, replicate a landing page functionality from an example i, 17 find an example of a blog and record the web address add suitable screenshots, i want to make an architectural logo give me an example, an example of a cover letter, an example of advert looking for a person with financial skills, an example of a good curriculum vitae, an example of a good cv, an example of an algorithm, an example of a problem statement, an example of a project proposal, an example of a project proposal for funding

About the Employer:
( 0 reviews ) Austin, United States

Project ID: #22369232

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

74 freelancers are bidding on average $487 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$500 USD in 3 days
(731 Reviews)
8.5
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
(330 Reviews)
7.9
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
(334 Reviews)
7.3
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
(229 Reviews)
7.5
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
(230 Reviews)
6.9
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
(48 Reviews)
6.4
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
(81 Reviews)
6.8
SShtv

Hello, I am interested in your proposal and I am ready to solve your task. I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data and constructing D More

$350 USD in 4 days
(84 Reviews)
6.0
wsh2

At your earliest convenience, could you please attach a workbook sample to this private chat message thread so we may better analyze and discuss your requirement. Many thanks in advance! Greetings from Easton PA, USA. More

$795 USD in 7 days
(35 Reviews)
6.1
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$250 USD in 3 days
(122 Reviews)
5.9
bhupendrayadav

I can develop an Excel based (VBA macros) to consolidate the data of all 50 fields and 8 locations from different files. I can also create a KPI dashboard to analyse and present that data into gtaphical [login to view URL] ini More

$250 USD in 3 days
(35 Reviews)
5.4
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
(11 Reviews)
5.5
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
(16 Reviews)
5.3
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
(22 Reviews)
5.3
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
(8 Reviews)
5.0
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
(14 Reviews)
4.6
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
(36 Reviews)
4.5
mmagr99

Hi, I am very confident to get this done for you. Check a few samples below [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] https://www More

$1000 USD in 12 days
(3 Reviews)
4.6
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
(15 Reviews)
4.5
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
(12 Reviews)
4.2