1 / 43

LODs on ALPO

LODs on ALPO. Bronson Shonk Sr. Product Consultant tableart.co. Agenda Techniques: Aggregate Bins Pivot Isolate + Propagate. Example 03: Aggregate Bins. How many matches has each player won while playing?. How many matches has each player won while playing?.

vwillingham
Download Presentation

LODs on ALPO

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LODs on ALPO Bronson Shonk Sr. Product Consultant tableart.co

  2. Agenda Techniques: Aggregate Bins Pivot Isolate + Propagate

  3. Example 03: Aggregate Bins

  4. How many matches has each player won while playing?

  5. How many matches has each player won while playing? SUM(My Goals) > SUM(Opponent Goals)

  6. How many matches has each player won while playing? SUM(My Goals) > SUM(Opponent Goals) 3 > 2 = win

  7. How many matches has each player won while playing? SUM(My Goals) > SUM(Opponent Goals) 0 > 0 = win

  8. How many matches has each player won while playing? SUM(My Goals) > SUM(Opponent Goals)

  9. How many matches has each player won while playing?

  10. How many matches has each player won while playing?

  11. How many matches has each player won while playing?

  12. How many matches has each player won while playing?

  13. Data Model

  14. Data Model

  15. Data Model SUM( Amount ) >= SUM( Quota ) 70 >= 80 FALSE

  16. Data Model SUM( Amount ) >= SUM( Quota ) 70 >= 80 FALSE

  17. Data Model SUM( Amount ) >= MIN( Quota ) 70 >= 20 TRUE

  18. Example 04: Pivot

  19. What is the gap between students’ 1st and 2nd highest exam scores?

  20. What is the gap between students’ 1st and 2nd highest exam scores?

  21. What is the gap between students’ 1st and 2nd highest exam scores? Table Calculation: RANK()

  22. What is the gap between students’ 1st and 2nd highest exam scores?

  23. What is the gap between students’ 1st and 2nd highest exam scores? Columnar Calculation: 1st – 2nd = 2

  24. What is the gap between students’ 1st and 2nd highest exam scores? Calculation 2 Calculation 1

  25. What is the gap between students’ 1st and 2nd highest exam scores? Calculation 1

  26. What is the gap between students’ 1st and 2nd highest exam scores? Calculation 1

  27. What is the gap between students’ 1st and 2nd highest exam scores?

  28. What is the gap between students’ 1st and 2nd highest exam scores? Calculation 2

  29. What is the gap between students’ 1st and 2nd highest exam scores?

  30. What is the gap between students’ 1st and 2nd highest exam scores?

  31. What is the gap between students’ 1st and 2nd highest exam scores?

  32. What is the gap between students' 1st and 2nd highest exam scores?

  33. What is the gap between students' 1st and 2nd highest exam scores? Columnar Calculation: 1st – 2nd = 2

  34. Example 05: Pivot + Isolate + Propagate

  35. Which subject do students score highest in?

  36. Which subject do students score highest in? Step 1: pivot Step 2: isolate Step 3: propagate (cohort)

  37. Which subject do students score highest in? Step 1: pivot Step 2: isolate Step 3: propagate (cohort)

  38. Which subject do students score highest in? Step 1: pivot Step 2: isolate Step 3: propagate (cohort)

  39. Which subject do students score highest in? Step 1: pivot Step 2: isolate Step 3: propagate (cohort)

  40. Which subject do students score highest in? Step 1: pivot Step 2: isolate Step 3: propagate (cohort)

  41. Which subject do students score highest in? Step 1: pivot Step 2: isolate Step 3: propagate (cohort)

  42. Bronson Shonk bshonk@tableau.com tableart.co

More Related