L3 Technologies successfully improved their internal process by using the SAP Agile Data Preparation tool. The scope of the project was to maintain and manipulate a worksheet received from an outside marketing company in Microsoft Excel format with 116 columns and over 150,000 records. L3 Technologies provided SAP Agile Data Preparation (ADP) tool with business users and loaded the base file received from the marketing company.
Users are exploring the tool and it will help to improve users to be able to add new columns/formulae quickly and encourage collaboration within the team. We were able to save time with performance improvement while working on the worksheet and load into database for dashboard consumption that will be consumed by executives.
In addition, a SAP Analytics Cloud user creates KPIs in a dashboard and maintains a KPI data dictionary as an additional tab in stories. All data is sourced from HANA. The user shares the data dictionary with IT to load into SAP HANA. With the SAP ADP tool, the user will be able to modify the data dictionary and save it to HANA data base table directly without help from the IT department. L3 Technologies is now able to maintain a data dictionary of KPIs.
Key business benefits:
- Team collaboration
- Process improvement and increased efficiency
- Reduce dependency on IT team
