Preview of How to Build Dynamic Leave Approval, Tracker & Analytics

(English) How to Build Dynamic Leave Approval, Tracker & Analytics with Google Form, Google Sheets & Google Data Studio

20210716 How to Build Dynamic Leave Approval, Tracker & Analytics with Google Form, Google Sheets & Google Data Studio

Preview of How to Build Dynamic Leave Approval, Tracker & Analytics with Google Form, Google Sheets & Google Data Studio (3:33)
Session #01 (111:21)
Session #02 (196:13)

Training Material & Notes

(Morning Session) Training Video - Part 1: Google Form (Hands on)

(Morning Session) Training Video - Part 2: Google Data Studio (Easy version)

(Morning Session) Training Video - Part 3: Final Digital Tools Showcase

(Afternoon Session) Training Video - Part 4: Set up settings

(Afternoon Session) Training Video - Part 5: Set up mark sheet

(Afternoon Session) Training Video - Part 6: Monthly Summary

Video 12: Monthly Date (12:11)
Video 13: Employee Name (5:44)
Video 14: Table of CF (5:30)
Video 15: CF working days (6:01)
Video 16: CF holidays (5:53)
Video 17: CF leave type (6:13)
Video 18: Vlookup (5:06)
Video 19: Sum product (15:10)
Video 20: Monthly summary (10:32)

(Afternoon Session) Training Video - Part 7: Summary

(Afternoon Session) Training Video - Part 8: Google Data Studio (Advance version)

Video 24: GDS (2:46)
Video 25: Title (1:41)
Video 26: Time series (4:38)
Video 27: Stacked column (3:08)
Video 28: Table of summary (4:41)
Video 29: Pie chart (2:15)
Video 30: Finale (4:13)

Discussion