The Excel + Dashboard
18 USD 1) Date 2) Region 3) City 4) No store 5) Store format 6) Store address 7) Subsidiary 8) Product category 9) Price per unit 10) Volume 11) Export amount 12) T.O.13) The share of the amount of the exchange % from T.O.The task.Create a table that can filter:
1) Contractors - by date (year, quarter, month), regions, cities and shops under this quarter, average price (year, quarter, month), product category, total volume, total amount of exchange (year, quarter, month).2) Regions - by date (year, quarter, month), cities and shops, suburbs, average price (year, quarter, month), product category, total volume, total amount of exchange (year, quarter, month), average share % of the price.3) Shop - according to the date (year, quarter, month), subjects, average price (year, quarter, month), product category, total volume, total amount of exchange (year, quarter, month), average share of % of the product.The Dashboard:
Price rating (depending on product category), volume
Regions rate by volume, exchange amounts, and the total average share of % from the region.Ranking of stores depending on format by volume, exchange amounts, and the overall average share % of the
You can see the example of the task at https://www.youtube.com/watch?v=j2YIAEmRpQs&t=221s
Applications 1
Client's review of cooperation with Mykola Y.
The Excel + DashboardGood expert, pleasant to communicate as a person with a person, no pain no problems!
Freelancer's review of cooperation with Oleksandr Oleksandrovich
The Excel + Dashboardinteresting tasks. the operational connection. Payment according to agreements.
I recommend it.
-
1 day18 USD
345 22 0 1 day18 USD
Hello to you. Ready to perform the task. I will be happy to cooperate. turn to
-
2 days22 USD
2 days22 USD
Good day !
I’m working with these tables for more than a year, I can start working all now!
-
4 days45 USD
176 4 days45 USD
Data on cities will need to look at the possible duplicates of the city or will need to geocodate if it is small cities
-
2 days11 USD
108 2 days11 USD
Good morning, a confident user with Excel tables and ready to help you.
-
Winning proposal1 day18 USD
928 14 0 Winning proposal1 day18 USD
Good Morning, Alexander
I will make this project for you. Examples can be seen in Portsmouth.
You can do this in Power BI.
Turn to
-
3 days45 USD
1134 38 0 3 days45 USD
Good day
I can make the Dashboard you need. The possibility of performing some functions as a video will depend on your Excel version. I can also do in Power BI in its free version.
-
1 day13 USD
412 7 0 1 day13 USD
Good day . A confident user of Excel. I have great experience in performing this kind of tasks (sized tables, dashboards, etc.) . I’m happy to cooperate.
-
2 days11 USD
3106 93 2 1 2 days11 USD
Good day .
I can do this project.
Before accepting the bet, I would like to look at the volumes.
The budget of the project is low.
-
1 day11 USD
3668 107 0 1 day11 USD
Interesting task!
Can you show the tables?
So it will be easier to assess the hardness of the work and call the price.
-
1 day45 USD
1539 34 0 1 day45 USD
the good.
Go back, I will do it.
It is necessary to clarify details, such as:
- how many of the listed tables will be convenient to analyze - depends on the number of data (members / stores / range)
- what graphs (desktop) you want to see - from the "stack" to the "live map" (this depends on the time and cost of the work)
- the quality of the input data - whether they should be directed to the analysis.
Specialization: Management Accounting.
Production - Design - Sales - BD - Finance - Analysis.
… Experience working with Excel over 20 years, working with Google Sheets, Google Data Studio (Looker Studio), Power BI.
Tables, formulas, UO systems (management accounting), scripts (VBA, gs) - everything.
The price is conditional.
Current freelance projects in the category Databases & SQL
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 5 hours 55 minutes back ∙ 2 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 21 hours 1 minute back ∙ 7 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 5 days 20 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 6 days 7 hours back ∙ 6 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 9 days 14 hours back ∙ 16 proposals |
Kyiv