Andrii Pysarevskyi
Junior Data Analyst | SQL, Python, Power BI
Welcome to my portfolio! I am a Junior Data Analyst with a background that blends analytical skills and insights into human behavior. My journey into data analysis began during a university statistics course, where I developed a strong interest in using data to inform decision-making. I focus on transforming complex data into clear, actionable findings that address real-world challenges and drive growth. Specializing in data wrangling, advanced analysis, and visualization, I am skilled in Python-based analysis, SQL, and creating interactive dashboards in Power BI and Tableau.
Skills
- Programming Languages: Python
- Libraries: Pandas, NumPy, Scikit-learn, Statsmodels
- Data Visualization: Power BI, Tableau, Matplotlib, Seaborn
- Tools: Jupyter Notebook, Git, GitHub, Excel
- Databases: MySQL
Featured Projects
- Objective: Conducted an in-depth analysis of a bike store’s sales data to identify top-performing stores, trends in product popularity, and key revenue-generating cities.
- Results: Highlighted key insights, including top revenue-generating stores, popular bike models, and cities contributing the most to sales. Created visualizations to reveal monthly sales trends.
- Tools: SQL, Power BI
- GitHub Repository: Bike Store Analysis
- Objective: Conducted a comprehensive analysis of Walmart’s sales data to uncover key patterns and external factors affecting weekly sales.
- Results: Identified how holidays, fuel prices, and unemployment rates influence sales performance. Created visualizations that revealed seasonal trends and the significance of key economic variables.
- Tools: Python (Pandas, Matplotlib, Seaborn)
- Kaggle Notebook: Walmart Sales Analysis
- Objective: Analyzed Airbnb rental performance and real estate trends across key nature retreat destinations in California, providing insights into revenue potential and property investment opportunities.
- Results: Demonstrated the impact of amenities like pools and hot tubs on revenue and nightly rates, identified top revenue-generating properties, and compared real estate prices across different regions and property sizes. Created an interactive Tableau dashboard to visualize data and provide actionable insights for potential investors.
- Tools: Python (Jupyter Notebook, Pandas) for data cleaning and preprocessing, Tableau for data visualization and analysis.
- Tableau Dashboard: California Nature Retreats: Airbnb Performance & Real Estate Trends
- Objective: Analyzed car sales data to identify pricing trends, customer preferences, and regional variations.
- Results: Provided insights into the factors that influence car pricing, including engine type, transmission, and region. Generated visualizations to communicate key findings to stakeholders.
- Tools: Python (Pandas, Matplotlib, Seaborn)
- Kaggle Notebook: Car Sales Analysis
- Objective: Explored key factors influencing students’ exam scores, focusing on the role of parental involvement, peer influence, teacher quality, and resource availability.
- Results: Found that higher parental involvement, access to resources, and better teacher quality are significantly associated with higher exam scores. The analysis also revealed the importance of motivation and attendance in improving academic performance. Visualized results using a comprehensive Tableau dashboard for easy interpretation of the findings.
- Tools: Python (Pandas, Matplotlib, Seaborn, Statsmodels) for statistical analysis and visualizations; Tableau for creating an interactive dashboard.
- Kaggle Notebook: Students Performance Analysis
- Tableau Dashboard: Students Performance Dashboard
- Objective: Investigated the factors affecting mental health and stress levels, using data to identify key associations and trends.
- Results: Discovered significant but weak relationships between stress and variables such as gender, occupation, family history, and access to mental health care. Applied statistical tests and created visualizations to support findings.
- Tools: Python (Pandas, Matplotlib, Seaborn, Statsmodels)
- Kaggle Notebook: Mental Health Data Analysis
I am always open to new opportunities and collaborations. Please feel free to reach out if you are interested in discussing how I can contribute to your data analysis needs.
Thank you for taking the time to review my portfolio. I look forward to connecting with you!