Mykola Y.
Private message 
Offer work 
Kyiv,
Ukraine
a little busy
Rating
Language proficiency level
English: pre-intermediate
CV
Key information:
- Over 20 years of experience in IT.
- Data Analytics in Excel and Power BI (Power Query, Power Pivot, DAX)
- Higher engineering education, additional courses in management, marketing, economics and analitics
- Optional SQL, Python, Google Sheets
I carry out projects on ABC-, XYZ-, RFM-analysis of product and customer bases, marketing reports, converting tabular reports from Excel and ERP into friendly reports in Power BI, analyzing the quality of work of sales managers, visualizing the results of surveys of internal staff and customers, etc. P.
Help with complex information processing in Excel, Google Sheets
Modeling, calculations, visualizations and analytics in Power BI
Information for cooperation:
- Base rate 600 UAH/hour
- For projects with a guaranteed duration of 20 hours or more, the rate is 480 UAH/hour (12.5USD)
- Hourly and piecework payment (by agreement)
- For projects - it is possible to draw up a preliminary estimate for the stages of implementation
- -20% discount for posting your project in my public portfolio* (only for new projects)
- Without your consent, no data and results of our joint work are subject to disclosure or publication.
Skills and abilities
Programming
-
Databases & SQL
from 14 USD for hour
Services
-
Data Processing
from 14 USD for hour
- Online Stores & E-commerce
Promotion
-
Marketing Research
from 14 USD for hour
Portfolio
-
72 USD RFM segmentation of customer base
Databases & SQL
On the basis of the company’s sales data for several years, the RFM-segmentation of the active customer base has been produced on the indicators of regularity of purchases, their lasting time and total accumulative value, the VIP and profitable customers segments have been distinguished, the company’s potentially leaving and sleeping customers have been found, requiring diversified marketing interaction.
Additionally, a map of the history of the company’s interaction with its customers was built, time intervals of losses and customer returns to the company were found, the structure of revenue was found on the firm’s permanent (loyal) and unstable customers.
-
180 USD Goods Analysis
3D Modeling
Analysis of goods matrix
-
361 USD Sales Analysis
Data Processing
Full sales analytics based on the client's CRM.
-
361 USD Analysis of Online Shop Sales
Data Processing
Complete analysis of the online store sales based on file downloads from the CRM client
Reviews and compliments on completed projects 14
31 October 2023
469 USD
Building the company’s analytical dashboard system (Power BI)
We thank you for the great work on our project! You really impressed us with your professionalism, creativity and dedication to the task.
You have demonstrated a high level of expertise in your industry, thoroughly exploring our needs and providing us with valuable tips and ideas to improve the project. You have always been available to communicate and always followed instructions timely.
The results even exceeded our expectations. Dashboards look professional, functional and are convenient and easy to use.
If you need a reliable and talented person for a similar project, it's your choice. We plan to cooperate with Mykola and in the future and sincerely recommend it as a high-quality specialist. Thank you again for your classwork!
|
8 August 2023
150 USD
Making macros for Excel and developing Power bi
More than pleased, I was pleased to work with Nicholas, I hope for further cooperation. On the 10 ball scale, he deserves at least 12 in all parameters.
|
6 June 2023
45 USD
Voting
I am very pleased with the work of Mikhail Yogorov. He got hard because of the customer, because of not a clearly formulated task, but he managed greatly and I got the result I wanted. Thank you for your patience and professionalism.) Not everyone wanted to take this job and I also chose it.
Mikhail put his part of his life, not much or little, in the democratization of Ukraine. A great thanks!
She was always confident in the talents of the Ukrainians. They just don’t need to be disturbed.)
May Happiness!
18 May 2023
14 USD
Зміна формату запису аналогів
Fast and quality.
7 April 2023
72 USD
Specialist in Data Analysis
I recommend the executive, a skilled approach to the task, everything is done in time. He also solve the issues arising in the course of the project.
14 February 2023
18 USD
The Excel + Dashboard
Good expert, pleasant to communicate as a person with a person, no pain no problems!
13 December 2022
27 USD
Create a template for Excel tables
Good work, accomplished the task according to the TZ, we will continue cooperation on the next projects
6 December 2022
9 USD
Data processing in Excel file
The task was done quickly and efficiently, I recommend this freelancer.
20 November 2022
9 USD
Excel Pivot tables
I turn not for the first time. Communication, as always, is clear. Exercise at a high level and timely.
21 July 2022
11 USD
Excel
The task is performed quickly. Communication is effective.
7 June 2022
14 USD
Table processing and data consolidation
The task was completed fully and before the deadline.
29 May 2022
19 USD
POWER BI יהוה Database Laborator
Everything is fast and in time.
17 May 2022
14 USD
Small Excel data analysis: table compiled and 2-3 previews
It’s okay, but it’s a little delayed and therefore the task has lost relevance to the moment of receiving the executed files.
19 April 2022
18 USD
Read the Excel table.
The young man performed the job as he promised quickly and clearly!
