Skip to Content
Author's profile photo Miguel Peredo Zurcher

Agile Data Preparation – a 7 minutes demo

Hi!

SAP Agile Data Preparation is a great tool for business users in the context of self service analytics. And for IT professionals/developers is suitable for prototyping or even for developing quick data combinations or transformations.

Based on this example…

https://help.sap.com/viewer/81fc9ae476d74e3f9ecad81de1a5f085/1.0.22/en-US/98bc010e33de479cb44bcc50dbbc9978.html

I recorded a 7 minutes video where I show the following:

a) Get data from an Excel file

b) Unpivot the data

c) Add a calculated column

d) Publish the result as a HANA calculation view

e) Access the view from Analysis for Office

 

Are you using Agile data preparation? In which context? Let me know your thoughts.

Cheers,

Miguel

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Michael Howles
      Michael Howles

      Thanks for sharing the demo.  I’m interested, but can you schedule project refreshes if the source were a different DB and you’d want to load into a HANA table nightly?

      Author's profile photo Miguel Peredo Zurcher
      Miguel Peredo Zurcher
      Blog Post Author

      Hello Mike, yes it’s possible. Check this link:

      https://help.sap.com/viewer/81fc9ae476d74e3f9ecad81de1a5f085/1.0.24/en-US/dc5170a98902413da138f98dd47a0117.html