Analysis you
can trust

Inspect the sources, method, and executed code behind each result. Rerun, share, and review the work with your team.

Data

retailSeasonality

retail_seasonality96 rows x 5 cols

series_id	category_name	month	month_name	pct_diff_from_avg

series_id	category_name	month	month_name	pct_diff_from_avg
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	1	Jan	-0.23
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	2	Feb	-0.24
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	3	Mar	-0.01
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	4	Apr	0.11
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	5	May	0.22
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	6	Jun	0.14
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	7	Jul	0.06
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	8	Aug	0.03
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	9	Sep	-0.01
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	10	Oct	0.03
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	11	Nov	-0.02
fred_MRTSSM444USN	Building Materials and Garden Equipment and Supplies Dealers	12	Dec	-0.07
fred_MRTSSM448USN	Clothing and Clothing Accessory	1	Jan	-0.26
fred_MRTSSM448USN	Clothing and Clothing Accessory	2	Feb	-0.16
fred_MRTSSM448USN	Clothing and Clothing Accessory	3	Mar	-0.04
fred_MRTSSM448USN	Clothing and Clothing Accessory	4	Apr	-0.10
fred_MRTSSM448USN	Clothing and Clothing Accessory	5	May	-0.01
fred_MRTSSM448USN	Clothing and Clothing Accessory	6	Jun	-0.06
fred_MRTSSM448USN	Clothing and Clothing Accessory	7	Jul	-0.03
fred_MRTSSM448USN	Clothing and Clothing Accessory	8	Aug	0.04

Methodology

retailSeasonality

OVERVIEW

Calculates the average monthly sales profile and percentage deviation from the annual average for various retail categories between 2010 and 2023, using data from FRED via fred.series.observations, to produce retail seasonality charts.

source

steps

Source ledger

DatabaseMarket Data

Database query.

Method ladder

SQL

Uses

Producesretail_seasonality

Chart

Usesretail_seasonality

ProducesretailSeasonality

Parameters

2010-2023Date filter applied to observations.
3Number of columns in facet grid
containerWidth of the plot
0Y-axis datum for horizontal rule

Open original analysis

Keep the work in view.

Trace each conclusion to its sources, method, and executed code. Review the assumptions before deciding what comes next.

Trace the evidence
Follow the sources, assumptions, and executed code behind a result.
Run it again
Reuse the method and rerun the analysis when the data changes.
Review together
Share the analysis so colleagues can inspect the work, question assumptions, and discuss the result.
Build shared understanding
Make evidence and review part of how your team makes decisions.