forked from manaswimishra/Cardinals-MLB-Data
-
Notifications
You must be signed in to change notification settings - Fork 0
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…
meghna-diwan/Cardinals-MLB-Data
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
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.\ \ \ }
About
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…
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published
Languages
- TSQL 98.3%
- Rich Text Format 1.7%