← Back to Datasets

Large sample sales dataset - 2.6 M rows of transactions

Explore a large sample sales dataset of 2.6 million rows of transaction data in a Row Zero spreadsheet. This sales spreadsheet also includes a sample Monthly Business Review with pivot tables, slicers, and charts. Explore for free in Row Zero, the world's most powerful spreadsheet.

Open Sample Sales Spreadsheet

Dataset Summary

This sample sales dataset includes 2.6 million rows of transactions over 24 months.
sample sales dataset in spreadsheet Columns include Transaction_ID, Date, Customer, SKU, Total Order, Price, Quantity, Region

View the Spreadsheet

Example Analysis

In the Monthly Business Review sheet, we created a pivot table to look at monthly sales metrics. We can use the built-in pivot table date grouping to group sales by month and the count unique Values calculation to find distinct customers by month. We then add a calculated column to our pivot table to find Avg Spend. monthly sales pivot table You can double-click on the pivot table to open the pivot table editor to make changes or see how it works.

Next we can chart the pivot table data to visualize monthly sales trends: monthly sales chart You have a number of options to configure your chart. Here we placed Avg Spend on the right axis, since it is on a different scale. We can see that Total Sales are growing faster than Avg Spend. Double-click on the chart to open the chart editor to make changes or see how it works.

Finally we can add slicers on the Monthly Business Review sheet so that we can dynamically filter the chart and pivot tables without going back to our source data. To add slicers, we go to our 'Sales Data' sheet, click a cell in the range and go to 'Insert', 'Slicer' in the header navigation and select the columns to create slicers for. You can then cut and paste the slicers onto the Monthly Business Review sheet. In this example, we created slicers for Region, SKU, and Customer, so we can easily filter our monthly sales pivot table and chart on these dimensions. monthly sales slicer Row Zero slicers are full-feature filters and can be added with or without pivot tables.

This analysis is just scratching the surface. Row Zero also has ~250 spreadsheet functions, built-in python, and native connectors to data sources so that you can build out connected spreadsheets that auto-update. Explore more for free in the sample sales spreadsheet.

Explore the Spreadsheet