Assortment Matrix Optimization 2026: Category Roles and SKU Rationalization
Category roles, the 80/20 rule, tail-cut analysis and demand transference — how to build a defensible assortment matrix instead of relying on buyer memory.
Isachenko Andrii
I'm Data Analyst
About
Andrii Isachenko
Data Analyst | Open to work
Summary
Data Analyst with experience in analyzing complex datasets and transforming data into actionable insights. Proficient in Excel, Google Sheets, SQL, and basic Python (Pandas, NumPy), with hands-on experience in data visualization using Looker, Tableau, and Power BI. Motivated to grow in data analytics and support data-driven decision-making.
- Location: Ukraine
- Work format: Remote
- Employment: Freelance, Part-time
- Resume: My resume (ATS)
Skills
Skills of working with data at all stages: collection, cleaning, analysis, visualization and automation of reporting using SQL, Python and BI tools.
Excel / Sheets 90%
SQL 85%
Python 75%
AI Tools 90%
PowerPoint / Presentations 90%
Looker Studio 80%
Tableau Public 90%
Power BI 85%
Portfolio
Practical projects on data analysis, construction of KPI-dashboards and automation of reporting in SQL and Python.
- All
- Sheets
- SQL
- Python
- Visualization
Services
Need help with data processing and analysis, dashboard building, and automated reporting to support business decisions? Contact me!
Data Acquisition
Configuring data flows from internal databases (SQL), external services via APIs and websites. Creating a single repository of information from all available sources.
Data Cleaning
Quality check, removal of duplicates and correction of errors in data sets. Bringing disparate information into a single format suitable for correct analysis.
Data Analysis
Calculating key performance indicators (KPIs), finding hidden patterns, and testing business hypotheses. Transforming numbers into concrete conclusions about the causes of business changes.
Data Visualization
Development of interactive dashboards and graphs that clearly reflect the state of affairs. Creation of tools for quick visual monitoring of processes in real time.
Reporting
Preparation of regular analytical reports and presentations with clear recommendations for management. Adaptation of complex technical conclusions to the requests of the business customer.
Automation
Creating scripts and systems for automatic report updates without human intervention. Setting up instant notifications about critical changes in indicators.
Product Listing
Adding and updating product cards on websites and marketplaces: titles, specifications, prices, photos and SEO descriptions. Bulk product uploads from supplier price lists or feeds.
Online Store Management
Technical support and content management for online stores on OpenCart, OKAY CMS and other platforms: catalog setup, categories, discounts and order status handling.
Category Management
Full ownership of a specific product category: keeping prices and stock levels accurate, maintaining subcategory structure, updating descriptions and quality-checking product cards.
Articles
Thoughts on data analytics, SQL, Python and BI tools — practical insights from real projects.
Assortment Planning
2026-10-04
Pricing
2026-09-27
Competitor Price Monitoring and Dynamic Pricing for Category Management 2026
What to track beyond the headline price, rule-based vs. AI repricing, and why matching a rival's flash sale quietly erodes your margin.
Category Management
2026-09-13
ABC Analysis and Inventory Optimization for Category Managers 2026
Build ABC and ABC-XYZ inventory classification, understand the nine resulting segments, and see what AI tools add to a once-static report.
Contact
I am open to work. Feel free to get in touch with me.
