🎥 A new Collate Clue is here. This episode gives you a quick walkthrough of the new Visual Governance Workflow Builder. In just a few minutes, you'll learn how to use this no-code feature to create sophisticated workflows. Watch here: youtu.be/DgFE_gI1Ze4 #dataengineering #datagovernace #dataworkflow #openmetadata

🖱 A new year and a new interactive demo. This new demo gives you a quick walkthrough of the new Visual Governance Workflow Builder. In just a few minutes, you'll learn how to use this no-code feature to create sophisticated workflows. Try here: collate.storylane.io/share/a… #dataengineering #datagovernace #dataworkflow #openmetadata

This tool made my entire data pipeline feel effortless - like I had superpowers. No setup stress. No syntax headaches. Just pure flow - ask, refine, deploy. @Zerve_AI turned hours of grunt work into minutes of clarity. It’s not code magic. It’s a collaboration with intelligence. Use it here: hubs.la/Q03RxyP00 #LovableForData #DataWorkflow #AIinAction

🎵 Oh, why don’t we be friends? 🎵 BenMakesDataEasy Tabular Editor 2 = 🎯 Quickly pull a list of measures → pair with AI → TE2 takes care of the rest. I’m quickly using AI to update measure descriptions and then batch load them in TE2. Effortless, fast, and a little bit magical. ✨ What do you think, boys? @KyleAMueller2, @DOtykier, @kurtbuhler #PowerBI #TabularEditor #BenMakesDataEasy #DataWorkflow

How to plan a data project 🧠 - Define the question - Explore the data - Clean & transform - Visualize & tell the story Keep it simple. Stay focused. #DataWorkflow #DataAnalysis #CloudComputing #BuildInPublic #DataAnalytics #PowerBI #SQL

📊 𝐓𝐇𝐄 𝐃𝐀𝐓𝐀 𝐀𝐍𝐀𝐋𝐘𝐒𝐈𝐒 𝐖𝐎𝐑𝐊𝐅𝐋𝐎𝐖: 𝟔 𝐒𝐓𝐄𝐏𝐒 𝐅𝐑𝐎𝐌 𝐑𝐀𝐖 𝐃𝐀𝐓𝐀 𝐓𝐎 𝐈𝐍𝐒𝐈𝐆𝐇𝐓 – 𝐔𝐍𝐋𝐎𝐂𝐊 𝐘𝐎𝐔𝐑 𝐃𝐀𝐓𝐀'𝐒 𝐏𝐎𝐓𝐄𝐍𝐓𝐈𝐀𝐋 Drowning in raw data but thirsty for real insights? You're not alone. Transforming chaos into clarity requires a structured approach. Our latest infographic unveils the 𝟔 𝐄𝐒𝐒𝐄𝐍𝐓𝐈𝐀𝐋 𝐒𝐓𝐄𝐏𝐒 𝐨𝐟 𝐭𝐡𝐞 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 𝐖𝐨𝐫𝐤𝐟𝐥𝐨𝐰, your roadmap from messy inputs to actionable intelligence. 𝘚𝘵𝘰𝘱 𝘨𝘶𝘦𝘴𝘴𝘪𝘯𝘨 𝘢𝘯𝘥 𝘴𝘵𝘢𝘳𝘵 𝘬𝘯𝘰𝘸𝘪𝘯𝘨! 𝐅𝐨𝐥𝐥𝐨𝐰 𝐭𝐡𝐞 𝐏𝐚𝐭𝐡 𝐭𝐨 𝐃𝐚𝐭𝐚-𝐃𝐫𝐢𝐯𝐞𝐧 𝐒𝐮𝐜𝐜𝐞𝐬𝐬! ➡️ 🎯 𝐃𝐞𝐟𝐢𝐧𝐞 𝐭𝐡𝐞 𝐏𝐫𝐨𝐛𝐥𝐞𝐦 𝐨𝐫 𝐑𝐞𝐬𝐞𝐚𝐫𝐜𝐡 𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧: What exactly are you trying to uncover? Clarity is the first step to impactful analysis. ⛏️ 𝐏𝐫𝐞𝐩𝐚𝐫𝐞 𝐨𝐫 𝐂𝐨𝐥𝐥𝐞𝐜𝐭 𝐭𝐡𝐞 𝐑𝐚𝐰 𝐃𝐚𝐭𝐚: Gather your information from the right sources, ensuring its relevance and accuracy. 🧼 𝐂𝐥𝐞𝐚𝐧 𝐚𝐧𝐝 𝐏𝐫𝐨𝐜𝐞𝐬𝐬 𝐃𝐚𝐭𝐚: Tidy up your dataset! Handle missing values, outliers, and inconsistencies to ensure reliable results. 🧠 𝐀𝐧𝐚𝐥𝐲𝐳𝐢𝐧𝐠 𝐭𝐡𝐞 𝐃𝐚𝐭𝐚: Apply the right techniques – statistical analysis, machine learning, etc. – to identify patterns and trends. 📈 𝐃𝐚𝐭𝐚 𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧: Bring your findings to life! Use charts, graphs, and dashboards to communicate complex information clearly. 🗣️ 𝐏𝐫𝐞𝐬𝐞𝐧𝐭𝐢𝐧𝐠 𝐭𝐡𝐞 𝐃𝐚𝐭𝐚: Tell the story your data reveals. Communicate your insights effectively to stakeholders for informed decision-making. 💡 At 𝐏𝐂 𝐃𝐨𝐜𝐭𝐨𝐫𝐬 𝐍𝐄𝐓, we empower businesses to harness the full power of their data. Our expert data analysis services guide you through every step of this crucial workflow, 𝐭𝐮𝐫𝐧𝐢𝐧𝐠 𝐫𝐚𝐰 𝐢𝐧𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧 𝐢𝐧𝐭𝐨 𝐬𝐭𝐫𝐚𝐭𝐞𝐠𝐢𝐜 𝐚𝐝𝐯𝐚𝐧𝐭𝐚𝐠𝐞𝐬. Ready to unlock your data's hidden potential? 𝐋𝐞𝐭'𝐬 𝐭𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦 𝐲𝐨𝐮𝐫 𝐢𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝐢𝐧𝐭𝐨 𝐢𝐦𝐩𝐚𝐜𝐭. 🌐 pcdoctorsnet.com 📞 1 (346) 355-6002 #DataAnalysis #DataWorkflow #DataToInsight #BusinessIntelligence #Analytics #DataDriven #DataVisualization #ProblemSolving #DecisionMaking #PCDOCTORSNET #Texas #USA #UnitedStates #Canada #India #TechTips

You don’t need a 10-page model to create value. Sometimes all it takes is: → One question → Clean data → A clear story That’s where Python shines. How do you turn raw data into insights? #DataWorkflow #PythonForData

Join us next week for a #webinar that explores the fundamentals of research #datamanagement, designed to help you establish a strong and transparent #dataWorkFlow for your projects. Registration is free but essential: ebi.ac.uk/training/events/pr… #FAIRdata @emblebi @embl #bioimaging

💬 Like, comment, share, and follow if this helped. Let’s make data cleaning less painful—and more powerful. #ExcelTips #PythonAutomation #DataCleaning #PrimedsoftTips #Pandas #BusinessEfficiency #DataWorkflow #ProcessOptimization #PythonForBusiness (7/7)

𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝗵𝗼𝘄 𝘁𝗼 𝗱𝗶𝘃𝗲 𝗱𝗲𝗲𝗽 𝗶𝗻𝘁𝗼 𝗰𝘂𝘀𝘁𝗼𝗺𝗲𝗿𝘀 𝘀𝘂𝗯𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻 𝗱𝗮𝘁𝗮 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! 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

𝗧𝗵𝗶𝘀 𝗶𝘀 𝗵𝗼𝘄 𝘆𝗼𝘂 𝘀𝗵𝗼𝘂𝗹𝗱 𝘀𝘁𝗮𝗿𝘁 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗽𝘆𝘁𝗵𝗼𝗻 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! 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

𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝘁𝗵𝗲 𝘀𝘆𝗻𝘁𝗮𝘅 𝗼𝗳 𝗩𝗶𝗲𝘄𝘀 𝗮𝗻𝗱 𝗵𝗼𝘄 𝘁𝗼 𝗰𝗿𝗲𝗮𝘁𝗲 𝘁𝗵𝗲𝗺 𝗶𝗻 𝗦𝗤𝗟 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁. A few days ago, I created a post discussing the use case of VIEWS and how you can leverage them as a data analyst. In this post, I have shown you how to create a VIEW in SQL. Let's see the business question we had today. 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻: How much average profit are we generating for each country? Solution: 𝗖𝗥𝗘𝗔𝗧𝗘 𝗩𝗜𝗘𝗪 𝗮𝘃𝗴_𝗽𝗿𝗼𝗳𝗶𝘁 𝗔𝗦 ( 𝗦𝗘𝗟𝗘𝗖𝗧 𝗰𝗼𝘂𝗻𝘁𝗿𝘆, 𝗔𝗩𝗚(𝗽𝗿𝗼𝗳𝗶𝘁) 𝗔𝗦 "𝗔𝘃𝗲𝗿𝗮𝗴𝗲 𝗣𝗿𝗼𝗳𝗶𝘁" 𝗙𝗥𝗢𝗠 𝘀𝗮𝗹𝗲𝘀_𝗱𝗮𝘁𝗮 𝗚𝗥𝗢𝗨𝗣 𝗕𝗬 𝗰𝗼𝘂𝗻𝘁𝗿𝘆) 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

𝗧𝗵𝗶𝘀 𝗶𝘀 𝗵𝗼𝘄 𝘆𝗼𝘂 𝘀𝗼𝗹𝘃𝗲 𝗮 𝗯𝗮𝘀𝗶𝗰 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗾𝘂𝗲𝘀𝘁𝗶𝗼𝗻 𝘂𝘀𝗶𝗻𝗴 𝗦𝗤𝗟 𝗳𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! So, let's understand the business problem. 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗣𝗿𝗼𝗯𝗹𝗲𝗺: Which Bike has maximum sales? 𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻 𝗦𝗘𝗟𝗘𝗖𝗧 𝗽𝗿𝗼𝗱𝘂𝗰𝘁_𝗺𝗼𝗱𝗲𝗹, 𝗦𝗨𝗠(𝗼𝗿𝗱𝗲𝗿_𝗾𝘂𝗮𝗻𝘁𝗶𝘁𝘆) 𝗔𝗦 "𝗧𝗼𝘁𝗮𝗹 𝗤𝘂𝗮𝗻𝘁𝗶𝘁𝘆" 𝗙𝗥𝗢𝗠 𝘀𝗮𝗹𝗲𝘀_𝗱𝗮𝘁𝗮 𝗚𝗥𝗢𝗨𝗣 𝗕𝗬 𝗽𝗿𝗼𝗱𝘂𝗰𝘁_𝗺𝗼𝗱𝗲𝗹 𝗢𝗥𝗗𝗘𝗥 𝗕𝗬 "𝗧𝗼𝘁𝗮𝗹 𝗤𝘂𝗮𝗻𝘁𝗶𝘁𝘆" 𝗗𝗘𝗦𝗖 𝗟𝗜𝗠𝗜𝗧 𝟭 Also, tell me how you use SQL 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