Igor Z.
Rating
Skills and abilities
Design & art
Services
Administration
Outsourcing & consulting
Writing
Portfolio
- All works 26
- Javascript and Typescript 1
- System & Network Administration 2
- Content Management 1
- Presentations 1
- Data Processing 21
-
WEB interface for downloading files based on Google tables
Data ProcessingScenario of work:
The interface receives xlsx files and csv files.
If the file is successfully downloaded, the information message about the successful completion of the script will be displayed / if failure, the error code will be displayed.
The file is converted from csv or xlsx to Google tables format and is stored on the Google disk.
… Each stored file contains transaction information and after the file is uploaded to the Google disk, all information will be uploaded to the archive file to which only those transactions that are not yet there will be added.
-
Dashboard survey analysis
Data ProcessingWhat was done?
Adaptation and modification of data structure (preparation for reporting)
- Extraction of key indicators (heat map, pie charts, histogram, filters)
Design of the project
-
Tracker of orders. Send notifications to Telegram from Google tables
Javascript and TypescriptImplementation of production chain:
Step 1 – Payment of the Order
Phase 2 - Transfer to production level 1
Phase 3 - Transfer to production Level 2
… Phase 4 - Logistics
Step 5 – completion of the order
Each of the stages is accompanied by PUSH notifications to the telegram group by chatbot means.
-
CRM based on Google Sheets for the mattress factory
Data ProcessingThe implementation of the project was done using Google App Script, Formula and SQL.
What was implemented:
Formation and modification of orders
… Tracker of orders
Chatbot (Statistics of Order)
Delivery of Production Orders
Control of Payment
-
Table and Dashboard for the restaurant
Data ProcessingProject for restaurant business.
What was done?
… A set of tables that includes:
Imported by R-Keeper
- Storage with an automatic product list (the complexity of the magazine consisted in the fact that one product consists of several under goods, and the subcharges can consist of subcharges, for example pizza consists of tomatoes, cheese, test and sauce, and those in turn consist of other ingredients)
Interchange between warehouses (buy, kitchen, etc.)
Introduction of Accounting
The Dashboard Complex which includes:
Complete analysis of sales
Cash and accounts in real time.
Control of warehouses in real time
-
API integration of Binotel with Google tables and Google Data Studio
Data Processing- API integration of Binotel with Google Sheets
Creating Dashboards in Google Data Studio
-
Dashboard with API integration in Google Data Studio
Data ProcessingConnectors of WhatsApp, Facebook, CRM
- Blended data for the combination of charts (reference by order with CRM and Facebook advertising campaign costs)
- Dashboards of high-end loading hours (applications / messengers / instagram)
Key indicators (the average check/the number of orders, etc.)
-
Set up the annual report in Google Data Studio
Data ProcessingHeat maps for regions
Reporting for cities and companies
Reporting on sales channels
The main indicators of the company
… Filtering is arranged
Changed data structure
-
Players statistics based on Google Data Studio
Data ProcessingScripts for sorting and archiving
- Changed the structure of the tables, reduced from 5 to one
- Reduced the number of manual processes, previously it was necessary to add information on each player and then archive and clone to other tables, now the information is added to one register and archive
Dashboard and Filters
-
Reporting the submission of documents in Google tables
Data ProcessingChanges to the structure of the table
Created script for automatic dating when clicking on the Checkbox
A table with schedules for submission of documents.
Monthly Diagrams
-
Table and Dashboard Complex for Taxi Company
Data ProcessingTwo work areas under two business schemes based on Google Spreadsheet
A model for calculating the period of repair of the car
Configuration of data imports
Set scripts for archiving data
… Scripts are set for interdependent lists
Automatic debt transfer on the car park
Calculation of the company’s main indicators
- Created interactive Dashboards on Google Data Studio
Corporate colors are applied in reports and tables.
-
Sales Report based on Google Data Studio
Data ProcessingData collected and ordered by the company for a year
Custom imports from the client tables to the general table to form current and future reports
Filters are set by date range, goods and traffic type (pay / free)
- Created Dashboard with Diagrams and Tables
…
You can see more in detail by going through the link. Modified data is used in the report.
-
Dashboard for Data Studio Sales Site
Data ProcessingFormation of the report structure
Loading and optimization of data
Creation of Filters
Creating interactive tables
-
Table for monitoring project tasks
Data ProcessingTable for communication team on tasks:
Create the structure of the table
Rules for sending reports
- Settings of triggers for sending reports to the mail (by change, time and days)
… Create a script for sending notifications (html, javascript)
-
Administration of the site
Content ManagementPayment instruments (credit, online payments)
Neaming and unique SKU codes
Complete the characteristics of SKU
Adding prices to SKU
… Create a description of SKU
Settings of work schedule and delivery methods
Configuration of YML and Excel
Adding goods in manual mode and using a file
Reviews and compliments on completed projects 43
22 October 2025
70 USD
Looker Consultation
Very productive consultation! Igor is attentive and deeply engages with the issues. I will process the information, but if additional questions arise, I will definitely reach out to Igor!
![]()
30 October 2024
56 USD
Data Visualization Consultation
Everything was clear and on time. Thank you for the consultation.
![]()
15 March 2023
68 USD
Reporting and financial structure in Google tables
Specialist in his business. He performed all the tasks set in time and in good quality. I will definitely ask for help.
![]()
9 March 2023
68 USD
Statistics in Looker Studio
A great specialist! Speed, feedback, quality of the work done – all at the highest level! In the future, I will definitely contact you again!
![]()
3 March 2023
135 USD
Analysis Journal of Exchange Trading Statistics on Binance in Excel
Another work, another success! A skilled, initiative specialist! We work with him further!
![]()
1 March 2023
95 USD
Interface for block analysis of stock exchange statistics
Excellent specialist with experience and initiative in cutting up improvements and looking for the optimal solutions when performing the task. I recommend and will continue to work with this person.
![]()
4 October 2022
9 USD
On the basis of two documents of 60+ thousand fields, you need to combine the same
Everything is clear and quickly according to the task.
27 September 2022
7 USD
Working with Excel data
Everything is done clearly and quickly!
23 September 2022
113 USD
The CRM Excel
The work was done well. I will contact more.
21 September 2022
113 USD
Excel Development (Bitrix 24 replacement)
Of course one of the best actors I’ve had to do with!!!The !
This was the first time I didn’t even write TZ- game I just understood everything and the main thing I remembered correctly after a simple telephone conversation. There were various options for implementation, as well as strong recommendations. The game was always on contact + the project was submitted before the declared deadlines. A very decent and responsible executive, I hope for further cooperation. Take care of your time, nerves and money, go here without any doubt!
26 August 2022
11 USD
Google Data Studio Consulting
Excellent consultation on Google Data Studio, all the problems were solved, Igor answered nf all the questions that interest me. I recommend cooperation!
16 August 2022
16 USD
Formulas in the Google Table
Thank you, everything went well, everything was done even better than it was in tz.
![]()
15 August 2022
10 USD
Writing formulas in the Google Task Table
Everything went great, fast professional work, pleasant communication, I will cooperate in the future, thank you
12 August 2022
14 USD
Google Sheets - Filtering data from the CSV file
Thank you for quick and good work.
![]()
31 July 2022
27 USD
[DS] Configuring a report in Google Data Studio
Great work, we continue cooperation.
23 July 2022
9 USD
Google Data Studio – Learn how to create a report
Thank you for the consultation,
Everything is good!
![]()
21 July 2022
9 USD
Google Data Studio – Learn how to create a report
Everything is fine, everyone is happy.
They made another important dashboard for the portfolio and created a new dashboard for Google Analytics visualization.
I am satisfied, I recommend!
![]()
19 July 2022
9 USD
Google Data Studio – Learn how to create a report
Thank you for great advice and extra time.
I made two deals, very pleased!
I recommend !
![]()
19 July 2022
45 USD
SEO report by GDStudio
Work strictly on the delays, attention to the details, fast communication. I recommend the executive!
![]()
16 July 2022
9 USD
Google Data Studio – Learn how to create a report
A wonderful consultation,
All planned tasks are resolved.
Thank you !
![]()
14 July 2022
68 USD
Processing of data in Excel
Igor in the literal sense of the word saved our project in the last days, as the state of health was unable to share 100%. The performers are distinguished by efficient communication, professionalism, high technical skills. I strongly recommend it to your team. I’m going to go to the game without any thought.
![]()
12 July 2022
33 USD
Google Spreadsheets, Part 2
Thank you for the work, done well.
![]()
| Personal | Response review
12 July 2022
27 USD
Google Sheets + Data Studio - Report by Table
I am happy with work. I recommend
9 July 2022
65 USD
[Fin] Google Spreadsheets adds two tables to one report
Great work, done very quickly and quickly.
9 July 2022
9 USD
Google Data Studio – Learn how to create a report
OK, thank you for understanding!
![]()
6 July 2022
9 USD
Google Data Studio – Learn how to create a report
Thank you for the wonderful consultation!
Igor answered all my questions.
Together we built the desired board.
I am very pleased with the result, I recommend the game to cooperate!
![]()
3 July 2022
9 USD
Google Data Studio – Learn how to create a report
Everything is good,
Thank you for the consultation.
![]()
12 June 2022
9 USD
Exel formulas
Thank you, everything is done as agreed.
![]()
9 June 2022
23 USD
Bonus to work.
Thank you for work, everything is fine.
![]()
| Personal | Response review
9 June 2022
36 USD
Create Dashboards
Excellent work, very responsible attitude to order
![]()
| Personal | Response review
5 May 2022
11 USD
Dashbord's creation in Google Data Studio
Everything is great, very pleased. We work further!
![]()
20 April 2022
9 USD
You need to link the data in Excel with the VPR function
The expert did everything as it was necessary.
19 April 2022
5 USD
Changes in Data Studio
The executive once again me in the work. It’s done as usual at 5+. We work further.
18 April 2022
7 USD
Доработка скрипта 8
Everything was finalized in the shortest possible time.
![]()
16 April 2022
23 USD
Analysis of sales and the construction of a heat map
The youth has done more than he has promised and has succeeded. I will contact him later.
13 April 2022
5 USD
Set the Excel table.
Thank you very much for the help! The project was completed very quickly and with explanations about the formulas. Thank you for work!
10 April 2022
23 USD
Перенос данных в Google Data Studio
I liked the work. Enchanted by the executive. Everything is done in the shortest time possible.
I recommend cooperation!
![]()
6 April 2022
16 USD
Macro or Excel / Google Sheet
Everything was done quickly, satisfied with the result.
5 April 2022
63 USD
Автоматически расчет заработных плат по сотрудникам
Thank you very much at the highest level.
![]()
30 March 2022
37 USD
Доработка Exsel
Again I called to Igora for help, I did everything at the highest level, thank you very much.
![]()
26 March 2022
23 USD
Creating a CRM for the car park
✅I recommend !Everything was done very professionally and even more than I expected.
14 March 2022
9 USD
Statistics of players in Google tables
The project was completed perfectly, without orders and in the shortest possible time. The execution is always in communication, offering different methods of solving one task. I strongly recommend this executive to work. We will work again!
13 March 2022
7 USD
Google Excel Sheets / Google Excel Sheets
The task was closed in the shortest time possible. Everything is great. Pleased with cooperation. A very talented artist.
Activity
| Latest proposals 10 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Automation of Google Sheets (processing reports from Rozetka + formulas)
28 USD
|
|||||
|
Looking for experienced developer
5000 USD
|
|||||
|
Looker Consultation
70 USD
|
|||||
|
SmartStock
|
|||||
|
Setting up Google Sheets for search
23 USD
|
|||||
|
Need a consultation
|
|||||
|
Consultation on analytics for e-commerce
92 USD
|
|||||
|
CRM in Google Sheets
45 USD
|
|||||
|
Creating and formatting a table in Excel based on data from a text file
200 USD
|
|||||
|
Price List of Liquids
|