buisness-analysis

FIT5120_IE Project

SQL analysis of the Netflix dataset using PostgreSQL to solve real-world business questions.

SQL analysis of 1M+ Amazon transactions - CTEs, window functions, business insights

PostgreSQL analysis of retail inventory data to evaluate product pricing, discounts, stock availability, estimated revenue, product value, and inventory distribution.

Кейс: Анализ транзакций сети розничных магазинов

SQL-based E-Commerce Sales Analytics project analyzing sales, customers, and business performance.

Gene Therapy Pipeline Tracker using Excel, SQL, Power BI, PowerPoint, Figma, BRD and FRD documentation.

Deloitte data analytics virtual experience

This project focuses on analyzing enterprise operational, financial, and risk-related data to generate meaningful business insights. The dataset was cleaned, processed, and analyzed using Python, Pandas, and data visualization techniques. Exploratory Data Analysis (EDA) was performed to identify operational trends, financial performance, and potent

Recruitment funnel analysis using SQL & Power BI — identifying hiring inefficiencies across 300 candidates, 6 departments and 6 sourcing channels.

Turnover AI provides indicative company turnover estimates using publicly available signals and data-driven inferences., serving as a starting point for financial evaluation of a company.

End-to-end Pizza Sales Analysis project using SQL and Power BI, featuring KPI reporting, interactive dashboards, and actionable business insights.

End-to-end SQL analytics on 500K+ e-commerce transactions using CTEs, Window Functions, and advanced aggregations

An end to end E-Commerece customer and sales analytics plateform to analayze sales, customer behaviour, marketing performance, and transactional data containing real world data quality issues. Used Python and pandas for data profiling and cleaning, SQL for analytical queries and buisness mterics, and poer BI for dasboards.

This is a retail analysis dashboard on Power BI built with a star schema data model to analyze sales, products, shipping performance, and other necessary statistics

AI-powered Sales Analytics Dashboard built with Streamlit, Plotly, Pandas and Groq LLM.

Interactive HR Attrition & Workforce Analytics Dashboard built using Power BI, Power Query, DAX.

A comprehensive SQL-based customer churn analysis project using MySQL. This project explores customer behavior, identifies churn patterns, calculates revenue loss, and provides actionable business insights through real-world SQL queries.

End-to-end retail analytics on a 9,994-row Superstore dataset using SQL, Python & Power BI — found that discounts above 20% turn profit negative, costing ~$135K/year.

A complete MySQL Data Analytics project demonstrating SQL fundamentals, business analysis, EDA, CTEs, Joins, Views, and Window Functions.