From Fax Machines to Data Warehouse
When Charlie first started as head of software development at HAPO, he noticed fax machines at each branch were outfitted with copper wiring. To put it a different way…this is like using old rotary telephones instead of smartphones. And analytics? It simply was nowhere on HAPO’s radar.
Fortunately, HAPO had a core with ODBC access and a lot of useful data, but it wasn’t being captured for analytics. This would be a monumental task to take on. However, Charlie was hopeful that he could jumpstart business intelligence adoption with the current data warehouse when he reached out to CSG for support two years ago.
“We started down this road four years ago. I quickly realized our team didn’t have the skills or the time to do what we needed to do,” Charlie said. “The deliverables that CSG provided with a quick turnaround bridged the gap to help my team see the benefits and value of agile BI solutions. Because of CSG, we are so much further down the road.”
Given Charlie’s goals, CSG recommended data warehouse automation tools WhereScape 3D and WhereScape RED. WhereScape 3D was the perfect tool for speeding data discovery across HAPO’s numerous complicated core banking systems, which often lack sufficient vendor documentation. WhereScape RED was recommended to develop the data warehouse and documentation in a quick and Agile manner.
After an initial demo, Charlie immediately saw the value of forgoing a lengthy data discovery process. He was impressed by the non-proprietary, best practice SQL code automagically built by WhereScape and how easy it would be for his team to take over the data warehouse in the future.
“The HAPO data warehouse project has involved many design and implementation hurdles that would have killed progress if we didn’t have WhereScape tools on our team, “ said Eric Tengs, Senior Analytics Consultant at CSG.
“We had just gone live with a warehouse that included changing tracking dimensions, daily and monthly account snapshots, and many-to-many relationships. Suddenly, we faced a core banking system migration that required importing and seamlessly conforming to a totally different data structure. This level of agile data warehouse development just wasn’t possible before WhereScape.”