Dataset

This dataset was created by Chris Chua

Contents

Dataset

This dataset was created by selvam mts

Released under MIT

Contents

1) Data Introduction • The Sample Sales Data is a retail sales dataset of 2,823 orders and 25 columns that includes a variety of sales-related data, including order numbers, product information, quantity, unit price, sales, order date, order status, customer and delivery information.

2) Data Utilization (1) Sample Sales Data has characteristics that: • This dataset consists of numerical (sales, quantity, unit price, etc.), categorical (product, country, city, customer name, transaction size, etc.), and date (order date) variables, with missing values in some columns (STATE, ADDRESSLINE2, POSTALCODE, etc.). (2) Sample Sales Data can be used to: • Analysis of sales trends and performance by product: Key variables such as order date, product line, and country can be used to visualize and analyze monthly and yearly sales trends, the proportion of sales by product line, and top sales by country and region. • Segmentation and marketing strategies: Segmentation of customer groups based on customer information, transaction size, and regional data, and use them to design targeted marketing and customized promotion strategies.

Sample Sales Data, Order Info, Sales, Customer, Shipping, etc., Used for Segmentation, Customer Analytics, Clustering and More. Inspired for retail analytics. This was originally used for Pentaho DI Kettle, But I found the set could be useful for Sales Simulation training.

Originally Written by María Carina Roldán, Pentaho Community Member, BI consultant (Assert Solutions), Argentina. This work is licensed under the Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License. Modified by Gus Segura June 2014.

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

Dataset

This dataset was created by Murat Mutlu

Released under Data files © Original Authors

Contents

Dataset

This dataset was created by Lirik Sadiku

Contents

The sample sales record is a comprehensive table that provides information on the sales performance of various products across different regions of the world. The table contains several columns, each of which captures critical information about the sales of the products. The first column is the Region column, which indicates the geographical region where the sales took place. The second column is the Country column, which provides information on the specific country where the sales occurred. The third column is the Item Type column, which identifies the type of product that was sold. The fourth column is the Sales Channel column, which indicates the channel used to sell the product, such as online, retail, or wholesale. The fifth column is the Order Priority column, which ranks the importance of the order, such as urgent or normal. The sixth column is the Order Date column, which captures the date when the order was placed. The seventh column is the Order ID column, which is a unique identifier for each order. The eighth column is the Ship Date column, which captures the date when the product was shipped. The ninth column is the Units Sold column, which indicates the number of units sold for each order. The tenth column is the Unit Price column, which captures the price of each unit sold. The eleventh column is the Unit Cost column, which provides information on the cost of producing each unit. The twelfth column is the Total Revenue column, which indicates the total revenue generated from the sales. The thirteenth column is the Total Cost column, which captures the total cost of producing and selling the product. The final column is the Total Profit column, which provides information on the total profit generated from the sales. By analyzing the data in the sample sales record, businesses can gain valuable insights into their sales performance across different regions and identify areas for improvement.

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

The annual Retail store data CD-ROM is an easy-to-use tool for quickly discovering retail trade patterns and trends. The current product presents results from the 1999 and 2000 Annual Retail Store and Annual Retail Chain surveys. This product contains numerous cross-classified data tables using the North American Industry Classification System (NAICS). The data tables provide access to a wide range of financial variables, such as revenues, expenses, inventory, sales per square footage (chain stores only) and the number of stores. Most data tables contain detailed information on industry (as low as 5-digit NAICS codes), geography (Canada, provinces and territories) and store type (chains, independents, franchises). The electronic product also contains survey metadata, questionnaires, information on industry codes and definitions, and the list of retail chain store respondents.

1.Introduction

Sales data collection is a crucial aspect of any manufacturing industry as it provides valuable insights about the performance of products, customer behaviour, and market trends. By gathering and analysing this data, manufacturers can make informed decisions about product development, pricing, and marketing strategies in Internet of Things (IoT) business environments like the dairy supply chain.

One of the most important benefits of the sales data collection process is that it allows manufacturers to identify their most successful products and target their efforts towards those areas. For example, if a manufacturer could notice that a particular product is selling well in a certain region, this information could be utilised to develop new products, optimise the supply chain or improve existing ones to meet the changing needs of customers.

This dataset includes information about 7 of MEVGAL’s products [1]. According to the above information the data published will help researchers to understand the dynamics of the dairy market and its consumption patterns, which is creating the fertile ground for synergies between academia and industry and eventually help the industry in making informed decisions regarding product development, pricing and market strategies in the IoT playground. The use of this dataset could also aim to understand the impact of various external factors on the dairy market such as the economic, environmental, and technological factors. It could help in understanding the current state of the dairy industry and identifying potential opportunities for growth and development.

1. Citation

Please cite the following papers when using this dataset:

I. Siniosoglou, K. Xouveroudis, V. Argyriou, T. Lagkas, S. K. Goudos, K. E. Psannis and P. Sarigiannidis, "Evaluating the Effect of Volatile Federated Timeseries on Modern DNNs: Attention over Long/Short Memory," in the 12th International Conference on Circuits and Systems Technologies (MOCAST 2023), April 2023, Accepted

1. Dataset Modalities

The dataset includes data regarding the daily sales of a series of dairy product codes offered by MEVGAL. In particular, the dataset includes information gathered by the logistics division and agencies within the industrial infrastructures overseeing the production of each product code. The products included in this dataset represent the daily sales and logistics of a variety of yogurt-based stock. Each of the different files include the logistics for that product on a daily basis for three years, from 2020 to 2022.

3.1 Data Collection

The process of building this dataset involves several steps to ensure that the data is accurate, comprehensive and relevant.

The first step is to determine the specific data that is needed to support the business objectives of the industry, i.e., in this publication’s case the daily sales data.

Once the data requirements have been identified, the next step is to implement an effective sales data collection method. In MEVGAL’s case this is conducted through direct communication and reports generated each day by representatives & selling points.

It is also important for MEVGAL to ensure that the data collection process conducted is in an ethical and compliant manner, adhering to data privacy laws and regulation. The industry also has a data management plan in place to ensure that the data is securely stored and protected from unauthorised access.

The published dataset is consisted of 13 features providing information about the date and the number of products that have been sold. Finally, the dataset was anonymised in consideration to the privacy requirement of the data owner (MEVGAL).

File

Period

Number of Samples (days)

product 1 2020.xlsx

01/01/2020–31/12/2020

363

product 1 2021.xlsx

01/01/2021–31/12/2021

364

product 1 2022.xlsx

01/01/2022–31/12/2022

365

product 2 2020.xlsx

01/01/2020–31/12/2020

363

product 2 2021.xlsx

01/01/2021–31/12/2021

364

product 2 2022.xlsx

01/01/2022–31/12/2022

365

product 3 2020.xlsx

01/01/2020–31/12/2020

363

product 3 2021.xlsx

01/01/2021–31/12/2021

364

product 3 2022.xlsx

01/01/2022–31/12/2022

365

product 4 2020.xlsx

01/01/2020–31/12/2020

363

product 4 2021.xlsx

01/01/2021–31/12/2021

364

product 4 2022.xlsx

01/01/2022–31/12/2022

364

product 5 2020.xlsx

01/01/2020–31/12/2020

363

product 5 2021.xlsx

01/01/2021–31/12/2021

364

product 5 2022.xlsx

01/01/2022–31/12/2022

365

product 6 2020.xlsx

01/01/2020–31/12/2020

362

product 6 2021.xlsx

01/01/2021–31/12/2021

364

product 6 2022.xlsx

01/01/2022–31/12/2022

365

product 7 2020.xlsx

01/01/2020–31/12/2020

362

product 7 2021.xlsx

01/01/2021–31/12/2021

364

product 7 2022.xlsx

01/01/2022–31/12/2022

365

3.2 Dataset Overview

The following table enumerates and explains the features included across all of the included files.

Feature

Description

Unit

Day

day of the month

-

Month

Month

-

Year

Year

-

daily_unit_sales

Daily sales - the amount of products, measured in units, that during that specific day were sold

units

previous_year_daily_unit_sales

Previous Year’s sales - the amount of products, measured in units, that during that specific day were sold the previous year

units

percentage_difference_daily_unit_sales

The percentage difference between the two above values

%

daily_unit_sales_kg

The amount of products, measured in kilograms, that during that specific day were sold

kg

previous_year_daily_unit_sales_kg

Previous Year’s sales - the amount of products, measured in kilograms, that during that specific day were sold, the previous year

kg

percentage_difference_daily_unit_sales_kg

The percentage difference between the two above values

kg

daily_unit_returns_kg

The percentage of the products that were shipped to selling points and were returned

%

previous_year_daily_unit_returns_kg

The percentage of the products that were shipped to selling points and were returned the previous year

%

points_of_distribution

The amount of sales representatives through which the product was sold to the market for this year

previous_year_points_of_distribution

The amount of sales representatives through which the product was sold to the market for the same day for the previous year

Table 1 – Dataset Feature Description

1. Structure and Format

4.1 Dataset Structure

The provided dataset has the following structure:

Where:

Name

Type

Property

Readme.docx

Report

A File that contains the documentation of the Dataset.

product X

Folder

A folder containing the data of a product X.

product X YYYY.xlsx

Data file

An excel file containing the sales data of product X for year YYYY.

Table 2 - Dataset File Description

1. Acknowledgement

This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No. 957406 (TERMINET).

References

[1] MEVGAL is a Greek dairy production company

1) Data Introduction • The Power BI Sample Data is a financial sample dataset provided for Power BI practice and data visualization exercises that includes a variety of financial metrics and transaction information, including sales, profits, and expenses.

2) Data Utilization (1) Power BI Sample Data has characteristics that: • This dataset consists of numerical and categorical variables such as transaction date, region, product category, sales, profit, and cost, optimized for aggregation, analysis, and visualization. (2) Power BI Sample Data can be used to: • Revenue and Revenue Analysis: Analyze sales and profit data by region, product, and period to understand business performance and trends. • Power BI Dashboard Practice: Utilize a variety of financial metrics and transaction data to design and practice dashboards, reports, visualization charts, and more directly at Power BI.

This dataset is generated for the purpose of analyzing furniture sales data using multiple regression techniques. It contains 2,500 rows with 15 columns, including 7 numerical columns and 7 categorical columns, along with a target variable (revenue) which represents the total revenue generated from furniture sales. The dataset captures various aspects of furniture sales, such as pricing, cost, sales volume, discount percentage, inventory levels, delivery time, and different categorical attributes like furniture type, material, color, and store location.

Guys please upload your notebook of this dataset so that others can also learn from your work

Nothing ever becomes real till it is experienced.

-John Keats

While we don't know the context in which John Keats mentioned this, we are sure about its implication in data science. While you would have enjoyed and gained exposure to real world problems in this challenge, here is another opportunity to get your hand dirty with this practice problem.

Problem Statement :

The data scientists at BigMart have collected 2013 sales data for 1559 products across 10 stores in different cities. Also, certain attributes of each product and store have been defined. The aim is to build a predictive model and find out the sales of each product at a particular store.

Using this model, BigMart will try to understand the properties of products and stores which play a key role in increasing sales.

Please note that the data may have missing values as some stores might not report all the data due to technical glitches. Hence, it will be required to treat them accordingly.

Data :

We have 14204 samples in data set.

Variable Description

Item Identifier: A code provided for the item of sale

Item Weight: Weight of item

Item Fat Content: A categorical column of how much fat is present in the item: ‘Low Fat’, ‘Regular’, ‘low fat’, ‘LF’, ‘reg’

Item Visibility: Numeric value for how visible the item is

Item Type: What category does the item belong to: ‘Dairy’, ‘Soft Drinks’, ‘Meat’, ‘Fruits and Vegetables’, ‘Household’, ‘Baking Goods’, ‘Snack Foods’, ‘Frozen Foods’, ‘Breakfast’, ’Health and Hygiene’, ‘Hard Drinks’, ‘Canned’, ‘Breads’, ‘Starchy Foods’, ‘Others’, ‘Seafood’.

Item MRP: The MRP price of item

Outlet Identifier: Which outlet was the item sold. This will be categorical column

Outlet Establishment Year: Which year was the outlet established

Outlet Size: A categorical column to explain size of outlet: ‘Medium’, ‘High’, ‘Small’.

Outlet Location Type: A categorical column to describe the location of the outlet: ‘Tier 1’, ‘Tier 2’, ‘Tier 3’

Outlet Type: Categorical column for type of outlet: ‘Supermarket Type1’, ‘Supermarket Type2’, ‘Supermarket Type3’, ‘Grocery Store’

Item Outlet Sales: The number of sales for an item.

Evaluation Metric:

We will use the Root Mean Square Error value to judge your response

Sample data for exercises in Further Adventures in Data Cleaning.

The given dataset appears to be a sales dataset containing information about different orders. Here is a description of the data:

1. Row ID: An identifier for each row in the dataset.
2. Order ID: Unique identifier for each order.
3. Order Date: The date when the order was placed.
4. Ship Date: The date when the order was shipped.
5. Ship Mode: The mode of shipping chosen for the order.
6. Customer ID: Unique identifier for each customer.
7. Customer Name: Name of the customer who placed the order.
8. Segment: The segment to which the customer belongs (e.g., consumer, corporate).
9. Country: The country where the order was placed (in this case, United States).
10. City: The city where the order was placed.
11. State: The state where the order was placed.
12. Postal Code: The postal code associated with the order's location.
13. Region: The region of the country where the order was placed.
14. Product ID: Unique identifier for each product.
15. Category: The category to which the product belongs (e.g., furniture, office supplies).
16. Sub-Category: The sub-category to which the product belongs (e.g., bookcases, chairs).
17. Product Name: The name of the product.
18. Cost: The cost of the product.
19. Price: The price at which the product was sold.
20. Profit: The profit made from the sale of the product.
21. Quantity: The quantity of the product ordered.
22. Sales: The total sales generated from the order (quantity multiplied by price).

The dataset provides detailed information about each order, including customer details, product details, sales information, and shipping information. It can be used to analyze various aspects of the sales data, such as profitability, customer segments, product categories, and regional sales performance.

Global Spend Analysis with Consumer Edge Credit & Debit Card Transaction Data

Consumer Edge is a leader in alternative consumer data for public and private investors and corporate clients. CE Vision EUR is an aggregated transaction feed that includes consumer transaction data on 6.7M+ Europe-domiciled payment accounts, including 5.3M+ active monthly users. Capturing online, offline, and 3rd-party consumer spending on public and private companies, data covers 4.4K+ brands and 620 symbols including 490 public tickers. Track detailed consumer behavior patterns, including retention, purchase frequency, and cross shop in addition to total spend, transactions, and dollars per transaction.

Consumer Edge’s consumer transaction datasets offer insights into industries across consumer and discretionary spend such as: • Apparel, Accessories, & Footwear • Automotive • Beauty • Commercial – Hardlines • Convenience / Drug / Diet • Department Stores • Discount / Club • Education • Electronics / Software • Financial Services • Full-Service Restaurants • Grocery • Ground Transportation • Health Products & Services • Home & Garden • Insurance • Leisure & Recreation • Limited-Service Restaurants • Luxury • Miscellaneous Services • Online Retail – Broadlines • Other Specialty Retail • Pet Products & Services • Sporting Goods, Hobby, Toy & Game • Telecom & Media • Travel

This data sample illustrates how Consumer Edge data can be used to understand a company’s growth by country for a specific time period (Ex: What was McDonald’s year-over-year growth by country from 2019-2020?)

Inquire about a CE subscription to perform more complex, near real-time global spend analysis functions on public tickers and private brands like: • Analyze year-over-year spend growth for a company for a subindustry by country • Analyze spend growth for a company vs. its competitors by country through most recent time

Consumer Edge offers a variety of datasets covering the US and Europe (UK, Austria, France, Germany, Italy, Spain), with subscription options serving a wide range of business needs.

Use Case: Global Spend Analysis

Problem A global retailer wants to understand company performance by geography to identify growth and expansion opportunities.

Solution Consumer Edge transaction data can be used to analyze shopper behavior across geographies and track: • Growth trends by country vs. competitors • Brand performance vs. subindustry by country • Opportunities for product and location expansion

Impact Marketing and Consumer Insights were able to: • Develop weekly reporting KPI's on key growth drivers by geography for company-wide reporting • Refine strategy in underperforming geographies, both online and offline • Identify areas for investment and expansion by country • Understand how different cohorts are performing compared to key competitors

Corporate researchers and consumer insights teams use CE Vision for:

Corporate Strategy Use Cases • Ecommerce vs. brick & mortar trends • Real estate opportunities • Economic spending shifts

Marketing & Consumer Insights • Total addressable market view • Competitive threats & opportunities • Cross-shopping trends for new partnerships • Demo and geo growth drivers • Customer loyalty & retention

Investor Relations • Shareholder perspective on brand vs. competition • Real-time market intelligence • M&A opportunities

Most popular use cases for private equity and venture capital firms include: • Deal Sourcing • Live Diligences • Portfolio Monitoring

Public and private investors can leverage insights from CE’s synthetic data to assess investment opportunities, while consumer insights, marketing, and retailers can gain visibility into transaction data’s potential for competitive analysis, understanding shopper behavior, and capturing market intelligence.

Most popular use cases among public and private investors include: • Track Key KPIs to Company-Reported Figures • Understanding TAM for Focus Industries • Competitive Analysis • Evaluating Public, Private, and Soon-to-be-Public Companies • Ability to Explore Geographic & Regional Differences • Cross-Shop & Loyalty • Drill Down to SKU Level & Full Purchase Details • Customer lifetime value • Earnings predictions • Uncovering macroeconomic trends • Analyzing market share • Performance benchmarking • Understanding share of wallet • Seeing subscription trends

Fields Include: • Day • Merchant • Subindustry • Industry • Spend • Transactions • Spend per Transaction (derivable) • Cardholder State • Cardholder CBSA • Cardholder CSA • Age • Income • Wealth • Ethnicity • Political Affiliation • Children in Household • Adults in Household • Homeowner vs. Renter • Business Owner • Retention by First-Shopped Period • Churn • Cross-Shop • Average Ticket Buckets

The Online Sales Dataset provides a detailed overview of global online sales transactions across various product categories. It includes transaction details such as order ID, date, product category, product name, quantity, unit price, total price, region, and payment method.

This is a case study for the company to improve sales

Business Goal
Date: 2023/09/15
Dataset: Sales quantity of a certain brand from January to December 2022 and from January to September 2023.

Please describe what you observe (no specific presentation format required). Among your observations, identify at least three valuable insights and explain why you consider them valuable.
If more resources were available to you (including time, information, etc.), what would you need, and what more could you achieve?

Metadata of the file Data Period: January 2022 - September 2023 Data Fields: - item - store_id - sales of each month

Metadata of the file Data Period: January 2022 - September 2023 Data Fields: - item - store_id - sales of each month

Sample question & answer 1. Product insights: identify the product sales analysis, such as BCG matrix 2. Store insights: identify the sales performance of the sales 3. Supply chain insights: identify the demand 4. Time series forecasting: identify tread, seasonality

Feel free to leave comments on the discussion. I'd appreciate your upvote if you find my dataset useful! 😀

This dataset was generated for use with Nile's Sales Assistant example: https://github.com/niledatabase/niledatabase/tree/main/examples/ai/sales_insight It includes:

Simulated sales conversations for 5 different fictional companies. Chunked and embedded version of these conversations (embeddings use OpenAI's text-embedding-3-small model).

The chunks and embeddings can be directly loaded to a vector databases and searched using vector similarity methods. The example's ./ingest directory… See the full description on the dataset page: https://huggingface.co/datasets/gwenshap/sales-transcripts.