I need dynamic visualisation of excel data
- or -
Post a project like this€100(approx. $108)
- Posted:
- Proposals: 24
- Remote
- #1234301
- Expired
100777313561551343845134083613358161331867132589713101271285157126714012373831228050
Description
Experience Level: Expert
Industry: Business
Description of excel work: I have a big data set regarding sales, volumes, prices for different categories of products per year and per countries. In order for me to analyze trends and understand what's going on, I need to be able to visualise this data dynamically in excel trough graphs (graphs where I can select countries, products, sum of a selected set of products, etc...)
I'm therefore looking for someone capable of building comprehensive dynamic graphs:
- Sales for categories of products by country per year (for products I select, countries I select, etc...)
- Sales per category of products per quarter
- Price / Volume / Mix
- Other graphs with dynamic selection of variable so I can analyse the sum of a selected number of products for a specific country, etc...
I do think that Pivot table or/and VBA might be required.
Design and target audience: Personnal Analysis
Extra notes: I'm already quite fluent in Excel so I'm really looking for advanced data visualisation here.
The Data of the sample spreadsheet is basically structured as the final product but the figures are random ones
I would appreciate a sample of what you can propose in Excel. Because the data of the sample spreadsheet attached will basically be structured the same way, this will provide me with a good idea of what you can achieve.
Description of excel work: I have a big data set regarding sales, volumes, prices for different categories of products per year and per countries. In order for me to analyze trends and understand what's going on, I need to be able to visualise this data dynamically in excel trough graphs (graphs where I can select countries, products, sum of a selected set of products, etc...)
I'm therefore looking for someone capable of building comprehensive dynamic graphs:
- Sales for categories of products by country per year (for products I select, countries I select, etc...)
- Sales per category of products per quarter
- Price / Volume / Mix
- Other graphs with dynamic selection of variable so I can analyse the sum of a selected number of products for a specific country, etc...
I do think that Pivot table or/and VBA might be required.
Design and target audience: Personnal Analysis
Extra notes: I'm already quite fluent in Excel so I'm really looking for advanced data visualisation here.
The Data of the sample spreadsheet is basically structured as the final product but the figures are random ones
I would appreciate a sample of what you can propose in Excel. Because the data of the sample spreadsheet attached will basically be structured the same way, this will provide me with a good idea of what you can achieve.
Abel R.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
7 May 2024
France
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies