Clicked-Data-Analysis-Sprint

Original Dataset Link: https://www.kaggle.com/datasets/wyattowalsh/basketball

SQLiteStudio Setup Link: https://sqlitestudio.pl/

Best resource for Data Visualizations: https://www.data-to-viz.com/

Project Plan Outline

Steps:

1. Access and Understand the Data:

• Connect to the database containing NBA data and access tables. (2 Methods: SQL Magic or Connection Object)
• Examine the data structure and identify key tables and fields.

2. Perform SQL Analysis:

• Write SQL queries to extract relevant data for analysis.
• Analyze relevant metrics to determine team, player or game outcomes.
• Identify trends, patterns, and anomalies in the data that could impact the outcomes of games.

3. Generate Insights:

• Summarize findings in a report.
• Identify factors contributing to player/team/game success.

4. Develop Recommendations:

• Based on analysis, formulate actionable recommendations to improve player/team/game.
• Consider strategies such as marketing initiatives, rule or official changes, or other related changes.

Tools:

1. Python
2. SQL
3. Kaggle
4. SQLiteStudio
5. Deepnote
6. Perplexity.ai
7. Gamma

Deliverables:

1. Portfolio with relevant documentation and files
2. Presentations with recommendations

Timelines for each phase:

• Access and Understand the Data: 29 July 2024 to 5 Aug 2024
• Perform SQL Analysis: 6 Aug 2024 to 11 August 2024
• Generate Insights: 12 August 2024 to 14 August 2024
• Develop Recommendations: 15 August 2024 to 16 August 2024

Clicked Certificate

IBM SkillsBuild Certificate and Badge

Propose Data Driven Insights Using SQL.pdf