Dark Mode
US Store Profit and Sales Dataset
Retail & Consumer Behavior
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
This dataset offers valuable insights into US store sales performance between 2010 and 2011. It encompasses detailed information on sales values in dollars, store attributes such as area, state, region, and size, as well as product specifics like ID, description, type, and category. Additionally, it includes essential accounting data, covering budget margin, actual profit, total expenses, and marketing expenditure. The data was meticulously extracted from 1st January 2010 to 31st December 2011.
Columns
The
sales.csv file contains 20 distinct columns, each providing a specific aspect of the sales operations:- Area Code: Unique identifier for each store.
- State: The US state where the store is located.
- Market: The region of the store (e.g., West, Central).
- Market Size: Categorisation of the store's size (e.g., Small Market, Major Market).
- Profit: The actual profit generated in US Dollars (£).
- Margin: Calculated as Profit + Total Expenses, or Sales - Cost of Goods Sold (£).
- Sales: The actual value acquired from sales in US Dollars (£).
- COGS: Cost of Goods Sold in US Dollars (£).
- Total Expenses: All expenses incurred to prepare a product for sale in US Dollars (£).
- Marketing: Expenses allocated to marketing activities in US Dollars (£).
- Inventory: The inventory value of the product at the point of sale in US Dollars (£).
- Budget Profit: The anticipated profit in US Dollars (£).
- Budget COGS: The anticipated Cost of Goods Sold in US Dollars (£).
- Budget Margin: The anticipated Profit + Expected Total Expenses, or Expected Sales - Expected COGS (£).
- Budget Sales: The anticipated value acquired from sales in US Dollars (£).
- ProductID: Unique identifier for each product.
- Date: The specific date of the sale.
- Product Type: The general category of the product (e.g., Espresso, Coffee).
- Product: A detailed description of the product (e.g., Columbian, Caffe Mocha).
- Type: Further classification of the product (e.g., Regular, Decaf).
Distribution
The dataset is provided as a CSV file named
sales.csv. It has a size of 589.01 kB and comprises a substantial table containing 4,248 records across 20 columns. All columns are fully populated with no missing values.Usage
This dataset is ideal for a variety of analytical applications and use cases, including:
- Sales Performance Analysis: Tracking sales trends, identifying top-performing stores or products.
- Profitability Assessment: Analysing profit margins and cost structures across different markets.
- Budget vs. Actual Analysis: Evaluating financial performance against planned budgets for sales, profit, and expenses.
- Marketing Effectiveness Studies: Understanding the impact of marketing expenditure on sales.
- Inventory Management Insights: Gaining insights into product inventory values at the time of sale.
- Regional Market Analysis: Comparing performance across different US states and regions.
Coverage
The dataset covers US store sales geographically across various states, including California and Utah, and different regions like the West and Central. Temporally, the data spans from 1st January 2010 to 31st December 2011, providing a two-year snapshot of retail activities. No specific demographic scope beyond store and product details is detailed.
License
CC0: Public Domain
Who Can Use It
This dataset is particularly useful for:
- Business Analysts: To conduct in-depth sales, profit, and expense analyses.
- Retail Managers: For strategic decision-making related to store performance and operational efficiency.
- Financial Controllers: To monitor and report on budget adherence and financial health.
- Marketing Professionals: To optimise marketing strategies based on historical spend and sales outcomes.
- Data Scientists: For developing predictive models, such as sales forecasting or profitability prediction.
- Academic Researchers: For studies on retail economics, market dynamics, and business analytics.
Dataset Name Suggestions
- US Retail Sales Data 2010-2011
- American Store Sales Performance
- Retail Financials USA (2010-2011)
- US Store Profit and Sales Dataset
Attributes
Original Data Source: US Store Profit and Sales Dataset
QUALITY