Create a dashboard by microsoft power bi , after clean data by power query editor and create a fact table and its dimensions depends on business logic