Data Analyst portfolio project that deals with business KPIs, cleaning and transforming data and visualizing it to create a dashboard. The tools used are: SQL Server, T-SQL, Excel and Power BI.

The objective of the project was to create innovative and interactive Tableau dashboards that focus on potential commodities, countries, year, trade amount and quantity. The client wanted to launch a new business unit, focusing on global trade and logistics, majorly in the countries such as USA, Canada and Australia The dataset provided by the client contained 59090 observations of 10 variables. The client insisted the data to be cleaned using Excel or R. The Dataset contained missing values and was cleaned using the R programming language. Tableau dashboards were created from the cleaned dataset.

HR Data Analytics portfolio project on a dataset of 80K records that deals with HR KPIs like Performance tracking, attrition rate. Project involved cleaning, transforming data and visualizing it to create a dashboard. I have used the MS Excel and Power BI's Query Editor for data cleaning and preprocessing and dashboard.

This project includes a Super Market sales dataset in Excel with product details, prices, quantities, discounts, and revenue. The data was cleaned and analyzed, then visualized in Power BI through dashboards that highlight sales trends, top categories, revenue insights, and business performance for better decision-making.

Bike Sales Excel Dashboard Project: Analyzed and visualized sales data, cleaned datasets, and created interactive dashboards in Excel.

An Excel-based interactive dashboard built using pivot tables, charts, slicers, conditional formatting, and KPI indicators to analyze India’s multi-year agricultural crop yield dataset. The project includes data cleaning, preprocessing, seasonal analysis, state-wise contribution comparison, year-on-year yield growth, and dynamic visual reporting.

This repository contains the artifacts and deliverables from my internship project at Accenture North America's Data Analytics and Visualization Job Simulation on Forage. It includes the Excel dashboard, cleaned datasets, PowerPoint presentations, and other relevant documents.

A excel project, data-set for Goa's Population has been taken from government website,cleaned the data-set and made dashboard for all the analysis.

An interactive Excel dashboard analyzing sales performance. Features data cleaning with Power Query, a structured data model, and dynamic visualizations. Utilizes PivotTables, DAX measures, and slicers for intuitive exploration. Designed to transform raw data into actionable business insights.

An Excel-based dashboard to track state-wise rural road infrastructure progress. Includes data cleaning, derived metrics, and visual insights on project completion, pending work, and financial utilization. Ideal for policy analysis and performance monitoring.

Telecom Customer Chunk Analysis Project using Excel through following a certain process and studying customers behaviors to ensure the accuracy of the insights, The process includes EDA, Data Validating, Cleaning, Manipulation, Designing a Dashboard And Getting insights out of data.

This Repository contains all my Data Analysis Dashboards Projects that I have created using PowerBi. Excel, SQl & Python is also used for data cleaning process.

This project is an interactive Excel-based sales dashboard that provides meaningful insights into business performance using pivot tables, charts, and data visualizations. Skills & Tools Used Microsoft Excel Pivot Tables & Pivot Charts Data Cleaning & Formatting Dashboard Design & VisualizationIn.

Interactive Excel dashboard for COVID-19 data analysis using age and sex-wise breakdown. Includes raw data, cleaned dataset, and visual insights.

This project analyzes California county-level public health data, focusing on adult physical activity rates across demographics and years. It includes data cleaning, aggregation, and preparation for dashboard visualization using tools like Excel and Python. Ideal for building insights into health trends by geography and ethnicity.

The HR Attrition Insights Dashboard is a Tableau-powered solution designed to provide a 360° view of workforce attrition using historical HR data. Built using cleaned datasets from Excel and Power Query, this dashboard visualizes attrition patterns across multiple dimensions—such as departments, age groups, satisfaction levels and education fields.

•Scraped LinkedIn data using Selenium, cleaned and created schema in Excel. •Analyzed data using SQL, and presented insights via Power BI dashboard. •Used natural language processing to improve skill matching feature, and developed Clustering ML Model. •Developed website using HTML, CSS, and Flask for a user-friendly experience.

This project analyzes global video game sales using Microsoft Excel. It features interactive dashboards, region-wise comparisons, genre/platform trends, and critic score evaluations. Data was cleaned and visualized using Pivot Tables, Charts, Slicers, and Conditional Formatting with custom hyperlinks for easy navigation.

A web-based facial recognition attendance system where admins register students with face data, ID, and roll number. Using any camera, the system auto-detects students, marks attendance, and exports reports in Excel or PDF. Includes secure admin and student logins, attendance dashboards, and a clean, responsive, perfectly aligned UI.

I developed a comprehensive project in Excel, creating multiple dashboards and tables to analyze the data. This process involved several stages, including data preprocessing, data cleaning, and data visualization.

This project demonstrates a complete workflow for cleaning, analyzing, and visualizing raw sales data using Microsoft Excel. The final output is a fully interactive dashboard designed to provide key business insights at a glance.

A Project on Data Cleaning, Exploratory Data Analysis and Dashboard building In Microsoft Excel

A data analysis project using Excel that includes data extraction, data cleaning, data transformation, integration and finally an interactive dashboard.

A data analytics project exploring cancer patient survival and diagnosis trends using Excel for data cleaning and Power BI for interactive dashboard visualization.

I developed a comprehensive project in Excel, creating multiple dashboards and table to analyze the data. This process involved several stages including data processing, data cleaning and data utilization.

I have developed a comprehensive project in MS Excel, creating multiple dashboards and tables to analyze the data. thhis process involved several stages,including data preprocessing , data cleaning and data visualization.

End-to-end data analysis project demonstrating advanced Excel proficiency in cleaning messy HR data, analyzing major payroll leakage, and developing a Power BI dashboard for strategic business recommendations.

This repository is used to design a dashboard for Blinkit, a quick commerce service in Excel. The project involved data cleaning, transformation and using pivot tables to design interactive visualizations in Excel only. .

Cleaned sales data, created a dashboard, and analyzed trends. Identified growth opportunities, regional performance gaps, and customer value insights. Recommended marketing strategies, discount adjustments, and inventory improvements. Demonstrated Excel skills in data cleaning, visualization, and reporting.

Data analyst projects using Excel, SQL, Power BI, Tableau, and Python. Includes data cleaning, EDA, visualization, and dashboard creation. Focused on extracting insights from real-world datasets to support data-driven decisions and business reporting.