build a dashboard
$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.)
Nº del proyecto: #12740178
Sobre el proyecto
7 freelancers están ofertando un promedio de $182 por este trabajo
Hi, I am a professional freelancer, and I can complete your task effectively and efficiently in a timely manner.
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
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