Data Analytics & BI portfolio This repository showcases end-to-end analytical solutions, ETL pipelines, non-parametric statistical hypothesis testing, and interactive dashboard systems developed for business analytics and portfolio projects.
- Data Analytics Specialist: Completed a comprehensive Data Analytics training program covering Python, SQL, Tableau, and Power BI.
- Portfolio Projects: Built end-to-end analytics projects on real-world datasets (USDA food nutrition data, e-commerce operations), including data cleaning, statistical analysis, and hypothesis testing to uncover meaningful insights.
- Bilingual Analytics: Comfortable building data solutions and writing business documentation in both Ukrainian and English.
- Data Analysis & Statistics: Python (Pandas, NumPy, SciPy), SQL, exploratory data analysis, hypothesis testing, correlation and outlier analysis.
- Business Intelligence: Tableau, Power BI (data modeling, DAX), interactive dashboards.
- Tools & Databases: Google BigQuery, PostgreSQL, Git/GitHub, Jupyter Notebooks, Excel/Google Sheets.
An end-to-end interactive Tableau analytics suite based on the Olist Brazilian E-Commerce dataset. Features a pixel-perfect 3-page UI covering Sales & Revenue trends, Logistics SLA & Review score impacts, and Customer Retention.
Food Nutrient Density Analysis
An end-to-end Python & Tableau analytical pipeline evaluating 7,000+ food items from USDA. Features EDA data preparation and cleaning, statistical correlation analysis and hypothesis testing to quantify how cooking affects nutrient levels.
E-commerce Operations & Web Analytics
A 6-page Power BI report analyzing e-commerce performance, with a well-structured data model, year-over-year growth tracking, sales concentration analysis, product-level drill-downs, traffic source tracking, and delivery performance monitoring.
A strategic business analytics and A/B testing project for UrbanScape Apparel, an online clothing marketplace. Includes SQL-based data processing, statistical analysis of what drives sales, hypothesis testing to identify what improves conversion rates, and 2 interactive Tableau dashboards.