remove duplicate values in the dataset using excel
create new columns to use it
create a pivot tables and the suitable pivot charts to visualize it
make pivot tables dynamic using slicer