Sales Analysis Report for Silver Touch – April 2023

I acquired the Silver Touch dataset from kaggle which contains sales data. Utilizing Microsoft Excel, I conducted a thorough analysis, including data cleaning to extract valuable insights. My objective was to identify trends and patterns that would enable me to provide actionable recommendations.

SALES PROJECT

PURPOSE: Analyzed sales data to identify trends, best-selling products, and overall total sales for business decision-making. This project was completed using Microsoft Excel. Data was cleaned in preparation for analysis. Finally, an interactive dashboard was made to monitor key business metrics.

Investigative Analytics Project

In SQL City, a murder occurred which implicated the victim named Morty. The inquiry started by looking through witness accounts, crime scene reports from the SQL City database. After careful data analysis, the case was solved and the murderer was apprehended as a result of the inquiry.

Justshop Supermarket project

In the highly competitive retail landscape, data-driven decision-making is crucial for maximizing sales and enhancing customer satisfaction. The JustShop Supermarket Sales Dashboard for 2014 was meticulously developed using Excel to visualize and analyze the supermarket's sales data.

Bank Customer Churn Project

The project aimed to analyze a dataset on customer churn to identify key factors contributing to customer attrition and provide actionable insights to improve customer retention. We successfully analyzed the customer churn dataset, uncovering valuable insights to inform business decisions

Prima India Heritage Diabetes

This dataset is originally from the National Institute of Diabetes and Digestive and Kidney Diseases. The objective of the dataset is to diagnostically predict whether a patient has diabetes based on certain diagnostic measurements included in the dataset.

Punchline World Billionaires

This analysis was done to look into Punchline World Billionaires for April 2023. The dataset used was gotten from kaggle.com where i carefully looked into the dataset to clean it. After this, I proceeded using pivot chart to make analysis.

Health Analytics project

This health Analytics project provides a comprehensive overview of Obsessive-Compulsive Disorder (OCD) patient data collected from 2013 to 2022.It offers insights into the distribution and trends of OCD among patients, segmented by various demographic factors such as ethnicity, gender etc.

Hr Analytics project

This dataset sourced from Youtube, focuses on analyzing employee attrition within an organization. Key metrics were extracted using PostgreSQL queries, and the data was then visualized using Power BI. These visualizations provide valuable insights to help organization make informed decision.

Global Superstore Analysis

I recently completed a project where I utilized SQL to extract data and Microsoft Excel for visualization purposes.