buisness-analysis

FIT5120_IE Project

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

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

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

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

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 SQL analytics on 500K+ e-commerce transactions using CTEs, Window Functions, and advanced aggregations

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

Excel-based sales and profit analysis using PivotTables, dashboards, and business insights.

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

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

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

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

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

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.

Deloitte data analytics virtual experience

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.