BI analyst portfolio

Ad-hoc analytics and dashboards. Search for insights in the data. Automation of reporting.

Data analysis

Skills
  • Python

    pandas, seaborn, numpy, scipy, statsmodels, matplotlib, plotly, sqlalchemy, folium, IPython, os, phik, sklearn
  • PostgreSQL

    Aggregation, grouping, JOIN, subqueries, CTE, window functions

  • Statistical data analysis

    Student's T-test, Mann-Whitney U-test, Fischer Z-test
  • Cohort analysis, unit economics

    LTV, CAC, ROI, ARPU, CR, Retention Rate
  • Prioritization of hypotheses

    Analysis of A/B test results
  • Basics of Machine Learning

    EDA, regression, classification, clustering
  • Web analytics

    Google Tag Manager, Google Analytics, Google Search Console, Tilda, CRO, VWO, Yandex.Metrica, Yandex.Webmaster
Work and pet projects
  • Prioritization of hypotheses and analysis of A/B test results

    Python: pandas, seaborn, numpy, scipy.stats.mannwhitneyu, matplotlib
  • Market research of public food establishments in Moscow

    Python: pandas, matplotlib, seaborn, numpy, scipy.stats.ttest_ind, plotly.graph_objects, folium.Map, Choropleth, Marker, DivIcon, folium.plugins.MarkerCluster
  • Analysis of the subscription book reading service

    PostgreSQL, Python: pandas, SQLAlchemy
  • Analysis of bank customer churn

    Python: pandas, numpy, matplotlib, seaborn, phik, scipy.stats.mannwhitneyu, scipy.stats.ttest_ind, statsmodels.stats.proportion.proportions_ztest
  • Investigation of the sales funnel and the results of the A/A/B experiment

    Python: pandas, matplotlib, seaborn, numpy, scipy.stats.ttest_ind, scipy.stats.mannwhitneyu, statsmodels.stats.proportion.proportions_ztest, plotly.graph_objects
  • Increasing website loading speed and filtering low-quality traffic

    Tilda, Google Tag Manager, Google Analytics, JavaScript, HTML
  • Changes in the value of the investment portfolio, S&P500 and RTS indices

    Highcharts, Google Sheets, JavaScript

Tableau

Calculated Field, Parameters, Hierarchy, Table Calculation, WINDOW, LOD, GEO, Actions, Filters, Reference & Trend Line, Forecast

Power BI

Power BI Desktop и Power BI Service, Power Query, Power Pivot, DAX

Contacts

Alexander Slobodskoi
BI analyst, Data analyst
I am looking for opportunities for further professional growth in data analysis and visualization