In the beginning, the case was just data for a company that did not indicate any useful information that would help decision-makers. In this case, after collecting a number of revenues and expenses over the months. Needed to know the answers to a number of questions to make important decisions based on intuition-free data. The Questions:- About Rev. & Exp.
- What is the total sales and profit for the whole period? And What Total products sold? And What is Net profit? - In which month was the highest percentage of revenue achieved? And in the same month, what is the largest day have amount of revenue? - In which month was the highest percentage of expenses achieved? And in the same month, what is the largest day have amount of exp.? - What is the extent of the change in expenditures for each month? Percentage change in net profit over the months? About Distribution - What is the number of products sold each month in the largest state? -The top 3 largest states buying products during the two years? Comparison - Between Sales Method by Sales? - Between Men and Women’s Product by Sales? - Between Retailer by Profit?

What I did? - Understanding the data - preprocessing and clean the data - Solve The problems in the cleaning like missing data or false type data - querying the data and make some calculations like "COGS" with power query "Excel". - Modeling and make some measures on the data with power pivot "Excel" - After finishing processing and preparation, I made Some Pivot tables to answers the questions. - Last, I made a dashboard with Power BI to visualize The Results.

A high-quality, clean dataset simulating global cosmetics and skincare product sales between January and August 2022. This dataset mirrors real-world transactional data, making it perfect for data analysis, Excel training, visualization projects, and machine learning prototypes.

📁 Dataset Overview

🧾 Sample Products

• Hydrating Face Serum
• Vitamin C Cream
• Aloe Vera Gel
• Charcoal Face Wash
• SPF 50 Sunscreen
• Niacinamide Toner
• Anti-Aging Serum
• Face Sheet Masks
• Hair Repair Oil
• Lip Balm Pack
• Body Butter Cream
• Salicylic Acid Cleanser

🌏 Countries Covered

• India
• USA
• UK
• Canada
• Australia
• New Zealand

📊 Quick Stats

• Total Rows: 374
• Date Range: Jan 1, 2022 – Aug 31, 2022
• Revenue Range: Varies from ~$100 to ~$20,000 per order
• Box Quantity Range: 10 – 500 boxes

🎯 Ideal For

• Excel Practice (VLOOKUP, IF, AVERAGEIFS, INDEX-MATCH, etc.)
• Pivot tables & data cleaning tasks
• Power BI / Tableau dashboards
• Sales trend forecasting
• Exploratory Data Analysis (EDA)
• Retail analytics & product demand modeling

📌 Suggested Projects & Questions

• Which salesperson generated the highest revenue overall?
• What’s the average amount per order in each country?
• Which product was most frequently sold?
• What month had the highest total boxes shipped?
• Create a dashboard comparing revenue across countries.

✅ Clean Data Guarantee

• ✅ No missing/null values
• ✅ No duplicates
• ✅ Realistic values
• ✅ Globally relatable product categories
• ✅ Ready for ML, BI, and teaching use cases

Analyzing sales data is essential for any business looking to make informed decisions and optimize its operations. In this project, we will utilize Microsoft Excel and Power Query to conduct a comprehensive analysis of Superstore sales data. Our primary objectives will be to establish meaningful connections between various data sheets, ensure data quality, and calculate critical metrics such as the Cost of Goods Sold (COGS) and discount values. Below are the key steps and elements of this analysis:

1- Data Import and Transformation:

• Gather and import relevant sales data from various sources into Excel.
• Utilize Power Query to clean, transform, and structure the data for analysis.
• Merge and link different data sheets to create a cohesive dataset, ensuring that all data fields are connected logically.

2- Data Quality Assessment:

• Perform data quality checks to identify and address issues like missing values, duplicates, outliers, and data inconsistencies.
• Standardize data formats and ensure that all data is in a consistent, usable state.

3- Calculating COGS:

• Determine the Cost of Goods Sold (COGS) for each product sold by considering factors like purchase price, shipping costs, and any additional expenses.
• Apply appropriate formulas and calculations to determine COGS accurately.

4- Discount Analysis:

• Analyze the discount values offered on products to understand their impact on sales and profitability.
• Calculate the average discount percentage, identify trends, and visualize the data using charts or graphs.

5- Sales Metrics:

• Calculate and analyze various sales metrics, such as total revenue, profit margins, and sales growth.
• Utilize Excel functions to compute these metrics and create visuals for better insights.

6- Visualization:

• Create visualizations, such as charts, graphs, and pivot tables, to present the data in an understandable and actionable format.
• Visual representations can help identify trends, outliers, and patterns in the data.

7- Report Generation:

• Compile the findings and insights into a well-structured report or dashboard, making it easy for stakeholders to understand and make informed decisions.

Throughout this analysis, the goal is to provide a clear and comprehensive understanding of the Superstore's sales performance. By using Excel and Power Query, we can efficiently manage and analyze the data, ensuring that the insights gained contribute to the store's growth and success.

The SHMI is the ratio between the actual number of patients who die following hospitalisation at the trust and the number that would be expected to die on the basis of average England figures, given the characteristics of the patients treated there. It includes deaths which occurred in hospital and deaths which occurred outside of hospital within 30 days (inclusive) of discharge. Deaths related to COVID-19 are excluded from the SHMI. The SHMI gives an indication for each non-specialist acute NHS trust in England whether the observed number of deaths within 30 days of discharge from hospital was 'higher than expected' (SHMI banding=1), 'as expected' (SHMI banding=2) or 'lower than expected' (SHMI banding=3) when compared to the national baseline. Trusts may be located at multiple sites and may be responsible for 1 or more hospitals. A breakdown of the data by site of treatment is also provided. The SHMI is composed of 142 different diagnosis groups and these are aggregated to calculate the overall SHMI value for each trust. The number of finished provider spells, observed deaths and expected deaths at diagnosis group level for each trust is available in the SHMI diagnosis group breakdown files. For a subset of diagnosis groups, an indication of whether the observed number of deaths within 30 days of discharge from hospital was 'higher than expected', 'as expected' or 'lower than expected' when compared to the national baseline is also provided. Details of the 142 diagnosis groups can be found in Appendix A of the SHMI specification. Notes: 1. As of the July 2020 publication, COVID-19 activity has been excluded from the SHMI. The SHMI is not designed for this type of pandemic activity and the statistical modelling used to calculate the SHMI may not be as robust if such activity were included. Activity that is being coded as COVID-19, and therefore excluded, is monitored in a new contextual indicator 'Percentage of provider spells with COVID-19 coding' which is part of this publication. 2. Please note that there has been a fall in the number of spells for most trusts between this publication and the previous SHMI publication, ranging from 0 per cent to 4 per cent. This is due to COVID-19 impacting on activity from March 2020 onwards and appears to be an accurate reflection of hospital activity rather than a case of missing data. 3. Day cases and regular day attenders are excluded from the SHMI. However, some day cases for University College London Hospitals NHS Foundation Trust (trust code RRV) have been incorrectly classified as ordinary admissions meaning that they have been included in the SHMI. Maidstone and Tunbridge Wells NHS Trust (trust code RWF) has submitted a number of records with a patient classification of ‘day case’ or ‘regular day attender’ and an intended management value of ‘patient to stay in hospital for at least one night’. This mismatch has resulted in the patient classification being updated to ‘ordinary admission’ by the HES data cleaning rules. This may have resulted in the number of ordinary admissions being overstated. The trust has been contacted to clarify what the correct patient classification is for these records. Values for these trusts should therefore be interpreted with caution. 4. On 1 October 2020 Poole Hospital NHS Foundation Trust (trust code RD3) merged with The Royal Bournemouth and Christchurch Hospitals NHS Foundation Trust (trust code RDZ). The new trust is called University Hospitals Dorset NHS Foundation Trust (trust code R0D). This new organisation structure is reflected from this publication onwards. 5. Airedale NHS Foundation Trust (trust code RCF) has submitted an increased number of delivery episode records. HES data cleaning rules have amended some of the records to birth episodes however, most records have not been changed. It is therefore considered likely that the increased number of delivery episodes (and corresponding reduction in ordinary episodes) is incorrect. Values for this trust should therefore be interpreted with caution. 6. Further information on data quality can be found in the SHMI background quality report, which can be downloaded from the 'Resources' section of the publication page. 7. This tool is in Microsoft Power BI which does not fully support all accessibility needs. If you need further assistance, please contact us for help.

I'm excited to share my recent project where I dived deep into the world of data analysis to gain valuable insights into Tata Motors' sales data for the fiscal year 2021-2022. 📈

Project Highlights:

1. Data Processing and Cleaning: I meticulously cleaned and processed the dataset, ensuring accuracy and reliability in the analysis.

2. In-Depth Analysis: Through advanced analytical techniques, I uncovered patterns, trends, and key metrics within the data, helping to reveal critical business insights.

3. Data Visualization: I transformed the complex sales data into clear and insightful visual representations, making it easier for stakeholders to grasp the findings.

4. Interactive Dashboard: I designed an interactive dashboard that allows users to explore the data dynamically, facilitating a deeper understanding of the sales performance.

5. Findings: Tata Motors achieved 105% growth in sales, marking an impressive 126% profit increase compared to the year 2021.

This remarkable growth not only showcases the company's resilience but also the effectiveness of their strategies and operations. It's a testament to the hard work and dedication of the entire Tata Motors team.