Features List

SAS® Banking Analytics Architecture Features List

SAS® Banking Analytics Architecture

Banking data model

  • Serves as a single version of the truth, covering all key banking subject areas, including banking, investment and insurance accounts.
  • Stores historical information at a granular level.
  • Provides a comprehensive dictionary that describes banking data elements.
  • Maps all physical data structures to business terms.
  • Includes both logical and physical data models – e.g., ERwin data models and SAS metadata.
  • Can be deployed in multiple databases, including SAS, Microsoft SQL Server, Oracle, Teradata and DB2.
  • Provides business data definitions that address the needs of global banking institutions with multiple lines of business, including consumer, corporate, mortgage lending, wealth management and investment banking.
  • Supports a variety of business analytics for marketing, finance, risk and compliance.

Data management

  • Accesses data from virtually any system in any form, including unstructured and semistructured data.
  • Embeds data quality into all processes.
  • Cleanses data in native languages, with specific language awareness and localizations for more than 20 worldwide regions.
  • Contains customized and reusable data quality business rules that can be accessed directly within process job flows.
  • Handles data migration and synchronization federation projects.
  • Includes wizards for accessing source systems, creating target structures, importing and exporting metadata, and building and executing data extraction, transformation and loading (ETL) process flows.
  • Provides a dedicated GUI for profiling data and identifying and repairing source system issues, while retaining the business rules for later use in the ETL processes.
  • Has enterprise connectivity to data sources - ODBC, IBM DB2/UDB, Microsoft Access and Excel, Microsoft SQL Server, Netezza, Oracle, Sybase, SAS, Teradata, banking core systems and more.
  • Uses out-of-the-box standardization rules to conform data to corporate standards, and lets you build customized rules for special situations.
  • Migrates or synchronizes data between database structures, enterprise applications, mainframe legacy files, text, XML, message queues and a host of other sources.
  • Joins data across sources for real-time access and analysis.

Reporting and business intelligence

  • Provides a web-based, interactive reporting interface for business users.
  • Includes query capabilities for all levels of users across multiple BI interfaces.
  • Slices and dices multidimensional data using a special slicer dimension and by applying filters on any level of a hierarchy.
  • Displays performance results via critical first-alert, call-to-action dashboards.
  • Provides dynamic business visualization tools for interactive data exploration, visual queries and more.
  • Includes access to SAS capabilities for data access, reporting and analytics directly from Microsoft Office, including Word, Excel and PowerPoint.
  • Enables wizard-driven report creation within Microsoft Office tools.