Before touching any data, determine exactly what the dashboard needs to achieve.

: Create a separate PivotTable for each visual you plan to have on your dashboard. 4. Visualise with Pivot Charts

: Use Remove Duplicates under the Data tab to eliminate errors that could skew your visuals.

: Track real-time or daily activities and frontline tasks.