GitHub - manaswimishra/Cardinals-MLB-Data: Create a relational database using 2010 - 2018 MLB at-bat information for Cardinals Enable the generation of insights into team dynamics Focus on both descriptive findings and predictive recommendations. Leverage this rich dataset to generate compelling visualizations of our findings and enable our audience to interact with the database via an intuitive dashboard.

manaswimishra / Cardinals-MLB-Data Public

Create a relational database using 2010 - 2018 MLB at-bat information for Cardinals Enable the generation of insights into team dynamics Focus on both descriptive findings and predictive recommendations. Leverage this rich dataset to generate compelling visualizations of our findings and enable our audience to interact with the database via an i…

0 stars 1 fork Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 22 Commits
OldData		OldData
.DS_Store		.DS_Store
2011_mlbdatatransformations.csv		2011_mlbdatatransformations.csv
BallparkID.csv		BallparkID.csv
Cardinals_At_Bar_Snowflake_DDL.sql		Cardinals_At_Bar_Snowflake_DDL.sql
Cardinals_At_Bar_Snowflake_DML.sql		Cardinals_At_Bar_Snowflake_DML.sql
CardsDataAggregation.sql		CardsDataAggregation.sql
DML_test.sql		DML_test.sql
EventID.csv		EventID.csv
MLB Analysis.pdf		MLB Analysis.pdf
MLB project part-DDL-1.sql		MLB project part-DDL-1.sql
PitchID.csv		PitchID.csv
PlayerIDs.csv		PlayerIDs.csv
ReadMe.rtf		ReadMe.rtf
TeamID.csv		TeamID.csv
mlbdatatransformations_all_years.csv		mlbdatatransformations_all_years.csv

Repository files navigation

Main File- MLB Analysis.pdf



{\rtf1\ansi\ansicpg1252\cocoartf1671\cocoasubrtf600
{\fonttbl\f0\fswiss\fcharset0 Helvetica-Bold;\f1\fswiss\fcharset0 Helvetica;}
{\colortbl;\red255\green255\blue255;}
{\*\expandedcolortbl;;}
\margl1440\margr1440\vieww17040\viewh4000\viewkind0
\pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\pardirnatural\partightenfactor0

\f0\b\fs24 \cf0 PULLING ALL THE TABLES INTO SQL\
\

\f1\b0 a) Create a new database called MLB\
b) Right-click on tables and click on \'92Table Data Import Wizard\'92\
c) Import the following files with the following names - \
	mlbdatatransformations_all_years.csv as mlbdatatransformations\
	TeamID.csv as teamid\
	PitchID.csv as pitched\
	EventID.csv as eventid\
	BallparkID.csv as ballparkid\
	PlayerIDs.csv as playerids\
\
Note: Do not change any data types when importing any of the above tables.\
\
\
}