Hi there! 👋

I'm a Data Analyst

My dashboards

My opensource projects

Project	Discribe	Stack
E-Commerce Product Analysis - Project for E-commerce with Python.	Includes: Product analysis, EDA, Cohort analysis, RFM analysis	Pandas, Numpy, Seaborn, Matplotlib
A/B testing a new payment mechanics	Project for e-learning with Python	, Pandas, Numpy, Pingouin, SciPy.stats, Matplotlib, Seaborn, requests, urllib.parse - for loading datasets via API, EDA, methods of statistical analysis: Chi-square (Pearson's criterion), Student’s t-test
Big query with SQL	Complex query to calculate metrics based on data from 3 datasets.	subqueries, join, ClickHouse, Python/pandahouse
Window functions SQL	Queries using window functions	Window functions, Redash
Dashboard in Redash	Dashboard created on the Redash platform using SQL. Provides an overview of the main sales metrics of e-Commerce.	subqueries, filters, grouping, Redash, ClickHouse
Dashboards in Tableau	My data visualization projects in Tableau: * Employee Satisfaction, * Cohort analysis, * What is the salary for an analyst in Russia?,* Profits overview by regions, states, categories	Python

About Me:

Before I completed a Data Analyst course and got the new profession, I had the following background:

• 2 years as a marketing analyst,
• 5 years as a lead project manager.

During five years as a project manager, among other duties, I monitored product economic metrics and took steps to improve them, set product prices, and calculated ROI on new product lines.

🏆 At this point, I started working as a Data Analyst/BI Analyst for the Interbank Processing Center (IPC), Bishkek, Kyrgystan. Wish me good luck, please :)

I believe that the right decisions leading to business success stand behind the good analyzing data. Here are just two examples from my career:

1. One day, the company that owned the main chain of photo labs in the city suddenly sold it and exited the business without a loss. A few weeks after that, the market for photo services collapsed. And I am proud that my market research report and correctly made forecasts pushed the company's management to make the right move.
2. Because of my love of analyzing, I didn't raise prices immediately every time I saw a product's profitability drop, as was my company's custom. First, I would examine the data and find the cause of the problem. Then, depending on the results of my analysis, we would either change one of the ingredients, negotiate with the supplier to freeze the price of raw materials, or take other measures that allowed us to improve profitability to the same level without raising the product's price.

My other projects

🔎 Research of consumers' perception of children's trademark image and use of its results in developing of a rebranding strategy.

🏆 Based on the research, I developed a concept for a children's brand and a rebranding strategy.

🔎 Analysis of the pharmaceutical labor market in Tomsk.

🏆 I made conclusions about the current market situation and proposed to the management of the Department of Pharmacy Faculty of the Medical University several activities to improve the position of their graduates. In particular, I proposed to teach the students the basics of commercial activity, which caused an explosion of laughter from the audience.

🔎 At the request of a pharmaceutical distributor, I conducted a complete analysis of their competitors (product range, price analysis, promotion methods).

🔎 Photo services market analysis

🏆 The company exited the photo services business without losses, having managed to sell a chain of photo labs before the market collapsed, thanks to my market research report and correctly made forecasts.

⚒️ Technical Stack

🔎Key competencies

• Unit economics
• Economic analysis
• Statistical analysis
• A/B tests
• Marketing analysis

🎓 Education

🎓 Completed a course and received a passing grade in the Data analyst course of Karpov.courses.

My certificate

Subjects studied:

*    Statistics
*    A/B tests
*    Python
*    SQL
*    Tableau
*    Git
*    Airflow
*    Probability theory 
*    Product analytics  

🎓 High Education

🎓 Marketing in commercial activity - Tomsk State University

Among the subjects studied were:

*    Statistics 
*    Economic analysis 
*    Marketing research   
*    Business economics   
*    Economic theory    
*    Finance, monetary circulation, and credit. 

🏆 Graduated with honors.

🎓 Pharmaceutical specialist - Siberian State Medical University

Among the subjects studied were:

*    Higher mathematics, including probability theory  
*    Organization and economics of pharmacy.

My contacts

📫 tasha.l.swan@gmail.com