Predictive Analysis using liner regression. We are working with a data set that has data for 2805 matches from 1871 to 2015. I will be performing an exploratory data analysis to understand the statistical properties and distribution shapes of 8 key variables and do a correlation analysis to study if win or loss has a correlation to run scores, run against, and run difference, from 1960 to 2010. Lastly I will be doing correlation analysis to games won, creating a test and train data set and build linear regression model for all of our 4 time periods, and test our model by predicting games won by NYY and TORR from 2012 - 2015

The first scenario is based on data stored in an SQLite relational database, accessible using SQL that is coded within a Python program.  This scenario is about a Video Rental Store company. The database is called “sakila.”  This database will be implemented using the SQLite database. The physical database will be stored as a file on your local computer and accessed using SQL commands via Python.

The second scenario is based on data stored in a MySQL database hosted on the Google Cloud Platform (GCP) This database describes the activities of a Soft Drink Distribution company. The database is relational and accessible by SQL. The physical schema on GCP is called “user.” The MySQL database will be accessed using SQL executed via the MySQL Workbench application and via Python. Note that the MySQL Workbench application and Python will be hosted on your local computer.

The third scenario is based on data describing the names, locations and cuisine categories for restaurants in New York City. This data is stored in MongoDB, a document NoSQL database. It is hosted on the Google Cloud Platform (GCP). You will access MongoDB using the Robo-3T application and Python. Both Robo-3T and Python will be hosted on your local computer.

The fourth scenario is based on a movie dataset showing which actors and directors have been involved with various movie titles. The data is stored in Neo4j, a graph NoSQL database. It is hosted on Neo4j’s sandbox accessed via Neo4j’s website. You will access this database using the Neo4j Browser application accessed via your local web browser.