Some of my quick notes and tips based on my learnings in Wave.
Even if the release changes the external features. These exercises would give you a core understanding of the product.
We convert real numbers to integers as they are more compact. This is done only for storage. End user will still see real numbers. This however, improves the storage aspect of Wave.
What affects the size of the inverted index?
The cardinality of your column affects it. Cardinality is the number of unique values in a column.
Entropy is the same as Cardinality.
If you have pdf and blobs as data points, then you need a CMS and not a BI
Can you have null values for dimensions? Yes!
Most of the time the data is not well formed
Null values is not allowed for measures. Measures is a construct on which there is a lot of mathematical values.
To work around this, default values are allocated.
Augment operation is like a join. Augment can happen with different schema
Merge is an append, merge happens with exact same schema
While talking to customers, think of the following things:
Should I be thinking of denormalizations
Should I be thinking of dashboards etc
No comments:
Post a Comment