Project Description
I’m building HP IP IBOXX into a focused customer-purchase analytics system and need someone to create the full analytical workflow. The sole data source in scope is our customers’ purchase history; demographic details or survey feedback may be incorporated later, but they are not part of this sprint.
Here’s what I need from you:
• An ingest and cleaning routine that pulls raw transaction data from the formats I supply (CSV today, database connection tomorrow) and readies it for analysis.
• A well-structured data model with repeatable SQL or Python scripts that surface key metrics—order frequency, basket size, product affinities, and time-series trends.
• An interactive dashboard (Tableau, Power BI, or a lightweight web app—use what you are fastest with) so non-technical users can slice and drill down without touching code.
• Concise documentation so the internal team can extend the pipeline later.
Acceptance criteria:
• All code runs end-to-end on my machine via a single command.
• Dashboards refresh correctly after each new data load.
• Written summary highlights at least three actionable insights drawn from the latest purchase history.
If you can move quickly and keep the build tidy, let’s talk.