SAS® Banking Analytics Architecture Features List

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.