Aleksei Ogarkov

Hi, everyone! I'm Aleksei, a Business Intelligence and Revenue Analyst.

I built this website to showcase my experience and skills, and to connect with like-minded professionals for exciting career opportunities, projects, and meaningful collaborations.

For over 10 years, I have held key roles in innovative Fortune 500 companies, driving sales efficiency and building the analytical foundation for the successful launch of 7 blockbuster products and 8 acceleration projects. My expertise includes implementing 3 CRM systems and developing a cutting-edge ML-driven BI platform, which earned me recognition as one of Russia's TOP 40 Digital Experts in 2024.
Selected Case Studies
Explore some practical examples of how I apply analytics to solve real business problems.

Customer Value & Retention Intelligence

RFM and Cohort Analysis
powered by PostgreSQL, Python and Power BI

Global Insight Engine in Excel

Real-Time Macroeconomic & Digital Readiness Analytics
powered by World Bank API, Power Query, DAX, and VBA
Optimizing Ad Impact: A/B Testing Insights
Tools: NumPy, Pandas, Matplotlib, Seaborn, Scipy, Statsmodels, Scikit-learn, Keras
Key steps:
  • Cleaned and balanced datasets (outliers removed, groups matched)
  • Assessed conversion lift via Z-tests, T-tests, and Chi-square tests
  • Modeled promo vs. control outcomes using a neural network
  • Uncovered optimal delivery times and exposure levels for maximum impact
Marketing Campaign Metrics Dashboard in Excel
This Excel dashboard provides insights into campaign performance across multiple channels. The project required using structured advertising data to analyze budget allocations, actual revenue, P&L, and GAP analysis.
Key Features:
  • Interactive Slicers
  • Dynamic KPI Metrics
  • GAP Analysis
  • Multi-Level Data Views
  • Custom Data Visualizations
  • Automated P&L Calculation
Explore the video overview
An interactive marketing analytics dashboard provides real-time insights into campaign performance across multiple channels.
I’m open to new job opportunities, projects, and collaborations — feel free to reach out.
Aleksei Ogarkov
CONTACTS
Made on
Tilda