Hi, all

Here's the list of questions which are for the Data analyst role.

Do check it out.✅

And share it with your fellow friends👍😉


Follow @codingdidi

COMMON TERMINOLOGIES IN PYTHON

Have you ever gotten into a discussion with a programmer before? Did you find some of the Terminologies mentioned strange or you didn't fully understand them?

In this series, we would be looking at the common Terminologies in python.

It is important to know these Terminologies to be able to professionally/properly explain your codes to people and/or to be able to understand what people say in an instant when these codes are mentioned. Below are a few:

IDLE (Integrated Development and Learning Environment) - this is an environment that allows you to easily write Python code. IDLE can be used to execute a single statements and create, modify, and execute Python scripts.

Python Shell - This is the interactive environment that allows you to type in python code and execute them immediately

System Python - This is the version of python that comes with your operating system

Prompt - usually represented by the symbol ">>>" and it simply means that python is waiting for you to give it some instructions

REPL (Read-Evaluate-Print-Loop) - this refers to the sequence of events in your interactive window in form of a loop (python reads the code inputted>the code is evaluated>output is printed)

Argument - this is a value that is passed to a function when called eg print("Hello World")... "Hello World" is the argument that is being passed.

Function - this is a code that takes some input, known as arguments, processes that input and produces an output called a return value. E.g print("Hello World")... print is the function

Return Value - this is the value that a function returns to the calling script or function when it completes its task (in other words, Output). E.g.
>>> print("Hello World")
Hello World
Where Hello World is your return value.

Note: A return value can be any of these variable types: handle, integer, object, or string

Script - This is a file where you store your python code in a text file and execute all of the code with a single command

Script files - this is a file containing a group of python scripts.


🫶Follow @codingdidi ✅

Hi, 🤗 everyone!!

https://www.instagram.com/reel/C6QN86Crvtv/?igsh=MTBpcXYxa2xjdHhpcw==

Here are the links!


1. SQL Data Analytics Project

https://www.youtube.com/watch?v=GHtX0QXfi6g&t=1664s

2. Data Analyst Portfolio Project - SQL

https://www.youtube.com/watch?v=0rB_memC-dA

3. Data Analyst Portfolio Project Complete Playlist

https://www.youtube.com/watch?v=qfyynHBFOsM&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f


Don't forget to comment on this video😉✅


✅Follow @codingdidi

Explore the List of 30 libraries used by data scientists.

https://www.linkedin.com/posts/akansha-yadav24_python-libraries-for-data-science-activity-7189858305530380289-x_2w?utm_source=share&utm_medium=member_android



Follow @Codingdidi✅

Here's the link of FREE DATA SCIENCE INTRODUCTORY COURSE.



LINK :- https://skillsforall.com/course/introduction-data-science?courseLang=en-US



https://www.instagram.com/reel/C6RE_pxSwrg/?igsh=MXB0bXBxYjF6M2ZxOQ==


✅Follow @codingdidi

Hi, All

Pandas day-3 video is live!!
Go check it out.

English video link:-

https://youtu.be/EbKzSqmS-Hg?si=qQhX8cFbrC-io7Wx


Hindi video link:-
https://youtu.be/F3niR44_L38?si=09M4Oc-iuFloexTy

Don't forget to like, share and comment on videos.


I'm waiting for your comments.



Follow @codingdidi

⭐️ The PyTorch team is developing a library for learning LLM called torch titan.

Today the library has become publicly available on GitHub, but it is still in a pre-release state and is actively being developed.

- Library link: https://github.com/pytorch/torchtitan

The library was created for preliminary training of models, and for fine tuning PyTorch has another library, torchtune:

https://github.com/pytorch/torchtune

✅ https://t.me/Codingdidi

TOP 10 SQL Concepts for Job Interview.

Don't forget to revise these concepts to clear the interview.

1. Aggregate Functions (SUM/AVG)
2. Group By and Order By
3. JOINs (Inner/Left/Right)
4. Union and Union All
5. Date and Time processing
6. String processing
7. Window Functions (Partition by)
8. Subquery
9. View and Index
10. Common Table Expression (CTE)



Like this post if you need more 👍❤️

Hope it helps :)

5 Unique Power BI projects for Resume✅

📌Website Traffic Analysis
🔗https://www.phdata.io/blog/web-traffic-power-bi-dashboard-example/

📌Weather Forecasting Analysis
🔗https://www.novypro.com/project/vstrix1303--github

📌Employee Performance Analysis
🔗https://github.com/Krishnkumar542/INX-Future-Inc-Employee-Performance-Analysis-using-Power-BI

📌Sales Data Visualization and Analysis
🔗https://github.com/yashsdoshi/Sales_report_using_PowerBi

📌 E-commerce website customer-purchasing Capability Analysis
🔗https://github.com/meysamraz/digikala-e-commerce-website-customer-purchase-dashboard

Follow @codingdidi –

Instagram https://www.instagram.com/codingdidi/
Youtube https://youtube.com/@codingdidi?si=TkcPMdGsgV8z61lh

Linkedin
www.linkedin.com/in/akansha-yadav24

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