Kpi automated dashboatd

$750-1500 USD

Closed

Posted

over 3 years ago

$750-1500 USD

Paid on delivery

We have around 80 kpi's provided by different departments on monthly, quarterly, mid yearly and yearly basis. These are provided by filled in excel sheets. We would like someone to create a professionally looking dashboard where these KPIs could be reviewed during the managment meeting, The dashboard can be created in power bi or any other suitable on premises softwares. Expectations for the dashboard: - 60 to 80 KPI's visual with trends and ability to see lowest / highest performers - ability to refresh and acquire data from the participants excel sheets - ability to set targets and modify targets after certain time - the charts / the synthetic table reacts on KPI below target - ability to add notes and remarks Expectations for the staff data input fileds - easy to fill and links to the dashboard - they may be in the fixed location or may be pasted to the fixed location - they may have fixed names for the easier connection to the dashboard More data will be provided to selected interested parties Read Less

Business Analysis

Project ID: 27867610

About the project

26 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

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

26 freelancers are bidding on average $949 USD for this job

@daniyal3214

I can perfectly help you with that. I am a professional Business & Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to design a highly dynamic, interactive and automotive dashboard to related to KPIs, Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.

$750 USD in 2 days

4.6

(39 reviews)

5.5

@BAVarun

Suggestions for an on-premise software - 1. Tableau 2. Power BI Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 54 projects on FL. Expertise - Macros Formulae VBA User forms Willing to share a sample of my work done on personal finance applications. Looking forward to hearing from you. Thank you BAVarun PS: Please have a look at the reviews given to me on this platform.

$750 USD in 7 days

5.0

(5 reviews)

3.1

@rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.

$750 USD in 1 day

5.0

(4 reviews)

2.5

@ajaykumar0701

I am a MBA in Finance with expertise in business analysis. I can create the required tool/ dashboard to make all necessary analytics from the KPIs. Please reach out to me to discuss further.

$750 USD in 7 days

4.4

(1 review)

1.0

@sevillajk01

Hello! I can help you with your KPI dashboard visualization project. I can create automated and interactive dashboard in excel and or powerbi. You can be assured of a high quality and accurate output. If I were to start the project, I need to see first the data to sort and identify the fields needed for easier data input and update. I hope to discuss with you more on details. thanks!

$800 USD in 15 days

0.0

(0 reviews)

0.0

@dsamwork20

Power BI | DAX | Dashboard | FREE Consulting Will do a POC first and then if you want you can onboard me for this assignment. Hi, I can help with this assignment. Since you have mentioned that the solution should be on premise and automated, we need to discuss first before getting started. Can we have a call and walkthough of the requirement ? First we prepare a strategy then we can proceed with development. I have 4 years of experience in Power BI. and over 8 years in Data analytics. I can build the dashboard for you. we can connect for a demo. consultation is free. Bid amount can also be disussed basis scope of work. Do message me. Thanks, DSam

$1,111 USD in 15 days

0.0

(0 reviews)

0.0

@chnsci

Greetings, I think here you are looking for someone to create a professionally looking dashboard where these KPIs could be reviewed during the managment meeting, The dashboard can be created in power bi or any other suitable on premises softwares. I understood your project description. I am an expert in Business Analysis and I am really interested in your project. I am really confident that, I can do this with 100% accuracy and ready to start now! But I want to know more about your project. So, can we discuss more? Thank you.

$850 USD in 15 days

0.0

(0 reviews)

0.0

@nikhilgupta84

Data Scientist/Analytics Consultant with over 13 years of industry experience. I have worked in various domains like Retail, Banking, Insurance and Healthcare (Real World evidence). I have been invoved into end-to-end analytics project execution which involves the following taks: a) Data Management (Processing, Cleaning, Transfomation) b) Data Reporting/Dashboarding (BI) c) Data Analysis/Modeling To accomplish the above mentioned tasks, I am extensively using the following tools: - SAS - SPSS - R - Python - Power BI - Tableau - SQL - MS Excel - MS Access

$800 USD in 2 days

0.0

(0 reviews)

1.4

@athifazad

Good Day! - Proficient in data analysis with MS Excel Power BI and Power View. - 8 plus years of experience in financial audits (including Big 4 Accounting firms) - Chartered Accountant and an Associate member of AICPA (US) With my team expertise, I can help you deliver a quality dashboard analysis with key business drivers, KPIs and ratios. Please get in touch to discuss your expectations and timelines.

$750 USD in 14 days

0.0

(0 reviews)

0.0

@mmurillofigueroa

Hi, My name is Marco Murillo. I am an industrial Engineer with a wide experience in evaluation of performance in different industries and the abilities to develop a dashboard in Microsoft excel using macros or even programing in your SharePoint to update it quickly and automatically. Additionally, I have created this kind of managing tools using different approach like balance score card, Lean manufacturing metrics, P&L and so on.

$1,125 USD in 7 days

0.0

(0 reviews)

0.0

@jdpatel4444

Will give good visualise dashboard with more feature include as well ans deliver in given time line as per need

$944 USD in 15 days

0.0

(0 reviews)

0.0

@MikayelNiyazyan

Hi, I am contacting you to submit my application for your job offer. I Have considerable experience in developing (Data importation from 7 different Excel sources + ETL + Dashboarding) and managing a Power BI and Excel VBA solution for a big international company. I feel that my profile matches your needs and would be happy to discuss more about your project. You can find on my profile page a video demonstration I made, showcasing a practical case study with a few examples of interesting Dashboard solutions. Kind regards, Mikayel N.

$1,490 USD in 14 days

0.0

(0 reviews)

0.0

@shehandg7

Hello, I'm a certified (Tableau Desktop) Tableau Consultant and I have extensive experience with developing dashboards for many clients in various fields. I can fulfill your requirement with Tableau which is one of the best BI tools available in the market today. The delivery time of the project will depend on the complexity of the dashboard and level of data available, incorporating 60-80 KPIs' with all the requirements that you have mentioned above requires planning from requirement gathering, design and development. Which is why I have estimated and increase the delivery time to 14 days. Please view my profile for more information, contact me if you require further information. Thank you and Best Regards, Shehan

$1,200 USD in 14 days

0.0

(0 reviews)

0.0

@itsolutions3016

Hi There, I have read your requirement and I have already implemented these things in my dashboards and having ability to deliver the quality work within time. Kindly chat with me to discuss this project. Thanks and Regards, Mayank Trivedi

$778 USD in 30 days