POC which shows the capabilities of HANA and Data Services.
This project involved conversion of Symantec’s existing Sales Discounting ETL process to Data Service Jobs and HANA Procedures
ŸMinimize sales discount levels to drive increased revenue and profitability
ŸEnable timely discount analysis including historic discount levels
ŸInfluence sales to utilize discount analysis for deal negotiation strategy and benchmarking of account executive performance
ŸScale discount analysis reporting across sales geographies, regions, areas, and districts
The process involved conversion of complex QlikView and MS SQL Scripts to derive a final aggregated output table in HANA used for reporting and Dash boarding purpose. The final outcome was the Sales discounting dashboard which used the calculation views in HANA to derive data of complex queries in no time.
1. Analysis of existing QlikView/SQL scripts and convert them to Data Service Job, by performing the necessary transformation
2.Create complex HANA stored procedures
3.SQL optimization in HANA to derive data in no time
4.Implementation of Row level Data Restriction on HANA calculation views
5.HANA Administration – user/Role creation, user rights to schema and Views.