11 results for “topic:vlookups”
Data Analysis and Visualization using SQL, Tableau, Power BI, Ms Excel, D3, Javascript and Vega-Altair
This project explores patterns behind customer attrition using real-world data. I applied data cleaning, exploratory analysis, and predictive modeling to identify key factors driving churn. The goal? Help businesses take proactive steps to retain customers before they walk away.
A collection of projects showcasing my learning in Excel
Performed E-commerce Sales Analysis to identify trends, optimize sales, and improve decision-making. Analyzed customer patterns, seasonal trends, and product performance using Python, SQL, and Power BI. Delivered actionable insights to enhance revenue, streamline inventory management, and boost customer engagement.
This project analyzes road accident data using MS Excel to identify trends, patterns, and contributing factors to accidents. Through data visualization techniques and statistical analysis, it provides insights that can inform safety measures and policy decisions, aiming to enhance road safety and reduce accident rates.
This repository contains a curated collection of practical Excel use cases, demonstrating real-world data analysis techniques using Excel functions, formulas, tables, charts, and tools.Excel Practice assignments
The tasks involve data exploration, data modeling, and building visualizations to deliver data-driven insights and solutions using tools like Powerpoint Presentation and Excel.
Dynamic coffee sales analysis using MS Excel, XLOOKUP, VLOOKUPS, Pivoting, pivot table visualizations and data analytical principles.
📊 An Excel-based healthcare data analysis project exploring medication usage patterns, patient transitions between drugs, dosage trends, and breakeven cost modeling. Includes insights using advanced Excel formulas, pivot tables, and logic functions.
Some important fuction and some Projects
Sprocket Central Pty Ltd, a medium size bikes & cycling accessories company, is looking to boost business by analysing their provided customer dataset to recommend which of these 1000 new customers should be targeted to drive the higher value for the company