These free courses provided by Microsoft—Azure Fundamentals (AZ-900), Azure Data Fundamentals (DP-900), and Azure AI Fundamentals (AI-900)—offer essential training for data analytics roles. They cover foundational cloud concepts, data management and analysis with Azure services, and AI and machine learning integration, equipping you with the skills needed to utilize Azure's capabilities effectively in data analytics.


Course Links:

1. Azure Fundamentals (AZ-900)
https://learn.microsoft.com/en-us/certifications/azure-fundamentals/


2. Azure Data Fundamentals (DP-900)
https://learn.microsoft.com/en-us/certifications/azure-data-fundamentals/


3. Azure AI Fundamentals (AI-900)
https://learn.microsoft.com/en-us/certifications/azure-ai-fundamentals/

1. Amazon ML Data Associate I

Exp: 0-2 Yr

https://lnkd.in/gyUuaDWW

2. Deutsche Bank Analytics - Data Analyst

Exp: Fresher/ Experience

https://lnkd.in/grTWm_mD

3. Genpact Business Analyst/ Data Analyst

Exp: Fresher/ Experience

Gurugram: https://lnkd.in/gDUqgz6q

Bangalore: https://lnkd.in/g2WkedpR

Kolkata: https://lnkd.in/gx9gB9z2

4. HP Financial Analyst

Exp: Fresher

https://lnkd.in/g8v5jMCX

5. Societe Generale Analyst/ Business Analyst

Exp: Fresher/ Experience

https://lnkd.in/gs-CdNeR

https://lnkd.in/gTyYMfkT

6. Codenera Data Analyst

Exp: 0-1 Yr

https://lnkd.in/gnYtHg48

7. Cognitiveview ML Engineer

Exp: 0-3 Yr

https://lnkd.in/gEVBCgdA

8. Jobsmill Data Science Engineer

Exp: Fresher

https://lnkd.in/g4Q_4XQ3

9. Novel Office Data Analyst

Exp: 0-1 Yr

https://lnkd.in/g_n7CV9N

10. Headstart Manpower Consultants Data Analyst

Exp: 0-5 Yr

https://lnkd.in/gfjrRAHi

11. Incanus Technologies Business Analyst

Exp: 0-4 Yr

https://lnkd.in/gxVFyfuV

12. LRP Captivators MIS Executive

Exp: 0-2 Yr

https://lnkd.in/gRWX6MQp

13. Abhi Impact Data Analyst

Exp: 0-2 Yr

https://lnkd.in/gE4PZYHK

14. Techworkslab Data Science Intern (Internship)

https://lnkd.in/gfFR6Ccj

KPMG hiring Data Engineer

Experience: Freshers

https://lnkd.in/d3MHdvZn

JPMorgan is hiring Business Management - Associate

Experience: Freshers/ Experienced

https://lnkd.in/dEEKStjj

PayPal Data Analyst

Experience: Freshers/ Experienced

https://lnkd.in/dpfydYRc


Gainwell Technologies Data Analyst

Experience: Freshers/ Experienced

https://lnkd.in/dgq2snj6

Deutsche Bank is hiring Analytics - Data Analyst

Experience: Freshers/ Experienced

https://lnkd.in/grTWm_mD

Amway India Enterprises Data Analyst

Exp: 0-5 Year

https://lnkd.in/dEPPcxz5

Codenera Data Analyst

Exp: 0-1 Year

https://lnkd.in/gnYtHg48

Cognitiveview MI Engineer

Exp: 0-3 Year

https://lnkd.in/gEVBCgdA

Jobsmill Data Science Engineer

Exp: Fresher

https://lnkd.in/g4Q_4XQ3

Novel Office Data Analyst

Exp: 0-1 Year

https://lnkd.in/g_n7CV9N

Crisil Economic Analyst

Exp: 0-3 Year

https://lnkd.in/dePU8VPG

Meritus Management Service Data Scientist /Data Science / Data Engineer

Exp: 0-1 Year

https://lnkd.in/d3SYQ9ga

1. Find the employee(s) with the second highest salary in the company

SQL:
SELECT employee_id, salary
FROM employees
WHERE salary = (SELECT DISTINCT salary
                FROM employees
                ORDER BY salary DESC
                LIMIT 1 OFFSET 1)

Pandas:
second_highest_salary = employees['salary'].nlargest(2).iloc[-1]
second_highest_salary_employees = employees[employees['salary'] == second_highest_salary]

2. Find employees who earn more than the average salary of their department

SQL:
SELECT employee_id, department_id, salary
FROM employees e
WHERE salary > (SELECT AVG(salary)
                FROM employees
                WHERE department_id = e.department_id)

Pandas:
avg_salary_by_dept = employees.groupby('department_id')['salary'].transform('mean')
higher_than_avg = employees[employees['salary'] > avg_salary_by_dept]

3. Identify the employees who have the longest tenure in each department

SQL:
SELECT department_id, employee_id, hire_date
FROM employees e
WHERE hire_date = (SELECT MIN(hire_date)
                   FROM employees
                   WHERE department_id = e.department_id)

Pandas:
longest_tenure = employees.loc[employees.groupby('department_id')['hire_date'].idxmin()]


4. Determine the top N percent of employees based on salary

SQL:
WITH ranked_employees AS (
  SELECT employee_id, salary,
         PERCENT_RANK() OVER (ORDER BY salary DESC) AS percentile
  FROM employees
)
SELECT employee_id, salary
FROM ranked_employees
WHERE percentile <= 0.1  -- Adjust this value for top N percent

Pandas:
top_n_percent = 0.1
salary_threshold = employees['salary'].quantile(1 - top_n_percent)
top_employees = employees[employees['salary'] >= salary_threshold]

Guys !! You can use it for Data Analytics interview too.

Policybazaar:

Exp Required: 1+ year

https://www.linkedin.com/jobs/view/3985507414

IndusInd Bank

Exp Required: 2+ year

https://jigya.co.in/jobs-apprenticeships/indusind-bank/data-scientist-business-analyst-2?Ref=Linkedin

Narvar

Exp Required: 2+ year

https://job-boards.greenhouse.io/narvar/jobs/6132782?gh_src=fa3ccd361us

Asign

Exp Required: 2+ year


https://in.talent.com/view?id=da1a240c286a

WeRize

Exp Required: 1+ year


https://www.hirist.tech/j/werize-data-analyst-sqlpython-1361384.html

Mercedes Interview Questions & Answers

LG Case Study Interview Question and Answer

Amazon is hiring Business Analyst

Experience: Freshers

https://lnkd.in/dUR_ge3p

Swiggy Data Scientist

Experience: 0-3 Years

https://lnkd.in/dZ9ZhgqT

Nestle Business Analyst - AOA MarTech/AdTech

Experience: 0-1 Years

https://lnkd.in/ds_g3xiQ

Easemytrip Data Analyst

https://lnkd.in/dzmydn63

Vmock Business Analyst

Experience: 0-2 years

https://lnkd.in/dASg26nB

Jobsmill Data Science Engineer

Experience: Fresher

https://lnkd.in/g4Q_4XQ3

Paradigmit Technology Services Data Engineer with Al

Experience: 0-2 Years

https://lnkd.in/dsqb6_vg

Aperiam Bio Machine Learning Engineer/DataScientist

Experience: 0-2 Years

https://lnkd.in/d9GEVfaU


Innovaccer Apprentice - Data Ops Engineer

Experience: 0-2 Years

https://lnkd.in/d2uNN-EP

BSD Infotech Accomplished Data Scientist

Experience: 0-3 Years

https://lnkd.in/dZWa79gr

Alphastream Technologies Data and Legal analyst

Experience: 0-4 Years

https://lnkd.in/dikkw9Xq?

Skillmine Technology Consulting Pvt. Ltd. Procurement Data Analyst

Experience: 0-3 Years

https://lnkd.in/dRm2D3zt

AD Astra Labs MI Engineer

Experience: 0-3 Years

https://lnkd.in/dXnMqNSi

Jar Business Analyst Intern

https://lnkd.in/dyXRFffe

Genpact Business Analyst

Exp: 0-5 Year

https://lnkd.in/duWNgwSt

DXC Technology Analyst III

Exp: 0-1 Year

https://lnkd.in/dUhVQzZQ

Zepto Mis Executive

Exp: 0-2 Year

https://lnkd.in/dMZSiqp4

Career Guideline MIS Executive

Exp: 0-3 Year

https://lnkd.in/d4G4YQGC

Connexio MIS Executive

Exp: 0-1 Year

https://lnkd.in/dxt9MGeJ

Parikh Global Lip MIS Specialist

Exp: 0-5 Year

https://lnkd.in/d6YYdktm

Prasanna Technologies Business Analyst

Exp: 0-3 Year

https://lnkd.in/dUcamYHm

Hi-Tech Animation Studios MIS Intern

Exp: 0-1 Year

https://lnkd.in/dkh-E6bR

Factly Media & Research Data Science Work From Home Internship

https://lnkd.in/du7GmUA3

Defloors Data Analytics Internship

https://lnkd.in/dFE6KiYC

Uboard India Limited Data Analyst Internship

https://lnkd.in/dWcq7Syt

Company Internkaksha IT Solutions

Role Data Analyst

Exp. - Fresher

Apply Here - https://lnkd.in/eyYwYfBz

Company Aadhvik Technologies

Role Data Science Intern

Exp. - Fresher

Apply Here - https://lnkd.in/efWPWXA4

Company Turing

Role Business Analyst

Exp. - Fresher

Apply Here - https://lnkd.in/e25cr2tT

Company W. R. Grace

Role Data Analyst

Exp. - 1 yr

Apply Here - https://lnkd.in/eRanDx6Q

Company PubMatic

Role Data Analyst

Exp. - 1-3 yrs

Apply Here - https://lnkd.in/eU742YxK

Company HRhelpdesk

Role Data Analyst

Exp. - 2 yrs

Apply Here - https://lnkd.in/er7z3QDh

Company - P&G

Role Data Scientist

Exp. - 2+ yrs

Apply Here - https://lnkd.in/eu9ebbnZ

Company Pathsetter Al

Role Data Engineer

Exp. - 3-4 yrs

Apply Here - https://lnkd.in/exTz9zNF


Apply Here - https://lnkd.in/exTz9zNF

Company - Turing

Role Data Scientist

Exp. - 2 yrs

Apply Here - https://lnkd.in/eNEjr796

Company Black Turtle

Role Data Engineer

Exp. - 2-4 yrs

Apply Here - https://lnkd.in/e9fz7wNp

Hi Guys!!

Most awaited video - "Data Analyst Roadmap with Free Resources" is live on YouTube. Please click on the below mentioned link & show your support 💓🙏.

YouTube Link: https://youtu.be/r3WuDHyOlv4?si=t14AHgWix1BURJMK


Thanks❤️!!

American Express Hiring Data Analyst -

https://aexp.eightfold.ai/careers/job/24236406-analyst-data-analytics-gurugram-haryana-india?domain=aexp.com

Check out this Data Analytics job at Kaseya:
https://www.linkedin.com/jobs/view/3996897640

Check out this Business Intelligence job at Pyramid Technology Solutions:
https://www.linkedin.com/jobs/view/3991675365