Introduction to SQL Programming for Excel Users Part 6 - More Feature Engineering

SQL is a critical skill for any aspiring analytics and data science professional and you can use your Excel knowledge to learn SQL programming. If you've been looking for content on SQL for beginners, this is it!

In this SQL tutorial series I will cover the 20% of SQL programming that is 80% useful for business analytics.

Not only will you learn super useful business analytics techniques like RFM and Pareto analysis, but you will also learn critical aspect of SQL for data analysis like:

- JOINS
- GROUP BY
- CASE WHEN
- SQL window functions
- And more

Make no mistake, SQL is a top skill for ANY professional looking to have more impact at work with business analytics.

-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:

Stay healthy and happy data sleuthing!

#SQL #SqlProgramming #SqlTutorial #SqlForBeginners #SqlForExcelUsers

[DaveOnData]

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:

[SamsdsReviews]

correction at min 17:10

In order to get two decimal places for the AvgCallsPerOperator, you must enclose the command within another CAST function. So the new command should look like this:

CAST (CAST(FCC.Calls as decimal (6, 2)) / (FCC.LevelOneOperators + FCC.LevelTwoOperators) AS decimal(6, 2)) AS AvgCallsPerOperator

This should now get it to work the way it's intended. Hope this helps! :)

[roywit]

Found this video very valuable to my newb learning
Working my way through your series this week, from UK, and we have entered full lockdown for a month.

11:14 - I love the way this is explained/shown in detail ... which perfectly set the flow of Understanding, into the CAST function

I've a feeling learning this early will save a lot of unnecessary synthax error pain in the forthcoming weeks!

Big thank you for detailing slowly, a missing ingredient many IT YouTubers have not mastered

[ayubaadigun]

Thanks David Langer for the videos. I really love your teachings.

But I observed after using the CAST(FCC.Calls(DECIMAL(6, 2)) function, the digits are more than 6 and the numbers to the right of the decimal are more than 2 as opposed to what you said in the video.

Any clarification on that.

[jean-marcherard]

Great video with clear explanations!
Totally enjoying your Excel / sql series.

[zubairso]

Another great video! I love the fact how you keep repeating small details and by the time the video is over, those concepts are embedded into memory.