Data Analytics

10+ Data Analytics Interview Questions and Answers

Updated 6 Apr 2024

Q1. Ways To Make Coin Change

Given an infinite supply of coins of varying denominations, determine the total number of ways to make change for a specified value using these coins. If it's not possible to make the c...read more

Frequently asked in

Standard Chartered

Goldman Sachs

Q2. Pair Sum Problem Statement

You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.

Note:

Each pa...read more

Data Analytics Interview Questions and Answers for Freshers

View all interview questions

Q3. Lexicographically Smallest Array Problem Statement

You are given an array ARR of 'N' integers and a positive integer 'K'.

Your task is to determine the lexicographically smallest array that can be obtained by p...read more

Q4. Longest Common Prefix Problem Statement

You are given an array ‘ARR’ consisting of ‘N’ strings. Your task is to find the longest common prefix among all these strings. If there is no common prefix, you have to ...read more

Are these interview questions helpful?

Q5. Rotting Oranges Problem Statement

You are given a grid containing oranges where each cell of the grid can contain one of the three integer values:

0 - representing an empty cell
1 - representing a fresh orange...read more

Q6. K-th Largest Number in a BST

Given a binary search tree (BST) consisting of integers and containing 'N' nodes, your task is to find and return the K-th largest element in this BST.

If there is no K-th largest e...read more

Share interview questions and help millions of jobseekers 🌟

Q7. Evaluate Division Problem Statement

Given an array of pairs of strings equations representing a fraction and an array of real numbers values. Each element in equations denotes a fraction with the first string a...read more

Q8. Peak Element Finder

For a given array of integers arr, identify the peak element. A peak element is an element that is greater than its neighboring elements. Specifically, if arr[i] is the peak, then both arr[i...read more

Data Analytics Jobs

American Express - Analyst/Product Owner - Data Analytics (1-7 yrs) • 1-7 years

American Express

•

4.2

Data analytics(Data Science & Data Analysis) • 5-9 years

Pepsico

•

4.1

Hyderabad / Secunderabad

Team Member - Data Analytics • 2-5 years

Aditya Birla Money

•

4.2

Mumbai

View all Data Analytics jobs

Q9. what is data visualisation

Ans.

Data visualisation is the graphical representation of data to help users understand trends, patterns, and insights.

Data visualisation uses charts, graphs, and maps to present data in a visually appealing way.
It helps in identifying correlations, outliers, and patterns in data.
Examples include bar charts, pie charts, scatter plots, and heat maps.
Interactive data visualisations allow users to explore data dynamically.

Q10. what is DBMS and RDBMS

Ans.

DBMS stands for Database Management System, while RDBMS stands for Relational Database Management System.

DBMS is a software system that allows users to define, create, maintain and control access to the database.
RDBMS is a type of DBMS that stores data in a structured format using tables with rows and columns.
Examples of DBMS include MySQL, Oracle Database, and Microsoft SQL Server.
Examples of RDBMS include MySQL, PostgreSQL, and Oracle Database.

Q11. what is PowerBI

Ans.

PowerBI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.

Developed by Microsoft
Allows users to create interactive visualizations and reports
Offers business intelligence capabilities
Can connect to various data sources such as Excel, SQL databases, and cloud services

Interview Tips & Stories

Ace your next interview with expert advice and inspiring stories

Explore community