Sneak Peek of Data Warehousing: Part Two

Some specific improvements to our Data Warehousing include:

  • Tables structures now have increased granularity to allow for more flexible reporting and data analysis
  • Additional columns and tables have been added to specifically make time-series reporting more powerful
  • Third-party feeds are now centralized in their native state and can now be included in reporting
  • The addition of data marts to improve reporting performance and flexibility
  • Employing of a strategy that aims to normalize common entities across the enterprise (e.g. issuers, assets, portfolios)

Other benefits:

  • Categorize and create data sets of any type, including real-time and historical data
  • Everest can extend its warehouse to handle data retention of any type such as daily or month-end snapshots to preserve historical data
  • Data in the warehouse can still be managed through Everest’s B2B service
  • We can work with existing data warehouse instances using Everest as a reporting overlay, or design and build the warehouse to work with existing compliance / controls / archiving requirements

Here is a visual representation of some of the changes mentioned above:

Article written as a joint effort between the Development, Professional Services and Relationship Management teams at Black Mountain Systems

Data Warehousing Part 1