victorayoola001/Tobacco-control-compliance-monitoring

This project seeks to evaluate the knowledge and compliance of different recreational facilities on the sale, use and control of Tobacco and Tobacco products across six states in the six geopolitical zones in Nigeria # Tobacco Control Compliance Monitoring ## 📚 Table of contents 1. Project Overview 2. Tools & Technologies 3. Dataset overview 4. Data cleaning & preparation 5. Exploratory Data Analysis 6. PowerBi Dashboard 7. Key Insights 8. Recommendations 9. Data Source ### Project Overview This project seeks to evaluate the knowledge and compliance of different recreational facilities on the sale, use, and control of Tobacco and Tobacco products across six states in the six geopolitical zones in Nigeria. Data was collected using Kobo Collect, a digital survey ODK tool for data collection, and was exported into an Excel spreadsheet for data cleaning and preparation. The data was cleaned by filling in missing values, taking out incorrect values, and ensuring all column values are in the correct data type formats. Data was prepared, and a preliminary analysis was carried out by calculating the required measures and columns not originally contained in the dataset before exploratory data analysis (EDA) commenced. EDA was designed to reveal hidden trends and patterns, correlations, relationships, and associations between variables in the dataset so useful insights could be drawn. ### Tools & Technologies The following tools were used in this project 1. Kobo Collect: Used for data collection 2. Excel: Used for data cleaning and preparation 3. MySQL: Used for preliminary Analysis and EDA 4. Jupyter Notebook: Used to document the EDA process & codes 5. PowerBI: Used to visualize trends, patterns, and Key Metrics ### Dataset Overview Sample Preview (Table rows and columns were truncated for easier readability) ### Data Cleaning & Preparation * The dataset was scanned for missing or null values and handled appropriately * Incorrect entries were corrected or taken out * Converted numeric and string columns to proper data type formats * Converted the date values to date format types ### Exploratory Data Analysis #### Question 1: How many facilities were visited across the six geopol …