Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Physicswallah Team. If you also belong to the team, you can get access from here

Physicswallah Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Physicswallah MIS Business Analyst Interview Questions, Process, and Tips

Updated 16 Apr 2024

Physicswallah MIS Business Analyst Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(7 Questions)

  • Q1. Tell me about yourself.
  • Q2. Basics of SQL and intermediate knowledge of SQL
  • Q3. What is Row level security?
  • Ans. 

    Row level security is a feature that restricts access to specific rows in a database based on the user's permissions.

    • Row level security limits access to certain rows of data based on the user's role or permissions.

    • It helps organizations ensure that sensitive data is only accessible to authorized users.

    • For example, a healthcare organization may use row level security to restrict access to patient medical records based o...

  • Answered by AI
  • Q4. How will you share the power BI reports
  • Ans. 

    I will share Power BI reports through email, shared folders, and scheduled data refreshes.

    • Share reports via email with stakeholders

    • Store reports in shared folders for easy access

    • Schedule data refreshes to ensure reports are up-to-date

  • Answered by AI
  • Q5. Difference between calculated colums & calculated measures ?
  • Ans. 

    Calculated columns are calculated at the row level, while calculated measures are aggregated over a set of rows.

    • Calculated columns are created at the individual row level in a table, using DAX formulas in Power BI or Excel.

    • Calculated measures are created at the aggregate level, such as sum or average, and are used in measures like totals or averages in a pivot table.

    • Calculated columns are stored in the data model, whil...

  • Answered by AI
  • Q6. How will you read files in Python ?
  • Ans. 

    Files in Python can be read using the open() function to open the file and read() function to read the contents.

    • Use the open() function to open a file in read mode: file = open('filename.txt', 'r')

    • Use the read() function to read the contents of the file: content = file.read()

    • Close the file after reading: file.close()

  • Answered by AI
  • Q7. What is standard deviations?
  • Ans. 

    Standard deviation is a measure of the amount of variation or dispersion of a set of values.

    • Standard deviation is calculated as the square root of the variance.

    • It indicates how spread out the values in a data set are around the mean.

    • A higher standard deviation means more variability in the data.

    • A lower standard deviation means values are closer to the mean.

    • For example, in a data set of test scores, a high standard devi...

  • Answered by AI
Round 2 - One-on-one 

(5 Questions)

  • Q1. What do you know about Excel and what are the best features of excel.
  • Ans. 

    Excel is a powerful spreadsheet software used for data analysis, reporting, and visualization.

    • Excel allows users to organize data in rows and columns, perform calculations, and create charts and graphs.

    • Features like pivot tables, conditional formatting, and data validation make it easier to analyze and present data.

    • Excel also supports automation through macros and functions like VLOOKUP and SUMIF.

    • It is widely used in b...

  • Answered by AI
  • Q2. What are window function.
  • Ans. 

    Window functions are a type of function in SQL that perform calculations across a set of table rows that are related to the current row.

    • Window functions are used to perform calculations on a specific subset of rows related to the current row.

    • They allow you to perform calculations without grouping the rows into a single output row.

    • Examples of window functions include ROW_NUMBER(), RANK(), and NTILE().

  • Answered by AI
  • Q3. What is CTE query
  • Ans. 

    CTE query stands for Common Table Expression query, used in SQL to create temporary result sets.

    • CTE query is used to simplify complex SQL queries by breaking them into smaller, more manageable parts.

    • It allows for recursive queries, which can be useful for tasks like hierarchical data retrieval.

    • CTE queries are defined using the WITH keyword followed by the query name and definition.

    • They can be referenced multiple times ...

  • Answered by AI
  • Q4. How will you join two tables. And asked practical questions in which joining the two tables and also returning the value as running total of fees paid by students.
  • Q5. One table has 5 other have 7 columns How many column will be there in Left Join, Inner join and union
  • Ans. 

    Left Join will have 12 columns, Inner Join will have 7 columns, Union will have 7 columns.

    • Left Join combines all columns from both tables, resulting in 12 columns.

    • Inner Join only includes columns that are common between the tables, resulting in 7 columns.

    • Union combines the results of two or more SELECT statements, keeping the same number of columns as the original tables (7 columns).

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident
Prepare practical questions related to SQL

Skills evaluated in this interview

Interview questions from similar companies

I applied via Walk-in and was interviewed before Jun 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How will you pursue parents of the child to buy our tablets?
  • Ans. 

    I will highlight the benefits of our tablets for children's education and offer discounts or promotions to attract parents.

    • Emphasize the educational benefits of our tablets

    • Offer discounts or promotions to attract parents

    • Provide testimonials from satisfied parents

    • Partner with schools or educational institutions to promote our tablets

    • Create engaging and informative marketing materials targeted towards parents

    • Offer a tria...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be smart and answer aggressively

I applied via Campus Placement and was interviewed before Dec 2020. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. SQL questions
  • Q2. Guestimates around sizing
  • Ans. 

    Guestimates around sizing

    • Guestimates are rough estimates based on limited information

    • They are useful in situations where precise data is not available

    • Factors such as historical data, industry benchmarks, and expert opinions can be used to make guestimates

    • Guestimates should be clearly communicated as rough estimates and not taken as exact figures

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and curious

I applied via Company Website and was interviewed before Mar 2020. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Write a program on bubble sort ?
  • Ans. 

    Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements and swaps them if they are in the wrong order.

    • Start from the first element and compare it with the next element

    • If the first element is greater than the next element, swap them

    • Repeat this process for all elements in the list

    • Continue this process until no more swaps are needed

  • Answered by AI
  • Q2. Define Turing Machine ?
  • Ans. 

    A Turing Machine is a theoretical device that can simulate any algorithmic computation.

    • It was proposed by Alan Turing in 1936 as a model for computation.

    • It consists of a tape, a head that can read and write symbols on the tape, and a set of rules for transitioning between states.

    • It can simulate any algorithmic computation, making it a powerful tool for theoretical computer science.

    • It is often used as a theoretical basi...

  • Answered by AI
  • Q3. Explain hash function
  • Ans. 

    A hash function is a mathematical function that converts input data of arbitrary size into a fixed-size output.

    • Hash functions are used to index data in hash tables.

    • They are also used in cryptography to securely store passwords.

    • Examples of hash functions include MD5, SHA-1, and SHA-256.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was lengthy process some questions were difficult to answer and i tried to amswer a few questions but i didnt clear interview process

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Will u be able to manage job stress

Interview Preparation Tips

Interview preparation tips for other job seekers - It was an average interview process nothing much difficult

I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Previous Experience, Some SQL Questions, Business Acumen.

Interview Preparation Tips

Interview preparation tips for other job seekers - Was tested mostly on SQL. A little bit of business knowledge and framework of thoughts and approach to solving a problem.

Business Analyst Interview Questions & Answers

NxtWave user image Hemanth Peddinti

posted on 31 Jul 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Assignment 

Market Research, Analysis

Round 2 - One-on-one 

(1 Question)

  • Q1. Basic questions

Interview Questionnaire 

1 Question

  • Q1. How do you measure growth of startup
  • Ans. 

    Startup growth can be measured through various metrics such as revenue, user acquisition, market share, and customer satisfaction.

    • Revenue growth is a key metric for measuring startup growth. This can be tracked through sales figures, profit margins, and overall revenue growth rate.

    • User acquisition is another important metric. This can be measured through the number of new users acquired over a period of time, as well a...

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL round consisting of joins, window functions
Round 2 - One-on-one 

(1 Question)

  • Q1. Managerial round mostly HR questions
Round 3 - Panel interview 

(1 Question)

  • Q1. Previous work exp, projects, mix of HR questions as well.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Apr 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Previous orgranization contributions
  • Ans. 

    Contributed to previous organization's growth by improving processes and implementing new technologies.

    • Developed and implemented a new project management system resulting in a 20% increase in efficiency

    • Streamlined the hiring process by introducing an applicant tracking system, reducing time-to-hire by 30%

    • Led a cross-functional team to identify and resolve bottlenecks in the supply chain, resulting in a 15% reduction in...

  • Answered by AI
  • Q2. Case scenario on growing revenue based on certain parameters.

Interview Preparation Tips

Interview preparation tips for other job seekers - Have ed-tech knowledge and practice case scenarios based on revenue and reachability growth.

Physicswallah Interview FAQs

How many rounds are there in Physicswallah MIS Business Analyst interview?
Physicswallah interview process usually has 2 rounds. The most common rounds in the Physicswallah interview process are One-on-one Round.
What are the top questions asked in Physicswallah MIS Business Analyst interview?

Some of the top questions asked at the Physicswallah MIS Business Analyst interview -

  1. What do you know about Excel and what are the best features of exc...read more
  2. One table has 5 other have 7 columns How many column will be there in Left Join...read more
  3. Difference between calculated colums & calculated measure...read more

Tell us how to improve this page.

Physicswallah MIS Business Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

BYJU'S Interview Questions
3.1
 • 2.1k Interviews
Planet Spark Interview Questions
3.7
 • 372 Interviews
Whitehat jr Interview Questions
3.4
 • 262 Interviews
Unacademy Interview Questions
3.0
 • 209 Interviews
upGrad Interview Questions
3.6
 • 201 Interviews
NxtWave Interview Questions
3.8
 • 188 Interviews
Vedantu Interview Questions
3.3
 • 184 Interviews
Chegg Interview Questions
4.1
 • 158 Interviews
View all

Physicswallah MIS Business Analyst Reviews and Ratings

based on 1 review

2.0/5

Rating in categories

3.0

Skill development

1.0

Work-life balance

2.0

Salary

2.0

Job security

2.0

Company culture

2.0

Promotions

2.0

Work satisfaction

Explore 1 Review and Rating
Senior Associate
353 salaries
unlock blur

₹2.5 L/yr - ₹6.7 L/yr

Associate Manager
237 salaries
unlock blur

₹3.2 L/yr - ₹10 L/yr

Associate
234 salaries
unlock blur

₹2 L/yr - ₹5.4 L/yr

Professor
149 salaries
unlock blur

₹7 L/yr - ₹27.6 L/yr

Business Analyst
131 salaries
unlock blur

₹3 L/yr - ₹11 L/yr

Explore more salaries
Compare Physicswallah with

BYJU'S

3.1
Compare

Whitehat jr

3.4
Compare

Unacademy

3.0
Compare

Extramarks Education

3.4
Compare
Did you find this page helpful?
Yes No
write
Share an Interview