Data Analytics Projects

This repository showcases comprehensive data analysis projects demonstrating expertise in extracting, processing, and visualizing data for business intelligence and analytical insights. Projects leverage Google BigQuery, Python, and Tableau to transform raw data into actionable business recommendations.

🚀 Projects Overview

1. A/B Vision: Data-Driven Insights

Comprehensive A/B testing analysis with statistical validation

Analyzes user behavior patterns across test groups by extracting session, order, and event data from Google BigQuery. Provides actionable insights for conversion optimization through multi-dimensional analysis of channels, devices, and user segments.

Key Features

• Advanced SQL queries for BigQuery data extraction
• Multi-dimensional data aggregation (test groups, channels, devices, regions)
• Statistical analysis using Pandas for data manipulation and insights
• User behavior analysis across sessions, orders, and account creation

---

2. Multi-Tool E-Commerce Analysis: SQL, Python, and Tableau

End-to-end e-commerce analytics with statistical testing and visualization

This project performs in-depth e-commerce analysis by extracting session and order-related data from Google BigQuery, performing statistical tests, and generating visualizations using Python and Tableau. Delivers insights into customer behavior, product performance, and business metrics through rigorous statistical validation.

Key Features

• Complex SQL queries for session and order data extraction
• Analysis of user sessions, product categories, and customer demographics
• Statistical hypothesis testing (Chi-Squared, Mann-Whitney U, Kruskal-Wallis)
• Interactive data visualizations using Plotly, Seaborn, and Tableau
• Correlation analysis between e-commerce metrics

🛠️ Technical Stack

Category	Technologies
Database	Google BigQuery, SQL
Programming	Python (Pandas, NumPy, SciPy, Statsmodels)
Visualization	Tableau, Plotly, Seaborn, Matplotlib
Statistical Analysis	Hypothesis testing, A/B testing, Correlation analysis
Platform	Google Colab, Google Cloud

🚀 Quick Start

1. Clone the repository

   git clone https://github.com/YuliiaHudz/Data-Analytics-Projects.git
   cd Data-Analytics-Projects

---