Healthcare Data Analyst 📍 Remote • Proficiency in SQL, Python & familiarity with electronic medical records and data management systems. • Experience with data visualization tools (Power BI, Tableau). Send CV & cover letter hr@mobihealthinternational.com #remotedataanalyst

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

𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝘁𝗵𝗲 𝗰𝗼𝗻𝘁𝗲𝘅𝘁 𝗼𝗳 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗽𝗿𝗼𝗯𝗹𝗲𝗺𝘀 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! When you work on business problems as a data analyst, you will have to solve a lot of business problems. When you focus on the context of the business problem, the remaining process gets easier. 𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱𝗶𝗻𝗴 𝘁𝗵𝗲 𝗰𝗼𝗻𝘁𝗲𝘅𝘁 𝗵𝗲𝗹𝗽𝘀 𝘆𝗼𝘂 𝗶𝗻: • Selecting crucial variables for analysis. • Selecting optimal analysis methods for generating actionable insight. 𝗘𝘅𝗮𝗺𝗽𝗹𝗲: 𝗪𝗵𝗲𝗻 𝘆𝗼𝘂 𝘂𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝘁𝗵𝗮𝘁 𝘆𝗼𝘂 𝗻𝗲𝗲𝗱 𝘁𝗼 𝗳𝗼𝗰𝘂𝘀 𝗼𝗻 𝘀𝗮𝗹𝗲𝘀, 𝘁𝗵𝗲𝗻 𝗳𝗲𝘄 𝗽𝗼𝘁𝗲𝗻𝘁𝗶𝗮𝗹 𝗰𝗿𝘂𝗰𝗶𝗮𝗹 𝘃𝗮𝗿𝗶𝗮𝗯𝗹𝗲𝘀 𝗮𝗿𝗲 : • Sales across week/month/quarter/year • Sales across the regions • Profit • Cost • Revenue • Product sales performance • Discount across products • Discount and profit/cost per product across time. These are just a few fundamental variables that you can look at when analyzing sales data or when you focus on sales. Actual variable selection depends upon the dataset. So, this is how understanding the context of business problems helps you as a data analyst. Also, tell me what methods you use to understand business problems as a data analyst. Enjoy. 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

𝗧𝗵𝗶𝘀 𝗶𝘀 𝘄𝗵𝘆 𝘆𝗼𝘂 𝗻𝗲𝗲𝗱 𝘁𝗼 𝘂𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝘆𝗼𝘂𝗿 𝗱𝗮𝘁𝗮 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! EDA is critical in data analytics! I know I have said it multiple times, but I think repeating important things is more about effective emphasis than repetition. 𝗟𝗲𝘁 𝗺𝗲 𝘁𝗲𝗹𝗹 𝘆𝗼𝘂 𝗮𝗻𝗼𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝘀𝗼𝗻 𝘄𝗵𝘆 𝗘𝗗𝗔 𝗶𝘀 𝗰𝗿𝗶𝘁𝗶𝗰𝗮𝗹 𝗶𝗻 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝗶𝘀: It helps you connect the dots between the data and actionable insights you want to generate. 𝗘𝘅𝗮𝗺𝗽𝗹𝗲: You want to understand the reason for the churn in the US states such as Texas, Florida, and Alaska. 𝗡𝗼𝘄, 𝘆𝗼𝘂 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗲𝗱 𝗘𝗗𝗔 𝗮𝗻𝗱 𝗰𝗼𝗻𝗻𝗲𝗰𝘁𝗲𝗱 𝘁𝗵𝗲 𝗱𝗼𝘁𝘀 𝘀𝘂𝗰𝗵 𝗮𝘀: • Out of churned customers, more than 70% had complaints. • Out of these customers, 63% gave a bad satisfaction rate. With EDA, you were able to identify a very important reason and connect the dots that were churned customers, complaints, and bad satisfaction rates. So, this is how EDA helps you to connect the dots as a data analyst. Also, tell me which tool you love to perform EDA as a data analyst. Enjoy. 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

𝗧𝗵𝗶𝘀 𝗦𝗤𝗟 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲 𝗶𝘀 𝗵𝗲𝗹𝗽𝗳𝘂𝗹 𝗳𝗼𝗿 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁𝘀! Sometimes you want to perform certain operations on your result but cannot do it directly in SQL. But you have a technique for that, it is known as 𝗩𝗶𝗲𝘄𝘀 and is really helpful for data analysts. 𝗟𝗲𝘁 𝗺𝗲 𝗲𝘅𝗽𝗹𝗮𝗶𝗻: • Views are virtual tables that store the result of the query. • You can run the View and it will rerun your query (Non-Materialized View) to get you those results. • You can then use it according to your needs. 𝗘𝘅𝗮𝗺𝗽𝗹𝗲: 1) I created a View and performed Join between salary, employees, and department table and retrieved the required details in the results: 𝗖𝗥𝗘𝗔𝗧𝗘 𝗩𝗜𝗘𝗪 𝘀𝗮𝗹𝗮𝗿𝘆_𝘃𝗶𝗲𝘄 𝗔𝗦( 𝗦𝗘𝗟𝗘𝗖𝗧 𝗗𝗜𝗦𝗧𝗜𝗡𝗖𝗧 𝗲.𝗳𝗶𝗿𝘀𝘁_𝗻𝗮𝗺𝗲, 𝗱.𝗱𝗲𝗽𝘁_𝗻𝗼, 𝘀.𝘀𝗮𝗹𝗮𝗿𝘆, 𝗔𝗩𝗚(𝘀.𝘀𝗮𝗹𝗮𝗿𝘆) 𝗢𝗩𝗘𝗥(𝗣𝗔𝗥𝗧𝗜𝗧𝗜𝗢𝗡 𝗕𝗬 𝗱.𝗱𝗲𝗽𝘁_𝗻𝗼) 𝗙𝗥𝗢𝗠 𝗲𝗺𝗽𝗹𝗼𝘆𝗲𝗲𝘀 𝗔𝗦 𝗲 𝗜𝗡𝗡𝗘𝗥 𝗝𝗢𝗜𝗡 𝗱𝗲𝗽𝘁_𝗲𝗺𝗽 𝗔𝗦 𝗱 𝗨𝗦𝗜𝗡𝗚 (𝗲𝗺𝗽_𝗻𝗼) 𝗜𝗡𝗡𝗘𝗥 𝗝𝗢𝗜𝗡 𝘀𝗮𝗹𝗮𝗿𝗶𝗲𝘀 𝗔𝗦 𝘀 𝗨𝗦𝗜𝗡𝗚 (𝗲𝗺𝗽_𝗻𝗼) 𝗢𝗥𝗗𝗘𝗥 𝗕𝗬 𝗱.𝗱𝗲𝗽𝘁_𝗻𝗼 𝗗𝗘𝗦𝗖) 2) Now, I used the view and performed another filter using the WHERE clause to fetch only those employees who earn more than the average salary of the specific department: 𝗦𝗘𝗟𝗘𝗖𝗧 𝗳𝗶𝗿𝘀𝘁_𝗻𝗮𝗺𝗲, 𝗱𝗲𝗽𝘁_𝗻𝗼, 𝘀𝗮𝗹𝗮𝗿𝘆, 𝗮𝘃𝗴 𝗙𝗥𝗢𝗠 𝘀𝗮𝗹𝗮𝗿𝘆_𝘃𝗶𝗲𝘄 𝗪𝗛𝗘𝗥𝗘 𝘀𝗮𝗹𝗮𝗿𝘆 > 𝗮𝘃𝗴 This was just an example. I know I don't need Views for this particular task, but I wanted to show you how to use it. Also, tell me have you used Views as a data analyst? Enjoy. 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

𝗥𝗲𝗺𝗲𝗺𝗯𝗲𝗿 𝘁𝗵𝗶𝘀 𝘄𝗵𝗲𝗻 𝘆𝗼𝘂 𝗰𝗿𝗲𝗮𝘁𝗲 𝘃𝗶𝘀𝘂𝗮𝗹𝘀 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! As a data analyst, you create visuals to explain your actionable insights so that non-technical entities and stakeholders can understand that! 𝗟𝗲𝘁 𝗺𝗲 𝘁𝗲𝗹𝗹 𝘆𝗼𝘂 𝘀𝗼𝗺𝗲 𝗽𝗼𝗶𝗻𝘁𝘀 𝘁𝗵𝗮𝘁 𝘆𝗼𝘂 𝘀𝗵𝗼𝘂𝗹𝗱 𝗸𝗲𝗲𝗽 𝗶𝗻 𝗺𝗶𝗻𝗱 𝘄𝗵𝗲𝗻 𝘆𝗼𝘂 𝗰𝗿𝗲𝗮𝘁𝗲 𝘃𝗶𝘀𝘂𝗮𝗹𝘀 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁: • Create only necessary visuals. • Focus on building simple visuals. • Don't overfit the visual. • Remove unnecessary variables from visuals. • Create visuals according to insight such as side-by-side bar charts for comparison, trends using line charts, and more. • Ensure efficient Labeling and Titling. These points will help you create efficient visuals as a data analyst. Also, tell me which tool you prefer to visualize data. Enjoy. 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

𝗙𝗼𝗹𝗹𝗼𝘄 𝘁𝗵𝗶𝘀 𝘀𝗲𝗾𝘂𝗲𝗻𝗰𝗲 𝘁𝗼 𝗹𝗲𝗮𝗿𝗻 𝗦𝗤𝗟 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! I have repeatedly mentioned that SQL is one of the most important tools/languages in data analytics. 𝗟𝗲𝘁'𝘀 𝗱𝗶𝘀𝗰𝘂𝘀𝘀 𝗶𝗻 𝘄𝗵𝗶𝗰𝗵 𝘀𝗲𝗾𝘂𝗲𝗻𝗰𝗲 𝘆𝗼𝘂 𝘀𝗵𝗼𝘂𝗹𝗱 𝗹𝗲𝗮𝗿𝗻 𝗶𝘁 𝗮𝗻𝗱 𝗴𝗲𝘁 𝗰𝗼𝗺𝗳𝗼𝗿𝘁𝗮𝗯𝗹𝗲: SELECT 👇 FROM 👇 WHERE 👇 ORDER BY and LIMIT or TOP 👇 JOIN 👇 GROUP BY 👇 HAVING 👇 AGGREGATE/SCALAR FUNCTIONS 👇 Subqueries 👇 Window Functions 👇 Case Statements, LIKE, IN, EXISTS 👇 CTEs 👇 Recursive CTEs 👇 Views 👇 UDFs In this way, you can learn SQL in a structured way. This is not a hard and fast rule, this is just my suggestion. Also, tell me if you have any difficulty in any SQL concept and I will try to create a video explaining that. Enjoy. 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

𝗣𝗿𝗲𝘃𝗲𝗻𝘁 𝗴𝗲𝘁𝘁𝗶𝗻𝗴 𝗹𝗼𝘀𝘁 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁 𝘄𝗶𝘁𝗵 𝘁𝗵𝗶𝘀! Data Analysts often get lost when they are working on a problem. They keep analyzing data and get lost in it. This is when you should go back to the business problem as this is the only way to get on track. When you refer to the business problem, you understand what to analyze, how to analyze, and how much to analyze. This way you will be on track and will be able to build those required actionable insights. So, always refer to the business problem when you feel lost as a data analyst. Also, tell me if you have any problems in data analytics and I will try my best to solve them. Enjoy. 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

𝗜𝗴𝗻𝗼𝗿𝗶𝗻𝗴 𝘁𝗵𝗶𝘀 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗽𝗵𝗮𝘀𝗲 𝗰𝗮𝗻 𝗰𝗼𝘀𝘁 𝘆𝗼𝘂 𝗶𝗻 𝘁𝗵𝗲 𝗹𝗼𝗻𝗴 𝗿𝘂𝗻! Often people or aspiring data analysts feel that data analytics is about building cool dashboards but that isn't the reality. Data Cleaning and Transformation is one of the most important parts of data analytics. 𝗜 𝗰𝗮𝗻 𝗲𝗮𝘀𝗶𝗹𝘆 𝘀𝗮𝘆 𝘁𝗵𝗮𝘁 𝗱𝗮𝘁𝗮 𝗰𝗹𝗲𝗮𝗻𝗶𝗻𝗴 𝗶𝘀 𝘁𝗵𝗲 𝗳𝗶𝗿𝘀𝘁 𝘀𝘁𝗲𝗽 𝗳𝗿𝗼𝗺 𝘄𝗵𝗲𝗿𝗲 𝘆𝗼𝘂 𝗰𝗮𝗻 𝗺𝗮𝗸𝗲 𝗼𝗿 𝗯𝗿𝗲𝗮𝗸 𝘆𝗼𝘂𝗿 𝗲𝗻𝘁𝗶𝗿𝗲 𝗱𝗮𝘁𝗮 𝗽𝗿𝗼𝗷𝗲𝗰𝘁 𝗮𝗻𝗱 𝗮𝗻𝗮𝗹𝘆𝘀𝗶𝘀. Also, tell me what techniques you guys use to clean your data. 𝗟𝗲𝘁'𝘀 𝗱𝗶𝘀𝗰𝘂𝘀𝘀 𝘀𝗼𝗺𝗲 𝗿𝗲𝗮𝘀𝗼𝗻𝘀 𝘄𝗵𝘆 𝘆𝗼𝘂 𝘀𝗵𝗼𝘂𝗹𝗱 𝗰𝗹𝗲𝗮𝗻 𝘁𝗵𝗲 𝗱𝗮𝘁𝗮: • How can you analyze data successfully when you are not even sure that it is correct? • When data is not cleaned, it has null values, outliers, and many such inconsistencies that can completely wreck your analysis. • Dirty data has standardization and formatting issues which can create so many issues such as representing "TX" and "Texas" as two different states. • You cannot even perform operations on variables due to incorrect data type, wrong values, and much more. I cannot stress enough how important data cleaning is. 𝗦𝗼, 𝗻𝗲𝘃𝗲𝗿 𝘀𝗸𝗶𝗽 𝗶𝘁 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁 𝗻𝗼 𝗺𝗮𝘁𝘁𝗲𝗿 𝘄𝗵𝗮𝘁! Enjoy. Follow for more! P.S - Ignore the spelling mistake in image as AI generated a really cool image and I love it. #DataAnalyst #DataCleaning #DataTransformation #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

𝗬𝗼𝘂 𝗰𝗮𝗻 𝗱𝗲𝘃𝗲𝗹𝗼𝗽 𝘆𝗼𝘂𝗿 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝘂𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱𝗶𝗻𝗴 𝘄𝗶𝘁𝗵 𝘁𝗵𝗶𝘀 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁! I discussed in my earlier post that you should spend an ample amount of time in each data analytics step. But you should do it for the business problems as well. So, whenever you have a business problem, spend an ample amount of time understanding it. It will allow you to solve that business problem efficiently. It will also develop your problem-solving skills as well as your business understanding. Tell me how much time do you spend on understanding business problems. Enjoy. Follow for more! #DataAnalyst #DataAnalytics #BusinessAnalyst #BusinessAnalytics #DataAnalysis #BusinessAnalysis #ProductAnalyst #DataAnalysisTips #AnalyticsCareer #CommunicationSkills #EffectiveCommunication #CrossFunctionalWorking #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