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
ICE, RICE, 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
I can understand business. Ask the right questions.
Turn business requirements into clear realizations.
Help users make effective decisions.
Use a systematic approach and the appropriate tools.
Seeking opportunities for professional growth in data analysis and visualization.
Turn business requirements into clear realizations.
Help users make effective decisions.
Use a systematic approach and the appropriate tools.
Seeking opportunities for professional growth in data analysis and visualization.