Data Analytics

10+ Data Analytics Interview Questions and Answers

Updated 6 Apr 2024

Popular Companies

search-icon
Q1. Ways To Make Coin Change

You are given an infinite supply of coins of each of denominations D = {D0, D1, D2, D3, ...... Dn-1}. You need to figure out the total number of ways W, in which you can make a change fo...read more

Frequently asked in,
Q2. Pair Sum

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

Note:

Each pair shou...read more

Data Analytics Interview Questions and Answers for Freshers

illustration image
Q3. Lexicographically Smallest Array

You have been given an array/list ARR consisting of ‘N’ integers. You are also given a positive integer ‘K’.

Your task is to find the lexicographically smallest ARR that can be o...read more

Q4. Longest Common Prefix

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 return an empty str...read more

Are these interview questions helpful?
Q5. Rotting Oranges

You have been given a grid containing some oranges. Each cell of this grid has one of the three integers values:

  • Value 0 - representing an empty cell.
  • Value 1 - representing a fresh orange.
  • ...read more
  • Q6. K-th largest Number BST

    You are given a binary search tree of integers with 'N' nodes. Your task is to return the K-th largest element of this BST.

    If there is no K-th largest element in the BST, return -1.

    A bi...read more

    Share interview questions and help millions of jobseekers 🌟

    man-with-laptop
    Q7. Evaluate Division

    You are given an array of pairs of strings 'EQUATIONS', and an array of real numbers 'VALUES'. Each element of the 'EQUATIONS' array denotes a fraction where the first string denotes the numera...read more

    Q8. Find Peak Element

    Given an array of ‘n’ integers arr. Find the Peak element of the array. The peak element of an array is defined as that element which is greater than both of its neighbours. I.e if arr[i] is th...read more

    Data Analytics Jobs

    Manager - Information Management - Data Analytics Office 3-9 years
    HSBC electronic data processing india pvt ltd
    4.0
    Hyderabad / Secunderabad
    Data Analytics (SQL, Snowflake, Alteryx, AWS) - Associate 7-9 years
    JPMorgan Chase
    4.1
    Hyderabad / Secunderabad
    Managed Services -DPSData AnalyticsSenior Manager-Consult 14-15 years
    Pricewaterhouse Coopers Private Limited
    3.4
    Bangalore / Bengaluru

    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

    Interview experiences of popular companies

    3.1
     • 2.1k Interviews
    3.4
     • 1.3k Interviews
    3.7
     • 791 Interviews
    4.0
     • 603 Interviews
    4.0
     • 469 Interviews
    4.0
     • 308 Interviews
    3.1
     • 66 Interviews
    4.0
     • 45 Interviews
    3.7
     • 3 Interviews
    View all

    Calculate your in-hand salary

    Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary

    Data Analytics Interview Questions
    Share an Interview
    Stay ahead in your career. Get AmbitionBox app
    qr-code
    Helping over 1 Crore job seekers every month in choosing their right fit company
    65 L+

    Reviews

    4 L+

    Interviews

    4 Cr+

    Salaries

    1 Cr+

    Users/Month

    Contribute to help millions
    Get AmbitionBox app

    Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

    Follow us
    • Youtube
    • Instagram
    • LinkedIn
    • Facebook
    • Twitter