檳榔嶼

Discrete vs continuous
  - Green : Continuous
  - Blue : Discrete

Row and columns
  - bar chart : one discrete value and one measure
  - scatter chart : two continuous value


Filter :
  - Discrete : selection box
  - Continuous : scroll bar


Color : for discrete, avoid using too many colors



Date :

Pills : Challenge


  - Solution


Connect a data




How to create data extract
  - Users can decide to refresh or not



  - Live and Extract have differenct icons


Filter Extract
  - Right click


Extract : Challenge


  - Solution


Clean and prep your data





  - UPPER(LEFT(LTRIM([REGIONS/COUNTRIES]),1))+MID(LOWER(LTRIM([REGIONS/COUNTRIES])),2)

Split fields :





Pivoting the data
  - Shift Select




Merge data using unions




Cross database joins
Join Transformation



**** Skip Join Transformation First, because of the version mismatch  ****

Colors to highlight data

  - Grey Color tends to mute the data in the background
  - Orange Color is great to use as highlight

  - Bias Highlight : Scatter Plot
  



Visual Highlighter





The Analyics pane



  - Cluster



Cross-database filtering



Analytic Challenge


When to Map your data?
  - Using map chart, it is very easy to be affected by the area.


  - However, these options are limited.
  - www.mapbox.com

Create custom territories
  - Allow to redesign the region and assign all into an area

  - Group states together





  - Can group data in different ways without changing the original data

Mapping Challenge


Create calculations based on a parameter





Create dynamic reference lines






Dynamic dimension and measure selector







Dynamic sheet selection using parameters



Top N Analysis




Parameter Challenge


== Dashboard Design  ==

String to Date


Time Duration