A project that utilizes Microsoft PowerBI to analyze personal financial data and visualize expenses through an interactive dashboard.

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.

The aim of this project is to analyse healthcare data to extract actionable insights using Microsoft Excel that could help improve patient care and healthcare resource management.

Unlock the full potential of Excel with our repository of advanced tips, templates, and tutorials. Elevate your spreadsheet game and supercharge your productivity.

The objective of this Advanced Excel project is to create a comprehensive sales analytics report for Atliq Hardware, a hardware company.

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

I'm Data analyst aspirant who want to join the data analytics team.

Analyzing the customer churn of a Telecom company using Power BI.

This repository contains a comprehensive Excel-based Power Query use case for transforming complex steel manufacturing production and inspection data

The objective is to find through excel the attributes of customers who are likely to buy the product when contacted through telemarketing. This is a classic case of acquisition analytics where companies use past data to predict the customers who are likely to buy certain products.

This enhanced Excel-based dashboard provides a comprehensive overview of sales performance, utilizing Power Query and Power Pivot for data integration and analysis.

Welcome to my Data Science and Analytics Portfolio! In this repository, I'll be showcasing my recent projects across various domains including Marketing, HR, Finance, Product, and Supply Chain. Expect to find a diverse range of analyses and visualizations powered by tools such as Python, R, SQL, and PowerBI. Join me, I am always open for feedbacks.

Performed comprehensive analysis of E-commerce sales data to uncover valuable insights into product sales trends across different regions and customer segments.

Developed an interactive Excel dashboard to analyze global coffee shop sales across multiple regions. Leveraged Power Query for data transformation and Power Pivot for calculating key KPIs including sales, profit, and margin metrics. Designed a visually compelling dashboard with slicers, gradient formatting, and dynamic pivot charts.

Conducted a statistical analysis of Microsoft, Tesla, and Apple stock performance compared to the S&P 500, examining price trends, volatility, and correlations to derive investment insights.

Competitive Automobile Market Analysis

A Healthcare Length of Stay (LOS) Analytics Power BI project typically focuses on analyzing patient admission and discharge data to optimize hospital operations, reduce costs, and improve patient care

AEC store wants to create an 3 Months sales report for 2022. So that, Manager can understand their customers and grow more sales in 2023.