Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak

Mykola Y.

Offer Mykola to work on your next project.

Ukraine Kyiv, Ukraine
3 hours 16 minutes ago
A little busy a little busy
14 Safe completed
4 months 28 days ago
13 Clients
added 2 bids
registered for 1 year

Rating

Successful projects
100%
Average rating
10 of 10
Rating
1155
Databases
Data processing
8 projects
Data processing
5 projects
Databases
2 projects
Application programming
2 projects
Data parsing

Language Proficiency Level

English 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

Services

Portfolio


  • 82 USD

    RFM segmentation of customer base

    Databases
    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.
  • 204 USD

    Goods Analysis

    3D modeling and visualization
    Analysis of goods matrix
  • 408 USD

    Sales Analysis

    Data processing
    Full sales analytics based on the client's CRM.
  • 408 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

Quality
Professionalism
Price
Availability
Terms

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!

Quality
Professionalism
Price
Availability
Terms

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 51 USD
Voting

Quality
Professionalism
Price
Availability
Terms

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 15 USD
Зміна формату запису аналогів

Quality
Professionalism
Price
Availability
Terms

Fast and quality.

7 April 2023 82 USD
Specialist in Data Analysis

Quality
Professionalism
Price
Availability
Terms

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 20 USD
The Excel + Dashboard

Quality
Professionalism
Price
Availability
Terms

Good expert, pleasant to communicate as a person with a person, no pain no problems!

13 December 2022 31 USD
Create a template for Excel tables

Quality
Professionalism
Price
Availability
Terms

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

Quality
Professionalism
Price
Availability
Terms

The task was done quickly and efficiently, I recommend this freelancer.

20 November 2022 10 USD
Excel Pivot tables

Quality
Professionalism
Price
Availability
Terms

I turn not for the first time. Communication, as always, is clear. Exercise at a high level and timely.

21 July 2022 13 USD
Excel

Quality
Professionalism
Price
Availability
Terms

The task is performed quickly. Communication is effective.

Quality
Professionalism
Price
Availability
Terms

The task was completed fully and before the deadline.

Quality
Professionalism
Price
Availability
Terms

Everything is fast and in time.

17 May 2022 15 USD
Small Excel data analysis: table compiled and 2-3 previews

Quality
Professionalism
Price
Availability
Terms

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 20 USD
Read the Excel table.

Quality
Professionalism
Price
Availability
Terms

The young man performed the job as he promised quickly and clearly!

Activity

  Recent proposals 10
Data table formatting and RFM analysis
41 USD
Power Query and Excel
20 USD
The KPI Excel Personal project
20 USD
Consultation Personal project
13 USD
Creating dashboards and analytical reports in the form of graphs and diagrams
13 USD
Freelance-project
178 USD
Freelance-project
Freelance-project
Freelance-project
Freelance-project