Business-Analytics-Project

To Predict Best Team of Basketball in New Jersey

In this Project Microsoft Excel Technology has been used.

Summary:

To perform prediction analysis, I have chosen the College Basketball Stats and History website at Reference

Basketball is one of most popular sports in the college and professional level in the America. In this project, I will be comparing the performance of the teams in many ways for the 2019-2020 season to determine which team is the best performer. I will be using various techniques and methodology taught during this course to perform analysis on selected dataset.

Source of the dataset: Sports-reference

The dataset attributes have following information:

Entity	Name of Team
G	Number of Games
MP	Minutes Played per Game
FG	Field Goals per Game
FGA	Field Goals Attempt per Game
FG%	Field Goals percentage per Game
2P	2 PTs Per Game
2PA	2 PTs Attempt per Game
2P%	2 PTs Field Goal percentage per Game
3P	3 PTs Per Game
3PA	3 PTs Attempt per Game
3P%	3 PTs Field Goal percentage per Game
FT	Free Throws per Game
FTA	Free Throws Attempt per Game
FT%	Free Throw Percentage per Game
ORB	Offensive Rebounds per Game
DRB	Defensive Rebounds per Game
TRB	Total Rebounds per Game
AST	Assists per Game
STL	Steals per Game
BLK	Blocks per Game
TOV	Turnovers per Game
PF	Personal Fouls
PTS	Points Per Game

Objective: Predicting out of 3 teams a Best Team Performance in Basketball in New Jersey

Action Plans:

• I am planning to use benchmark to measure a performance using very specific indicators such as productivity per unit of measure, cost per unit of measure, cycle time of x per unit of measure or defects per unit of measure.

• These outcomes will give us performance results and it is easy to compare with each other teams.

• At the minimum, will include the following performance indicators for each team:

Number of games won
Number of games lost
PTS -- Total Points
G -- Number of Games played during the season
FG% -- Field Goal Percentage
2P% -- 2 Points Field Goal percentage per Game
TOV -- Total Turnovers

Expectations:

Apply all the knowledge of lessons learned in class, in additional try out more Business analytics techniques on the data set, to find out what could be more scope of study in different area. The main aim of project to gain experience in versatile Business analytics subject.

Using Tools:

I have decided to use Excel and functions such as Min, Max, Sum, Average, Count, Count IF, VlookUp to ease analysis work. I will also use some of the different features of Excel like Dashboard, ICON Sets, Sparklines, Descriptive Statistics, Predictive Model. This will be new function for me Use the Slicer functionality to slice the data

bchavan22 / business-analytics-project Goto Github PK