Dashboards based on data
Assistance is needed in setting up and creating dashboards (charts based on data that is added once a day)
Input:
The company has 4 different products
About 250 agents (clients)
About 10 managers handling clients.
About 30 currencies (countries)
It is necessary to compile all this into convenient, understandable dashboards. The data consists of several profitability indicators.
Dashboards are needed for monitoring profitability over time, so that one can timely orient themselves, find weak spots, and bring profitability to a normal level.
Initially, I envision this with several levels of dashboards:
1) A general dashboard, where one can see how profitability has fallen/risen across all products, clients, currencies. 2) In case we see a problem, it is necessary to have the ability to drill down into a specific product
3) And then drill down into specific countries/currencies, finding weak links.
Data is filled in daily, for now, it is Google Sheets.
It is necessary for the dashboards to be generated automatically based on the data in Excel (we can consider another option)
If Excel is preliminary, it consists of 2-4 separate tables
In which we update the data, and going into the dashboards, one can choose the desired level of depth and obtain the necessary charts.
The timeline in the charts is most likely needed to be weekly or monthly.
It is important not to overload with data and different tables, but to have a clear picture and convenient charts, through which one could quickly identify problem areas (currencies/products/clients) and track dynamics.
We tried to build it based on Google Sheets - but building charts in some cases lags, and when you start drilling down, the cell formatting gets disrupted. It is desired to understand the problem in 5-10 clicks. Easy, beautiful, clear.
-
Hello, I worked on the project "Performance Monitoring Dashboard," where I optimized the tracking of 300+ clients and 20 currencies per month. I created clear graphs for quick data analysis.
What specific data source do you plan to use going forward – will Excel remain the main one or are you considering other options?
I suggest we get in touch; I will consult you for free on the technical side and we will create a development plan + I will tell you about my team!
-
434 9 0 Hello. I propose to create a dashboard in Looker Studio linked to the existing GSheets table. For discussions, please write in private.
-
957 19 0 Good day!
I create dashboards in Google Sheets.
The data will be updated automatically when new data is added.
You can send the table, or part of the table with data, so I can demonstrate how to visualize your data.
Here are examples of my work:
https://fex.net/uk/s/nlfbt8m
-
172 1 1 Hello! I am ready to complete this project and have extensive experience in developing various applications.
-
2318 8 0 Good day, the project sounds quite interesting, I have extensive experience in implementing similar monitoring systems.
Are there any references of external dashboard views that could be used as a guideline to fully understand the style and functionality?
I am happy to discuss the project details and implementation, thank you.
-
6177 74 1 Good day. I have experience with dashboards for crypto exchanges, data updates very quickly, almost every 1-3 seconds. It can be faster.
Write to me, we will discuss the details, I will tell you about the project stack.
I will be happy to help.
-
1572 19 0 Good afternoon, I see the implementation of your task using the business analysis tool Power BI. I have extensive experience in creating dashboards with it. This tool will help implement convenient visualizations, ensure interactivity, and stability of operation. Since the tool does not break the structure and formatting of your Google Sheets, but only uses them as data sources.
-
446 10 0 Hello!
I propose to develop a convenient web service with Google Sheets integration, where you can visually obtain a chart based on specified criteria with flexible timeline selection. Analytics can also be added, which will immediately process data and identify potential weaknesses.
I have over 3 years of commercial experience in web development and can implement the specified case without any issues. For a more accurate assessment of timelines and costs, I suggest discussing the project details in private messages.
I look forward to collaborating!
-
567 28 2 Why complicate things? All of this can be implemented in Excel (selecting the necessary data, chart-diagram, options are discussed). Write to me and we will communicate.
-
231 Very interesting task, I would like to implement it, I have an idea and know how to make it convenient, write to me and we will discuss the details.
-
2937 73 4 2 Hello! I am ready to discuss possible solutions to your issue!!! Feel free to reach out!!!!!!
-
463 4 0 Good day! 👋
I am engaged in full stack development with a focus on backend.
I work with Django + DRF, FastAPI, and Flask, and I have over 3 years of commercial experience with these frameworks.
I also provide data parsing services of any complexity — from collecting basic data to automated monitoring systems.
I would be happy to communicate and offer my services.
You can view ready cases in my portfolio or at the link:
👉 https://devescrow.space/
-
124 Hello, I am a data analyst. I will create dashboards, let's agree on the details.
Current freelance projects in the category Data Parsing
Scrape the database and add it to the Telegram chatScrape the database from List.ua and add by numbers to the Telegram chat. The chat is about repairs and interior design. Data Parsing, Customer Support ∙ 23 minutes back ∙ 9 proposals |
It is necessary to develop a Telegram bot for monitoring cars from auctions in the USA (Copart, IAAI)A Telegram bot is needed for automatic searching and monitoring of "BUY IT NOW" cars at auctions in the USA (Copart, IAAI). The bot should operate automatically and send notifications about new cars that meet the specified filters.Main functionalityFilter settings: 1. Car… Data Parsing, Bot Development ∙ 7 hours 56 minutes back ∙ 59 proposals |
Parsing products, preparation for import to WPScrape the full catalog of these websites: https://svit-mebliv.ua/ https://kompanit.com.ua/ru https://amia.com.ua/ https://mebliromax.com.ua/ https://pehotin.com.ua/catalog/ https://www.sokme.ua/ru/ All products need to be combined into one general table for import into WP.… Web Programming, Data Parsing ∙ 3 days back ∙ 57 proposals |
A specialist in Telegram promotion is required.
28 USD
Tasks: invite real users from the username database to new chats and send messages to the target database. Only quality traffic and work with a live audience are of interest — performers using bots, fake engagement, or low-quality methods are requested NOT TO DISTURB. Work… Data Parsing, Social Media Marketing (SMM) ∙ 8 days back ∙ 9 proposals |
Consultation on parsing Instagram account subscribersHello. It is necessary to conduct a preliminary assessment of the feasibility of the following task. I have a list of Instagram accounts. The goal is to obtain contact information (primarily email addresses) of users who follow these accounts. Previously, I encountered companies… Data Parsing ∙ 11 days 19 hours back ∙ 13 proposals |