build a dashboard

Completado Publicado hace 7 años Pagado a la entrega
Completado 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

Nº del proyecto: #12740178

Sobre el proyecto

7 propuestas Proyecto remoto Activo hace 7 años

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 y Más

$140 SGD en 3 días
(3 comentarios)
2.4

7 freelancers están ofertando un promedio de $182 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 Más

$250 SGD en 2 días
(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
(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 extens Más

$155 SGD en 3 días
(9 comentarios)
3.8
humayoonsheikh4u

A proposal has not yet been provided

$205 SGD en 4 días
(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 satisfac Más

$155 SGD en 3 días
(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 hel Más

$120 SGD en 4 días
(2 comentarios)
0.0