已关闭

Comprehensive MIS dashboard in Excel

We are a service provider to a large number of Customers. We have multiple offices and over a hundred employees. We use 4-5 different softwares. We want to create a very detailed dashboard in MS Excel that can give us an overall view of the business. Data will be sourced from these 4-5 softwares and from other excel sheets.

Points to note

1) Fairly large amounts of data - in the range of 1,00,000 rows. (This is for you to get a broad range - The actual number may differ significantly)

2) Largely unstructured data from multiple sources (At least 5)

3) This will be an long term project as we will go on reiterating the dashboard based on evolving business needs

4) You will be required to sign a Non Disclosure Agreement before we start on the project

The dashboard will capture mostly operational aspects of our business. Things we are looking to measure is average time taken to service customers, efficiency of manpower, response time of our vendors amongst other things.
While we will also capture financial aspects of the business - the primary function of the dashboard is to give us an operational snapshot of the business.

技能: 商业分析, Excel

查看更多: business service agreement, mis data, excel service, Data analysis in excel , Dashboard, business dashboard, excel based dashboard, data dashboard, dashboard analysis, mis excel data, analysis dashboard, data analysis large excel data, comprehensive, comprehensive business, excel term project, unstructured data analysis, create dashboard project, create project dashboard, Analysis Service, excel business, data analysis project excel, want dashboard excel, excel analysis project, create provider excel, mis data excel

About the Employer:
( 12 reviews ) Mumbai, India

项目ID: #5245484

29名威客为此工作的平均竞标价是$451

nayabsiddiqi

Hi Hope all is well at your end. I'm excellent in designing the dashboards pertaining operational KPIs with different available tools. Not only Excel (Macros or through PowerPivot), but can also give you a demo throu 更多

$684 USD 在10天内
(32条评论)
6.1
funnyhoney

MBA, PMP with over 10 years of management experience. I can create the best excel MIS dashboard for you.

$515 USD 在10天内
(35条评论)
6.0
priyal1997

ear Sir/Madam I'm happy to help you on this. I have developed lots of excel dash boards for various purpose. (Please reply to this text so i van send you my samples). Please visit my profile to see my reliability 更多

$400 USD 在5天内
(84条评论)
5.8
pkcyber

Hi, I can develop a web solution for you as i did similar for my previous clients. Keenly looking forward for your response. As a demo see the link below. [url removed, login to view]

$555 USD 在7天内
(25条评论)
5.5
Pigo

I am an experienced financial analyst and, since 2005, CFA Charter-holder. I have more than 10 year of working experience in the financial industry. I started to work in 2000 as a financial analyst; from 2006 to 2009, 更多

$555 USD 在30天内
(23条评论)
5.3
bouslimi1979

Dear, I m a VBA Expert and I m interested in your project and a long term cooperation. I need to see the source files received from the softs you use in order to see how I cane code a macro to unify the structure of a 更多

$333 USD 在10天内
(37条评论)
5.3
SiroosJafary

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. PLEASE CONTACT ME,I WILL PROVIDE YOU 更多

$555 USD 在4天内
(17条评论)
4.5
dviruki

Hello! I have over 12 years of experience in financial and business analysis with Excel and have built a number of custom Excel dashboards, including recent ones for companies in hospitality and construction businesses 更多

$320 USD 在5天内
(26条评论)
4.4
KarrarRaza

Hi there. I'm Karrar, an ACCA member (CA equivalent) and I have five years of experience working as a financial consultant at a Big4. During this tenure, I have created many dashboards (databooks, as we call the 更多

$500 USD 在35天内
(7条评论)
3.1
vikas0903

Revising: Based on additional explanation. Hi, I have been working as Sr. pricing analyst since last 4+ years. During this stint, I have worked on projects involving price models, creating competitive information 更多

$374 USD 在15天内
(2条评论)
2.4
kaumochan

I have over 7 years in consulting practice. Shall be glad to undertake the assignment. Please share more details.

$250 USD 在10天内
(2条评论)
2.4
adityachatterjee

Hi, I am a software QA professional with 6 years of exp. I would love to work with you in this project. Please consider my bid. In case you want to discuss about the test strategies or the budget please IM me. Adity 更多

$555 USD 在12天内
(1条评论)
1.3
rgexpressindia

I am expert in Excel, Data Entry and Analysis. This is not a matter of heavy work and hence bid with the least amount. I can finish the task in 5 to 10 days. (Even before that) Also your data will be handled in safe 更多

$250 USD 在5天内
(1条评论)
0.4
dhanaraj1989

HI, this is dhanaraj from pondicherry... i am new to this industry... previously worked for an international voice process... since i am new i need to grow so i can give u 100% acuracy on ur project and can finish i 更多

$555 USD 在10天内
(0条评论)
0.0
pgerbrands

Dear sir/madam, Why more expensive and a longer duration? Because your decisions will be based on the dashboard I will develop for you. Are you willing to make future decisions on questionable information? I provide 更多

$700 USD 在30天内
(0条评论)
0.0
mariusch1641

hy! I am senior business analyst with more than 10 years experience in IT. My expertise includes multiple domains like : oil&gas, power&utilities, public sector, retail, insurance. I have worked with multiple I 更多

$333 USD 在10天内
(0条评论)
0.0
somoo89

Hello, I am an Associate Chartered Certified Accountant (ACCA), having more than 3 years of professional experience of providing business solutions. My team consist of qualified professionals lead by senior Cert 更多

$555 USD 在10天内
(0条评论)
0.0
saini82

Hi, I am a experienced professional having the same kind of experience more than 8 years. Started working as MIS executed to business analyst now in a good reputed company. Specialization: 1. Business / Data rep 更多

$555 USD 在10天内
(0条评论)
0.0
sritechnocrat

Hello Sri Technocrat will provide fully interactive application/website for your project. As per the detail, Sri Technocrat will provide three template functional schemes and sample pages to make your choice for lay 更多

$789 USD 在30天内
(0条评论)
3.8
ajanreduan

A proposal has not yet been provided

$555 USD 在10天内
(0条评论)
0.0