Skip to content

as16082023/Project-Portfolio

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 

Repository files navigation

📊 Akansha's Portfolio

Welcome to my portfolio! This space showcases a summary of my projects in the data domain.

🗂️ Contents

Excel

Project Link Project Description
Supermarket Sales Examining the operational efficiency of supermarkets across three diverse urban landscapes, designed an Excel dashboard to visualize and analyze their performance metrics.
Coffee Bean Sales This project entails analyzing coffee bean sales data over four years to gain insights into consumer behavior and market trends.
Manufacturing Downtime Analysis The project focused on analyzing manufacturing downtime data for a beverage production line operated by Wolf Cola, aiming to uncover inefficiencies and deliver actionable recommendations to enhance productivity.
Global Electronics Retailer Examined Maven Electronics' performance data to uncover factors contributing to the revenue decline since 2020.
Employee Survey Analysis Assessed survey data from 1,500 employees to evaluate job satisfaction and engagement, providing insights to enhance workplace culture and retention.

SQL

Project Link Project Description
Music Store Analysis The project involves analyzing music store data using SQL queries to enhance decision-making, identify trends, and understand customer behavior.
Restaurant Order Analysis As a data analyst at The Taste of the World Café, assessed the reception of newly introduced menu items by analyzing customer data.
Covid-19 Data Exploration The project focuses on analyzing COVID-19 data using SQL queries. It involves two tables, CovidDeaths and CovidVaccinations, which provide detailed information about COVID-19 cases
Nashville Housing Data Cleaning This project involved cleaning and optimizing a Nashville housing dataset, addressing key data quality issues to ensure it was ready for accurate analysis.
Global Layoffs Analyzing global company layoffs to uncover industry trends and workforce impacts through data cleaning and exploratory data analysis.
AtliQ Hardwares Analyzed data for Atliq Hardware to provide key insights through a SQL challenge.
Motor Vehicle Thefts Analyzed vehicle thefts in New Zealand to identify when and where they take place.
Goodcabs' Performance Analysis Analysing Goodcabs' performance in transportation across India from January to June 2024.

Tableau

Project Link Project Description Dashboard Link
Space Missions Dashboard Created a Tableau dashboard to visualize the history of space missions, highlighting key trends, patterns, and insights on launches, successes, companies, and rocket types. Dashboard
Law Enforcement Encounter Analysis Develop a comprehensive Tableau dashboard analyzing US law enforcement encounters in 2015-2016 Dashboard
Online Retail Dashboard Completed a virtual internship with Forage-Tata, utilizing Excel for data cleaning, Tableau for visualization, and PowerPoint for presenting insights to address business questions. Dashboard
Mapping Heart Health Risks A Tableau project analyzing heart disease risks by age, gender, and key health metrics to identify critical trends and insights. Dashboard

Power-BI

Project Link Project Description
Data Professional Survey Breakdown Developed a dashboard to visualize 2022 survey data from Alex the Analyst, providing insights into data professionals' salary distribution, preferred programming languages, and satisfaction with salary and work-life balance.
AdventureWorks- Bike Shop Analysis Using Power BI, this project analyzes AdventureWorks' sales, revenue, profit, and returns, comparing regional performance and identifying trends and high-value customers from a comprehensive dataset.
Credit Card Financial Dashboard Developed a comprehensive Power BI dashboard for real-time credit card operations insights, visualizing transaction data and customer demographics.
Atliq Grand Hospitality Analysis This project presents an overview of AtliQ Grands' performance in the hospitality industry.
Electric Vehicles Sales A resume project challenge by Codebasics, analyzing the EV/Hybrid Vehicles Industry to provide actionable insights for strategic decisions.

Python

Project Link Project Description
Hotel Booking Analysis This project explores and analyzes hotel booking data to identify key factors influencing bookings, providing insights for hotel management to enhance business performance through targeted campaigns.
Fuel Economy Prediction The project focuses on predicting vehicle fuel efficiency (mpg) using linear regression in Python.