Tableau Prep - Add Rows for Daily and Monthly Reports / Dashboards | sqlbelle
Tableau Prep Builder can generate sequential rows that can help us when we have sparse records, or missing some data points. This is called the "Add Rows" step.
In this video we will walk through 2 use cases:
1. Daily sales / order count report
2. Monthly payment schedule
Tableau Prep Builder is a tool that allows us to clean / prep / transform our data prior before we use it in Tableau Desktop.
Chapters
00:16 - Setup
02:32 - Use Case 1: Daily Sales / Order Counts
04:03 - Use Case 2: Monthly Payment Schedule
Additional Tutorials
Level Up Tableau
https://www.youtube.com/watch?v=rKTudr3lKc4
Table Calculations
https://youtu.be/3_DeQdE25Bc
Level of Detail (LOD) Expressions
https://youtu.be/yush1yNz9VM
Calculations Playlist
https://www.youtube.com/playlist?list=PLkZ_g9Y7eszKalPnHxchnp93YjeWgYitS
Sets and Set Actions
https://youtu.be/tGO1D18hKv4
Top 1-5 LOD Expressions
https://youtu.be/j6j_Lxx3ndM
Dates
https://youtu.be/ufhNJmYrVhs
Filters
https://youtu.be/DVTFvmoUnlE
Sample Certification Exam Questions
https://www.youtube.com/playlist?list=PLkZ_g9Y7eszJAm-ZbUT7jnldrl-uF-bWe