Solving an SDG Problem with Data (Choose Your SDG)

Overview

Select a Sustainable Development Goal (SDG) that resonates with you and develop a data-driven solution to address a specific problem within that SDG. Design a database, perform data analysis, and use Microsoft Excel as the user interface.

Objectives

• Choose an SDG and identify a specific problem to address.
• Design and implement a relational database relevant to your chosen problem.
• Write SQL queries to retrieve and analyze data.
• Use Microsoft Excel for data visualization and analysis.

Requirements

Part 1: SDG Selection and Problem Definition

• SDG Selection: Choose an SDG (e.g., SDG 3: Good Health, SDG 7: Affordable and Clean Energy).
• Problem Definition: Define a specific problem within your chosen SDG that can be addressed using data.

Part 2: Database Design

• ERD: Design an ERD for your project, including entities relevant to your SDG problem.
• Schema: Write SQL statements to create the database schema based on your ERD.
• Sample Data: Populate the database with relevant sample data.

Part 3: SQL Programming

• Data Retrieval: Write SQL queries to retrieve relevant data based on your problem definition.
• Data Analysis: Write SQL queries to analyze data and generate insights related to your SDG problem.

Part 4: Data Analysis Using Excel

• Import Data: Import data from your database into Excel.
• Analysis: Analyze the data using pivot tables, charts, and other Excel tools.
• Dashboard: Create an interactive Excel dashboard to visualize key insights.

Part 5: Integration and Testing

• Integration: Document the process of importing data into Excel and ensuring consistency.
• Testing: Test the integration and functionality of your Excel dashboard.

Part 6: Presentation

• Pitch Deck: Develop a 10-slide PowerPoint presentation as taught in the entrepreneurship module covering:
  • Project overview and SDG alignment.
  • Problem definition and significance.
  • Database design and schema.
  • Data analysis insights.
  • Excel dashboard demonstration.
• Delivery: Present your pitch deck, demonstrating how your project addresses the SDG problem.

Deliverables (upload onto this repo)

• SDG problem definition document
• ERD
• SQL scripts
• Excel workbook with data analysis and dashboard
• Integration documentation
• Pitch deck presentation (Provide the link e.g Canva or Gamma in your documentation)