Analytics

JDB needed a way to report on year over year sales and dynamically configure vectors, dimensions, and targets in their sales data. Implemented a star schema and a batch update process to prevent contention with the main OLTP database.

SlideImage: 
Skills: 
Skills: OLAP, ROLAP, MSSQL, DTS, SQL, Data Cubes Outcomes: Executive decision makers were able to make real time decisions from actual sales and channel data