PLAY WITH EINSTEIN ANALYTICS PART 3
Hi All, hope you all are enjoying the tutorial series of Einstein Analytics. In the previous tutorial, we learned how we can create Application, Dashboards, Datasets, Lenses, and Steps into Einstein Analytics. So, on Day 3 we will learn the below topics.
For those who have not gone through with the previous tutorials please visit the same so that you can come on the same track and understand the things in easy and better way. Here is the Link for the previous posts.
When to use which chart for analytics: – It’s very important to understand which chart is suitable whenever we wanted to analyze the data. Below are two images which illustrate when we should for which chart.
Create Dataset using CSV File: – In many cases, Company has some legacy data that resides outside the Salesforce ORG and they do not want to import the old data into Salesforce. So, in this case, we can use. CSV file and import the same into Analytics to analyze the data.
Introduction to SAQL: – Salesforce Analytics Query Language Analytics Cloud uses SAQL behind the scenes in lenses, dashboards, and explorer to gather data for visualizations. Users don’t write SAQL statements, they use the UI and the app makes the queries. SAQL loads the dataset, perform the operations on it and generate the output dataset.
When to use SAQL: –
Developers can write SAQL to directly access Analytics Cloud data via:
SAMPLE SAQL –
q = load "0Fcc00000004DI1CAM/0Fd500000004F4sCAE"; q = group q by all; q = foreach q generate count() as 'count', unique('OL.Helpful') as 'unique_OL.Helpful'; limit q 2000;
Basic SAQL Elements: –
Refer the video
Thanks for reading 🙂
Sharing is caring 🙂 😉
If you have any questions/query/suggestions please come up in the comment section or you can tweet me @cloudyamit