Sourav-Pattanayak
|Aspiring Data Analyst||Advanced Excel| |My SQL| ||Power BI||Python||Tableau||ML| |Pandas|
Kolkata,India
Pinned Repositories
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.
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. 📊🚀
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.
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.
TradeGuard-SQL-Based-Detection-of-Market-Abuses
TradeGuard: SQL-Based Detection of Market Abuses uses SQL to analyze trading data, regulatory enquiries, and market manipulation records to detect patterns of fraud, such as insider trading and spoofing. This project provides actionable insights to enhance market surveillance and compliance.
Sourav-Pattanayak's Repositories
Sourav-Pattanayak/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.
Sourav-Pattanayak/Ad-hoc-Insights-in-Consumer-Goods-Domain
Sourav-Pattanayak/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.
Sourav-Pattanayak/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.
Sourav-Pattanayak/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.
Sourav-Pattanayak/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. 📊🚀
Sourav-Pattanayak/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.
Sourav-Pattanayak/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.
Sourav-Pattanayak/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.
Sourav-Pattanayak/TradeGuard-SQL-Based-Detection-of-Market-Abuses
TradeGuard: SQL-Based Detection of Market Abuses uses SQL to analyze trading data, regulatory enquiries, and market manipulation records to detect patterns of fraud, such as insider trading and spoofing. This project provides actionable insights to enhance market surveillance and compliance.
Sourav-Pattanayak/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.
Sourav-Pattanayak/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.
Sourav-Pattanayak/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.
Sourav-Pattanayak/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.
Sourav-Pattanayak/FP-20-Mobile-Phone-sales-Analysis
This Power BI project focuses on Mobile Phone Sales Analysis, providing insights to enhance net sales in 2023.
Sourav-Pattanayak/Customer-Analysis-for-Retail
This project focuses on analyzing retail customer data by merging datasets and generating insights on customer behavior, popular product categories, store performance, and sales metrics. The analysis aims to help the retail store improve customer targeting and optimize its strategies.
Sourav-Pattanayak/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.
Sourav-Pattanayak/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.
Sourav-Pattanayak/HR-Data-Analytics-Comparative-Algorithm-Study
This project is focused on HR dataset analysis, revealing insights on employee performance, demographics, and ML modeling.
Sourav-Pattanayak/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.
Sourav-Pattanayak/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.
Sourav-Pattanayak/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.
Sourav-Pattanayak/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.
Sourav-Pattanayak/Spending-Insights-Predicting-Customer-Purchases
This case study utilizes machine learning to predict future credit card spending by analyzing customer data. A Random Forest Regressor was built to forecast spending patterns, helping businesses optimize credit allocation and target key customers. The model achieves an R² score of 0.85, that shows a strong predictive power.
Sourav-Pattanayak/SQL-Community-Challenges
SQL Challenges and queries all over the web with variable difficulty levels.
Sourav-Pattanayak/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.