Power BI Portfolio Project | Analyzing Kobe Bryant's Shot Selection: A Data-Driven Tutorial!

Описание к видео Power BI Portfolio Project | Analyzing Kobe Bryant's Shot Selection: A Data-Driven Tutorial!

In this episode of Data Discoveries, we dive into some Kobe Bryant shot stats!

I know very little about basketball, but I know just enough to know whether I'm visualizing the data correctly. This video is proof that you do NOT have to know a ton about the subject matter to be a successful Data and BI Analyst. You just have to be curious.

I've always admired Kobe's dedication to his craft. Everyone's heard the crazy stories about him getting into practice at 3 AM and already having done workouts by the time the rest of the players arrived. His persistence is what made him so masterful, and I'm grateful to have the opportunity to pay tribute via his shot data!

-----------------------------------------
Data source (thanks Xavier!):
https://www.kaggle.com/code/xvivancos...
-----------------------------------------
Interactive published view of report: https://app.powerbi.com/view?r=eyJrIj...
-----------------------------------------
Gear Check:
Keyboard: Keychron K12 60% Keyboard
Mouse: Dell MS900
Wrist Pad: DeltaHub.io wrist pad
-----------------------------------------
Download this PBIX, images, and and source data here (Google drive):
https://drive.google.com/drive/folder...
-----------------------------------------
Diagrams:
https://lucidchart.com
-----------------------------------------
SQL Server Resources:
https://whoisactive.com
-----------------------------------------
Powershell Resources:
(Powershell for SQL Server) https://dbatools.io
/ @dbatools
(Powershell Tutorials) Powershell in a month of lunches: https://www.manning.com/books/learn-p...\
-----------------------------------------
Data Sources
https://kaggle.com
https://data.gov
https://statista.com
https://www.microsoft.com/en-us/resea...
/ datasets
https://datos.estadisticas.pr
-----------------------------------------
Resources:
Notepad ++: https://notepad-plus-plus.org/downloads
Power BI Visual Vocabulary: https://community.fabric.microsoft.co...
https://dbatools.io/commands
https://liveSQL.oracle.com
-----------------------------------------
Favorite PBI Channels:
/ @howtopowerbi
/ @datapears
/ @guyinacube
/ @powerbipark
-----------------------------------------
Favorite SQL Server Channels:
/ @erikdarlingdata
/ @kendra_little
/ @brentozarunlimited
/ @andyleonard

-----------------------------------------
Catch me live on Twitch!   / sqldevdba  

Check out my Power BI Report Demos: https://SQLDevDBA.com/power-bi-demos
-----------------------------------------

Chapters:
00:00 - Intro / Topic Discussion
03:15 - Gear check: Keychron / Dell
05:53 - Dataset discussion
08:50 - Getting started - downloading/reviewing the data
13:58 - Starting our Power BI Report (Importing Data)
18:36 - Creating a Data Grid and reviewing data points/topics
25:10 - ROD720TV en la casa! Quick chat on data topics.
28:10 - Calculated column: Converting 1/0 to Y/N
33:49 - JeanTonos En la casa! Quick chat on Unknown values
37:48 - Scatter plot to show raw shot locations
39:15 - Quick note on custom visuals (how to download)
43:42 - Working with the scatter plot + a diagram of the court
52:07 - Analyzing by # of points
56:47 - Conditional formatting on scatter plots to show points easily
01:07:56 - Analyzing by Shot Type (Hook, Jump, Dunk, etc.)
01:12:48 - Adding User-friendly summaries / visuals
01:18:50 - Applying filters to specific visuals
01:20:35 - Adding a Bar Chart for Shot Made
01:23:46 - Conditional formatting on bar charts
01:27:24 - Duplicating formatted/designed page
01:30:08 - Adding Images with Web Links
01:32:07 - Other design features/tricks
01:38:26 - Updating Width of Axis Names in Bar Charts
01:47:07 - Adding Data Labels to bar graphs, adding % of Grand Total
01:59:54 - Adding Easy Page Navigation
02:09:20 - Publishing the report, publishing to web to share
02:12:38 - Close/Outro


------------------------------------------------------------
Music provided by Chillhop Music: https://chillhop.ffm.to/creatorcred
-----------------------------------------
Tags: #sql #sqlserver #powerbitutorial #powerbi #kobebryant #kobe #datavisualization #datavisualization #analytics #powerbidashboard #basketball #nba #nbadata

Комментарии

Информация по комментариям в разработке