Customer loyalty program dashboard in cognos

Dashboard is based on Customer Loyalty Program data.

Following KPI’s as displayed

  • Product Sales
    • Total quantity sold
    • Total revenue generated
    • Product line performance by year
  • Customer Response
    • Revenue and quantity sold by location
    • Marketing response by department
    • Customer lifetime value and quantity sold by city
    • Department sales by loyalty status
  • Product & Location based analysis
    • Average margin
    • Total revenue
    • Revenue by product line colored by location code
    • Top 10 quantity sold by city
    • Margin by quarter colored by product line