Data Analysis & SQL: Dognition’s Data in MySQL

(Summer 2018)
Data Analysis & SQL: Dognition’s Data in MySQL (Summer 2018)
• Do exploratory data analysis for Dognition test records, then Design, build and query Dognition’s database from records.
• Learn Dognition’s dataset by Tableau; then design a Relational Database for Dognition with ER diagram and relational schema; create a Dognition’s database by MySQL
• Implement SQL to learn more about different kinds of dogs and what kind of users with dogs are more interested in Dognition. https://github.com/JianhuanZeng/Dognition-Data-in-MySQL

1. EDA Tableau, Python(Pandas, Matplotlib)
   

2. Design my Dognition database
   dognitionER.erdplus: ER diagram
   dognitionRS.erdplus: relational schema
   

3. Build the database in MySQL with tables
   (1). Split the csv doc into 3 tables:
   tests.csv,
   users.csv,
   dogs.csv
   (2). Create my Dognition Database
   

4. Queries in database
   (1). look at database
   (2). summarize
   (3). customer service
   (4). learn more about dogs