the data was cleaned using power query, analyzed using excel, kpis and insights were extracted using pivot tables, the dashboard were created using canva