realNommy/maji-ndogo-data-analytics

End-to-end data analytics project using SQL, MySQL, Power BI, Power Query, DAX, data modeling, and data visualization. -- ============================================================================== -- MAJI NDOGO WATER SERVICES DATABASE (COMPLETE SEED SCRIPT) -- Course: ALX Data Analytics / Maji Ndogo Project -- ============================================================================== CREATE DATABASE IF NOT EXISTS maji_ndogo; USE maji_ndogo; -- ------------------------------------------------------------------------------ -- Table: employee -- ------------------------------------------------------------------------------ DROP TABLE IF EXISTS employee; CREATE TABLE employee ( assigned_employee_id INT PRIMARY KEY, employee_name VARCHAR(255) NOT NULL, phone_number VARCHAR(50), email VARCHAR(255), address VARCHAR(255), province_name VARCHAR(100), town_name VARCHAR(100), position VARCHAR(100) ); INSERT INTO employee (assigned_employee_id, employee_name, phone_number, email, address, province_name, town_name, position) VALUES (0, 'Jengo Tumaini', '+99712584936', 'jengo.tumaini@mdwater.gov', '123 River View', 'Sokoto', 'Balanja', 'Field Agent'), (1, 'Vuyisile Ghadir', '+99317854629', 'vuyisile.ghadir@mdwater.gov', '45 Lab Lane', 'Amanzi', 'Dahabo', 'Micro Biologist'), (2, 'Usafi Bahir', '+99234156789', 'usafi.bahir@mdwater.gov', '78 Health St', 'Hawassa', 'Zuri', 'Data Analyst'), (3, 'Bello Pendo', '+99654123890', 'bello.pendo@mdwater.gov', '89 Central Ave', 'Sokoto', 'Balanja', 'Field Agent'), (4, 'Farai Simba', '+99432187654', 'farai.simba@mdwater.gov', '12 Green Rd', 'Amanzi', 'Dahabo', 'Field Agent'); -- ------------------------------------------------------------------------------ -- Table: location -- ------------------------------------------------------------------------------ DROP TABLE IF EXISTS location; CREATE TABLE location ( location_id VARCHAR(50) PRIMARY KEY, province_name VARCHAR(100), town_name VARCHAR(100), location_type VARCHAR(50) ); INSERT INTO location (location_id, province_name, town_name, location_type) VALUES ('SoBa31102', 'Sokoto', 'Balanja', 'Urban' …