The link for the Excel project to download can be found on GitHub here. It includes the raw data, Pivot Tables, and an interactive dashboard with Pivot Charts and Slicers. The project also includes business questions and the formulas I used to answer. The image below is included for ease. https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F12904052%2F61e460b5f6a1fa73cfaaa33aa8107bd5%2FBusinessQuestions.png?generation=1686190703261971&alt=media" alt=""> The link for the Tableau adjusted dashboard can be found here.

A screenshot of the interactive Excel dashboard is also included below for ease. https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F12904052%2Fe581f1fce8afc732f7823904da9e4cce%2FScooter%20Dashboard%20Image.png?generation=1686190815608343&alt=media" alt="">

This dataset contains a list of sales and movement data by item and department appended monthly. Update Frequency : Monthly

Standard error reference tables for the Retail Sales Index in Great Britain.

Analyzing Coffee Shop Sales: Excel Insights 📈

In my first Data Analytics Project, I Discover the secrets of a fictional coffee shop's success with my data-driven analysis. By Analyzing a 5-sheet Excel dataset, I've uncovered valuable sales trends, customer preferences, and insights that can guide future business decisions. 📊☕

DATA CLEANING 🧹

• REMOVED DUPLICATES OR IRRELEVANT ENTRIES: Thoroughly eliminated duplicate records and irrelevant data to refine the dataset for analysis.

• FIXED STRUCTURAL ERRORS: Rectified any inconsistencies or structural issues within the data to ensure uniformity and accuracy.

• CHECKED FOR DATA CONSISTENCY: Verified the integrity and coherence of the dataset by identifying and resolving any inconsistencies or discrepancies.

DATA MANIPULATION 🛠️

• UTILIZED LOOKUPS: Used Excel's lookup functions for efficient data retrieval and analysis.

• IMPLEMENTED INDEX MATCH: Leveraged the Index Match function to perform advanced data searches and matches.

• APPLIED SUMIFS FUNCTIONS: Utilized SumIFs to calculate totals based on specified criteria.

• CALCULATED PROFITS: Used relevant formulas and techniques to determine profit margins and insights from the data.

PIVOTING THE DATA 𝄜

• CREATED PIVOT TABLES: Utilized Excel's PivotTable feature to pivot the data for in-depth analysis.

• FILTERED DATA: Utilized pivot tables to filter and analyze specific subsets of data, enabling focused insights. Specially used in “PEAK HOURS” and “TOP 3 PRODUCTS” charts.

VISUALIZATION 📊

• KEY INSIGHTS: Unveiled the grand total sales revenue while also analyzing the average bill per person, offering comprehensive insights into the coffee shop's performance and customer spending habits.

• SALES TREND ANALYSIS: Used Line chart to compute total sales across various time intervals, revealing valuable insights into evolving sales trends.

• PEAK HOUR ANALYSIS: Leveraged Clustered Column chart to identify peak sales hours, shedding light on optimal operating times and potential staffing needs.

• TOP 3 PRODUCTS IDENTIFICATION: Utilized Clustered Bar chart to determine the top three coffee types, facilitating strategic decisions regarding inventory management and marketing focus.

*I also used a Timeline to visualize chronological data trends and identify key patterns over specific times.

While it's a significant milestone for me, I recognize that there's always room for growth and improvement. Your feedback and insights are invaluable to me as I continue to refine my skills and tackle future projects. I'm eager to hear your thoughts and suggestions on how I can make my next endeavor even more impactful and insightful.

THANKS TO: WsCube Tech Mo Chen Alex Freberg

TOOLS USED: Microsoft Excel

DataAnalytics #DataAnalyst #ExcelProject #DataVisualization #BusinessIntelligence #SalesAnalysis #DataAnalysis #DataDrivenDecisions

This is a spreadsheet of 1 of 10 companies in the shoe industry. Highlighting COGS, Total Revenue, Market share and Industry share.

Sample data for exercises in Further Adventures in Data Cleaning.

This dataset contains information about India's Sales of Motor Vehicles for2007-2019.Data from Ministry of Road Transport and Highways.

ITC reported INR180.2B in Sales Revenues for its fiscal quarter ending in June of 2025. Data for ITC - Sales Revenues including historical, tables and charts were last updated by Trading Economics this last October in 2025.

This dataset contains information about the sales of shoes in a particular region. The data includes information on the brand, model, type of shoe, gender, size, color, material, and price.

Column Details

Brand: The brand of the shoe, such as Nike, Adidas, or Reebok.

Model: The specific model name or number of the shoe, such as Air Jordan 1, Ultra Boost 21, or Classic Leather.

Type: The type of shoe, such as running, casual, or skate. This column describes the intended use or function of the shoe.

Gender: The gender the shoe is designed for, such as men, women, or unisex. This column specifies the target demographic for the shoe.

Size: The size of the shoe, using US sizing. This column indicates the length of the shoe in inches or centimeters.

Color: The color of the shoe's exterior. This column describes the predominant color or color combination of the shoe.

Material: The primary material of the shoe, such as leather, mesh, or suede. This column indicates the material that comprises the majority of the shoe's construction.

Price: The price of the shoe, in US dollars. This column specifies the cost of purchasing the shoe.

** The purpose of creating this dataset is solely for educational use, and any commercial use is strictly prohibited and this dataset was large language models generated and not collected from actual data sources.

cover image: https://pin.it/6Eb04Gf

Tunisia number dataset provides millions of powerful contacts for direct marketing. Our List To Data website gives an accurate and active phone numbers library. On the other hand, everybody can get all confirmed contact numbers from our site for any business to communicate with new clients. This Tunisia number dataset creates powerful options for promoting company sales. Likewise, this Tunisia number dataset is highly efficacious for business promotion through cold calls and text messages. For that reason, cell phone lead gives instant feedback from consumers and grows contracts. Our special team presents all number databases to you in CSV or Excel structure. However, anyone can download it in any CRM software without any risk. Tunisia phone data is a very helpful contact library for SMS and telemarketing. Mainly, the marketing tool plays a vital role in future business plans. Even, we prioritize security and privacy, so we strictly adhere to all the GDPR laws. In short, anyone can purchase this without any mistrust from the List To Data website. As a result, buy this contact number dataset for your benefit. Moreover, the Tunisia phone data helps in many ways to earn more money from this country. This country is very wealthy in all those business sectors, so you can buy this number package now. This website is an excellent place for its reputation to collect all authentic client mobile contact numbers. To that end, our skilled team is ready to assist you 24/7 in supplying your necessary leads. Tunisia phone number list makes your business more profitable in a couple of months. This country has the nominal GDP (US$53 billion) and the most vast by purchasing power parity (US$179 trillion). Moreover, it creates a big possibility to earn more from this place. Hence, you can get a consumer contact number lead from us to catch them easily through direct calls or SMS. Also, this Tunisia phone number list is far better for your business activities nationwide. Primarily, people can do the marketing with this enormous group of people. Actually, it will increase your profit rapidly and expand the return on investment [ROI]. Thus, as a businessman, anyone bears your needed B2C sales leads from our website at a cheap cost.

On an annual basis (individual hospital fiscal year), individual hospitals and hospital systems report detailed facility-level data on services capacity, inpatient/outpatient utilization, patients, revenues and expenses by type and payer, balance sheet and income statement.

Due to the large size of the complete dataset, a selected set of data representing a wide range of commonly used data items, has been created that can be easily managed and downloaded. The selected data file includes general hospital information, utilization data by payer, revenue data by payer, expense data by natural expense category, financial ratios, and labor information.

There are two groups of data contained in this dataset: 1) Selected Data - Calendar Year: To make it easier to compare hospitals by year, hospital reports with report periods ending within a given calendar year are grouped together. The Pivot Tables for a specific calendar year are also found here. 2) Selected Data - Fiscal Year: Hospital reports with report periods ending within a given fiscal year (July-June) are grouped together.

This dataset provides detailed information about car sales in India for the year 2024. It includes monthly sales figures for various car makes and models, along with additional metrics and attributes that help analyze market trends and performance. The dataset is ideal for data analysis, visualization, and understanding the automobile market dynamics in India.

Features: - Make: The manufacturer of the car - Model: The specific car model - January Sales to December Sales: Monthly sales data for each car model in 2024. - Total Sales: The cumulative sales for the entire year. - Segment: The market segment the car belongs to - Body Type: The type of car body - Month-on-Month Percentage (MoM %): Percentage change in sales compared to the previous month. - Year-on-Year Percentage (YoY %): Percentage change in sales compared to the same month in 2023.

Potential Use Cases: - Analyzing car sales trends over 2024. - Comparing performance of car models and manufacturers. - Studying market preferences for segments and body types. - Identifying seasonal trends in car sales. - Developing sales forecasts or business strategies for the automobile industry.

This dataset was sourced from Auto Punditz (https://www.autopunditz.com/). The website allows sharing the data but does not specify whether modifications are permitted. As a precaution, this dataset is shared under the CC BY-ND 4.0 license, which prohibits modification. Please refer to the original website's terms of use for more information.

Belize number dataset is now available at List to Data. If anyone wants to increase the sales of their products, they should go after the directory. Our valuable offering can help you improve your marketing campaign in this area. Most importantly, you will receive hundreds of data and valid information if you buy this potent digital product from us. Additionally, the current and functional addresses we’ll offer will assist you and your company in the long run. Belize number dataset is right now the best for telemarketing and SMS marketing. Indeed, we have been in the market for a very long time and dealing with genuine contact lists. We have also developed a solid reputation through providing real service. So, if you purchase Belize number dataset, you can be certain that you will receive full value for your money. Belize phone data contains the best quality data for consumers. You can use these addresses to create effective marketing campaigns. Furthermore, using our list will help you generate a ton of new business and revenue. List to Data is there to create it for you. Consequently, it could benefit your company in every possible way. A well-built list allows you to launch any kind of marketing or sales products or services. Belize phone data can bring new sales leads for any business. However, we make sure that your list contains only genuine leads. We adhere to a precise set of procedures for that aim. Besides, our team exclusively gathers leads from trustworthy sources. Also, they check the Belize phone data several times and discard any that are no longer active. Again, they eliminate all inactive leads and duplicate contacts. Get Belize phone number list by just paying one time. The price of this dataset is very low. In this time, you will receive the precise data you need at a price that fits within your budget. After completing purchasing anyone can download it instantly in Excel or CSV file format. Use this comprehensive database to drive your business properly. In the end, Belize phone number list is the product that you need for your business. To know more about the product or if you are interested in our other products then please contact us. Also, after you purchase this Belize phone number list you will get 24/7 service support from us.

Annual estimates for UK manufacturers' sales by product covered by the ProdCom survey.

Market Basket Analysis

Market basket analysis with Apriori algorithm

The retailer wants to target customers with suggestions on itemset that a customer is most likely to purchase .I was given dataset contains data of a retailer; the transaction data provides data around all the transactions that have happened over a period of time. Retailer will use result to grove in his industry and provide for customer suggestions on itemset, we be able increase customer engagement and improve customer experience and identify customer behavior. I will solve this problem with use Association Rules type of unsupervised learning technique that checks for the dependency of one data item on another data item.

Introduction

Association Rule is most used when you are planning to build association in different objects in a set. It works when you are planning to find frequent patterns in a transaction database. It can tell you what items do customers frequently buy together and it allows retailer to identify relationships between the items.

An Example of Association Rules

Assume there are 100 customers, 10 of them bought Computer Mouth, 9 bought Mat for Mouse and 8 bought both of them. - bought Computer Mouth => bought Mat for Mouse - support = P(Mouth & Mat) = 8/100 = 0.08 - confidence = support/P(Mat for Mouse) = 0.08/0.09 = 0.89 - lift = confidence/P(Computer Mouth) = 0.89/0.10 = 8.9 This just simple example. In practice, a rule needs the support of several hundred transactions, before it can be considered statistically significant, and datasets often contain thousands or millions of transactions.

Strategy

• Data Import
• Data Understanding and Exploration
• Transformation of the data – so that is ready to be consumed by the association rules algorithm
• Running association rules
• Exploring the rules generated
• Filtering the generated rules
• Visualization of Rule

Dataset Description

• File name: Assignment-1_Data
• List name: retaildata
• File format: . xlsx
• Number of Row: 522065

• Number of Attributes: 7

  • BillNo: 6-digit number assigned to each transaction. Nominal.
  • Itemname: Product name. Nominal.
  • Quantity: The quantities of each product per transaction. Numeric.
  • Date: The day and time when each transaction was generated. Numeric.
  • Price: Product price. Numeric.
  • CustomerID: 5-digit number assigned to each customer. Nominal.
  • Country: Name of the country where each customer resides. Nominal.

https://user-images.githubusercontent.com/91852182/145270162-fc53e5a3-4ad1-4d06-b0e0-228aabcf6b70.png">

Libraries in R

First, we need to load required libraries. Shortly I describe all libraries.

• arules - Provides the infrastructure for representing, manipulating and analyzing transaction data and patterns (frequent itemsets and association rules).
• arulesViz - Extends package 'arules' with various visualization. techniques for association rules and item-sets. The package also includes several interactive visualizations for rule exploration.
• tidyverse - The tidyverse is an opinionated collection of R packages designed for data science.
• readxl - Read Excel Files in R.
• plyr - Tools for Splitting, Applying and Combining Data.
• ggplot2 - A system for 'declaratively' creating graphics, based on "The Grammar of Graphics". You provide the data, tell 'ggplot2' how to map variables to aesthetics, what graphical primitives to use, and it takes care of the details.
• knitr - Dynamic Report generation in R.
• magrittr- Provides a mechanism for chaining commands with a new forward-pipe operator, %>%. This operator will forward a value, or the result of an expression, into the next function call/expression. There is flexible support for the type of right-hand side expressions.
• dplyr - A fast, consistent tool for working with data frame like objects, both in memory and out of memory.
• tidyverse - This package is designed to make it easy to install and load multiple 'tidyverse' packages in a single step.

https://user-images.githubusercontent.com/91852182/145270210-49c8e1aa-9753-431b-a8d5-99601bc76cb5.png">

Data Pre-processing

Next, we need to upload Assignment-1_Data. xlsx to R to read the dataset.Now we can see our data in R.

https://user-images.githubusercontent.com/91852182/145270229-514f0983-3bbb-4cd3-be64-980e92656a02.png"> https://user-images.githubusercontent.com/91852182/145270251-6f6f6472-8817-435c-a995-9bc4bfef10d1.png">

After we will clear our data frame, will remove missing values.

https://user-images.githubusercontent.com/91852182/145270286-05854e1a-2b6c-490e-ab30-9e99e731eacb.png">

To apply Association Rule mining, we need to convert dataframe into transaction data to make all items that are bought together in one invoice will be in ...

Dataset

This dataset was created by Dhruv Anurag

Released under Data files © Original Authors

Contents

The revenue of DMart was estimated at over *** billion Indian rupees in the financial year 2025, up from the previous year's *** billion rupees. The revenue of the retail chain in that year had increased over ******* since the financial year 2012.