Find Jobs
Hire Freelancers

Comprehensive MIS dashboard in Excel

$250-750 USD

Closed
Posted over 10 years ago

$250-750 USD

Paid on delivery
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
Project ID: 5245484

About the project

29 proposals
Remote project
Active 10 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
29 freelancers are bidding on average $451 USD for this job
User Avatar
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 through other available technologies at no-cost. Kindly provide the data-set from all sources (5 as you mentioned) that may need to be presented on dashboard, so I can prove you my skills
$684 USD in 10 days
5.0 (32 reviews)
6.1
6.1
User Avatar
MBA, PMP with over 10 years of management experience. I can create the best excel MIS dashboard for you.
$515 USD in 10 days
4.8 (35 reviews)
6.0
6.0
User Avatar
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 If you are comfortable with those,I'm happy to discuss the project further I assure you that, I will do my best to go beyond your expectations I look forward to hearing from you Best regards Priyal
$400 USD in 5 days
5.0 (84 reviews)
5.8
5.8
User Avatar
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, I was chief financial officer for a renewable energy company. After this experience, I started offering corporate financial services as a professional consultant delivering business plan, company valuation, helping companies to raise capital (both equity and debt), implementing planning and control procedures and organizing the capital structure. I have long time expertise in: - company valuation - financial analysis - delivering business plans - excel financial plans - project financing - corporate finance duties. - capital budgeting - business development projects - finance writing Most recent business plan made: - food production startup business plan - IOS/Android APP focusing on medical services - project management advisory company - testing lab - IOS/Android APP - company producing and selling sauces - religious based IOS/Android APP - educational training center - tattoo APP project - product to be employed in hospitals - transport business development project - biodiesel plant and oil fuel plantation -plan for start-up entertainment social network - e-marketplace selling consumption experiences - total cargo management development project - digital signage start-up company At your disposal Best regards
$555 USD in 30 days
4.9 (23 reviews)
5.3
5.3
User Avatar
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 all the data. After that we can make all the tests and add all the feautures you want to have a global business view. We should also have a short discussion to clarify all the points. Best Regards, Issam
$333 USD in 10 days
4.9 (37 reviews)
5.3
5.3
User Avatar
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 DASHBOARDS WHICH I ALREADY BUILT. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html Regards.
$555 USD in 4 days
5.0 (17 reviews)
4.5
4.5
User Avatar
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 (see employers' feedback and project details in my portfolio; projects "Excelsheet need to to fixed and to convert that sheet to a dashborad" and "Material Progress & Tracking Report", respectively). I'm sure I can add value to the project.
$320 USD in 5 days
5.0 (26 reviews)
4.4
4.4
User Avatar
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 them) and therefore I think this is s suitable task for me to work on. I would like to discuss this further with you. Regards, Karrar
$500 USD in 35 days
4.9 (7 reviews)
3.1
3.1
User Avatar
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 databases etc. In my projects, I work extensively on excel (with 100K rows of data from production sites). For your project, I expect solution to be on following lines: 1) User form: This will be design on excel and will collect user inputs, which will then be stored in ACCESS DB. This will be connected to various data sources (which could be excel files/access) 2) Access operations: Need to control database operations, (like automated picking of raw data from sources, formatting it to be stored in predefined format). Buttons should be provided in User form sheet to control operations like this. 3) Processing/Calculation logic: Logic will be needed to perform data processing/calculations over formatted data. In my estimation, whole process may take 20 - 25 days for completion. This estimation will also depend (and may vary) on how prepared you are with project draft and related details. I guess I have understood your requirement and can help you in that. [I have worked on similar project before where PWA analysis was done, on data residing in Access, based on user inputs.] Please revert back for any questions/clarifications. Regards! Vikas
$374 USD in 15 days
5.0 (2 reviews)
2.4
2.4
User Avatar
I have over 7 years in consulting practice. Shall be glad to undertake the assignment. Please share more details.
$250 USD in 10 days
4.3 (2 reviews)
2.4
2.4
User Avatar
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. Aditya.
$555 USD in 12 days
5.0 (1 review)
1.3
1.3
User Avatar
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 and secure manner.
$250 USD in 5 days
5.0 (1 review)
0.4
0.4
User Avatar
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 it in time can i get a chance.... please kindly inbox me..
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I would like to do this job and i will sign on NDA agreement. I will do this work on your way. I have experience in data entry & processing. I have dual internet connection & power backup. I can do this work. Also i am interested in long term relationship. I look forward to hearing from you. Thank you for your consideration. Thanks,
$277 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi There, I have been working in MNCs as Reporting Specialist . I'm having 6 years of experience in preparing DashBoards in Excel. Very good in Excel formulae & Macros. Trained by New Horizon Institute which is located in US. I'll discuss more about my work culture and experience. My skype id : abdulrahman.8665 Thanks A
$333 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good day, I found your job post and I’m very interested in your project. I am hard working and results oriented professional and see to it builds a good relationship with my clients. I am very dependable, efficient, resourceful, computer savvy, highly organized and flexible with ability to multitask and meet changing deadlines. I have comprehensive computer skills in Microsoft Office Applications and in Admin and Finance. Adept in Data Processing and more for 12 years. I can process: 2 page document/hour 100data/hour (computation is based from 1000 data entries) Duration: 1 day, 10 hours/day Cost per line: $0.015 Cost per page: $0.75 Please take a look at my portfolio to get an idea of the kind of other projects I have developed in different format specially in Excel. I am committed to deliver best outcome to contribute for your project and can start work anytime as I take pride in my job and strive for excellence each and every day. Thank you for your consideration and looking forward to hear from you. Best, Abby Dedicated Freelancer
$250 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
With my working style: There will be a transparency in working Also a time to time update with a clear cut dead line.
$250 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir/Madam, I have done such tasks in my prior real life job, I have 5 year experience at HSBC bank as financial controller/analyst, I can do this task very fast and accurate as I am an excel guru(writing VBA macros). I will sign a Non Disclosure Agreement . Please consider my candidacy! Kind Regards
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 layout. It will be developed as per your requirement document. We would invite your feedback and suggestions on the selected format so as to make it exactly as per your requirements. The timeline for development is stated along with the bid. During development period, the site would be visible on one of our test servers. At the time of transfer of complete application to your control, we will send you complete code and documentation. We will provide a copy of complete site management manual. The total cost of the development is stated along with the bid. Sri Technocrat takes services of professionals in the fields of graphic designer, site management and programming. In order to provide best performance and in time, we accept milestone payment along with contract. We transfer all source codes, security protocols and password management to the client. We carryout site development in a modular form, so that and additional feature / facility can be added without disturbing the existing site. Thanking you for considering Sri Technocrat as a partner in development. With regards, Sri Technocrat
$789 USD in 30 days
0.0 (0 reviews)
3.8
3.8
User Avatar
A proposal has not yet been provided
$250 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Mumbai, India
4.8
12
Payment method verified
Member since Jul 6, 2012

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.