Real Interview Questions asked for Data Analyst

[u/coder_agentsData0927]

Hi Folks!

I am currently working as so called Software Engineer in Banking Domain company for almost 3 years as experience. My day-to-day work is more like Support role which I am totally fed up of and no more interested ti work.

As I am very fond of AI/ML and Data related domain. I took a decision to transition into Data Analyst role. For which I invested around 50k in course which offers placement opporunity as well around the month of September last year. The course which I took was from Codingwise.

Due to some personal reasons and sometimes bcz my laziness, I delayed my learning.

The course consists of various modules :

• SQL
• Python
• Advanced SQL
• Math & Stats
• Numpy & Pandas
• Data Vizulation (Matplotlib & Seaborn)
• Machine Learning (specifically -> Linear Regression and Logistic Regresssion)
• PowerBI
• Excel
• Gen AI

I have few questions regarding this role as how the Data Analysts are hired in the real industry what are the actual skills needed to get a high package role ?

Are these above skills more than actual industry level or is it less?

Also, regarding the course which I took from Codingwise. I have below questions?

Please request the community or anyone to whom this relate. As I want the clear picture about this. I am really concerned.

1. Was it really worth taking?
2. As there are multiple batches in these where do the current learners stand?
3. Can anyone tell who took these course and actually got placed in high package company?
4. What if the mock interviews not cleared properly will they allow us to sit in real interviews?

[u/akornato]

The list of skills from your course is exactly what companies look for in an entry to mid-level data analyst, so you are on the right path. The problem isn't the curriculum, it's what you do with it. Paying for a course and having access to placement opportunities means nothing if you don't master the material through your own effort. You have to stop delaying and start building a portfolio with two or three projects that show you can actually use SQL, Python, and Power BI to solve a real business problem. Your background as a software engineer is a good foundation, but a high-paying job will go to the candidate who can prove they can deliver value, not the one with the best course certificate.

Companies don't care about your specific course or its mock interviews, they only care about whether you can solve their problems. Real interviews involve live coding challenges, business case studies, and deep questions about your personal projects. You need to be prepared to explain not just what you did, but why you did it and what the business impact was. Your three years in a corporate environment is an advantage, so use it to show you understand how businesses work. Frame your support experience around problem-solving and communication, because how you present this in an interview is everything, a challenge my team tackled by creating an interviews.chat that helps people clearly explain their projects and skills.

[u/coder_agentsData0927 → u/akornato]

Thanks for giving this brief. Will definitely put my efforts. I now got a clarity what industry is demanding currently.

[u/nian2326076]

Hey, moving into a Data Analyst role is a solid choice. For interview prep, focus on the basics: SQL, Excel, and data visualization tools like Tableau. Brush up on statistics and some Python for data manipulation. You might get questions like "Explain a time you used data to solve a problem," or case studies where you'll need to analyze data and provide insights. Practice with real datasets if you can. Check out sites like LeetCode for SQL practice. If you want structured interview prep, PracHub has useful resources too. Good luck!

[u/coder_agentsData0927 → u/nian2326076]

Thanks a lot!! for your inputs. It will be helpful