i
Impact Analytics
Filter interviews by
Resultant rows for different SQL joins
Inner join - returns rows that have matching values in both tables
Left join - returns all rows from the left table and the matched rows from the right table
Right join - returns all rows from the right table and the matched rows from the left table
Full outer join - returns all rows when there is a match in either left or right table
I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.
The test covered questions around stats (mean, median, etc), python, SQL and aptitude questions
Q1. Write a python code for the Fibonacci series.
Q2. Write a SQL code find the mean salary for every department.
Q3. Write a SQL code to find the employee age at the time of joining the company.
Q4. Rewrite the above queries in Python.
loc and iloc are methods in pandas used for selecting rows and columns by label or integer position.
loc is used for selecting rows and columns by label
iloc is used for selecting rows and columns by integer position
Example: df.loc[0:5, 'column_name']
Example: df.iloc[0:5, 2]
Vlookup is simpler and easier to use, while Index Match is more flexible and efficient.
Vlookup is easier for beginners to understand and use
Vlookup is quicker to set up and requires less formula writing
Index Match is more flexible as it can look up values in any column, not just the first one
Index Match is more efficient for large datasets as it does not require the entire column to be searched
BRD focuses on business requirements while FRD focuses on functional requirements.
BRD (Business Requirements Document) outlines the business problem that needs to be solved.
FRD (Functional Requirements Document) details how the system will meet the business requirements.
BRD is more high-level and focuses on the 'what', while FRD is more detailed and focuses on the 'how'.
BRD is typically created before FRD in the projec...
Retail experience and analysis
I have over 5 years of experience in retail industry analysis
Proficient in using data analytics tools to track sales trends and customer behavior
Implemented strategies based on market research to increase sales and customer satisfaction
Collaborated with cross-functional teams to optimize inventory management and pricing strategies
Top trending discussions
posted on 10 May 2020
I applied via Recruitment Consultant and was interviewed in Apr 2020. There were 4 interview rounds.
I am a detail-oriented business analyst with experience in data analysis and process improvement.
I have a Bachelor's degree in Business Administration
I have worked with various stakeholders to identify business needs and requirements
I am proficient in SQL and Excel for data analysis
I have experience in process improvement and project management
I am a strong communicator and collaborator
I have completed a business analyst certification course and have interned at a software development company.
Completed a business analyst certification course from XYZ Institute
Interned at ABC Software Development Company for 6 months
Worked on requirement gathering, documentation and analysis for a project
Assisted senior business analysts in creating project plans and reports
The Instrumentation Department is responsible for designing, installing, and maintaining control systems and instruments used in industrial processes.
Designing and implementing control systems for industrial processes
Installing and maintaining instruments used in industrial processes
Ensuring accuracy and reliability of instruments and control systems
Collaborating with other departments to optimize processes and improve...
I am excited to join Affine Analytics because of their reputation for delivering innovative solutions and their focus on employee growth.
Affine Analytics has a strong track record of delivering cutting-edge solutions to clients across industries.
I am impressed by the company's commitment to employee growth and development, as evidenced by their training and mentorship programs.
I am excited about the opportunity to work...
Data analytics allows me to use my technical skills to solve business problems and make data-driven decisions.
Data analytics helps me to identify patterns and trends in data that can be used to improve business processes.
It allows me to work with large datasets and use statistical methods to extract insights.
I can use my technical skills to develop and implement data models and algorithms.
Data analytics is a growing fi...
No, two diodes in series cannot work as a transistor.
Transistors have three terminals while diodes have two.
Transistors can amplify signals while diodes cannot.
Transistors can be used as switches while diodes cannot.
Diodes in series will only increase the voltage drop.
Transistors have different modes of operation such as common emitter, common base, and common collector.
I developed a drone that can detect and monitor forest fires.
Designed and built a drone with thermal imaging camera
Integrated machine learning algorithm to detect fire
Tested and validated the drone in a controlled forest environment
Presented the project at a national engineering conference
I play badminton twice a week as a hobby.
I enjoy playing badminton as a way to stay active and relieve stress.
I usually play with friends or family members at a local community center.
I have been playing badminton for several years and have improved my skills over time.
No, I don't have any problem working in Bangalore.
I am familiar with the city and its culture
I have worked in Bangalore before and enjoyed my experience
I am open to new experiences and challenges
I am willing to adapt to the local environment and work culture
Real Madrid is my favorite because of their rich history, success, and style of play.
Real Madrid has won a record 13 Champions League titles, which is a testament to their success
Their style of play is attractive and entertaining to watch
The club has a rich history and has had some of the greatest players in football history, such as Cristiano Ronaldo and Zinedine Zidane
Factors to consider before going App only as CEO of Flipkart
Analyze the data from website and app to understand user behavior
Evaluate the impact on sales and revenue
Consider the potential loss of customers who prefer website over app
Assess the cost of developing and maintaining the app
Evaluate the competition and their strategies
Consider the impact on brand image and customer loyalty
Assess the feasibility of providing ...
posted on 6 Aug 2021
posted on 30 Jan 2021
I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 3 interview rounds.
API testing methods involve functional, performance, security, and exploratory testing.
Functional testing ensures that the API meets the requirements and specifications.
Performance testing checks the API's response time, throughput, and resource utilization.
Security testing verifies the API's authentication, authorization, and encryption mechanisms.
Exploratory testing involves ad-hoc testing to discover defects and usa...
Sanity and Smoke are types of software testing. Sanity tests a specific functionality while Smoke tests the entire system.
Sanity testing is a narrow and deep testing approach while Smoke testing is a broad and shallow testing approach.
Sanity testing is performed after a small change in code while Smoke testing is performed after a major change in code.
Sanity testing is used to check if the critical functionalities are ...
Retesting is testing the same functionality again after fixing the defects. Regression is testing the unchanged functionality after making changes.
Retesting is done to ensure that the defects have been fixed and the functionality is working as expected.
Regression is done to ensure that the changes made to the software have not affected the existing functionality.
Retesting is a subset of regression testing.
Retesting is ...
I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.
The first round was a combination of MCQs and SQL Coding test. It consisted of 23 MCQs on SQL, 10 MCQs on Power BI and 5 SQL Coding questions.
A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.
Pivot tables allow you to analyze and summarize large amounts of data in a spreadsheet.
You can easily rearrange the layout of the data to view it from different perspectives.
Pivot tables can perform functions like sum, average, count, and more on the data.
They are useful for creating reports...
Data Validation in Excel ensures that data entered in a cell meets certain criteria or conditions.
Data Validation allows you to set rules for what can be entered in a cell, such as a range of values, a list of items, or a custom formula.
Examples of Data Validation include setting a drop-down list of options for a cell, restricting input to a certain number range, or ensuring dates are entered in a specific format.
Data ...
The order of execution of an SQL query involves multiple steps to retrieve data from a database.
1. Parsing: The SQL query is first parsed to check for syntax errors.
2. Optimization: The query optimizer creates an execution plan to determine the most efficient way to retrieve data.
3. Compilation: The optimized query is compiled into an executable form.
4. Execution: The compiled query is executed by the database engine t...
Tree Map visualizes hierarchical data using nested rectangles, while Heatmap displays data values using color gradients.
Tree Map displays data hierarchically with nested rectangles, where the size and color represent different measures.
Heatmap visualizes data values using color gradients, with darker colors indicating higher values.
Tree Map is useful for showing hierarchical data structures, while Heatmap is effective ...
Extract Data saves a snapshot of data in Tableau workbook, while Live Connection directly connects to data source.
Extract Data creates a static copy of data in Tableau workbook, while Live Connection directly queries data source in real-time.
Extract Data is useful for working offline or with small datasets, while Live Connection is ideal for large datasets or when data is frequently updated.
Extract Data can improve per...
based on 3 interviews
Interview experience
based on 6 reviews
Rating in categories
Senior Software Engineer
77
salaries
| ₹12 L/yr - ₹39 L/yr |
Senior Data Scientist
74
salaries
| ₹10 L/yr - ₹26.5 L/yr |
Data Scientist
66
salaries
| ₹6.5 L/yr - ₹23 L/yr |
Senior Business Analyst
54
salaries
| ₹10.7 L/yr - ₹28 L/yr |
Software Engineer
52
salaries
| ₹6 L/yr - ₹24.8 L/yr |
Maxgen Technologies
Value Point Systems
JoulestoWatts Business Solutions
F1 Info Solutions and Services