A scatter plot is a chart used to show the relationship between two numerical variables. It displays data as individual dots on a graph:
One variable is placed on the X-axis (horizontal axis)
Another variable is placed on the Y-axis (vertical axis)
Each dot represents a single record or observation in the dataset.
For example:
· X-axis: Product Stock Quantity
· Y-axis: Product Price
Every product becomes one point on the chart.
Example: Website Load Time vs User Satisfaction
Imagine you own several websites and want to understand, "Does slower website speed reduce user satisfaction?". A scatter plot is perfect for answering this question.
user_statisfaction_metrics.csv
website_name,site_type,load_time_ms,user_satisfaction ShopMax,E-Commerce,900,96 ShopMax,E-Commerce,965,95 ShopMax,E-Commerce,1030,94 ShopMax,E-Commerce,1095,93 ShopMax,E-Commerce,1160,92 ShopMax,E-Commerce,1225,91 ShopMax,E-Commerce,1290,90 ShopMax,E-Commerce,1355,89 ShopMax,E-Commerce,1420,88 ShopMax,E-Commerce,1485,87 ShopMax,E-Commerce,1550,86 ShopMax,E-Commerce,1615,85 ShopMax,E-Commerce,1680,84 ShopMax,E-Commerce,1745,83 ShopMax,E-Commerce,1810,82 ShopMax,E-Commerce,1875,81 ShopMax,E-Commerce,1940,80 ShopMax,E-Commerce,2005,79 ShopMax,E-Commerce,2070,78 ShopMax,E-Commerce,2135,77 ShopMax,E-Commerce,2200,76 ShopMax,E-Commerce,2265,75 ShopMax,E-Commerce,2330,74 ShopMax,E-Commerce,2395,73 ShopMax,E-Commerce,2460,72 ShopMax,E-Commerce,2525,71 ShopMax,E-Commerce,2590,70 ShopMax,E-Commerce,2655,69 ShopMax,E-Commerce,2720,68 ShopMax,E-Commerce,2785,67 ShopMax,E-Commerce,2850,66 ShopMax,E-Commerce,2915,65 ShopMax,E-Commerce,2980,64 ShopMax,E-Commerce,3045,63 ShopMax,E-Commerce,3110,62 ShopMax,E-Commerce,3175,61 ShopMax,E-Commerce,3240,60 ShopMax,E-Commerce,3305,59 ShopMax,E-Commerce,3370,58 ShopMax,E-Commerce,3435,57 ShopMax,E-Commerce,3500,55 StreamNow,Streaming,300,97 StreamNow,Streaming,370,96 StreamNow,Streaming,440,95 StreamNow,Streaming,510,94 StreamNow,Streaming,580,93 StreamNow,Streaming,650,92 StreamNow,Streaming,720,91 StreamNow,Streaming,790,90 StreamNow,Streaming,860,89 StreamNow,Streaming,930,88 StreamNow,Streaming,1000,87 StreamNow,Streaming,1070,86 StreamNow,Streaming,1140,85 StreamNow,Streaming,1210,84 StreamNow,Streaming,1280,83 StreamNow,Streaming,1350,82 StreamNow,Streaming,1420,81 StreamNow,Streaming,1490,80 StreamNow,Streaming,1560,79 StreamNow,Streaming,1630,78 StreamNow,Streaming,1700,77 StreamNow,Streaming,1770,76 StreamNow,Streaming,1840,75 StreamNow,Streaming,1910,74 StreamNow,Streaming,1980,73 StreamNow,Streaming,2050,72 StreamNow,Streaming,2120,71 StreamNow,Streaming,2190,70 StreamNow,Streaming,2260,69 StreamNow,Streaming,2330,68 StreamNow,Streaming,2400,67 StreamNow,Streaming,2470,66 StreamNow,Streaming,2540,65 StreamNow,Streaming,2610,64 StreamNow,Streaming,2680,63 StreamNow,Streaming,2750,62 StreamNow,Streaming,2820,61 StreamNow,Streaming,2890,60 StreamNow,Streaming,2950,60 StreamNow,Streaming,3000,60 BankSecure,Banking,200,99 BankSecure,Banking,260,98 BankSecure,Banking,320,97 BankSecure,Banking,380,96 BankSecure,Banking,440,95 BankSecure,Banking,500,94 BankSecure,Banking,560,93 BankSecure,Banking,620,92 BankSecure,Banking,680,91 BankSecure,Banking,740,90 BankSecure,Banking,800,89 BankSecure,Banking,860,88 BankSecure,Banking,920,87 BankSecure,Banking,980,86 BankSecure,Banking,1040,85 BankSecure,Banking,1100,84 BankSecure,Banking,1160,83 BankSecure,Banking,1220,82 BankSecure,Banking,1280,81 BankSecure,Banking,1340,80 BankSecure,Banking,1400,79 BankSecure,Banking,1460,78 BankSecure,Banking,1520,77 BankSecure,Banking,1580,76 BankSecure,Banking,1640,75 BankSecure,Banking,1700,74 BankSecure,Banking,1760,73 BankSecure,Banking,1820,72 BankSecure,Banking,1880,71 BankSecure,Banking,1940,70 BankSecure,Banking,2000,69 BankSecure,Banking,2060,68 BankSecure,Banking,2120,67 BankSecure,Banking,2180,66 BankSecure,Banking,2240,65 BankSecure,Banking,2300,65 BankSecure,Banking,2360,65 BankSecure,Banking,2420,65 BankSecure,Banking,2480,65
Follow below step-by-step procedure to build the Scatter Plot.
Step 1: Create user_satisfaction dataset.
Data -> Upload CSV to database
Upload csv file.
Choose the database and schema name where you want to upload the data.
Give table name as user_satisfaction_metrics
Click on Upload button.
Navigate to datasets listing page, you can able to see the user_satisfaction_metrics dataset.
Step 2: Create Scatter plot.
Click on user_satisfaction_metrics dataset. You will be taken to the chart configuration page.
Click on ‘View all charts’ link.
Select scatter plot.
Drag and drop load_time_ms column to the X-axis section, user_satisfaction to the metrics section and site_type to the Dimensions.
Click on Create chart button, you can able to see the chart rendered like below.
Navigate to Customize tab and tick Data Zoom feature.
You can able to see horizontal slider is added to the chart.
Use the slider to focus on specific area of interest.
Save that chart.
That’s it, you're good to go.
Previous Next Home
No comments:
Post a Comment