/week-8-c-Kuria

database-week-8-week8.2 created by GitHub Classroom

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)