Chapter 5: Advanced ETL Using CRMA Data Prep

This chapter will demonstrate how to use the CRM Analytics (CRMA) Data Prep tool to its full capability. This is where the more powerful extract, transform, and load (ETL) work will be explained and demonstrated, instructing you in how to combine many sources of data, perform complex transformations and calculations, and create accurate, complete datasets for analytics.

Understanding and applying your data prep and dataflow skills are critical as a foundation for building accurate and useful data analytics in CRMA.

By the end of this chapter, you will have a much deeper understanding of how to join Salesforce and external data. You should be able to apply advanced use cases of the Aggregate node. ...

Get Creating Actionable Insights Using CRM Analytics now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.