𝐊𝐏𝐌𝐆 - 𝐎𝐟𝐟 𝐂𝐚𝐦𝐩𝐮𝐬 𝐑𝐞𝐜𝐫𝐮𝐢𝐭𝐦𝐞𝐧𝐭 𝐃𝐫𝐢𝐯𝐞!
Position: Analyst
Qualification: Bachelor's Degree
Salary: 4 - 7 LPA (Expected)
Experience: Freshers
Location: Pune/ Noida

📌Apply Now: https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/jobs/preview/INTG10032516/?keyword=Analyst&mode=location

https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/INTG10029753?keyword=Analyst&mode=location

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Essential Excel Concepts for Beginners

1. VLOOKUP: VLOOKUP is a popular Excel function used to search for a value in the first column of a table and return a corresponding value in the same row from another column. It is commonly used for data lookup and retrieval tasks.

2. Pivot Tables: Pivot tables are powerful tools in Excel for summarizing and analyzing large datasets. They allow you to reorganize and summarize data, perform calculations, and create interactive reports with ease.

3. Conditional Formatting: Conditional formatting allows you to format cells based on specific conditions or criteria. It helps highlight important information, identify trends, and make data more visually appealing and easier to interpret.

4. INDEX-MATCH: INDEX-MATCH is an alternative to VLOOKUP that combines the INDEX and MATCH functions to perform more flexible and powerful lookups in Excel. It is often preferred over VLOOKUP for its versatility and robustness.

5. Data Validation: Data validation is a feature in Excel that allows you to control what type of data can be entered into a cell. You can set rules, create drop-down lists, and provide error messages to ensure data accuracy and consistency.

6. SUMIF: SUMIF is a function in Excel that allows you to sum values in a range based on a specific condition or criteria. It is useful for calculating totals based on certain criteria without the need for complex formulas.

7. CONCATENATE: CONCATENATE is a function in Excel used to combine multiple text strings into one. It is helpful for creating custom labels, joining data from different cells, and formatting text in a desired way.

8. Goal Seek: Goal Seek is a built-in tool in Excel that allows you to find the input value needed to achieve a desired result in a formula. It is useful for performing reverse calculations and solving what-if scenarios.

9. Data Tables: Data tables in Excel allow you to perform sensitivity analysis by calculating multiple results based on different input values. They help you analyze how changing variables impact the final outcome of a formula.

10. Sparklines: Sparklines are small, simple charts that provide visual representations of data trends within a single cell. They are useful for quickly visualizing patterns and trends in data without the need for larger charts or graphs.

Wipro is hiring Freshers!
Position: Associate Analyst
Qualification: Bachelor’s/ Master’s degree
Salary: 3.5 - 7 LPA (Expected)
Experience: Entry Level
Location: Chennai; Coimbatore, India

📌Apply Now: https://careers.wipro.com/job/Chennai-Associate-Analyst-600119/1159560655/

https://careers.wipro.com/job/Coimbatore-Associate-Analyst-641004/1164881955/

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Circle K is hiring Associate Data Scientist 🚀

Experience : 1-2 Year
Location : Gurugram

Apply link : https://www.linkedin.com/jobs/view/4262895888

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Schbang is hiring Business Analyst 🚀

Min. Experience : 1 Year
Freshers with Finance background can apply ✅
Location : Mumbai

Apply link : https://www.linkedin.com/jobs/view/4260358144

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

6thStreet . com is hiring Data Analyst 🚀

Experience : 1-2 Year
Location : Bangalore

Apply link : https://www.linkedin.com/jobs/view/4261104574

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Zepto is hiring Business Analyst 🚀

Experience : 2+ Years
Location : Bangalore

Apply link : https://www.linkedin.com/jobs/view/4260796866

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Volvo is hiring!
Position: Data Analyst
Qualifications: Bachelor’s/ Master’s Degree
Salary: 8 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://jobs.volvogroup.com/job/Bangalore-Experienced-Data-Analyst-562122/1161166255/?feedId=361555

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

I see so many people jump into data analytics, excited by its popularity, only to feel lost or uninterested soon after. I get it, data isn’t for everyone, and that’s okay.

Data analytics requires a certain spark or say curiosity. You need that drive to dig deeper, to understand why things happen, to explore how data pieces connect to reveal a bigger picture. Without that spark, it’s easy to feel overwhelmed or even bored.

Before diving in, ask yourself, Do I really enjoy solving puzzles? Am I genuinely excited about numbers, patterns, and insights? If you’re curious and love learning, data can be incredibly rewarding. But if it’s just about following a trend, it might not be a fulfilling path for you.

Be honest with yourself. Find your passion, whether it’s in data or somewhere else and invest in something that truly excites you.

Hope this helps you 😊

EY is hiring!
Position: Analyst - Business Consulting
Qualifications: Bachelor's degree/ Graduation
Salary: Up to 8 LPA (Expected)
Experience: Freshers (0 - 1 Years)
Location: Bengaluru; Gurugram, India

📌Apply Now: https://careers.ey.com/ey/job/Gurugram-Analyst-Business-Consulting-Risk-CHS-CNS-Risk-Digital-Risk-Gurgaon-HR-122003/1220323201/

https://careers.ey.com/ey/job/Bengaluru-Analyst-Business-Consulting-Risk-FS-CNS-Risk-Digital-Risk-Bangalore-KA-560001/1222446201/

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

PwC is hiring!
Position: Junior Data Analyst - Associate
Qualifications: Bachelor’s/ Master's/ MBA
Salary: 6 - 12 (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://jobs-ta.pwc.com/global/en/job/633933WD/Junior-Data-Operations-Support-Analyst-Associate-Operate

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

NatWest Group is hiring!
Position: Business Analyst
Qualifications: Bachelor’s/ Master’s/ MBA
Salary: 6 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Chennai; Gurugram, India (Hybrid)

📌Apply Now: https://jobs.natwestgroup.com/jobs/16009975-business-analytics

https://jobs.natwestgroup.com/jobs/16009974-business-analytics

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

United Airlines is hiring!
Position: Analyst - Data Scientist Machine Learning
Qualifications: Bachelor’s/ Master’s Degree/ MBA
Salary: 8 - 20 LPA (Expected)
Location: Gurugram, India

📌Apply Now: https://careers.united.com/us/en/job/GGN00001899/Analyst-Data-Scientist-Machine-Learning

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

American Express is hiring Analyst 🚀

Qualification : Master's degree from Reputed College
Experience : 0-2 Years
Location : Gurugram

Apply link : https://aexp.eightfold.ai/careers/job/30088736?hl=en&utm_source=linkedin&domain=aexp.com

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Standard Chartered hiring Analyst, Data Engineer

Apply link: https://jobs.standardchartered.com/job/Bangalore-Analyst%252C-Data-Engineer/817788102/?feedId=363857&utm_source=lilimitedlistings

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Deutsche Bank is hiring!
Position: Analytics - Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 7 - 15 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore; Pune, India

📌Apply Link: https://careers.db.com/professionals/search-roles/#/professional/job/64719

https://careers.db.com/professionals/search-roles/#/professional/job/64166

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

IBM is hiring!
Position: Data Engineer
Qualifications: Bachelor’s/ Master’s Degree
Salary: 6.8 - 11 LPA (Expected)
Experience: Freshers/ Experienced
Location: India

📌Apply Now: https://ibmglobal.avature.net/en_US/careers/JobDetail?jobId=32590&source=WEB_Search_INDIA

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Morgan Stanley is hiring!
Position: Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 7 - 15 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bengaluru, India

📌Apply Now: https://morganstanley.eightfold.ai/careers/job/549785887964?domain=morganstanley.com&hl=en

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

𝐃𝐞𝐥𝐨𝐢𝐭𝐭𝐞 𝐈𝐧𝐭𝐞𝐫𝐧𝐬𝐡𝐢𝐩 𝐏𝐫𝐨𝐠𝐫𝐚𝐦𝐦𝐞!
Position: Intern - Data Science
Qualifications: Bachelor’s/ Master’s Degree
Salary: 3.8 - 8 LPA (Expected)
Batch: 2023/ 2024/ 2025/ 2026/ 2027
Experience: Freshers
Location: Bengaluru, India

📌Apply Link: https://southasiacareers.deloitte.com/job/Bengaluru-Intern-Data-Science-Bengaluru-Digital-Excellence-Centre/42903044/

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Visualizing SQL Queries

A mental model can help visualize how SQL queries are executed. Conceptually, SQL statements execute in this sequence:

1. FROM: Tables are identified and joined to create the initial dataset.
2. WHERE: Filters are applied to the initial dataset based on specified criteria.
3. GROUP BY: The filtered rows are grouped according to the specified columns.
4. HAVING: Additional filters are applied to the grouped rows based on aggregate criteria.
5. SELECT: Specific columns are chosen from the resultant dataset for the output.
6. ORDER BY: The output rows are sorted by the specified columns in ascending or descending order.
7. LIMIT: The number of rows in the output is restricted.

While the actual execution plan may vary due to query optimization, this mental model provides a valuable framework for understanding SQL logic.

𝐖𝐞𝐥𝐥𝐬 𝐅𝐚𝐫𝐠𝐨 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐈𝐧𝐭𝐞𝐫𝐧𝐬𝐡𝐢𝐩!
Position: Intern Analyst
Qualifications: Bachelor’s/ Master’s / MBA
Salary: ₹57,272 Per Month (Expected)
Batch: 2022 - 2026
Experience: Freshers
Location: India

📌Apply Now: https://www.wellsfargojobs.com/en/jobs/r-473284/intern-analyst-quantitative-analytics-profile/

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍