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

Vitalii Svyatoshenko

Offer Vitalii work on your next project.

Ukraine Kyiv, Ukraine
10 months 11 days back
Available for hire available for hire
on the service 1 year
Freelancer Vitalii S. — Ukraine, Kyiv. Core skill — Databases & SQL, Articles & Blog Posts

Rating

Successful projects
No data
Average rating
No data
Rating
174
Databases & SQL
361 place out of 1215
Articles & Blog Posts 2
785 place out of 3284

Skills and abilities

Programming

Writing

Portfolio


  • Analysis of user activity and variability Variability +

    Databases & SQL
    Analysis of user activity and variability Variability + — example of freelancer's portfolio work in category Databases & SQL
    Calculated key indicators of user age variability:
    Average age
    Standard deviation
    Median
    … Interquartile range
    10th and 90th percentiles
    Conducted user engagement assessment:
    Counted DAU (Daily Active Users)
    Counted WAU (Weekly Active Users)
    Calculated Stickiness (DAU/WAU)
    Implemented calculations using COUNTUNIQUE, COUNTIFS, SUMIF, COUNTIF, WEEKDAY

  • Analysis of gaming metrics in Google Sheets

    Databases & SQL
    Calculated key metrics for games: Total Revenue, Paid Users Count, CR to Paid, ARPPU, average/median/minimum/maximum age of paying users.
    Built a summary row with Total metrics.
    Written analytical conclusions and hypotheses regarding the reasons for differences in user behavior.
    Identified possible reasons for low conversion to payers and differences in ARPPU between games.
    … Formulated recommendations for improving game monetization.
    Tools and approaches: #GoogleSheets, formulas SUMIF, COUNTIF, AVERAGEIF, logical functions, table formatting.

  • Company Income Analysis

    Databases & SQL
    An interactive dashboard has been created for visualizing the company's key financial indicators.
    Graphs of revenue dynamics over periods have been built.
    Revenues across different product categories and regions have been compared.
    Filters for flexible analytics (e.g., by countries or subscription types) have been added.
    … Trends and anomalies have been visualized.
    Goal:
    To help the business quickly assess sales performance, identify strengths and weaknesses, and make informed decisions based on data.

  • Time of play and user analysis

    Databases & SQL
    Time of play and user analysis — example of freelancer's portfolio work in category Databases & SQL
    Calculated key metrics for games: Total Revenue, Paid Users Count, CR to Paid, ARPPU, average/median/minimum/maximum age of paying users.
    Built a summary row with Total metrics.
    Written analytical conclusions and hypotheses regarding the reasons for differences in user behavior.

  • Key metrics of the subscription model for the mobile application

    Databases & SQL
    Key metrics of the subscription model for the mobile application — example of freelancer's portfolio work in category Databases & SQL
    Developed an interactive analytical dashboard in Tableau for visualization and analysis of financial metrics of a SaaS product. The main goal is to track revenue dynamics, the number of paying users, and the average revenue per paying user (ARPPU) over time, by product, and geography.

Activity

  Latest proposals 2
Proposal Personal project
Financial report in Excel
56 USD