Biomedical Data Analysis: mini-Projects

Introduction

• Projects
  • mini Project 1: drug – target interaction
  • mini Project 2: topics of your own research

• Purpose
  • Learn the practical skill of data modeling, database usage, and data based analysis
• Objectives
  • 1. Practice data modeling
  • 2. Learn to construct a database and use it
  • 3. Analyze data using database

mini Project 1: practice to build a simpler database using a complex database (ChEMBL)

Drug – target interaction

Practice to model a small database (entity – relationship model) using Chembl data

• Data modeling
  • simplified entity
    • compound
    • target
    • activity
  • Base database
    • Chembl
• Database construction
  • Create you own database
    • MySQL Workbench
    • Forward engineering
• Data analysis
  • Load data from the database (your database)
  • Plot data (histogram of activity)
• Presentation
  • Prepare presentation
  • Explain your experience on the data analysis procedures

mini Project 2: organize your own data for research

• Presentation 1. Introduce your research topic
  • Introduce you research
  • Think of the data you can utilize
  • Suggest a conceptual data model of database related to your research
    • the model should be simple as we are exercising
• Data modeling
  • Create your data models
• Database construction
  • Fill in the actual research data or pseudo data to the database
  • If you are not have real data yet, you can make any arbitrary data and use them
• Data analysis
  • Create a data analytics using the database
  • Employ statistical analysis and machine learning method
  • Visualize the data and explain the meaning of the results
    • The significance of result does not matter.
• Presentation 2. Present your data analysis
  • Explain the purpose of your project, data modeling, database construction, and data analysis results
  • Focus on the purpose of the research