Ivan Bakharovsky
Web/Data Analyst.
My skills
Google Analytics
Yandex.Metrika
Excel
Python and SQL for Analysis
GTM
Dashboards
Analytics
To understand your clients, and their needs you should analyse a lot of data. Using powerful analytics tools such as Google Analytics and Yandex Metrica not only you are able to track your clients’ routes, but to gain a deep understanding of their needs and provide the best decisions to improve the UX/UI of a website. I have created a sample e-commerce store with GA and YM code installed via GTM. You can have a look at the store by clicking the bottom below.
Excel
Gathering data is not everything. Any analyst has to be able to process data and explain it. The solution is Microsoft Excel. A classic tool which allows to process and visualize data. However, not many people know, that you can create beautiful dashboards using the well-known program. Download a sample spreadsheet with an unusual visualization style.
Python
The best and easiest decision to process data is by Python. Python libraries have a wide range of tools allowing data analysts to handle data with thousands of rows easily and quickly. With its flexibility and simplicity, Python has always been a ‘must have’ language to know. Here is a sample dataset, taken from Kaggle, which I processed and visualized using Python.
Dashboards
Data studio
Yandex.Lens
Google sheets
