@Codingdidi

Here's what you will learn!!

🥳 🥳 Good news 🗞️🗞️ 🥳 I want to inform you that the MySQL classes 👩🏻‍🏫 will be starting from 10th July 🗓️ if you're interested please enroll in the classes ASAP 🔔 as there are limited seats 💺. Thank you ☺️ Regards, Codingdidi 👩🏻‍💻

Free website to learn and get certificates!! https://panx.io/awesome-certificates/ ❤️✅like more posts like these!!

Expand your job search to increase your chances of becoming a data analyst. Here are alternative roles to explore: 1. 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗔𝗻𝗮𝗹𝘆𝘀𝘁: Focuses on using data to improve business processes and decision-making. 2. 𝗢𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝘀 𝗔𝗻𝗮𝗹𝘆𝘀𝘁: Specializes in analyzing operational data to optimize efficiency and performance. 3. 𝗠𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴 𝗔𝗻𝗮𝗹𝘆𝘀𝘁: Uses data to drive marketing strategies and measure campaign effectiveness. 4. 𝗙𝗶𝗻𝗮𝗻𝗰𝗶𝗮𝗹 𝗔𝗻𝗮𝗹𝘆𝘀𝘁: Analyzes financial data to support investment decisions and financial planning. 5. 𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗔𝗻𝗮𝗹𝘆𝘀𝘁: Evaluates product performance and user data to help product development. 6. 𝗥𝗲𝘀𝗲𝗮𝗿𝗰𝗵 𝗔𝗻𝗮𝗹𝘆𝘀𝘁: Conducts data-driven research to support strategic decisions and policy development. 7. 𝗕𝗜 𝗔𝗻𝗮𝗹𝘆𝘀𝘁: Transforms data into actionable business insights through reporting and visualization. 8. 𝗤𝘂𝗮𝗻𝘁𝗶𝘁𝗮𝘁𝗶𝘃𝗲 𝗔𝗻𝗮𝗹𝘆𝘀𝘁: Utilizes statistical and mathematical models to analyze large datasets, often in finance. 9. 𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝗔𝗻𝗮𝗹𝘆𝘀𝘁: Analyzes customer data to improve customer experience and drive retention. 10. 𝗗𝗮𝘁𝗮 𝗖𝗼𝗻𝘀𝘂𝗹𝘁𝗮𝗻𝘁: Provides expert advice on data strategies, data management, and analytics to organizations. 11. 𝗦𝘂𝗽𝗽𝗹𝘆 𝗖𝗵𝗮𝗶𝗻 𝗔𝗻𝗮𝗹𝘆𝘀𝘁: Analyzes supply chain data to optimize logistics, reduce costs, and improve efficiency. 12. 𝗛𝗥 𝗔𝗻𝗮𝗹𝘆𝘀𝘁: Uses data to improve human resources processes, from recruitment to employee retention and performance management. Hope this helps you 😊

𝐒𝐭𝐫𝐢𝐧𝐠 𝐌𝐚𝐧𝐢𝐩𝐮𝐥𝐚𝐭𝐢𝐨𝐧 𝐢𝐧 𝐏𝐲𝐭𝐡𝐨𝐧: Strings in Python are immutable sequences of characters. 𝟏- 𝐥𝐞𝐧(): 𝐑𝐞𝐭𝐮𝐫𝐧𝐬 𝐭𝐡𝐞 𝐥𝐞𝐧𝐠𝐭𝐡 𝐨𝐟 𝐭𝐡𝐞 𝐬𝐭𝐫𝐢𝐧𝐠. my_string = "Hello" length = len(my_string)  # length will be 5 𝟐- 𝐬𝐭𝐫(): 𝐂𝐨𝐧𝐯𝐞𝐫𝐭𝐬 𝐧𝐨𝐧-𝐬𝐭𝐫𝐢𝐧𝐠 𝐝𝐚𝐭𝐚 𝐭𝐲𝐩𝐞𝐬 𝐢𝐧𝐭𝐨 𝐬𝐭𝐫𝐢𝐧𝐠𝐬. num = 123 str_num = str(num)  # str_num will be "123" 𝟑- 𝐥𝐨𝐰𝐞𝐫() 𝐚𝐧𝐝 𝐮𝐩𝐩𝐞𝐫(): 𝐂𝐨𝐧𝐯𝐞𝐫𝐭 𝐚 𝐬𝐭𝐫𝐢𝐧𝐠 𝐭𝐨 𝐥𝐨𝐰𝐞𝐫𝐜𝐚𝐬𝐞 𝐨𝐫 𝐮𝐩𝐩𝐞𝐫𝐜𝐚𝐬𝐞. my_string = "Hello" lower_case = my_string.lower()  # lower_case will be "hello" upper_case = my_string.upper()  # upper_case will be "HELLO" 𝟒- 𝐬𝐭𝐫𝐢𝐩(): 𝐑𝐞𝐦𝐨𝐯𝐞𝐬 𝐥𝐞𝐚𝐝𝐢𝐧𝐠 𝐚𝐧𝐝 𝐭𝐫𝐚𝐢𝐥𝐢𝐧𝐠 𝐰𝐡𝐢𝐭𝐞𝐬𝐩𝐚𝐜𝐞 𝐟𝐫𝐨𝐦 𝐚 𝐬𝐭𝐫𝐢𝐧𝐠. my_string = "   Hello   " stripped_string = my_string.strip()  # stripped_string will be "Hello" 𝟓- 𝐬𝐩𝐥𝐢𝐭(): 𝐒𝐩𝐥𝐢𝐭𝐬 𝐚 𝐬𝐭𝐫𝐢𝐧𝐠 𝐢𝐧𝐭𝐨 𝐚 𝐥𝐢𝐬𝐭 𝐨𝐟 𝐬𝐮𝐛𝐬𝐭𝐫𝐢𝐧𝐠𝐬 𝐛𝐚𝐬𝐞𝐝 𝐨𝐧 𝐚 𝐝𝐞𝐥𝐢𝐦𝐢𝐭𝐞𝐫. my_string = "apple,banana,orange" fruits = my_string.split(",")  # fruits will be ["apple", "banana", "orange"] 𝟔- 𝐣𝐨𝐢𝐧(): 𝐉𝐨𝐢𝐧𝐬 𝐭𝐡𝐞 𝐞𝐥𝐞𝐦𝐞𝐧𝐭𝐬 𝐨𝐟 𝐚 𝐥𝐢𝐬𝐭 𝐢𝐧𝐭𝐨 𝐚 𝐬𝐢𝐧𝐠𝐥𝐞 𝐬𝐭𝐫𝐢𝐧𝐠 𝐮𝐬𝐢𝐧𝐠 𝐚 𝐬𝐩𝐞𝐜𝐢𝐟𝐢𝐞𝐝 𝐬𝐞𝐩𝐚𝐫𝐚𝐭𝐨𝐫. fruits = ["apple", "banana", "orange"] my_string = ",".join(fruits)  # my_string will be "apple,banana,orange" 𝟕- 𝐟𝐢𝐧𝐝() 𝐚𝐧𝐝 𝐢𝐧𝐝𝐞𝐱(): 𝐒𝐞𝐚𝐫𝐜𝐡 𝐟𝐨𝐫 𝐚 𝐬𝐮𝐛𝐬𝐭𝐫𝐢𝐧𝐠 𝐰𝐢𝐭𝐡𝐢𝐧 𝐚 𝐬𝐭𝐫𝐢𝐧𝐠 𝐚𝐧𝐝 𝐫𝐞𝐭𝐮𝐫𝐧 𝐢𝐭𝐬 𝐢𝐧𝐝𝐞𝐱. my_string = "Hello, world!" index1 = my_string.find("world")  # index1 will be 7 index2 = my_string.index("world")  # index2 will also be 7 𝟖- 𝐫𝐞𝐩𝐥𝐚𝐜𝐞(): 𝐑𝐞𝐩𝐥𝐚𝐜𝐞𝐬 𝐨𝐜𝐜𝐮𝐫𝐫𝐞𝐧𝐜𝐞𝐬 𝐨𝐟 𝐚 𝐬𝐮𝐛𝐬𝐭𝐫𝐢𝐧𝐠 𝐰𝐢𝐭𝐡 𝐚𝐧𝐨𝐭𝐡𝐞𝐫 𝐬𝐮𝐛𝐬𝐭𝐫𝐢𝐧𝐠. my_string = "Hello, world!" new_string = my_string.replace("world", "Python")  # new_string will be "Hello, Python!" 𝟗- 𝐬𝐭𝐚𝐫𝐭𝐬𝐰𝐢𝐭𝐡() 𝐚𝐧𝐝 𝐞𝐧𝐝𝐬𝐰𝐢𝐭𝐡(): 𝐂𝐡𝐞𝐜𝐤𝐬 𝐢𝐟 𝐚 𝐬𝐭𝐫𝐢𝐧𝐠 𝐬𝐭𝐚𝐫𝐭𝐬 𝐨𝐫 𝐞𝐧𝐝𝐬 𝐰𝐢𝐭𝐡 𝐚 𝐬𝐩𝐞𝐜𝐢𝐟𝐢𝐞𝐝 𝐬𝐮𝐛𝐬𝐭𝐫𝐢𝐧𝐠. my_string = "Hello, world!" starts_with_hello = my_string.startswith("Hello")  # True ends_with_world = my_string.endswith("world")  # False 𝟏𝟎- 𝐜𝐨𝐮𝐧𝐭(): 𝐂𝐨𝐮𝐧𝐭𝐬 𝐭𝐡𝐞 𝐨𝐜𝐜𝐮𝐫𝐫𝐞𝐧𝐜𝐞𝐬 𝐨𝐟 𝐚 𝐬𝐮𝐛𝐬𝐭𝐫𝐢𝐧𝐠 𝐢𝐧 𝐚 𝐬𝐭𝐫𝐢𝐧𝐠. my_string = "apple, banana, orange, banana" count = my_string.count("banana")  # count will be 2 Python pandas Complete 👇👇 https://topmate.io/codingdidi Hope you'll like it Like this post if you need more resources like this 👍❤️

Free SQL COURSES!! https://www.instagram.com/reel/C8jA6lWSYOs/?igsh=MXVwdzdldzBrN204Mw==

Basic- course

1. Introduction to SQL https://www.simplilearn.com/free-online-course-to-learn-sql-basics-skillup 2.Introduction-to-database-and-sql https://www.mygreatlearning.com/academy/learn-for-free/courses/introduction-to-database-and-sql 3. My-sql-basics https://www.mygreatlearning.com/academy/learn-for-free/courses/my-sql-basics 4. Oracle-sql https://www.mygreatlearning.com/academy/learn-for-free/courses/oracle-sql

Advanced- Course

5.Advanced-tsql-querying-using-sql-2014 https://www.udemy.com/course/advanced-tsql-querying-using-sql-2014/ 6. Sql-for-real-world-data-analysis https://www.udemy.com/course/sql-for-real-world-data-analysis/ 7. advanced-sql( text based) https://www.kaggle.com/learn/advanced-sql Share with credit https://t.me/codingdidi ✅✅FOLLOW @CODINGDIDI

Amazon Interview Process for Data Scientist position 📍Round 1- Phone Screen round This was a preliminary round to check my capability, projects to coding, Stats, ML, etc. After clearing this round the technical Interview rounds started. There were 5-6 rounds (Multiple rounds in one day). 📍 𝗥𝗼𝘂𝗻𝗱 𝟮- 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗕𝗿𝗲𝗮𝗱𝘁𝗵: In this round the interviewer tested my knowledge on different kinds of topics. 📍𝗥𝗼𝘂𝗻𝗱 𝟯- 𝗗𝗲𝗽𝘁𝗵 𝗥𝗼𝘂𝗻𝗱: In this round the interviewers grilled deeper into 1-2 topics. I was asked questions around: Standard ML tech, Linear Equation, Techniques, etc. 📍𝗥𝗼𝘂𝗻𝗱 𝟰- 𝗖𝗼𝗱𝗶𝗻𝗴 𝗥𝗼𝘂𝗻𝗱- This was a Python coding round, which I cleared successfully. 📍𝗥𝗼𝘂𝗻𝗱 𝟱- This was 𝗛𝗶𝗿𝗶𝗻𝗴 𝗠𝗮𝗻𝗮𝗴𝗲𝗿 where my fitment for the team got assessed. 📍𝗟𝗮𝘀𝘁 𝗥𝗼𝘂𝗻𝗱- 𝗕𝗮𝗿 𝗥𝗮𝗶𝘀𝗲𝗿- Very important round, I was asked heavily around Leadership principles & Employee dignity questions. So, here are my Tips if you’re targeting any Data Science role: -> Never make up stuff & don’t lie in your Resume. -> Projects thoroughly study. -> Practice SQL, DSA, Coding problem on Leetcode/Hackerank. -> Download data from Kaggle & build EDA (Data manipulation questions are asked) Resources: https://topmate.io/codingdidi/digital_products ENJOY LEARNING 👍👍

Gentle reminder 🎗️ "I've seen a great response from you guys and it truly means a lot 🙌🏻 💯 because of your support and efforts, the maximum number of seats are filled 💺✅. *I want to inform all of you that the course enrollment will be closed on 20th June 2024 ⚠️⚠️. So, if you're still interested in enrolling in this course please update before 20th June* ☺️⭐ Thank you!! Regards Codingdidi

Amazon is hiring! Position: Data Analyst/ Business Analytics Qualifications: Bachelor’s/ Master’s Degree Salary: 5 - 8 LPA (Expected) Experience: Freshers/ Experienced Location: Bangalore/ Hyderabad 📌Apply Now: https://www.amazon.jobs/en/jobs/2650214/data-analyst-in-easyship? https://www.amazon.jobs/en/jobs/2574412/business-analyst-i-lat-mile-analytics-and-quality-lmaq?

Adobe is hiring! Position: Data Science Engineer Qualifications: Bachelor’s/ Master’s or PhD Degree Salary: 8 - 23 LPA (Expected) Experience: Freshers/ Experienced Location: Bangalore, India 📌Apply Now: https://careers.adobe.com/us/en/job/ADOBUSR144292EXTERNALENUS/Data-Science-Engineer

Company: HSBC! Position: Business Analyst - Accounts Qualifications: Bachelor’s/ Master’s Degree Salary: 7 - 12 LPA (Expected) Experience: Freshers/ Experienced Location: Work From Home/ Office https://mycareer.hsbc.com/en_GB/external/PipelineDetail/Business-Analyst-Accounts-SSI-s/217665

Company: Sanofi! Position: Trainee Data Analyst Experience: Freshers (0 - 1 Years) Location: Hyderabad, India https://sanofi.wd3.myworkdayjobs.com/SanofiCareers/job/Hyderabad/Trainee-Data-Analyst_R2748187

https://www.instagram.com/reel/C8Q9BfJyNmp/?igsh=ajEyODRkeXM3Nmlo Here's the 🔗 Link:- https://drive.google.com/file/d/1chHIxSL28TQbvWAaBFdaJ2KseV82p7iR/view?usp=sharing

That's all you need for a data analyst role and this is the kick starter for the data science role. Begin and invest for your future. Grad your seats Today!! 😍😍 👌 Waiting to see you all in the session. ✅

Sharpsell.ai is hiring Business Analyst interns with 0-2 years of experience with a background of Computer Science/Information Systems/ Data Analytics, or a related field. Candidates with knowledge of SQL and experience writing queries, familiar with BI tools such as Tableau/Power BI, or similar dashboarding platforms are preferred for the role. This role is for Bangalore location, and three days working from office. Interested candidates please share your CVs with priyadarshini.r@sharpsell.ai

BCG is hiring for the role of Data Analyst. Experince - 2 to 4 Years Location - Bengaluru, Gurgaon Apply Now : https://unstop.com/o/RYPqncH?lb=8eEx09ow&utm_medium=Share&utm_source=shortUrl Like for more ❤️ All the best 👍👍

COMC is hiring for Data Analyst Salary Range $80,000.00 - $100,000.00 Apply Link: https://www.paycomonline.net/v4/ats/web.php/jobs/ViewJobDetails?job=100986&clientkey=DB4B2E90705AD5F0635FBD274EAB4268 Job Qualifications Bachelor’s degree in Computer Science, Information Systems, Statistics, or a related field. 2+ years of experience in data analysis. Proficient in SQL for data querying and manipulation. Experience with Power BI or similar data visualization tools. Understanding of data warehousing and database structures. Basic knowledge of statistical analysis and data modeling. Excellent analytical and problem-solving skills. Ability to communicate complex data insights in a clear and concise manner. Like for more ❤️ All the best 👍👍

Thanks for commenting 😄. Here's the link for ML handwritten note. https://drive.google.com/file/d/1XEDuGOUgDu0349dSDxY8wkTH4YN0QIvL/view?usp=sharing https://www.instagram.com/reel/C7-7i-RSoCC/?igsh=MWFjbDkwcTNuaHFmMw==

Link for TensorFlow pdf. https://www.instagram.com/reel/C78WuK2S-HB/?igsh=NDZ5MnAzb3BidGJ4 https://drive.google.com/file/d/1f241hhkC5z2_wW87HC7c2Zr40brWJrRP/view?usp=sharing