Data Warehouse Consulting & Implementation Case Study

Welcome to ExistBi's consulting case study for Boyd Corporation. Our client, was established in 1928 in the Bay Area, California. The company is now one of the world’s most innovative problem-solvers, helping their customers solve their toughest technical challenges. Their expertise range from space exploration to brain surgery. As you can easily imagine this company produces a vast amount of data. The Boyd team approached ExistBI regarding a data warehouse project. The technology used included; Microsoft SQL Server database for Data Warehouse, Microsoft SQL Server Reporting Services for static reporting, Microsoft SQL Server Analysis Services for OLAP analysis of financial data, Microsoft.NET application for parsing and enrichment of unstructured datasets and Informatica Cloud Data Integration.

About us:

ExistBI solves their customers toughest challenges by providing unmatched data warehouse consulting and business intelligence services in digital, technology, finance, marketing, operations and enablement. With offices in California, Ohio, New Jersey, London and Zagreb, they partner with medium to large Companies and government organizations, driving innovation through intelligent data led initiatives. They have experience across most industries and all business functions to deliver transformational outcomes for a demanding new digital world.

Links
https://www.existbi.com/
https://www.linkedin.com/company/exist-business-intelligence/
https://twitter.com/@exist_solutions
https://plus.google.com/b/103754088035047143516/103754088035047143516
https://www.facebook.com/ExistBI/

____________________________________________________________

Video Details


Boyd Corporation was established in 1928 in the Bay Area, California. The company is now one of the world’s most innovative problem-solvers, helping their customers solve their toughest technical challenges. Their expertise range from space exploration to brain surgery. As you can easily imagine this company produces a vast amount of data. The Boyd team approached ExistBI regarding a data warehouse project.

In our initial communications, Boyd were unhappy with their external business intelligence consulting firm on a complex data warehouse project. We took it upon ourselves to gather the requirements quickly on multiple calls and began solving their complex problems within a few days of the initial enquiry.

The technology used included; Microsoft SQL Server database for Data Warehouse, Microsoft SQL Server Reporting Services for static reporting, Microsoft SQL Server Analysis Services for OLAP analysis of financial data, Microsoft.NET application for parsing and enrichment of unstructured datasets and Informatica Cloud Data Integration.

What were the results?
Our Data consultants quickly understood the customers pain points and turned around high-value wins for the CTO and CEO, we then further developed the relationship and took on the lead role in their new data warehouse project. Our engagement to-date involves:

•Redesign their data warehouse model
•Provide analytical support
•Develop data masking templates for delivering sensitive content to data warehouse
•Development of processing unstructured data sets
•Provide operational analytics for procurement and finances
•Support in development of quotes and billings