← Back to list
Registration: 30.09.2026

Liliya Kanatova

Specialization: Data Analyst
Data analyst with hands-on experience in SQL, Python (pandas), Power BI and Excel. I clean and analyse data, spot trends and anomalies, and turn findings into clear recommendations. Previously worked in fast-paced operations, making decisions under time pressure. Keen to bring a careful, data-driven approach to product quality.
PostgreSQL Python SQL Power BI Data Analysis Excel Excel VBA ETL NumPy pandas Matplotlib VS Code Jupyter
Data analyst with hands-on experience in SQL, Python (pandas), Power BI and Excel. I clean and analyse data, spot trends and anomalies, and turn findings into clear recommendations. Previously worked in fast-paced operations, making decisions under time pressure. Keen to bring a careful, data-driven approach to product quality.
PostgreSQL Python SQL Power BI Data Analysis Excel Excel VBA ETL NumPy pandas Matplotlib VS Code Jupyter

Portfolio

Marketing Campaign Analysis | Excel

● Cleaned a dataset of 2,236 customers in Power Query: handled missing values, removed outliers, and created derived metrics (age groups, income segments, total spend) ● Found that responders spend twice as much as non-responders (€987 vs €539), and that Campaign 2 reached only a 1.3% response rate vs. a 7% average – defining the most responsive segments

Sales & Customer Dashboard | Power BI

● Built a Star Schema data model with 8 tables, a custom date table, and DAX measures using TOTALYTD, SAMEPERIODLASTYEAR, CALCULATE, and TOPN ● Found that Classic Cars generated 40% of revenue and that revenue grew 36% year-on-year; flagged 11 products at critical stock risk and two VIP customers driving a disproportionate share of profit

Delivery Service Metrics Analysis | SQL / PostgreSQL

● Wrote 15 SQL queries using CTEs, window functions, and subqueries to calculate DAU/WAU/MAU, ARPU, ARPPU, AOV, cancel rate, and courier efficiency ● Found that returning users generate a growing share of revenue, that Saturday has the highest ARPU and ARPPU, and that cancel rate does not increase during the 19:00–20:00 peak

Skills

Excel
PowerBI
PostgreSQL
Python

Work experience

Senior Front Desk Administrator
07.2024 - 07.2025 |Hotel Nacional 5*
Opera PMS, Excel, CRM
● Oversaw up to 100 check-ins and 100 check-outs daily, tracking room statuses, bookings and payments ● Resolved a 7-room overbooking: analysed room inventory, identified rooms that could be restored quickly after repairs, coordinated fixes with engineering and anticipated no-shows ● Coordinated several processes at once with engineering, housekeeping, reservations and other departments, making decisions under tight deadlines and incomplete information ● Raised loyalty-card sales by 10% (hotel became #1 in the chain; repeatedly the top administrator); promoted to Senior after 6 months and trained new staff
Sales Department Intern
05.2024 - 07.2024 |TEXA
Bitrix24 CRM, Excel
● Maintained customer contacts, preferences and history in Bitrix24 in a consistent format ● Checked cards for duplicates and inconsistencies before edits and merges to keep the base accurate

Educational background

Master’s in Tourism Direction and Planning (Masters Degree)
2025 - 2026
University of Alicante (Universidad de Alicante)
Data Analyst (Professional Retraining) (Bachelor’s Degree)
2024 - 2025
Moscow State University of Transport
Bachelor’s in Foreign Trade Management (Bachelor’s Degree)
2021 - 2025
Russian Foreign Trade Academy

Languages

SpanishUpper IntermediateEnglishUpper IntermediateRussianNative