build a dashboard

$30-250 SGD

Abgeschlossen

Veröffentlicht

vor mehr als 7 Jahren

$30-250 SGD

Bezahlt bei Lieferung

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

Projekt-ID: 12740178

Über das Projekt

7 Vorschläge

Remote Projekt

Aktiv vor 7 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@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 in 3 Tagen

5,0

(3 Bewertungen)

2,4

7 Freelancer bieten im Durchschnitt $182 SGD für diesen Auftrag

@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 in 2 Tagen

5,0

(118 Bewertungen)

6,3

@KavTan

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

$250 SGD in 7 Tagen

4,8

(23 Bewertungen)

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 in 3 Tagen

4,8

(9 Bewertungen)

3,8

@humayoonsheikh4u

A proposal has not yet been provided

$205 SGD in 4 Tagen

4,8

(7 Bewertungen)

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 in 3 Tagen

0,0

(0 Bewertungen)

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 in 4 Tagen