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