build a dashboard

$30-250 SGD

Terminado

Publicado

hace más de 7 años

$30-250 SGD

Pagado a la entrega

To derive from raw data given by excel spreadsheet (attached) into a one-page information dashboard with visualized effects. If there is a way to auto populate with minimal manual intervention into dashboard as repeated process on a monthly or quarterly basis depending on new added or eliminated data from monthly excel spreadsheet. Objectives: 1. Sales pipelines - to identify key deals based on value of deals based on tier threshold (for example >$100,000; $100,000, $50,000-$99,999). Smaller deals <$50,000 with lower priorities for analysis (maybe a different segment on dashboard). Summarize into how many key deals, which markets, percentage based on total volume, market share, etc. 2. Product offering - identify and category into 7 key products and services, which markets offer which products, value of deals, etc. 3. Basic excel formula or graphs for easy updates. Updates based on new deals being added or deleted from previous month (how to identify this, etc.)

Analytics

Excel

ID del proyecto: 12740178

Información sobre el proyecto

7 propuestas

Proyecto remoto

Activo hace 7 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@telfordm

Hi, I am a Finance professional with over 15 years experience using Excel to provide business analysis and reporting. I can help you with your project. I would propose to provide tables and/or graphs to represent your data. Potentially even a Bing map to show products on global markets. I would set up all of these so that they automatically updated when new data is uploaded. (I would firstly like to understand how new data is uploaded? Is there a chance that a date indicator could be placed on each deal (i.e. when the opportunity first arose)?) In order to automate the data into thresholds / dates etc I would propose to set up a few more columns to identify each row into one of these groups. I would set up an admin page where these thresholds could be changed if desired. I welcome the opportunity to discuss your project further and to work with you. Regards Melanie

$140 SGD en 3 días

5,0

(3 comentarios)

2,4

7 freelancers están ofertando un promedio de $182 SGD por este trabajo

@ACMAuk

I am Chartered Management Accountant from Chartered Institute Of Management Accountants UK and CGMA from American Institute Of CPAs, having 6 years of professional experience in dashboard reporting as well as financial modeling. We can create an excellent, professional and functional dashboard as required, kindly provide further information so that we may proceed accordingly. Awaiting your kind response. Cheers, AHK

$250 SGD en 2 días

5,0

(118 comentarios)

6,3

@KavTan

Hi, I am a professional freelancer, and I can complete your task effectively and efficiently in a timely manner.

$250 SGD en 7 días

4,8

(23 comentarios)

4,2

@jssinfosys

I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have extensive experience and knowledge in corporate finance, accounting, financial statements, financial analysis, modelling, projections etc. So lets discuss this project in detail and start at your earliest convenience. I can guarantee you the best possible work in least possible price.

$155 SGD en 3 días

4,8

(9 comentarios)

3,8

@humayoonsheikh4u

A proposal has not yet been provided

$205 SGD en 4 días

4,8

(7 comentarios)

3,8

@muturi123

Dear Client, Are you looking for an honest, credible and reliable writer? Then welcome on board to one of the most professional writer. I have handled several papers of this kind and always leave a mark of satisfaction to my clients. I welcome you to join my long list of satisfied customers. More to that, I will handle your work within your deadline and budget without any disappointments. I always take my time to understand the project at hand and involve my client whenever any clarification is needed for the best results. I guarantee satisfaction and am sure we will work together in your future projects. Regards, Muturi.

$155 SGD en 3 días

0,0

(0 comentarios)

0,0

@cadeeptiarora

Hi I am a qualified finance professional with more than a decade of experience in working on similar assignments. I have designed multiple Dashboards and automated then within my organizations and can definitely help here as well. I have worked with multiple MNC's over the last 14 years and have recently entered the freelancing world. Look forward to speaking with you in more detail about the task. Thanks and Regards CA Deepti

$120 SGD en 4 días