Automotive aftermarket pricing analytics
-
Updated
Apr 1, 2026 - Python
Automotive aftermarket pricing analytics
Free Excel, Python and LLM toolkit for planning usage-based cloud and AI products: usage to revenue, LLM and cloud cost, gross margin, risk-adjusted ROI. Synthetic data
SQL analysis of 8,399 Canadian retail transactions identifying $1.1M in hidden losses and their root cause
Margin and mix bridge in Excel with SKU and channel contribution, price volume mix and a gross margin walk.
This margin analysis quantifies unrecovered profit, identifies loss making jobs, clients, and routes, and delivers clear recommendations to improve pricing and operational efficiency.
ICT full-stack quoting and bid engine: internet customer scenario in; three-tier quote, 3-year TCO, margin validation against the 7.37% published direct-sales baseline, and a bid playbook (response table plus strategy) out. No fabricated prices - enterprise equipment pricing is not public, so a relative cost index is used.
家清品类经营分析:渠道达成 / 毛利桥(结构效应拆解)/ SKU 生命周期。SQLite 可直接跑
Power BI gross-margin model and report (PBIP, DAX, TMDL): gross profit and margin by brand, product and channel against last year and before discounts, with price × volume, outlet reach vs. sales per outlet, and kept/new/lost behind each change — fully documented, with CI checks and a DAX audit.
Pricing and costing decision studio for pocket margin, revenue leakage, quality controls, elasticity evidence, and Power BI/Streamlit actions across 240 products.
Unit economics by SKU and channel in Excel with contribution, payback and cohort views.
Pricing, margin and market intelligence for a foodservice produce distributor on 68,593 real Toronto wholesale prices (Python, SQL, Excel, Streamlit)
Margin Sentinel — real-time freight-disruption & margin-intelligence dashboard for import/export merchants. React + tRPC + Drizzle/MySQL, LLM-augmented risk scoring.
Fintech pricing operations platform for managing merchant pricing requests, margin validation, approval workflows, SLA tracking, and audit trails.
Cost & Margin Analysis — an installable Claude Code skill/plugin that audits a project's unit economics: inventories paid surfaces, models pricing, and computes per-plan / per-user margins with redlines flagged.
End-to-end margin analysis identifying $566k in revenue leakage across 9,994 transactions using Python, DuckDB, SQL, and Tableau.
Governed margin and inventory source of truth for small/mid retail and DTC teams - dbt star schema, DAX measure library, and RLS-scoped Power BI cockpit.
Sales and profitability analytics solution using SQL, Python and Power BI to identify margin leakage, discount impact, regional performance and sales opportunities.
Automated Data Engineering pipeline tracking KINZ product COGS, competitor pricing, and real-time B2B/B2C profit margins with Slack alerting. Airflow + Postgres + FastAPI + Streamlit.
CPG Margin Diagnostic Tool — cpg.jakeherridge.com
To associate your repository with the margin-analysis topic, visit your repo's landing page and select "manage topics."