Анастасия Афонина

I work as a Data Analyst at a furniture retail chain, where I collect, clean, and structure data from multiple sources—removing duplicates and errors so decisions rest on reliable inputs. I focus on turning data into clear performance monitoring through KPI dashboards.

I automate monthly reporting in Excel using Power Query, pivot tables, and complex formulas, then connect numbers to outcomes via plan-vs-actual and factor analysis. I also run A/B tests end-to-end—from hypothesis and data collection to statistical significance and team recommendations.

On the technical side, I write SQL queries in PostgreSQL and MySQL (JOIN, GROUP BY, window functions, and CTEs), and I use Python with pandas and numpy to automate calculations and data cleaning. This combination helps me move from raw data to actionable insights faster and with fewer manual steps.

Before my analytics role, I spent 2.5 years in financial accounting, maintaining primary records and management reporting in Excel. That experience deepened my understanding of P&L structure, cost drivers, and financial processes, and I continue building my skills through data analysis and BI-focused courses.