Лана

Lana Letodiani
Data Analyst
Data Analyst who's good at making sense of tricky data. I handle basic
data stuff like gathering and cleaning info. I want to use what I know to
explore data, predict things, and make easy-to-understand visuals. I
enjoy working with teams to solve problems using data and help
companies grow.

PROJECT EXPERIENCE
GA4 Data Extraction & Analysis Project: Year 2021 Insights
CONTACTS I created a Google Analytics 4 query to fetch data for the year
[открыть контакты](см. выше в блоке «контактная информация»). The query includes fields like event timestamp, user
[открыть контакты](см. выше в блоке «контактная информация») pseudo ID, session ID, event name, country, device category,
Linkedin source, medium, and campaign. Events encompass session start,
Telegram product view, adding a product to the cart, starting checkout,
Lviv, Ukraine adding shipping and payment information, and purchase

Conversion Optimization Initiative: Data Analysis and Visualization
HARD SKILLS During this project, I created tables for registrations, trial periods,
SQL and payments. I also developed graphs showing conversion rates
Python and average duration between registration and payment per
Probability Theory month. My tasks also involved creating funnel diagrams to
Mathematical Analysis visualize user steps and conversion rates, aiding in identifying
Linear Algebra optimization areas for enhancing user conversion.

Retention Analysis: Understanding User Engagement
TOOLS
Excel This project analyzes user activity within a game or application.
Using a pivot table, the retention rate is measured, indicating
Power BI
how long users remain active after initially using the product.
Amplitude
Additionally, data visualizations such as conditional formatting
BigQuery
are applied, and slices are added based on the game's title,
Google Analytics
activity type, and user language for further analysis.
Tableau
New User Revenue Analysis Dashboard
SOFT SKILLS This project creates a revenue analysis dashboard for new users
Accurate turned paying customers in specific months. It comprises three
Committed sheets: one for monthly revenue from new users, another for total
Determined revenue and its percentage changes, and a third for cohort analysis.
Flexible Filters for location and date facilitate analysis.

LANGUAGES EDUCATION
IT School "GoIT" Lviv Polytechnic National University
Ukrainian - Native Data Analysis Bachelor's degree in Applied
English - Upper-Intermediate December 2023 - April 2024 Mathematics (Financial Engineering)
2022 - 2026