𝗧𝗵𝗶𝘀 𝗶𝘀 𝗵𝗼𝘄 𝘆𝗼𝘂 𝗰𝗮𝗻 𝗮𝗻𝘀𝘄𝗲𝗿 𝗽𝗼𝘁𝗲𝗻𝘁𝗶𝗮𝗹 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗾𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝗯𝘆 𝗛𝗥 𝘂𝘀𝗶𝗻𝗴 𝗷𝗼𝗶𝗻𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁!
As a data analyst, you will work with multiple tables in SQL.
This is why you should know how to perform Joins as a data analyst.
Also, let’s try to answer a potential business question by HR using joins in SQL.
𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻: How much maximum salary an employee got?
𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻:
𝗦𝗘𝗟𝗘𝗖𝗧 𝗲.𝗳𝗶𝗿𝘀𝘁𝗻𝗮𝗺𝗲 𝗔𝗦 “𝗳𝗶𝗿𝘀𝘁𝗻𝗮𝗺𝗲”,
𝗠𝗔𝗫(𝘀.𝘀𝗮𝗹𝗮𝗿𝘆) 𝗔𝗦 “𝗺𝗮𝘅_𝘀𝗮𝗹𝗮𝗿𝘆”
𝗙𝗥𝗢𝗠 𝗲𝗺𝗽𝗹𝗼𝘆𝗲𝗲𝘀 𝗮𝘀 𝗲
𝗜𝗡𝗡𝗘𝗥 𝗝𝗢𝗜𝗡 𝘀𝗮𝗹𝗮𝗿𝗶𝗲𝘀 𝗔𝗦 𝘀 𝗨𝗦𝗜𝗡𝗚 (𝗲𝗺𝗽_𝗻𝗼)
𝗚𝗥𝗢𝗨𝗣 𝗕𝗬 𝗲.𝗳𝗶𝗿𝘀𝘁_𝗻𝗮𝗺𝗲
So, this is how you can perform inner join and answer a potential business question by HR.
Enjoy. Like, Comment, and Follow for more!
#DataAnalyst #BusinessProblems #DataAnalytics #BusinessAnalyst #BusinessAnalytics #DataAnalysis #BusinessAnalysis #ProductAnalyst #DataAnalysisTips #AnalyticsCareer #BusinessProblems #CommunicationSkills #EffectiveCommunication #DataScienceCommunity #AnalyticsTips #DataWorkflow #AnalyticsBestPractices #DataProcesses #DataTypes #AnalyticsDocumentation #US #UK #Europe #Singapore #Germany #SQL #Python #PowerBI #Excel #AmazonRedshift #ABTesting #Remotework #GlobalRemoteWork #SalesAnalyst #HealthcareAnalyst #MarketingAnalyst #FinancialAnalyst #SalesAnalysis #FinancialAnalysis #HealthcareAnalysis #MarketingAnalysis #RemoteDataAnalyst #RemoteWork #USRemote #UKRemote #EuropeRemote #SingaporeRemote #HiringRemote #UjjwalJha
No responses yet