Pavel Liaoshka - Data Analysis portfolio

About me

Hello everyone! My name is Pavel, and this is my portfolio.
I love investigating different types of data, discovering insights, and representing it with beautiful visuals.
I have a background in digital marketing and financial data analysis.

You can see more information in my CV.

This repository was created to showcase my analytical and technical skills (Excel, Python, SQL, Power BI, PowerPoint, and others).

Contents

• About me
• Portfolio Projects

- German cars data analysis - Adidas US sales data analysis - Real estate US SQL and Power BI analysis

• Study projects

- Python Data Analysis - Excel Exercises - R Exercises - SQL Exercises - ETL pipelines project

• Certificates
• Contacts

Portfolio Projects

This section contains a list of projects with brief descriptions.

German cars data analysis

Description: The main goal of this project is to analyze a dataset scraped from https://www.autoscout24.de containing data in 46405 rows about cars on sale in Germany with production years from 2011 to 2021 using different Python libraries. Find out some interesting information and insights, visualize them, and present them using MS PowerPoint.
Code: german-cars-data-analysis.ipynb
Presentation: PDF static version PowerPoint PPTX dynamic version
Original dataset: german-cars-dataset.csv
Skills: analytical thinking, data cleaning, data analysis, data vizualization, presentations
Hard skills: MS PowerPoint, Python: Pandas, NumPy, Mathplotlib, Seaborn.
Results: An analysis of a dataset containing information about cars posted on AutoScaut 24 was conducted. Some insights were found, visualized, and included in the presentation.

Adidas US sales data analysis

Description: The goal of this project is to use Excel functionality to analyze data about Adidas's product sales in the United States, which contain information in 9652 rows and 14 columns for the fiscal years 2020 and 2021. Visualize data, prepare different types of reports and interactive dashboard.
Reports and conclusions: adidas-sales-data-analysis.xlsx
Dashboard: adidas-sales-dashboard.xlsx
Original dataset: adidas-us-sales.xlsx
Skills: analytical thinking, data cleaning, data analysis, data vizualization.
Hard skills: Excel, Pivot Tables, Formulas, Functions, Charts, Dashboards, Slices, Pivot Charts.
Results: An analysis of financial data on the sale of Adidas products in the USA for 2020 and 2021 was performed. Reports and dashboard were created.

Real estate US SQL and Power BI analysis

Description: The main goals of this project are:
1) To clean the dataset from Kaggle about real estate in the United States using SQL,
2) Explore data in Bigquery,
3) Group and prepare data for visualization in Power BI,
4) Create comprehensive dashboards, including interactive property stats, the price calculator that can count average prices by given parameters, and a dashboard that shows the quantity of sold properties in different states and the sales distribution among the months in the year for effective data exploration.
Data cleaning and exploring SQL: datacleaning.sql data_exploration.sql
Power BI dashboards: real-estate-dashboards.pbix real-estate-dashboards.pdf
Skills: analytical thinking, data cleaning, data analysis, data vizualization
Hard skills: Bigquery SQL, Power BI, Dashboards
Results: Data was cleaned (which reduced the amount of data by about nine times), explored in Bigquery, imported into Power BI, transformed, and 3 dashboards were created.

Study Projects

Python Data Analysis

Repository: python-data-analysis
Description: This repository contains ipynb files with tasks that were completed during the Python Data Analysis course on LinkedIn Learning. The main goal is to improve Python's analytical abilities.
Skills: Python, Pandas, NumPy, Matplotlib, Data Analysis, Data Visualization
Status: Completed in 2022

Excel Exercises

Repository: excel-data-analysis
Description: This repository contains xlsx files with completed tasks from the Excel Data Analysis course on LinkedIn Learning. The main goal is to advance knowledge in spreadsheets and statistical analysis.
Skills: Excel, Formulas, Functions, Data Analysis, Statistical Analysis.
Status: Completed in 2022

R Exercises

Repository: r-data-analysis
Description: This repository contains some completed exercises with R practice. The main goal is to gain basic knowledge of the R programming language and its use for data analysis and visualization.
Skills: R programming language, Data Analysis, Data Visualization.
Status: Completed in 2022

SQL Exercises

Repository: sql-queries
Description: This repository contains SQL queries that I was writing to accomplish different tasks during different courses. The main goal is to improve SQL knowledge and fluency.
Skills: SQL, Queries, data analysis, data cleaning
Status: Completed in 2022

ETL pipelines project

Repository: etl-pipelines
Description: This repository contains screenshots of the final project in the ETL and Data Pipelines with Shell, Airflow, and Kafka. Main goal: create data pipelines using Apache Airflow, Bash commands, and Kafka.
Skills: Bash, Apache Airflow, Kafka
Status: Completed in 2022

Certificates

• Google Data Analytics Certificate - Coursera, 2022
• IBM Data Analysis with Python - Coursera, 2022
• Mastering Data Analysis with Pandas - Coursera, 2022
• Python Data Analysis - Linkedin Learning, 2022
• Excel Data Analysis - Linkedin Learning, 2022
• ETL and Data Pipelines with Shell, Airflow and Kafka - Coursera, 2022
• Intermediate SQL: Data Reporting and Analysis - Linkedin Learning, 2022
• Prepare, Clean, Transform, and Load Data using Power BI - Coursera, 2022
• Excel: Working Together with Power Query and Power Pivot - Linkedin Learning, 2022
• Business Benefits Realization Foundations - Linkedin Learning, 2023
• Business Analyst and Project Manager Collaboration - Linkedin Learning, 2023
• Business Analysis Foundations - Linkedin Learning, 2023
• Agile Requirements Foundations - Linkedin Learning, 2023

Contacts

• Linkedin: https://www.linkedin.com/in/pavelliaoshka
• Email: pavelliaoshka818@gmail.com
• Telegram: @franch8888