No video

SQL Analysis Project: Identifying Outliers and Department Statistics

  Рет қаралды 3,555

Absent Data

Absent Data

Күн бұрын

Пікірлер: 19
@simonoganga9535
@simonoganga9535 Жыл бұрын
Wow, this is an amazing tutorial packed with a lot of content to boost SQL learning. Thank you so much for this.
@JW-pu1uk
@JW-pu1uk 11 ай бұрын
Coming back to this to let you know what a phenomenal tutorial this is!
@absentdata
@absentdata 11 ай бұрын
Awesome. I am glad that you are enjoying it. I enjoyed making it!!
@ericaleverson9430
@ericaleverson9430 Жыл бұрын
Thanks for sharing. I will use this as a project at work.
@Adeyeye_seyison
@Adeyeye_seyison Жыл бұрын
Thanks a million sir, For the value adding contents...
@theresaparker3384
@theresaparker3384 Жыл бұрын
I really liked this video. I thought you explained difficult concepts i. An easy to understand format and in a brief manner. Kudos! I loved seeing the statistics in SQL! I havent noticed many content creators covering statistics using SQL like you did. Would love to see more projects like this!!
@absentdata
@absentdata Жыл бұрын
I love the feedback. I would love to provide more of these types of videos. Its important to understand not only the techniques but also analysis. Please share them with anyone you think it will help
@theresaparker3384
@theresaparker3384 Жыл бұрын
@Absent Data I agree! I would be intrigued to see an expanded video that also includes a data visualization piece. I am curious how you would visually present this to an audience (like a box/whisker plot) that is not technical like executive leadership. Just a thought!
@zanderrita2526
@zanderrita2526 Жыл бұрын
Wow thank you for sharing sir
@diamondsandlipgloss
@diamondsandlipgloss 2 ай бұрын
I'm unable to import the excel file. my errror message says I do not have a configuration string or file set up. I googled the error msgs and apparently the Salary column cannot have "dbNull". Is this working in 2024 for everyone else?
@tboykelvin1865
@tboykelvin1865 Жыл бұрын
Thank uuu
@nahavasa
@nahavasa Жыл бұрын
Thanks very much sir. I'll definitely do this project later. Can I use this project to my portfolios?
@absentdata
@absentdata Жыл бұрын
Of course!
@camomile4085
@camomile4085 2 ай бұрын
WITH cte1 AS ( SELECT *, AVG(salary) OVER (PARTITION BY department) AS salary_avg, STDDEV_SAMP(salary) OVER (PARTITION BY department) AS std_dev FROM employee_salaries WHERE Salary >= 10000 ), cte2 AS ( SELECT *, (salary - salary_avg)/std_dev AS z_scores FROM cte1 ), cte3 AS ( SELECT cte2.department, cte2.salary_avg, cte2.std_dev, ROUND(cte2.std_dev/cte2.salary_avg*100,2) AS Coefficient_of_variation, SUM(CASE WHEN ABS(z_scores) > 1.96 THEN 1 ELSE 0 END) AS Ouliers_count FROM cte2 GROUP BY cte2.department, cte2.salary_avg, cte2.std_dev ) SELECT * FROM cte3 ORDER BY Coefficient_of_variation DESC ;
@carolinecarr56
@carolinecarr56 Жыл бұрын
Can we also get the database to we can follow along??
@absentdata
@absentdata Жыл бұрын
Added the dataset to the description.
@simonoganga9535
@simonoganga9535 Жыл бұрын
How can someone reach you Sir(email, linkedin, etc)? Your teaching is AMAZING
@absentdata
@absentdata Жыл бұрын
You can reach me on Linkedin. My contact is in the profile.
@tboykelvin1865
@tboykelvin1865 Жыл бұрын
Thank uuu
Find Outliers in SQL
8:58
Absent Data
Рет қаралды 10 М.
Joker can't swim!#joker #shorts
00:46
Untitled Joker
Рет қаралды 41 МЛН
Please Help Barry Choose His Real Son
00:23
Garri Creative
Рет қаралды 23 МЛН
白天使选错惹黑天使生气。#天使 #小丑女
00:31
天使夫妇
Рет қаралды 15 МЛН
Correcting Skewed Data with Scipy and Numpy
11:36
Christopher Pulliam, PhD
Рет қаралды 7 М.
Isolation Forest: A Tree based approach for Outlier Detection (Clearly Explained)
18:02
Data Cleaning in MySQL | Full Project
51:11
Alex The Analyst
Рет қаралды 129 М.
Outliers : Data Science Basics
13:07
ritvikmath
Рет қаралды 12 М.
Removing Outliers From a Dataset
5:29
Dr. Vimal
Рет қаралды 427
How to Find Outliers with Excel
6:07
Absent Data
Рет қаралды 300 М.
Joker can't swim!#joker #shorts
00:46
Untitled Joker
Рет қаралды 41 МЛН