【再掲】 7月から参画する案件が変わります🔥 案件の内容：データ活用基盤の構築(主にBIツール（Cognos Analytics）を使用したレポート開発、データマート作成（Amazon Redshiftで作成）、バッチ処理の作成など) 担当工程：要件整理〜保守運用 言語：SQL、PL/SQL、Python 今の案件でデータをレポート表示できるようになるまでの 流れはある程度イメージはできているので あとは案件に入って経験を積んでいくだけです🔥 #データエンジニア #SQL #Python #CognosAnalytics #AmazonRedshift

CVE-2026-8178 in Amazon Redshift JDBC Driver allows RCE via unsafe class loading. Protect your data warehouse and update to version 2.2.2 now! #AWS #AmazonRedshift #CyberSecurity #InfoSec #RCE #DatabaseSecurity #VulnerabilityAlert #CVE #BigData #Java securityonline.info/amazon-r…

自分の技術スタック整理してみた。 DB：Oracle/AmazonRedshift BI：PowerBI/Spotfire クラウド：AWS/Azure 言語：Python/SQL 運用：ServiceNow/JP1 OS：Linux 運用と効率改善業務が中心でした。DWHの運用保守でDE領域を少しかじってたけど、4月からは本格的にDEをやるのでここらを深くしていきたい。

いつも御覧いただきありがとうございます。 新着案件情報を追加しました。 #React #AmazonRedshift #地方 参画可能の案件など。 #フリーランスエンジニア #SE #コンサル #案件 #freeanken #副業 各応募、案件の詳細は↓ のサイトからご覧になれます。 freeanken.com/

🤖 Amazon Redshift anuncia acceso por API a las recomendaciones de Advisor aws.amazon.com/es/about-aws/… #AmazonRedshift #DataWarehousing #APIIntegration #AWS #RoxsRoss

☀️おはようございます！ 火曜日は進捗も気分も乗ってくる頃。 波に乗っていきましょう🌊 【今日のDX占い】 本日の1位星座：いて座♐ ラッキーAWSサービス：#AmazonRedshift 分析に強い日！ データを活かす一工夫で、大きな気づきが得られるかもしれません📊 #情シス #DX #企業公式つぶやき部

📢#AmazonRedshift 導入事例 クライアント増でログ量・要望が多様化。 スプレッドシート運用から脱却するため、Amazon Redshiftで集計基盤を刷新🚀 ▼詳細はこちら findy-tools.io/products/amaz…

遂に来ました！🥳　CData Connect Cloud でリモートMCP が使えるように！ #kintone や #Salesforce ・ #Dynamics365 といったSaaS はもちろん、 #Snowflake や #BigQuery 、 #AmazonRedShift のようなDWH、 #SQLServer や #Oracle といったRDB まで！ ぜひお試しあれ！ cdata.com/cloud/ai/

Amazon Redshift gets new default settings to prevent data breaches reconbee.com/amazon-redshift… #Amazon #amazonredshift #databreaches #databreach #cybersecurity #cyberattack

Amazon Redshift がデータ侵害を防ぐための新しいデフォルト設定を導入 Amazon Redshift gets new default settings to prevent data breaches #BleepingComputer (Feb 3) #AmazonRedshift #セキュリティ強化 #デフォルト設定 #データベース暗号化 #SSL接続 buff.ly/3WFw1Ar

𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝗵𝗼𝘄 𝘁𝗼 𝗱𝗶𝘃𝗲 𝗱𝗲𝗲𝗽 𝗶𝗻𝘁𝗼 𝗰𝘂𝘀𝘁𝗼𝗺𝗲𝗿𝘀 𝘀𝘂𝗯𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻 𝗱𝗮𝘁𝗮 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! A lot of time, to understand and analyze the data in a better way, you may need to dig deep into the data as a data analyst. 𝗟𝗲𝘁'𝘀 𝗱𝗶𝘀𝗰𝘂𝘀𝘀 𝗵𝗼𝘄 𝘆𝗼𝘂 𝗰𝗮𝗻 𝗮𝗻𝗮𝗹𝘆𝘇𝗲 𝘀𝘂𝗯𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻𝘀 𝗮𝗰𝗰𝗼𝗿𝗱𝗶𝗻𝗴 𝘁𝗼 𝗹𝗼𝗰𝗮𝘁𝗶𝗼𝗻 𝗮𝗻𝗱 𝗮𝗴𝗲 𝗴𝗿𝗼𝘂𝗽𝘀 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁. Solution: 𝘀𝗲𝗹𝗲𝗰𝘁 "𝗹𝗼𝗰𝗮𝘁𝗶𝗼𝗻",𝗮𝗴𝗲_𝗴𝗿𝗼𝘂𝗽, 𝗰𝗼𝘂𝗻𝘁(𝘀𝘂𝗯𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻_𝘀𝘁𝗮𝘁𝘂𝘀) 𝗮𝘀 𝘀𝘂𝗯𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻_𝗰𝗼𝘂𝗻𝘁 𝗳𝗿𝗼𝗺 𝘀𝗵𝗼𝗽𝗽𝗶𝗻𝗴_𝗱𝗮𝘁𝗮 𝘄𝗵𝗲𝗿𝗲 𝘀𝘂𝗯𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻_𝘀𝘁𝗮𝘁𝘂𝘀 𝗶𝗻 ('𝗬𝗲𝘀') 𝗴𝗿𝗼𝘂𝗽 𝗯𝘆 "𝗹𝗼𝗰𝗮𝘁𝗶𝗼𝗻", 𝗮𝗴𝗲_𝗴𝗿𝗼𝘂𝗽 𝗼𝗿𝗱𝗲𝗿 𝗯𝘆 "𝗹𝗼𝗰𝗮𝘁𝗶𝗼𝗻" 𝗟𝗶𝗸𝗲❤️ and 𝗥𝗲𝗽𝗼𝘀𝘁🔄 if you find it helpful! 𝗙𝗼𝗹𝗹𝗼𝘄✅ for more data analytics content! #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

This is another thing that you need to consider when you are learning a new tool as a Data analyst! Whenever you decide a new tool to learn, first decide: How this tool improves your data analysis process. Is it automating anything which can improve productivity? Is it improving code execution by making things simpler? Or any such improvement. This is important as it gives you a clear understanding about the benefit of that tool. Then you can learn it effectively. Like♥️ and Repost🔄 if you find it helpful! Follow✅ for more data analytics content! #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

𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝘄𝗵𝘆 𝗦𝗤𝗟 𝗶𝘀 𝗼𝗻𝗲 𝗼𝗳 𝘁𝗵𝗲 𝗺𝗼𝘀𝘁 𝗶𝗺𝗽𝗼𝗿𝘁𝗮𝗻𝘁 𝘀𝗸𝗶𝗹𝗹𝘀 𝗶𝗻 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀! SQL is such a tool/language which is used for almost all the data-related roles. It is one such tool in data analytics that isn't dependent on the industry because everyone uses it. There are a lot of data analytics tasks that you can perform in SQL. Some are: • Data Cleaning, Pre-Processing, and Transformation. • Performing EDA. • Creating scripts using techniques such as Procedures. • Performing ad-hoc requests. • Validate data and much more. These tasks are very important and the foundation for effective analysis. So, it will be your biggest mistake if you skip SQL if you want to become a data analyst. 𝗟𝗶𝗸𝗲💚 and 𝗥𝗲𝗽𝗼𝘀𝘁🔃 if you find it helpful! 𝗙𝗼𝗹𝗹𝗼𝘄✔️ for more data analytics content! #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

𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝗵𝗼𝘄 𝘁𝗼 𝗰𝗵𝗮𝗻𝗴𝗲 𝗱𝗮𝘁𝗮𝘁𝘆𝗽𝗲𝘀 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! You can work with multiple data types in Power BI. Being a data analyst, you will get issues in datatypes of variables as well and if not fixed, they can lead to bigger issues in the analysis. 𝗦𝗼, 𝗹𝗲𝘁'𝘀 𝘀𝗲𝗲 𝗵𝗼𝘄 𝘆𝗼𝘂 𝗰𝗮𝗻 𝘄𝗼𝗿𝗸 𝗮𝗻𝗱 𝗰𝗵𝗮𝗻𝗴𝗲 𝗱𝗮𝘁𝗮 𝘁𝘆𝗽𝗲𝘀 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! • Go to Power Query. • Now check the top left of each column and you will see the data types icon, Click on it. • You can change the data type here. • You can also change data types by going to the Transform Tab and then Data Type. Enjoy! 𝗟𝗶𝗸𝗲 and 𝗙𝗼𝗹𝗹𝗼𝘄 for more data analytics content! #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

🚀¡Somos AWS Redshift Service Delivery Partners! Este hito avala nuestro expertise para diseñar e implementar soluciones con #AmazonRedshift, el potente servicio de análisis que lleva el procesamiento de datos a otro nivel. Más🔗 hiberus.com/tecnologias-dife… @awscloud @awscloud_es

𝗧𝗵𝗶𝘀 𝗶𝘀 𝗵𝗼𝘄 𝘆𝗼𝘂 𝘀𝗵𝗼𝘂𝗹𝗱 𝘀𝘁𝗮𝗿𝘁 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗽𝘆𝘁𝗵𝗼𝗻 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! Python is a really good tool/language if you want to automate data analysis tasks, perform all tasks in one place, and much more. But often aspiring data analysts start learning Python inefficiently. 𝗟𝗲𝘁 𝗺𝗲 𝗴𝗶𝘃𝗲 𝘆𝗼𝘂 𝗮𝗻 𝗮𝗱𝘃𝗶𝗰𝗲: • First, understand the basic syntax and functioning of Python. • Then you should learn Pandas because you will be cleaning, pre-processing, transforming, and manipulating data in Python using Pandas. • Spend an ample amount of time learning Pandas as it will make or break your data analysis learning with Python. • Don't jump to visualization libraries or statistical libraries. So, start learning Python like if as a data analyst. Merry Christmas to all. 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

𝗬𝗼𝘂 𝗻𝗲𝗲𝗱 𝘁𝗼 𝗸𝗻𝗼𝘄 𝘁𝗵𝗶𝘀 𝗶𝗳 𝘆𝗼𝘂 𝘄𝗮𝗻𝘁 𝘁𝗼 𝗹𝗮𝗻𝗱 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁 𝗿𝗼𝗹𝗲 𝗶𝗻 𝟮𝟬𝟮𝟱! You all must be looking forward to 2025 for landing a data analyst role! 𝗟𝗲𝘁 𝗺𝗲 𝘁𝗲𝗹𝗹 𝘆𝗼𝘂 𝘁𝗵𝗮𝘁: • SQL will be required in 2025 to land a data analyst role. • It is not going to vanish at all. • SQL has been here for decades and will stay relevant for a very long time. • So, don't ignore SQL. • Create a portfolio project using SQL to showcase your skills. • Practice SQL questions from various platforms to sharpen your SQL skills. So, keep grinding and keep learning. Merry Christmas to all. 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

𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝗵𝗼𝘄 𝘁𝗼 𝗮𝗻𝘀𝘄𝗲𝗿 𝗮𝗻 𝗶𝗺𝗽𝗼𝗿𝘁𝗮𝗻𝘁 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗾𝘂𝗲𝘀𝘁𝗶𝗼𝗻 𝘂𝘀𝗶𝗻𝗴 𝗱𝗲𝗻𝘀𝗲 𝗿𝗮𝗻𝗸 𝘄𝗶𝗻𝗱𝗼𝘄 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! You will use a lot of window functions in your career as a data analyst. 𝗟𝗲𝘁'𝘀 𝘁𝗿𝘆 𝘁𝗼 𝗮𝗻𝘀𝘄𝗲𝗿 𝗮𝗻 𝗶𝗺𝗽𝗼𝗿𝘁𝗮𝗻𝘁 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗾𝘂𝗲𝘀𝘁𝗶𝗼𝗻: Business Question: 𝗛𝗼𝘄 𝗲𝗮𝗰𝗵 𝗰𝗮𝗺𝗽𝗮𝗶𝗴𝗻 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗲𝗱 𝗶𝗻 𝗲𝗮𝗰𝗵 𝗰𝗼𝘂𝗻𝘁𝗿𝘆 𝗯𝘆 𝗽𝗿𝗼𝗳𝗶𝘁? 𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻: 𝗦𝗘𝗟𝗘𝗖𝗧 𝗰𝗮𝗺𝗽𝗮𝗶𝗴𝗻_𝘁𝗶𝘁𝗹𝗲, 𝘃𝗮𝗿𝗶𝗮𝗻𝘁_𝗰𝗼𝘂𝗻𝘁𝗿𝘆, 𝘃𝗮𝗿𝗶𝗮𝗻𝘁_𝘁𝘆𝗽𝗲, 𝘁𝗼𝘁𝗮𝗹_𝗽𝗿𝗼𝗳𝗶𝘁, 𝗱𝗲𝗻𝘀𝗲_𝗿𝗮𝗻𝗸() 𝗢𝗩𝗘𝗥(𝗽𝗮𝗿𝘁𝗶𝘁𝗶𝗼𝗻 𝗯𝘆 𝗰𝗮𝗺𝗽𝗮𝗶𝗴𝗻_𝘁𝗶𝘁𝗹𝗲 𝗢𝗥𝗗𝗘𝗥 𝗕𝗬 𝘁𝗼𝘁𝗮𝗹_𝗽𝗿𝗼𝗳𝗶𝘁 𝗗𝗘𝗦𝗖) 𝗔𝗦 𝗽𝗿𝗼𝗳𝗶𝘁_𝗿𝗮𝗻𝗸 𝗙𝗥𝗢𝗠 𝗲𝗺𝗮𝗶𝗹_𝗰𝗮𝗺𝗽𝗮𝗶𝗴𝗻 So, this is how you can answer marketing business question as a data analyst. 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

𝗧𝗵𝗶𝘀 𝗶𝘀 𝗵𝗼𝘄 𝘆𝗼𝘂 𝗷𝗼𝗶𝗻 𝘁𝘄𝗼 𝘁𝗮𝗯𝗹𝗲𝘀 𝘄𝗶𝘁𝗵𝗼𝘂𝘁 𝗰𝗼𝗺𝗺𝗼𝗻 𝗰𝗼𝗹𝘂𝗺𝗻 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! A lot of times, as a data analyst, you will have tables that don't have common columns between them due to strict normalization. Also, you will need to perform a join between them as a data analyst. 𝗦𝗼, 𝗹𝗲𝘁 𝗺𝗲 𝘁𝗲𝗹𝗹 𝘆𝗼𝘂 𝗵𝗼𝘄 𝘁𝗼 𝗽𝗲𝗿𝗳𝗼𝗿𝗺 𝗷𝗼𝗶𝗻 𝗶𝗻 𝘀𝘂𝗰𝗵 𝘀𝗶𝘁𝘂𝗮𝘁𝗶𝗼𝗻: • You may have a branching table that contains the primary key of both these tables as the primary key or foreign key. • Connect both of these tables with the branching table. • This creates an indirect link between those two tables and you can extract relevant data from them. 𝗘𝘅𝗮𝗺𝗽𝗹𝗲: 𝗦𝗘𝗟𝗘𝗖𝗧 𝗲.𝗲𝗺𝗽_𝗻𝗼, 𝗲.𝗳𝗶𝗿𝘀𝘁_𝗻𝗮𝗺𝗲, 𝗱.𝗱𝗲𝗽𝘁_𝗻𝗮𝗺𝗲 𝗙𝗥𝗢𝗠 𝗲𝗺𝗽𝗹𝗼𝘆𝗲𝗲𝘀 𝗔𝗦 𝗲 𝗜𝗡𝗡𝗘𝗥 𝗝𝗢𝗜𝗡 𝗱𝗲𝗽𝘁_𝗲𝗺𝗽 𝗔𝗦 𝗱𝗲 𝗨𝗦𝗜𝗡𝗚 (𝗲𝗺𝗽_𝗻𝗼) 𝗜𝗡𝗡𝗘𝗥 𝗝𝗢𝗜𝗡 𝗱𝗲𝗽𝗮𝗿𝘁𝗺𝗲𝗻𝘁𝘀 𝗔𝗦 𝗱 𝗨𝗦𝗜𝗡𝗚 (𝗱𝗲𝗽𝘁_𝗻𝗼) Here, emp_no is the primary key of employees table dept_no is the primary key of dept_emp and departments table. 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

𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝘄𝗵𝘆 𝗗𝗮𝘁𝗮 𝗖𝗹𝗲𝗮𝗻𝗶𝗻𝗴 𝗶𝘀 𝗶𝗺𝗽𝗼𝗿𝘁𝗮𝗻𝘁 𝗮𝘀 𝗮 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁! Suppose stakeholders ask you a very simple business question such as: 𝗛𝗼𝘄 𝗺𝘂𝗰𝗵 𝗿𝗲𝘃𝗲𝗻𝘂𝗲 𝗱𝗶𝗱 𝘄𝗲 𝗴𝗲𝗻𝗲𝗿𝗮𝘁𝗲 𝗳𝗿𝗼𝗺 𝗲𝗮𝗰𝗵 𝗰𝗼𝘂𝗻𝘁𝗿𝘆? • You performed a simple SQL query for that and got the results. • The issue is for some values "United States" had more than one space and now SQL is aggregating them separately. • So, now you have two different "Total Revenue" for the United States. • Also, if you directly loaded this data in Power BI and created a dashboard, what would happen then? • Uncleaned data skews your analysis and you can never analyze data accurately and precisely with such data. So, always clean your data as a data analyst! 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