Loading repository data…
Loading repository data…
paulo81818 / repository
This repository was created to showcase my analytical and technical skills (Excel, Python, SQL, Power BI, PowerPoint, and others).
A transparent discovery signal based on current public GitHub metadata.
This score does not audit code, security, maintainers, documentation quality, or suitability. Verify the repository and its current documentation before adoption.
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).
This section contains a list of projects with brief descriptions.
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 PDF static version PowerPoint PPTX dynamic version german-cars-dataset.csv analytical thinking, data cleaning, data analysis, data vizualization, presentations MS PowerPoint, Python: Pandas, NumPy, Mathplotlib, Seaborn. 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.
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.
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: data_cleaning.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.
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
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
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
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
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