Data Warehouse Build to Support Learning Management System Reporting

OLAP Reporting Solution

Client:

Sales Training and Content Company

Software:

MS SQL, SSIS, Analysis Services, and Olap Office integrated with NetDimensions

What we provided:

The client was using a very manual and not scalable solution to generate complex reports in MS Excel. Think was engaged to develop a plan to implement a hosted solution that is automated and scalable for future needs.

The results:

In phase 1, Think deployed a solutions architect who designed and implemented a SQL database that would interface with MS OLAP tools. The goal of the work was to rebuild the data repository to ready it for enterprise deployment and replace their MS Excel Workbook with SQL-based procedures while adding OLAP capabilities via Excel for fast report production and data analysis. The end result was pre and post assessment reports by team, individual and organization that provided increased data quality, accuracy, and speed to produce the client reports. In phase 2, Think continued work with the client to implement a sandbox region in the SQL database. Additionally, enhancement work was completed to develop and implement reports for additional courses and in a variety of different languages.

What the client said:

“I appreciated working with Think on developing our automated reporting solution. You and your team are so professional, so responsive, so attentive to detail….it really was a pleasure. I knew I could count on Think to deliver, and you didn’t let me down. Looking forward to working with you again soon.”

– Gretchen Porkert, Director, Product Development