Author: Anthony Kippen | Filed under: Case Study | Tags: BI, Business Intelligence, Case Study, data, economy, financial, OLAP, sample, Service, SQL, SSAS, SSIS, XML | No Comments »
Megode delivered a complete Data Warehousing “eco-system” to understand and report revenue for a large financial services client. This client had been operating in “startup mode”, but as they were acquired, the urgency to be auditable and demonstrate viability in their accounting practices became critical to their success as a company.
Not only did Megode deliver the systems and reports to complete end of 2009 revenue reporting, but the architecture of the system is such that the client may now continue on to grow the system for more partners and increased capabilities.
The RevRec system is built upon Microsoft SQL Server 2008, SSIS and SSAS using Visual Studio. Architecting and building the solution required knowledge of these technology components combined with depth of expertise in dimensional modeling and accounting principles.