Wave 102: Org Enablement of Wave Analytics

First enable the org and then give permission sets for the users  

How to enable analytics cloud for users? 

Setup-> Analytics Cloud->Getting Started-> Enable Analytics.  

This enables Analytics Cloud(AC) for the organization.  

But this does not mean the user has access to it. For this permission set licenses have to be enabled.  

Go to User-> permission set licenses (PSL) and give the explore license or build license.  

Explore license to create dashboards based on existing data sets 

Builder license for power users to create dashboards and data sets 

Permission sets under manage users and click New.  

Give a label api name and description and give the license as default null.  

Next go to the system permissions, go to edit and then create a permission set specific for analytics cloud.  

-SAQL editor 

-Create Analytics Cloud Apps 

-Create and edit Analytics cloud Dashboards 

-Edit Analytics cloud dataflows 

-Manage analytics cloud 

-Upload external data to AC 

-Use AC (already checked) 

Minimum sets to assign for AC builder.  

Click manage assignments for assigning to users.  

Click add assignment and assign a user.  

Now you will be able to see the analytics in the dropdown and you will be able to see the analytics cloud page for wave. 

Overview how to query in AC: 

Components of dashboard can come from one or many datasets.  

An app is a folder. It is specific for a user/group of users. 

Default dataset is a count of rows 

Three basic parts of a query: 

Grouping, Filter & Aggregation 

The charts available gives aggregated views. To see the raw data we can click the raw aggregated data. 

Recap: 

Dimension is a descriptive attribute with a discrete value of your data 

Measure is a mathematical value on which mathematical operations are performed. Ex: Age, Stage Duration 

 How to find the grain level? 

By looking at the raw data table.  

Some chart types support only one measure and some support more than one measure.  

More than one measure: 

-Scatter Plot 

-Compare Table (Multiple measure in Tabular format) 

To get a formula column.  

Edit formula and format. 

Raw measures is the raw data and the computed measures are the formula fields.  

The groupings are not counted as the Measures. They are dimensions.  

Stacked bars: The stacking by default is done by dimensions currently. 

Note: Try to keep the number of measures low and the dimensions higher. Preferably 1 measure and multiple dimensions 

Ask questions like what is the grouping, what is the dimension and what is the measure.