sourav-pattanayak Goto Github PK

abc-call-volume-trend-analysis

This project is focused on analyzing inbound call data to optimize agent allocation and reduce abandon rates for an insurance company.

ad-hoc-insights-in-consumer-goods-domain

adventureworks-eda

Throughout this project, I utilized Power BI to dissect Order, Revenue, Profit, and returns data from Adventure Works, an imaginative bike shop. It became a valuable learning journey, offering step-by-step guidance on techniques by Maven Analytics.

amazon-sales-report

An in-depth report on Amazon's sales data, including monthly growth, product performance, customer retention, and geographical distribution of sales across Indian states.

analyzing-the-impact-of-car-features-on-price-and-profitability

Optimizing car manufacturing decisions through data analysis and an interactive Excel dashboard for pricing and product development.

bank-loan-case-study

This project is done using Advanced-Excel for in-depth exploratory data analysis on loan applications, identifying patterns to differentiate loan defaulters from reliable borrowers. By addressing missing data, outliers, and imbalances, I've unveiled influential factors, aiding informed lending decisions.

data-analysis-in-hospitality-domain

AtliQ Grands, a make-believe hospitality company operating in four cities, took on a strategic analysis using Python and the Pandas library, along with visualization tools like Seaborn and Matplotlib, to tackle market competition. The goal was to use data-driven insights to overcome challenges and boost business growth.

electric-vehicle-sales-an-sql-case-study

Explore electric vehicle sales and customer engagement through data-driven insights. Optimize email campaigns for a 2.39% click-through rate and boost customer retention. 📊🚀

employee-data-analysis

This SQL project analyzes employee work efficiency, fraud levels, sector-specific fraud analysis, capacity assessment, gender distribution, and average salaries by country and age range.

financial-forecasting-and-analysis.

In this project, I brought data analytics to AtliQ Hardware using Power BI. I used tools like SQL, Excel, and DAX to improve decision-making in finance, sales, marketing, and supply chain. Now, I'm creating dynamic dashboards for this growing tech company.

fp-20-mobile-phone-sales-analysis

This Power BI project focuses on Mobile Phone Sales Analysis, providing insights to enhance net sales in 2023.

global-terrorism-analysis

This project delves into a comprehensive exploration of terrorism worldwide, drawing critical insights from extensive data analysis. This study unravels the some key findings that shape our understanding of global terrorism dynamics.

hiring-process-analytics

This project is done by analyzing hiring data, addressing missing values, simplifying columns, managing outliers, and providing insights on gender distribution, average salary, salary distribution, departmental proportions, and position tiers using visualizations.

hr-data-analytics-comparative-algorithm-study

This project is focused on HR dataset analysis, revealing insights on employee performance, demographics, and ML modeling.

imdb-movie-analysis

This project is completed analyzing IMDB movie languages' impact on ratings and exploring director influence through top director identification and budget-profit correlation analysis.

instagram-user-analytics

This project is executed with various SQL tasks for Instagram. I found the five oldest users, identified inactive users, declared a contest winner, researched popular hashtags, and suggested the best day for ad campaigns. For investors, I calculated user engagement metrics and flagged potential bot accounts.

operation-analytics-and-investigating-metric-spike

This project involves analyzing job review patterns, calculating throughput averages, and examining language usage in the first case. In the second case, it is focused on actively assessing user engagement, growth, retention, device-based engagement, and email engagement.

pwc-power-bi-job-simulation

In this project, I have crafted Power BI dashboards for a telecom client, emphasizing customer retention strategies and tackling HR diversity challenges. By delivering visually compelling insights, the dashboards aim to empower informed decision-making, fostering a holistic understanding of key metrics and actionable recommendations.

revenue-analysis-on-upi-apps

This project analyzes the impact of Diwali sales and in-app games on popular UPI payment apps (Google Pay, PhonePe, BHIM UPI, Paytm) in various cities during 2021-2022.

sales-finance-analytics-fmcg-

In this project, I delved into the data of a real company known as AtliQ Hardware. Leveraging advanced tools such as Power Pivot and Pivot Tables, we dissected the company's sales performance, unearthing valuable insights into its market presence. Notably, our analysis uncovered intriguing opportunities, particularly in Indian market.

sql-community-challenges

SQL Challenges and queries all over the web with variable difficulty levels.

superstore-analysis-a-power-bi-case-study

This Power BI project analyzes grocery store data, offering insights through Executive Summary, Product, Sales, and Return analyses with user-friendly navigation.

telengana-growth-analysis-a-power-bi-case-study

The objective was to examine Telangana's progress in different areas using numbers, providing useful information to the Telangana government. This analysis, carried out using SQL and Power BI, aims to help officials make informed choices backed by data, supporting the ongoing development of the state.