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