Times Group is #hiring for a Data Analyst.

Experience: 1-2 yrs
Location: Noida office (Film city)
Skills: Data analysis, visualization skills (Tableau) and MS Excel

Interested candidates can send their resume at :
c-dwitika.gambhir@timesgroup.com , madhavi.dhumal@timesgroup.com

Also, please mention current CTC and notice period in the email.

Follow @Codingdidi✅

Hi All, here is the template for the cover letter.

Make sure to update it as per the job description.

https://www.instagram.com/reel/C6VXPGVrDU3/?igsh=amlrbzRwbWV4aGEw


✅Follow @codingdidi

Citi hiring for Fresher Data Scientist

https://jobs.citi.com/job/-/-/287/63060553280?

Amazon Hiring Fresher For Data Analyst
Location: Bangalore, Hyderabad, Gurugram
Qualification: Bachelor/Master Degree
Work Experience: Fresher
Salary: 5 - 8 LPA

👍✅Apply Link: https://www.amazon.jobs/en/jobs/2616762/data-analyst-abcs-analytics


Amazon Hiring Fresher For Data Analyst
Location: Bangalore
Qualification: Bachelor/Master Degree
Work Experience: 1+ years
Salary: 8 - 12 LPA

✅👍Apply Link: https://www.amazon.jobs/en/jobs/2613934/data-analyst

✅For Daily job Updates join here: https://t.me/Codingdidi

If you are trying to transition into the data analytics domain and getting started with SQL, focus on the most useful concept that will help you solve the majority of the problems, and then try to learn the rest of the topics:

👉🏻 Basic Aggregation function:
1️⃣ AVG
2️⃣ COUNT
3️⃣ SUM
4️⃣ MIN
5️⃣ MAX

👉🏻 JOINS
1️⃣ Left
2️⃣ Inner
3️⃣ Self (Important, Practice questions on self join)

👉🏻 Windows Function (Important)
1️⃣ Learn how partitioning works
2️⃣ Learn the different use cases where Ranking/Numbering Functions are used? ( ROW_NUMBER,RANK, DENSE_RANK, NTILE)
3️⃣ Use Cases of LEAD & LAG functions
4️⃣ Use cases of Aggregate window functions

👉🏻 GROUP BY
👉🏻 WHERE vs HAVING
👉🏻 CASE STATEMENT
👉🏻 UNION vs Union ALL
👉🏻 LOGICAL OPERATORS

Other Commonly used functions:
👉🏻 IFNULL
👉🏻 COALESCE
👉🏻 ROUND
👉🏻 Working with Date Functions
1️⃣ EXTRACTING YEAR/MONTH/WEEK/DAY
2️⃣ Calculating date differences

👉🏻CTE
👉🏻Views & Triggers (optional)


✅Share with credits: https://t.me/codingdidi

❤️Hope it helps :) 😃

Hi all,

Here's the link for pandas day-4 video.


English :- https://youtu.be/UaoseR5HnUY?si=7jz5SRkaoNzrIb1U


Hindi:-
https://youtu.be/jQTKaqRjVos?si=9k9XGnv7nobEDQZT


I'm waiting for you all in the comment section.


✅Share it with your fellow learners.


Follow @codingdidi

American Express is hiring for a Data Analyst!

https://aexp.eightfold.ai/careers?pid=21324925

Paytm is hiring for a Data Scientist (Product Analytics)!

https://jobs.lever.co/paytm/4850b2c2-0045-458b-9c43-3b50cc4bb4cc

Like for more ❤️

All the best 👍👍

Hi, all
here's the roadmap for learning EXCEL with free resources.


INSTAGRAM:- https://www.instagram.com/reel/C6X8J-yLNSW/?igsh=MWwxZHI1Z3pzbWJvZw==



✅FOLLOW @CODINGDIDI

👉Freshers jobs opportunity:

https://www.linkedin.com/feed/update/urn:li:share:7190925456852815872/

✅Follow @codingdidi

HI, all


Pandas day-5 video is live..!



👉Looking for your love and comments on videos...!


Go check out the video 📸



Hindi:- https://youtu.be/4NTWYUeuSWM?si=M6WYYY5K_azhjYk2


English :-

https://youtu.be/CrvY0QIURyg?si=TQDzMXCl8QLnANWY




✅Follow @Codingdidi

NTT DATA is hiring!
Position: Data Analyst
Experience: Entry Level
Location: Hyderabad, India

https://nttdata.eightfold.ai/careers?pid=563327918064034&domain=nttdata.com


✅Follow @Codingdidi

Make your journey easier by accelerating your learning.


Learn these libraries of python.

Follow @codingdidi.

:-More likes👍 more posts 😀-:

Hi, all

Here's the python roadmap !


https://www.instagram.com/reel/C6agoDarrij/?igsh=bHV6b3Awem4wenJ4


Follow @codingdidi

Hi, all


Another pandas long video is out on my yt channel.

Here are the link.


English:-

https://youtu.be/DYSAc3Pmzwo?si=-zz7PM46j6PsUDVt



Hindi:- https://youtu.be/r9H6ybaLWv4?si=gjIm3xD1NTWkitzD

Go and check out the video.


Don't forget to subscribe and hit the 🔔 bell icon ☺️.


Follow @codingdidi

Hi all, I need your help.

I'm looking for a free tool using which I can automate the comments. 😅 As it's getting really difficult to revert back on each comment. Instagram is also restricting the commenting.


If anyone of you can help that would be really appreciated. 😇

THIS IS WHAT POPS UP.