Sales Analytics Implementation (S.A.I.) using FNP Dataset to Derive Data Architecture for a Custom Printing Startup

• Analyzed a gifting dataset (FNP) to understand how an occasion-based business operates in terms of sales, demand, and trends.
• Cleaned and organized raw data, built a structured model, and developed a dashboard to study revenue, customers, products, and delivery behavior.
• Used these findings to define the key metrics and design a basic data structure for an early-stage custom printing startup.

Files to Refer

• FNP SALES ANALYSIS DASHBOARD.xlsx Main workbook covering:

  • data cleaning and transformation
  • structured data model (orders, customers, products)
  • pivot-based analysis
  • KPI calculations (revenue, orders, avg spend, delivery time)
  • interactive dashboard for exploring trends across time, category, occasion, and city

• S.A.I. Project Document Complete project breakdown:

  • why FNP dataset was chosen as a proxy for a custom printing business
  • insights extracted from the sales analysis (seasonality, demand patterns, customer behavior)
  • how these insights helped identify required business metrics
  • metrics considered for designing the startup’s data flow and architecture
  • final outcomes and key learnings from both analytics and data design perspective

• imgs/ Quick visual reference for understanding the project without going through the full document.

  Includes:

  • Designed INKmatrix Technical Architecture Visual layout of how customer, order, and product data is expected to flow into the startup’s data structure.

  • FNP Sales Analytics Dashboard Snapshot of the final interactive dashboard built from the FNP dataset.

  • INKmatrix Customers Table Structure of customer-level data fields considered for the startup.

  • INKmatrix Orders Table Order-level structure showing key transactional fields and metrics.

  • INKmatrix Products Table Product data design including category and pricing-related fields.

  • S.A.I. Project Flow Diagram Workflow diagram showing the complete project flow from dataset analysis to data structure design.

• FNP Dataset/ Source data used for analysis:

  • customers data
  • orders data
  • products data

Notes

• S.A.I. Project Document.pdf is the main reference for complete project context and detailed reasoning
• For a quick overview, refer to imgs/, especially the S.A.I. Project Flow Diagram