Mykola Y.
Private message 
Offer work 
Kyiv,
Ukraine
available for hire
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
Programming
-
Databases & SQL
from 14 USD per hour
Services
-
Data Processing
from 14 USD per hour
- Online Stores & E-commerce
Promotion
-
Marketing Research
from 14 USD per hour
Portfolio
-
77 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.
-
193 USD Goods Analysis
3D Modeling
Analysis of goods matrix
-
386 USD Sales Analysis
Data Processing
Full sales analytics based on the client's CRM.
-
386 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
501 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
48 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
77 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
19 USD
The Excel + Dashboard
Good expert, pleasant to communicate as a person with a person, no pain no problems!
13 December 2022
29 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
10 USD
Data processing in Excel file
The task was done quickly and efficiently, I recommend this freelancer.
20 November 2022
10 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
12 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
20 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
19 USD
Read the Excel table.
The young man performed the job as he promised quickly and clearly!
Activity
| Recent proposals 10 | Budget | Added | Terms | Proposal | |
|---|---|---|---|---|---|
|
Create interactive dashboards in Power BI
19 USD
|
|||||
|
I have a large Excel spreadsheet, I need to display everything in beautiful charts in Power BI.
80 USD
|
|||||
|
Visualization in PowerBi
14 USD
|
|||||
|
Projects using BI segment tools
362 USD
|
|||||
|
Dashboard creation
500 USD
|
|||||
|
Working with Excel spreadsheets
39 USD
|
|||||
|
Accounting of raw materials, products, and finished goods
96 USD
|
|||||
|
Product analyst
45 USD
|
|||||
|
Build a report on customer LTV
39 USD
|
|||||
|
From the Excel file of 731 thousand cells-rows, compile a file for upload.
19 USD
|