CLIENT: A GLOBAL DISTRIBUTOR OF HOME ENTERTAINMENT CONTENT
Our client commissioned their sales reporting data warehouse in 2005, using SAP Business Objects (then Business Objects) as the reporting platform and SQL Server as the data storage medium. The company developing the data warehouse used the industry best practice for the day, and was a reputable firm.
Over time however the data warehouse underwent many modifications as new data was added and new systems brought online. In a sense, the data warehouse became a victim of its own success, unwieldy, complex and expensive to manage.
In 2009 Triatin acquired the company that designed the data warehouse and inherited the support role. Working closely with the local and Asia based IT leadership team, Triatin re-engineered the data warehouse to bring it into more modern best practice design concepts.
We upgraded the SQL Scripts from DTS to SSIS, added slow changing dimensions, consolidated many of the new fact tables built because of limitations in older versions of SQL server and added our unique organic management techniques to the overall support model. Over 300 load scripts and over 100 000 lines of code, with 100’s of dependencies were remediated and modernized.
We also upgraded all the BusinessObjects technology, with hundreds of reports, and some of the most complex Universes in the industry, and we have introduced our ABBIE technology to the stack, facilitating metric analytics for tools like Tableau in their Australian, Taiwanese, Japanese and New Zealand operations.
We now operate an ongoing service and support desk for their systems onsite, manned 8×5 but available when needed 24×7 if asked. We can do this because our consulting services model and project managed team based approach gives our clients onshore services at lower cost and higher consistent quality than offshore can offer.
Triatin is a certified SAP analytics partner, and we have skills in HANA, BusinessObjects full stack, BW and the Data Governance, Information Steward and Data Integration products. We also have skills on the Microsoft BI full stack including Integration Services, and we have skills in Azure, AWS and Google cloud. For any help understanding, using, learning or migration to or from these technologies, call us.