Simple Power BI Dashboard

I have an excel file tracking the work of 9 managers. Within each manager we have 6 tables of data (54 total tables).

I would like to visualize the following:
Overview dashboard showing an aggregate view of activities for all 9 managers that can be sliced by Quarter, Month or Week (day?)
Aggregate total based on 10 charts below
Dive into each Manager on the following:
Daily Journal: How they spent their day across three choices (Office Day, Regional/Team Meeting, Travel with Rep)
Coached Proficiency:
How many Proficiency Themes have they coached & what Reps have they coached them on
How many proficiencies have they coached on
What Reps have they worked with on what proficiency
Pre-Meeting Planner:
What Reps have they helped prepare a pre-meeting planner for?
Visualize the number of meetings and Buy Call objectives
Retailer Name & Buy Call Objectives
Business Impact (Dealer Meeting):
Link to the Pre-Meeting planner and show how the meetings were attended
Show success of each meeting across objectives (outcomes)
Show this by Rep & Retailer
Measure Wins:
Show count of Retailer & Objective against a long-term goal of 40
Show count of wins against Rep