I have developed several projection tools with the rich operational data my clients have compiled.
1) Sales projection – Given recent sales trends relative to prior year, project sales for an upcoming week.
2) Labor projection – Given the sales projection from #1 and a series of labor band targets, project the labor hours and costs for an upcoming week. During the week, compare sales and labor to projection so managers can make adjustments if necessary.
3) Marketing campaign projection – Given recent loyalty member transactions, project the revenue generated from those members over the course of a scheduled promotion. Post-promotion analyze the success of the campaign compared to the projection.
Skills: Data analysis, database design and development, reporting
Tools: SQL Server, SQL Server Reporting Services