Publish date June 30, 2017
SAP HANA is a game changer when it comes to data processing and analytics.
Data Modeling is the core of HANA application development. Primarily , Data Modeling is a fusion of both ETL ( extract , transform, load ) technology and business processes. It helps the transformation of disparate and normalized data into an organized structure suitable for reporting and decision-making. The main function of Data Modeling task is to deliver quality and consistent access to data. This exercise results in building a data mart or data warehouse.
Without these processes, Business Intelligence for organizations will be anything but intelligent. Failing to implement a strong data foundation will fail to deliver meaningful analytics.
SAP HANA modeling helps to create rich views and multi-dimensional analytics of data. It has the ability to aggregate, analyze, calculate, compare and forecast enormous volumes of data at speeds unlike any currently available database in the market. Here is a peek into HANA 2.0 Modeling features:
Data modeling views are created on top of database tables along with implementing business logic to generate meaningful reports. By using Java, HTML based application or even SAP HANA native applications the modeling views can be consumed. Third party tools like MS Excel can also be used to link with HANA to create reports.
Enhanced performance at runtime by modeling views is achieved by implicit use of optimized SAP HANA In-Memory calculation engines. To get the most out of SAP HANA the SAP views need to be modeled. The views are categorized into:
It represents master data and can be used to join to a dimension or other attribute view. These are highly reused and shared in the other two views.
Designed specifically to execute star schema queries this view leverage the computing power of SAP HANA to calculate aggregate data.
Used on top of the above two views, the calculation views are composite views. It can perform complex calculations.
Improved searching and filtering on dates. Dynamic search rules help to detect duplicate data. Batch mode search run can check a large number of records in a single call.
Easily embed natural language processing into company’s products with a new native SQL interface. Text analysis is possible for all languages including ones using space between words. Manage domain-specific custom dictionaries and rules within the Web IDE for SAP HANA.
New visualization enables more efficient and faster graph data analysis. Leverage existing Cypher query language skills for Cypher for pattern matching.
More pre-packaged algorithms helps to create richer predictive applications. Parallel processing across large-scale partitioned data can run-scoring functions faster.
Suresh Suravarapu S4 HANA, BI Analytics, EIM, BIBO, BI Consultant @YASH Technologies
For More Information Download SAP HANA Services Brochure