Citi is hiring!
Position: Business Analytics, Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 6 - 10 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bengaluru, India (Hybrid)

📌Apply Now: https://jobs.citi.com/job/bengaluru/business-analyst-c9/287/84491032800

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

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

All the best! 👍👍

Barclays is hiring!
Position: Data Analyst - SQL
Qualification: Bachelor's/ Master’s Degree
Salary: 8 - 11 LPA (Expected)
Experience: Freshers/ Experienced
Location: India

📌Apply Now: https://search.jobs.barclays/job/pune/data-analyst-sql/13015/84679192224

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

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

All the best! 👍👍

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

📌Apply Now: https://careers.cognizant.com/india-en/jobs/00064931851/consulting-analyst/

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

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

All the best! 👍👍

Appinventiv is hiring Junior Analyst 🚀

Experience : 1 Year
Location : Noida

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

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

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

All the best! 👍👍

Morning Star is hiring Data Analyst 🚀

Fresh Graduates are eligible ✅
Location : Mumbai

Apply link : https://careers.morningstar.com/us/en/job/MORMORUSREQ052274EXTERNALENUS/Data-Analyst?utm_source=linkedin&utm_medium=phenom-feeds&source=LinkedIn

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

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

All the best! 👍👍

MakeMyTrip is hiring Data Analyst 🚀

Experience : 2 Years
Location : Gurugram

Apply link : https://careers.makemytrip.com/prod/opportunity/a6604089828fe8/data-analyst?src=Linkedin

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

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

All the best! 👍👍

Data analytics isn't sexy.

Stakeholders often don't know what you bring to the table so you're pigeon-holed into...

- being seen purely for your technical skills
- creating routine reports without insights
- focusing only on data cleaning & prep
- just tracking basic metrics or KPIs
- handling ad-hoc data requests

So what can you do?

Show your stakeholders the value you bring to the table by...

- asking thoughtful questions and using them to guide your analysis
- focusing on actionable insights, not just the numbers
- understanding their business needs
- being a clear communicator
- recognizing the impact you can have
- using data visualizations to tell a compelling story
- identifying potential issues and proactively proposing solutions

This isn't an overnight change.

But if you consistently show what you can do, you'll start to build relationships with stakeholders and become their go-to for data-driven insights.

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

📌Apply Now: https://www.wellsfargojobs.com/en/jobs/r-389220/intern-analyst/

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

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

All the best! 👍👍

JPMorgan is hiring!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 7 - 11 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://jpmc.fa.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1001/jobs/preview/210653091/?keyword=Client+Data+Analyst&mode=location

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

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

All the best! 👍👍

If you want to Excel at using the most used database language in the world, learn these powerful SQL features:

• Wildcards (%, _) – Flexible pattern matching
• Window Functions – ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD(), LAG()
• Common Table Expressions (CTEs) – WITH for better readability
• Recursive Queries – Handle hierarchical data
• STRING Functions – LEFT(), RIGHT(), LEN(), TRIM(), UPPER(), LOWER()
• Date Functions – DATEDIFF(), DATEADD(), FORMAT()
• Pivot & Unpivot – Transform row data into columns
• Aggregate Functions – SUM(), AVG(), COUNT(), MIN(), MAX()
• Joins & Self Joins – Master INNER, LEFT, RIGHT, FULL, SELF JOIN
• Indexing – Speed up queries with CREATE INDEX

Like it if you need a complete tutorial on all these topics! 👍❤️

#sql

📌Deloitte is hiring for Junior Analyst
Experience: 0 - 1 year's
Apply here: https://usijobs.deloitte.com/en_US/careersUSI/JobDetail/USI-R-FA-FY-26-EH-FinCrime-Investigator-Junior-Analyst-Fixed-Term-Hire/308611

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

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

All the best! 👍👍

📌Bain & Company is hiring for Analyst
Experience: 0 - 1 year's
Expected CTC: 9 - 10 LPA
Apply here: https://www.linkedin.com/jobs/view/4279890043/

All the best 👍👍

Here are some advanced SQL techniques that are game-changers

Window Functions: Learn how to use OVER() for advanced analytics tasks. They are crucial for calculating running totals, rankings, and lead-lag analysis in datasets.

CTEs and Temp Tables: Common Table Expressions (CTEs) and temporary tables can simplify complex queries, especially when dealing with large datasets.

Dynamic SQL: Understand how to construct SQL queries dynamically to increase the flexibility of your database interactions.

Optimizing Queries for Performance: Explore how indexing, query restructuring, and understanding execution plans can drastically improve your query performance.

Using PIVOT and UNPIVOT: These operations are key for converting rows to columns and vice versa, making data more readable and analysis-friendly. If you're looking to deepen your SQL knowledge, these areas are a great start.

Sugar.fit is hiring Data Analyst 🚀

Min. Experience : 1 Year
Location : Bangalore
CTC : 6-7 LPA

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

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

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

All the best! 👍👍

Netflix hiring Analyst, Talent Analytics (Machine Learning)

Location: USA - Remote

Required Qualifications:

Education: Degree in Data Science, Computer Science, Statistics, Mathematics, Industrial-Organizational Psychology (with strong quantitative focus), or a related quantitative field.

Experience: 2-4 years of hands-on professional experience as a Data Scientist or Advanced Analytics, with a significant portfolio of machine learning projects, ideally within the HR or Talent Acquisition domain.

Programming: Strong proficiency in R or Python for data manipulation, statistical analysis, and machine learning model development.

Machine Learning Expertise: Deep understanding and practical experience with a wide range of supervised and unsupervised machine learning algorithms relevant to predictive modeling, classification, regression, and clustering.

Statistical Modeling: Strong foundation in statistical inference, hypothesis testing, experimental design, time series analysis, and causal inference.

Data Querying & Databases: Proficient in SQL for extracting and transforming data from complex relational databases (e.g., HRIS, ATS). Experience with large-scale data warehouses.

Communication & Storytelling: Exceptional ability to translate complex analytical findings and technical concepts into clear, concise, and actionable recommendations for non-technical audiences, including senior executives.

Apply link: https://explore.jobs.netflix.net/careers/job/790303869069?microsite=netflix.com

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

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

Like for more such opportunities ❤️

All the best! 👍👍

Unacademy is hiring Intern Data Analyst

For 2024, 2025, 2026 grads
Location: Bangalore

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

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

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

Like for more such opportunities ❤️

All the best! 👍👍

FinThrive is hiring Analyst

For 2022, 2023, 2024, 2025 grads
Location: Gurugram

https://jobs.dayforcehcm.com/en-US/finthrive/CANDIDATEPORTAL/jobs/5494?iis=Job+Board&iisn=LinkedIn

JPMorgan is hiring!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 7 - 11 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://jpmc.fa.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1001/jobs/preview/210653091/?keyword=Client+Data+Analyst&mode=location

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

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

Like for more such opportunities ❤️

All the best! 👍👍

Data Analyst INTERVIEW QUESTIONS AND ANSWERS
👇👇

1.Can you name the wildcards in Excel?

Ans: There are 3 wildcards in Excel that can ve used in formulas.

Asterisk (*) – 0 or more characters. For example, Ex* could mean Excel, Extra, Expertise, etc.

Question mark (?) – Represents any 1 character. For example, R?ain may mean Rain or Ruin.

Tilde (~) – Used to identify a wildcard character (~, *, ?). For example, If you need to find the exact phrase India* in a list. If you use India* as the search string, you may get any word with India at the beginning followed by different characters (such as Indian, Indiana). If you have to look for India” exclusively, use ~.

Hence, the search string will be india~*. ~ is used to ensure that the spreadsheet reads the following character as is, and not as a wildcard.


2.What is cascading filter in tableau?

Ans: Cascading filters can also be understood as giving preference to a particular filter and then applying other filters on previously filtered data source. Right-click on the filter you want to use as a main filter and make sure it is set as all values in dashboard then select the subsequent filter and select only relevant values to cascade the filters. This will improve the performance of the dashboard as you have decreased the time wasted in running all the filters over complete data source.


3.What is the difference between .twb and .twbx extension?

Ans:
A .twb file contains information on all the sheets, dashboards and stories, but it won’t contain any information regarding data source. Whereas .twbx file contains all the sheets, dashboards, stories and also compressed data sources. For saving a .twbx extract needs to be performed on the data source. If we forward .twb file to someone else than they will be able to see the worksheets and dashboards but won’t be able to look into the dataset.


4.What are the various Power BI versions?

Power BI Premium capacity-based license, for example, allows users with a free license to act on content in workspaces with Premium capacity. A user with a free license can only use the Power BI service to connect to data and produce reports and dashboards in My Workspace outside of Premium capacity. They are unable to exchange material or publish it in other workspaces. To process material, a Power BI license with a free or Pro per-user license only uses a shared and restricted capacity. Users with a Power BI Pro license can only work with other Power BI Pro users if the material is stored in that shared capacity. They may consume user-generated information, post material to app workspaces, share dashboards, and subscribe to dashboards and reports. Pro users can share material with users who don’t have a Power BI Pro subnoscription while workspaces are at Premium capacity.

ENJOY LEARNING 👍👍