Data Analysis Projects in New YorkData Analysis Projects in New YorkData, AI, Software, Technical Writing
๐ฌ๐ข๐จ๐ฅ ๐ฆ๐๐๐๐ฆ ๐๐๐ง๐ ๐๐๐ฅ๐๐๐๐ฌ ๐๐ก๐ข๐ช๐ฆ ๐ช๐๐๐๐ ๐๐จ๐ฆ๐ง๐ข๐ ๐๐ฅ๐ฆ ๐๐ฅ๐ ๐๐๐ข๐จ๐ง ๐ง๐ข ๐๐๐๐ฉ๐.
Most owners check that money came in. Few ask what the numbers say about next month.
I ran a 90-day Dead Stock Check on Horti Supplies data (about $14,500 in sales).
In plain sight:
๐ค ๐ฒ ๐ผ๐ณ ๐๐ต๐ฒ ๐๐ผ๐ฝ ๐ฎ๐ฑ ๐ฐ๐๐๐๐ผ๐บ๐ฒ๐ฟ๐ ๐พ๐๐ถ๐ฒ๐๐น๐ ๐๐๐ผ๐ฝ๐ฝ๐ฒ๐ฑ ๐ฏ๐๐๐ถ๐ป๐ด: about $550 a month walking away.
$๐ต๐ฐ๐ฌ ๐๐๐๐ฐ๐ธ ๐ผ๐ป ๐๐ต๐ฒ ๐๐ต๐ฒ๐น๐ณ - 8 products unsold for 30 to 83 days made 2.4% of sales but held 22% of stock value.
๐ ๐ง๐ต๐ฒ ๐ฏ๐ฟ๐ฑ ๐ฏ๐ฒ๐๐-๐๐ฒ๐น๐น๐ถ๐ป๐ด ๐ฝ๐ฟ๐ผ๐ฑ๐๐ฐ๐ ๐ฟ๐ฎ๐ป๐ธ๐ฒ๐ฑ ๐ฎ๐ญ๐๐ ๐ณ๐ผ๐ฟ ๐ฝ๐ฟ๐ผ๐ณ๐ถ๐.
๐ ๐ง๐ต๐ฟ๐ฒ๐ฒ ๐๐น๐ผ๐ ๐ฎ๐ณ๐๐ฒ๐ฟ๐ป๐ผ๐ผ๐ป ๐ต๐ผ๐๐ฟ๐ - brought in 7% of sales; rent and staff costs didnโt drop.
๐ง๐ฟ๐ ๐๐ต๐ถ๐ ๐๐ผ๐ฑ๐ฎ๐ (๐ญ๐ฌ ๐บ๐ถ๐ป๐๐๐ฒ๐, ๐ป๐ผ ๐๐ผ๐ณ๐๐๐ฎ๐ฟ๐ฒ): export last monthโs sales, sort by profit, and circle anything that earned almost nothing but took up shelf space.
๐ง๐๐ผ ๐๐ฎ๐๐ ๐ ๐ฐ๐ฎ๐ป ๐ต๐ฒ๐น๐ฝ:
1๏ธโฃ ๐ง๐ต๐ฒ ๐๐ฒ๐ฎ๐ฑ ๐ฆ๐๐ผ๐ฐ๐ธ ๐๐ต๐ฒ๐ฐ๐ธ: send one month of sales data (names removed is fine) and get a one-page report on where cash is stuck, which customers are drifting, and 3 actions for this week. ๐ The first 10 get it free, in return for sharing the anonymised result as a case study.
2๏ธโฃ ๐๐ผ๐บ๐ถ๐ป๐ด ๐๐ผ๐ผ๐ป, ๐๐ป๐๐ถ๐ด๐ต๐๐๐ผ๐ผ๐ฝ: upload a CSV or SQL export and get a named diagnosis (Customer Churn, Dead Stock, Demand Forecast) plus a visual report.
๐๐ผ๐บ๐บ๐ฒ๐ป๐ โ๐๐๐๐๐โ ๐ณ๐ผ๐ฟ ๐ฎ ๐ณ๐ฟ๐ฒ๐ฒ ๐๐ฒ๐ฎ๐ฑ ๐ฆ๐๐ผ๐ฐ๐ธ ๐๐ต๐ฒ๐ฐ๐ธ, ๐ผ๐ฟ โ๐๐ข๐ข๐ฃโ ๐ณ๐ผ๐ฟ ๐๐ต๐ฒ ๐๐ป๐๐ถ๐ด๐ต๐๐๐ผ๐ผ๐ฝ ๐๐ฎ๐ถ๐๐น๐ถ๐๐.
Iโm Moses, a data engineer and founder of Closertune. Do you know an owner who says, โSales are slow, but I donโt know whyโ?