California Pizza Kitchen

Tools: MicroStrategy, SQL Server

As a MicroStrategy partner, we were engaged at CPK to help with:

  • Full life-cycle data warehouse development, including data model, ETL procedures, BI schema and reporting layer
  • Automated Flash P&L from operational (POS) data
  • Financial and inventory reporting built on near-realtime data feeds from ERP/GL systems
  • Daily operational dashboards and pixel-perfect reports