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! 😀

📊 Supplement Sales Data (2020–2025) Overview This dataset contains weekly sales data for a variety of health and wellness supplements from January 2020 to April 2025. The data includes products in categories like Protein, Vitamins, Omega, and Amino Acids, among others, and covers multiple e-commerce platforms such as Amazon, Walmart, and iHerb. The dataset also tracks sales in several locations including the USA, UK, and Canada.

Dataset Details Time Range: January 2020 to April 2025

Frequency: Weekly (Every Monday)

Number of Rows: 4,384

Columns:

Date: The week of the sale.

Product Name: The name of the supplement (e.g., Whey Protein, Vitamin C, etc.).

Category: The category of the supplement (e.g., Protein, Vitamin, Omega).

Units Sold: The number of units sold in that week.

Price: The selling price of the product.

Revenue: The total revenue generated (Units Sold * Price).

Discount: The discount applied on the product (as a percentage of original price).

Units Returned: The number of units returned in that week.

Location: The location of the sale (USA, UK, or Canada).

Platform: The e-commerce platform (Amazon, Walmart, iHerb).

Use Cases This dataset is ideal for:

Time-series forecasting and sales trend analysis 📈

Price vs. demand analysis and revenue prediction 📊

Sentiment analysis and impact of promotions (Discounts) on sales 🛍️

Product performance tracking across different platforms and locations 🛒

Business optimization in the health and wellness e-commerce sector 💼

Potential Applications Build predictive models to forecast future sales 📅

Analyze the effectiveness of discounts and promotions 💸

Create recommendation systems for supplement products 🧠

Perform exploratory data analysis (EDA) and uncover trends 🔍

Model return rates and their effect on overall revenue 📉

Why This Dataset? This dataset provides an excellent starting point for those interested in building business intelligence tools, e-commerce forecasting models, or exploring health & wellness trends. It also serves as a perfect dataset for data science learners looking to apply regression, time-series analysis, and predictive modeling techniques.

Analysis of ‘Sample Sales Data’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/kyanyoga/sample-sales-data on 28 January 2022.

--- Dataset description provided by original source is as follows ---

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.

--- Original source retains full ownership of the source dataset ---

Analysis of ‘Warehouse and Retail Sales’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/9b8c4f87-15a5-40a3-ac82-cd637e3535c4 on 13 February 2022.

--- Dataset description provided by original source is as follows ---

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

--- Original source retains full ownership of the source dataset ---

Analysis of ‘Dummy Marketing and Sales Data’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/harrimansaragih/dummy-advertising-and-sales-data on 28 January 2022.

--- Dataset description provided by original source is as follows ---

I made this data for my students in 'Data-Driven Marketing' and 'Data Science for Business'. Data contains: - TV promotion budget (in million) - Social Media promotion budget (in million) - Radio promotion budget (in million) - Influencer: Whether the promotion collaborate with Mega, Macro, Nano, Micro influencer - Sales (in million)

This data can be used for simple tasks: - Data preprocessing - Exploratory Data Analysis - Visualization - Prediction using Linear Regression and Model Evaluation

--- Original source retains full ownership of the source dataset ---

Application and use cases

1 )Market Analysis: Evaluate overall trends and regional variations in car sales to assess manufacturer performance, model preferences, and demographic insights. 2) Seasonal Patterns and Competitor Analysis: Investigate seasonal and cyclical patterns in sales. 3) Forecasting and Predictive Analysis Use historical data for forecasting and predict future market trends. Support marketing, advertising, and investment decisions based on insights. 4) Supply Chain and Inventory Optimization: Provide valuable data for stakeholders in the automotive industry.

Autos include all passenger cars, including station wagons. The U.S. Bureau of Economic Analysis releases auto and truck sales data, which are used in the preparation of estimates of personal consumption expenditures.

Snapshot img

Sales Intelligence Market Size 2025-2029

The sales intelligence market size is forecast to increase by USD 4.86 billion at a CAGR of 17.6% between 2024 and 2029.

The market is experiencing significant growth, driven primarily by the increasing demand for custom-made solutions that cater to the unique needs of businesses. This trend is fueled by the rapid advancements in cloud technology, enabling real-time access to comprehensive and accurate sales data from anywhere. However, the high initial cost of implementing sales intelligence solutions can act as a barrier to entry for smaller organizations. Furthermore, regulatory hurdles impact adoption in certain industries, requiring strict compliance with data privacy regulations. With the advent of cloud computing and SaaS customer relationship management (CRM) systems, businesses are able to store and access customer information more efficiently. Moreover, the exponential growth of marketing intelligence, driven by big data and natural language processing (NLP) technologies, enables organizations to gain valuable insights from customer interactions.
Despite these challenges, the market's potential is vast, with opportunities for growth in sectors such as healthcare, finance, and retail. Companies seeking to capitalize on these opportunities must navigate these challenges effectively, investing in cost-effective solutions and ensuring regulatory compliance. By doing so, they can gain a competitive edge through improved lead generation, enhanced customer insights, and streamlined sales processes.

What will be the Size of the Sales Intelligence Market during the forecast period?

Request Free Sample

In today's business landscape, sales intelligence has become a critical driver of revenue growth. The go-to-market strategy of companies relies heavily on predictive lead scoring and sales pipeline analysis to prioritize opportunities and optimize resource allocation. Sales operations teams leverage revenue intelligence to gain insights into sales performance and identify trends. Data quality is paramount in sales analytics dashboards, ensuring accurate sales negotiation and closing. Sales teams collaborate using sales enablement platforms, which integrate CRM systems and provide sales performance reporting. Sales process mapping and sales engagement tools enable effective communication and productivity. Conversational AI and sales automation software streamline sales outreach and prospecting efforts. Messaging and alerting features help sales teams engage with potential customers effectively, while chatbots facilitate efficient communication.
Sales forecasting models and intent data inform sales management decisions, while salesforce automation and data governance ensure data security and compliance. Sales effectiveness is enhanced through sales negotiation training and sales enablement training. The sales market is dynamic, with trends shifting towards advanced analytics and AI-driven solutions. Companies must adapt to stay competitive, focusing on data-driven strategies and continuous improvement.

How is this Sales Intelligence Industry segmented?

The sales intelligence industry research report provides comprehensive data (region-wise segment analysis), with forecasts and estimates in 'USD million' for the period 2025-2029, as well as historical data from 2019-2023 for the following segments.

Deployment

  Cloud-based
  On-premises


Component

  Software
  Services


Application

  Data management
  Lead management


End-user

  IT and Telecom
  Healthcare and life sciences
  BFSI
  Others


Geography

  North America

    US
    Canada
    Mexico


  Europe

    France
    Germany
    Italy
    UK


  APAC

    China
    India
    Japan


  Rest of World (ROW)

By Deployment Insights

The cloud-based segment is estimated to witness significant growth during the forecast period. In today's business landscape, sales intelligence platforms have become indispensable tools for organizations seeking to optimize their sales processes and gain a competitive edge. These solutions offer various features, including deal tracking, win-loss analysis, data mining, sales efficiency, customer journey mapping, sales process optimization, pipeline management, sales cycle analysis, revenue optimization, market research, data integration, customer segmentation, sales engagement, sales coaching, sales playbook, sales process automation, business intelligence (BI), predictive analytics, target account identification, lead generation, account-based marketing (ABM), sales strategy, sales velocity, real-time data, artificial intelligence (AI), sales insights, sales enablement content, sales enablement, sales funnel optimization, sales performance metrics, competitive intelligence, sales methodology, customer churn, and machine learning (ML) for sales forecasting and buyer person

Envestnet®| Yodlee®'s Retail Transaction Data (Aggregate/Row) Panels consist of de-identified, near-real time (T+1) USA credit/debit/ACH transaction level data – offering a wide view of the consumer activity ecosystem. The underlying data is sourced from end users leveraging the aggregation portion of the Envestnet®| Yodlee®'s financial technology platform.

Envestnet | Yodlee Consumer Panels (Aggregate/Row) include data relating to millions of transactions, including ticket size and merchant location. The dataset includes de-identified credit/debit card and bank transactions (such as a payroll deposit, account transfer, or mortgage payment). Our coverage offers insights into areas such as consumer, TMT, energy, REITs, internet, utilities, ecommerce, MBS, CMBS, equities, credit, commodities, FX, and corporate activity. We apply rigorous data science practices to deliver key KPIs daily that are focused, relevant, and ready to put into production.

We offer free trials. Our team is available to provide support for loading, validation, sample scripts, or other services you may need to generate insights from our data.

Investors, corporate researchers, and corporates can use our data to answer some key business questions such as: - How much are consumers spending with specific merchants/brands and how is that changing over time? - Is the share of consumer spend at a specific merchant increasing or decreasing? - How are consumers reacting to new products or services launched by merchants? - For loyal customers, how is the share of spend changing over time? - What is the company’s market share in a region for similar customers? - Is the company’s loyal user base increasing or decreasing? - Is the lifetime customer value increasing or decreasing?

Additional Use Cases: - Use spending data to analyze sales/revenue broadly (sector-wide) or granular (company-specific). Historically, our tracked consumer spend has correlated above 85% with company-reported data from thousands of firms. Users can sort and filter by many metrics and KPIs, such as sales and transaction growth rates and online or offline transactions, as well as view customer behavior within a geographic market at a state or city level. - Reveal cohort consumer behavior to decipher long-term behavioral consumer spending shifts. Measure market share, wallet share, loyalty, consumer lifetime value, retention, demographics, and more.) - Study the effects of inflation rates via such metrics as increased total spend, ticket size, and number of transactions. - Seek out alpha-generating signals or manage your business strategically with essential, aggregated transaction and spending data analytics.

Use Cases Categories (Our data provides an innumerable amount of use cases, and we look forward to working with new ones): 1. Market Research: Company Analysis, Company Valuation, Competitive Intelligence, Competitor Analysis, Competitor Analytics, Competitor Insights, Customer Data Enrichment, Customer Data Insights, Customer Data Intelligence, Demand Forecasting, Ecommerce Intelligence, Employee Pay Strategy, Employment Analytics, Job Income Analysis, Job Market Pricing, Marketing, Marketing Data Enrichment, Marketing Intelligence, Marketing Strategy, Payment History Analytics, Price Analysis, Pricing Analytics, Retail, Retail Analytics, Retail Intelligence, Retail POS Data Analysis, and Salary Benchmarking

1. Investment Research: Financial Services, Hedge Funds, Investing, Mergers & Acquisitions (M&A), Stock Picking, Venture Capital (VC)

2. Consumer Analysis: Consumer Data Enrichment, Consumer Intelligence

3. Market Data: AnalyticsB2C Data Enrichment, Bank Data Enrichment, Behavioral Analytics, Benchmarking, Customer Insights, Customer Intelligence, Data Enhancement, Data Enrichment, Data Intelligence, Data Modeling, Ecommerce Analysis, Ecommerce Data Enrichment, Economic Analysis, Financial Data Enrichment, Financial Intelligence, Local Economic Forecasting, Location-based Analytics, Market Analysis, Market Analytics, Market Intelligence, Market Potential Analysis, Market Research, Market Share Analysis, Sales, Sales Data Enrichment, Sales Enablement, Sales Insights, Sales Intelligence, Spending Analytics, Stock Market Predictions, and Trend Analysis

Retail Sales in the United States decreased 0.90 percent in May of 2025 over the previous month. This dataset provides - U.S. December Retail Sales Increased More Than Forecast - actual values, historical data, forecast, chart, statistics, economic calendar and news.

📜 Dataset Overview

This dataset contains 3,400 records of fashion retail sales, capturing various details about customer purchases, including item details, purchase amounts, ratings, and payment methods. It is useful for analyzing customer buying behavior, product popularity, and payment preferences.

📂 Dataset Details

🔍 Key Insights

• The dataset contains 3,400 transactions.
• Missing values are present in:
  • Purchase Amount (USD): 650 missing values
  • Review Rating: 324 missing values
• Payment Method includes multiple categories, allowing analysis of payment trends.
• Date Purchase is in DD-MM-YYYY format, which can be useful for time-series analysis.
• The dataset can help analyze sales trends, customer preferences, and payment behaviors in the fashion retail industry.

📊 Potential Use Cases

• Sales Analysis: Understanding which fashion items are selling the most.
• Customer Insights: Analyzing purchase behaviors and spending patterns.
• Trend Forecasting: Identifying seasonal trends in fashion retail.
• Payment Method Preferences: Understanding how customers prefer to pay.

Analysis of ‘Video Games Sales Dataset’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/sidtwr/videogames-sales-dataset on 28 January 2022.

--- Dataset description provided by original source is as follows ---

Context

Motivated by Gregory Smith's web scrape of VGChartz Video Games Sales, this data set simply extends the number of variables with another web scrape from Metacritic. Unfortunately, there are missing observations as Metacritic only covers a subset of the platforms. Also, a game may not have all the observations of the additional variables discussed below. Complete cases are ~ 6,900

Content

Alongside the fields: Name, Platform, Year_of_Release, Genre, Publisher, NA_Sales, EU_Sales, JP_Sales, Other_Sales, Global_Sales, we have:-

Critic_score - Aggregate score compiled by Metacritic staff Critic_count - The number of critics used in coming up with the Critic_score User_score - Score by Metacritic's subscribers User_count - Number of users who gave the user_score Developer - Party responsible for creating the game Rating - The ESRB ratings

Acknowledgements

This repository, https://github.com/wtamu-cisresearch/scraper, after a few adjustments worked extremely well!

Inspiration

It would be interesting to see any machine learning techniques or continued data visualisations applied on this data set.#

--- Original source retains full ownership of the source dataset ---

We'll customize a Wildberries dataset to align with your unique requirements, incorporating data on product categories, customer reviews, pricing trends, popular items, demographic insights, sales figures, and other relevant metrics. Leverage our Wildberries datasets for various applications to strengthen strategic planning and market analysis. Examining these datasets enables organizations to understand consumer preferences and online shopping trends, facilitating refined product offerings and marketing campaigns. Tailor your access to the complete dataset or specific subsets according to your business needs. Popular use cases include conducting competitor analysis to understand market positioning, monitoring brand reputation through consumer feedback, and performing consumer market analysis to identify and predict emerging trends in e-commerce and online retail.

Heavy trucks include trucks with more than 14,000 pounds gross vehicle weight. Prior to the 2003 Benchmark Revision heavy trucks were more than 10,000 pounds. The U.S. Bureau of Economic Analysis releases auto and truck sales data, which are used in the preparation of estimates of personal consumption expenditures.

The global Sales Data Fusion market is experiencing robust growth, driven by the increasing need for businesses to leverage disparate data sources for improved sales performance and strategic decision-making. The market's expansion is fueled by the rising adoption of cloud-based solutions, advancements in artificial intelligence (AI) and machine learning (ML) for data integration and analysis, and the growing demand for real-time sales insights. Key players like Thomson Reuters, AGT International, and LexisNexis are leading the charge, offering comprehensive platforms that consolidate data from CRM systems, marketing automation tools, and other relevant sources. This consolidation provides a holistic view of customer interactions, sales performance, and market trends, enabling businesses to optimize sales strategies, improve forecasting accuracy, and ultimately enhance revenue generation. The market is segmented by deployment (cloud, on-premise), by industry (BFSI, retail, healthcare, manufacturing), and by component (software, services). While data security and privacy concerns represent a potential restraint, the overall market outlook remains positive, indicating continued growth driven by technological advancements and the ever-increasing value placed on data-driven decision-making within organizations. The forecast period of 2025-2033 is expected to witness significant expansion, building upon a strong historical period (2019-2024). Assuming a conservative CAGR of 15% (a reasonable estimate given the growth drivers mentioned), we can expect substantial market expansion. This growth will be particularly evident in regions with high technological adoption rates and robust digital infrastructures. The competitive landscape is characterized by both established players and emerging technology companies, creating a dynamic and innovative ecosystem. Future growth will likely be shaped by advancements in big data analytics, improved data integration capabilities, and the increasing availability of sophisticated sales intelligence tools. The market will continue to attract investments as businesses recognize the critical role of effective sales data fusion in achieving a competitive advantage.

Here is the updated list with web_events.csv included:

1. Orders Dataset:

   • Contains details of customer orders, including order dates, total order amounts (in USD), and associated customer IDs.
   • Helps analyze revenue trends, customer purchasing behavior, and seasonal patterns.

2. Accounts Dataset:

   • Represents customer account information such as account IDs, names, and sales representative assignments.
   • Useful for understanding customer demographics and their engagement with the company.

3. Regions Dataset:

   • Defines geographical regions managed by sales representatives, including region names and IDs.
   • Enables regional sales performance analysis and comparative insights across regions.

4. Sales Representatives Dataset:

   • Includes data on sales representatives, their IDs, names, and the regions they serve.
   • Helps link customer accounts to specific regions and analyze rep performance.

5. Web Events Dataset:

   • Logs customer interactions on the company's website, including timestamps, event types, and user IDs.
   • Helps track user activity, identify trends in website engagement, and optimize the online user experience.

These datasets collectively enable comprehensive insights into sales performance, customer behavior, website engagement, and regional trends, forming the backbone of the interactive dashboard.

Dashboard Link:

Click Here To Visit Dashboard 📊

Analysis of ‘Sales – kWh by Customer Class’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/405b9f75-a389-40f6-9430-afea16d94d64 on 26 January 2022.

--- Dataset description provided by original source is as follows ---

This table groups Austin Energy customers into five classes: residential, primary 1 & 2, secondary 1, 2, & 3, lighting, and contract/tes/trans/highload. View sales in dollars and kWh.

--- Original source retains full ownership of the source dataset ---

Market Analysis for Sales Tools The global sales tools market is estimated to reach a value of $574 million by 2033, growing at a CAGR of 4.8% from 2025 to 2033. The market is primarily driven by the increasing adoption of cloud-based sales tools and the growing need for efficient and effective sales management solutions. Small and medium-sized enterprises (SMEs) and large enterprises are the key market segments, while cloud-based and on-premises are the dominant types of sales tools. Major players in the market include Salesflare, Snov.io, and HubSpot Sales Hub. Key trends in the sales tools market include the integration of artificial intelligence (AI) and machine learning (ML) into sales software, the increasing use of mobile sales tools, and the adoption of data analytics to improve sales performance. Additionally, the shift towards remote and hybrid work models is fostering the demand for cloud-based sales tools that enable seamless collaboration and productivity.

Amazon Products dataset to explore detailed product listings, pricing, reviews, and sales data. Popular use cases include competitive analysis, market trend forecasting, and e-commerce strategy optimization.

Use our Amazon Products dataset to explore detailed information on products across various categories, including pricing, reviews, ratings, and sales data. This dataset is ideal for e-commerce professionals, market analysts, and product managers looking to analyze market trends, optimize product listings, and refine competitive strategies.

Leverage this dataset to track pricing trends, assess customer feedback, and uncover popular product categories. Whether you're conducting competitive analysis, performing market research, or optimizing product strategies, the Amazon Products dataset provides key insights to stay ahead in the e-commerce landscape.

Dataset Features

• Title: The name or title of the product.
• seller_name: The name of the seller offering the product.
• Brand: The brand associated with the product.
• Description: A detailed description of the product, including key features.
• initial_price: The original price of the product before any discounts.
• final_price: The current price of the product after discounts.
• Currency: The currency in which the product is priced (e.g., GBP, USD).
• Availability: The stock status (e.g., in stock, out of stock).
• reviews_count: The total number of customer reviews.
• Categories: The specific category the product belongs to.
• asin: Amazon Standard Identification Number.
• buybox_seller: The seller currently winning the Amazon Buy Box.
• number_of_sellers: The number of sellers offering this product.
• root_bs_rank: The overall ranking of the product in the Amazon best-sellers list.
• answered_questions: The number of questions answered in the product Q&A section.
• domain: The website domain where the product is being sold.
• images_count: The number of images available for the product.
• URL: The link to the product page on Amazon.
• video_count: The number of videos available for the product.
• image_url: The URL of the primary image associated with the product.
• item_weight: The weight of the product.
• Rating: The average rating of the product based on customer reviews.
• product_dimensions: The dimensions of the product (e.g., length, width, height) and weight.
• seller_id: The unique identifier for the seller.
• date_first_available: The date when the product was first made available on Amazon.
• discount: Any discount applied to the product.
• model_number: The model number of the product.
• manufacturer: The company that manufactures the product.
• department: The department under which the product is categorized (e.g., Health & Household).
• plus_content: A flag indicating if the product has Amazon’s “Plus Content” (additional marketing content).
• upc: The Universal Product Code (UPC) associated with the product.
• video: URL(s) of any video content associated with the product.
• top_review: A summary or excerpt from the top customer review.
• variations: Different product variations (e.g., different sizes or flavors).
• delivery: Information on the delivery options (e.g., free delivery or Prime delivery).
• features: Key features or highlights of the product.
• format: The format of the product (e.g., powder, liquid).
• buybox_prices: Pricing details for the product, including the base and tiered prices.
• parent_asin: The ASIN of the parent product (if the product is part of a larger group of similar products).
• input_asin: The ASIN of the product as input for Amazon searches.
• ingredients: List of ingredients in the product (if applicable).
• origin_url: The source URL for product-related information or ingredients.
• bought_past_month: A flag indicating if the product was bought in the past month.
• is_available: Availability status of the product (True/False).
• root_bs_category: The broad product category (e.g., Health & Household).
• bs_category: The specific subcategory the product belongs to.
• bs_rank: The rank of the product in its specific subcategory.
• badge: Any badge or label the product has earned (e.g., Amazon's Choice).
• subcategory_rank: The rank of the product within its subcategory.
• amazon_choice: A flag indicating if the product has been selected as Amazon’s Choice.
• images: A list of URLs for additional product images.
• product_details: Detailed product specifications and features.
• prices_breakdown: A breakdown of the price, including any discounts or promotions.
• country_of_origin: The country where the product is made.
• from_the_brand: Information from the brand or manufact

1) Data Introduction • The Grocery Sales Database is a retail dataset of relational tables of grocery store sales transactions, customer information, product details, employee records, geographic information, and more across cities and countries.

2) Data Utilization (1) Grocery Sales Database has characteristics that: • The data consists of seven tables, including product categories, city/country information, customer/employee/product details, and sales details, each of which is interconnected by a unique ID. • Sales data are linked to products, customers, employees, and regions, enabling a variety of business analyses, including monthly sales, popular products, customer behavior, and regional performance. (2) Grocery Sales Database can be used to: • Analysis of sales trends and popular products: It can be used to identify trends and derive best-selling products by analyzing sales by monthly and category and sales by product. • Customer Segmentation and Marketing Strategy: Define customer groups based on customer frequency of purchases, total expenditure, and regional information and apply them to developing customized marketing and promotion strategies.