MercyIyanu/Analysis-of-Road-Accident-in-Nigeria-using-MySQL-and-Power-BI

Analysis of dataset of information on reported road accident cases in Nigeria from 2020 (quarter four) - 2022 (quarter one). Analysis of Road Accident in Nigeria using MySQL and Power BI Overview: Explored a dataset of information on reported road accident cases in Nigeria from 2020(quater four) to 2022(quarter one). Conducted extensive data cleaning procedures and introduced an additional column to enhance dataset comprehensiveness and accuracy. Imported the refined data into Power BI to create an interactive dashboard revealing the severity of reported cases, trends into the number of casualties across all states within this period. Aim: To know the preferred streaming platform in Nigeria To know the preferred streaming platform for different gender To know the preferred streaming platform across different age groups To determine if these streaming platforms affect viewers' cinema viewing experience Tools used: MySQL Microsoft Power BI Key Performance Indicators: 1. Total amount spent on monthly subscription 2. Average Age