100+ Data Analyst Intern Interview Questions and Answers

The Water Jug Problem involves determining if a target measurement can be achieved using two jugs of different capacities and specific operations.

• Start by filling one jug and transferring water between the jugs to reach the target measurement.

• Consider all possible combinations of filling, emptying, and transferring water between the jugs.

• Keep track of the states of both jugs and the amount of water in each jug during the operations.

• If the target measurement is reached, return...read more

Implement insertion sort on a singly linked list to sort the elements in-place.

• Iterate through the linked list and for each node, find its correct position in the sorted part of the list

• Adjust pointers to insert the node in the correct position

• Repeat this process until all nodes are sorted

loc is label-based indexing while iloc is integer-based indexing in data science. Dashboards are visual tools for data analysis.

• loc is used for selecting rows and columns by labels

• iloc is used for selecting rows and columns by integer position

• Dashboards are visual representations of data for easy analysis and decision-making

Different types of keys in a database include primary key, foreign key, unique key, and composite key.

• Primary key: uniquely identifies each record in a table, must be unique and not null.

• Foreign key: establishes a link between two tables, ensures referential integrity.

• Unique key: ensures that all values in a column are unique.

• Composite key: combination of two or more columns to uniquely identify a record.

Pick a fruit from the jar labeled Apples and Oranges, then pick a fruit from the jar labeled Oranges (since it can't be Oranges), and finally pick a fruit from the jar labeled Apples (since it can't be Apples).

• Pick a fruit from the jar labeled Apples and Oranges

• Since the jar labeled Oranges can't be Oranges, it must be Apples and Oranges

• The remaining jar must be Apples

Data modeling is the process of creating a visual representation of data structures and relationships.

• Data modeling involves defining the structure of data, its storage, and how it will be accessed and manipulated.

• Types of data models include conceptual, logical, and physical models.

• Conceptual models focus on high-level business concepts and relationships.

• Logical models define the structure of the data without considering how it will be implemented in a database system.

• Physic...read more

Python code to check if a sentence is palindrome or not

• Remove all spaces and convert to lowercase

• Reverse the string and compare with original

• If both are same, then it is a palindrome

Query to find department wise highest salary in an organisation

• Use GROUP BY clause to group data by department

• Use MAX() function to find highest salary in each department

• Join the tables if necessary to get department information

RDBMS is a relational database management system. Objects in a database include tables, views, indexes, functions, stored procedures, constraints, and foreign keys. OLAP is for data analysis while OLTP is for transaction processing.

• RDBMS stands for Relational Database Management System

• Objects in a database include tables, views, indexes, functions, stored procedures, constraints, and foreign keys

• OLAP (Online Analytical Processing) is used for data analysis and reporting

• OLTP (...read more

Separate lines in standard output in C++ are used to display different pieces of information on separate lines for better readability.

• Separate lines are used to display different outputs or messages in a clear and organized manner.

• They are commonly used with the 'endl' or ' ' characters to move to the next line.

• For example, cout << 'Hello' << endl; will display 'Hello' on one line and move to the next line for the next output.

I start by defining the problem, collecting relevant data, cleaning and organizing the data, performing analysis using statistical methods and tools, and finally interpreting and presenting the results.

• Define the problem statement and objectives of the analysis

• Collect relevant data from various sources

• Clean and organize the data to ensure accuracy and consistency

• Perform analysis using statistical methods and tools such as Excel, Python, or R

• Interpret the results and present f...read more

List of SQL languages and their brief explanation

• SQL (Structured Query Language) is a standard language for managing relational databases

• T-SQL (Transact-SQL) is a proprietary extension of SQL used by Microsoft SQL Server

• PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's proprietary extension of SQL

• MySQL is an open-source relational database management system that uses SQL

• PostgreSQL is an open-source object-relational database management system that...read more

Super key is a set of attributes that uniquely identifies a record, while foreign key is a reference to a primary key in another table.

• Super key is a combination of one or more attributes that uniquely identifies a record in a table.

• Foreign key is a field in a table that refers to the primary key of another table.

• Super key can have additional attributes that are not necessary for uniqueness.

• Foreign key establishes a relationship between two tables.

• Example: In a database of st...read more

4-stroke engines have 4 strokes per cycle, while 2-stroke engines have 2 strokes per cycle.

• 4-stroke engines are more fuel-efficient and produce less pollution than 2-stroke engines.

• 2-stroke engines are simpler and lighter than 4-stroke engines.

• 4-stroke engines have separate intake, compression, power, and exhaust strokes, while 2-stroke engines combine intake and compression, and power and exhaust strokes.

• Examples of 4-stroke engines include those found in cars, while example...read more

A double linked list is a data structure where each node contains a reference to the previous and next node.

• In a linked list, each node contains a reference to the next node only, while in a double linked list, each node contains references to both the previous and next nodes.

• Double linked lists allow for traversal in both directions, making operations like deletion and insertion easier compared to single linked lists.

• Example: In a double linked list, a node might have pointe...read more

Outliers in a boxplot are defined as data points that fall below Q1 - 1.5*IQR or above Q3 + 1.5*IQR.

• Calculate the interquartile range (IQR) by subtracting Q1 from Q3.

• Identify the lower bound as Q1 - 1.5*IQR and the upper bound as Q3 + 1.5*IQR.

• Any data points below the lower bound or above the upper bound are considered outliers.

• For example, if Q1 = 10, Q3 = 20, and IQR = 5, then the lower bound = 10 - 1.5*5 = 2.5 and the upper bound = 20 + 1.5*5 = 27.5.

Joins are used to combine rows from two or more tables based on a related column between them.

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match 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 JOIN returns rows when there is a match in one of the tabl...read more

Power BI is a business analytics tool used to visualize and analyze data. Power Query is a data transformation and shaping tool in Power BI.

• Power BI is a powerful business intelligence tool developed by Microsoft.

• It allows users to connect to various data sources, transform and clean the data, and create interactive visualizations and reports.

• Power BI enables data analysts to gain insights and make data-driven decisions.

• Power Query is a data transformation and shaping tool wi...read more

Memory management and hash map are important concepts in Java programming.

• Memory management is the process of allocating and deallocating memory in a program.

• Java uses automatic memory management through garbage collection.

• Hash map is a data structure that stores key-value pairs and uses hashing to retrieve values efficiently.

• Java's HashMap class implements the Map interface and provides constant-time performance for basic operations.

• It is important to properly manage memory ...read more

SQL joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.

• SQL joins are used to retrieve data from multiple tables based on a related column between them (e.g. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN).

• Window functions are used to perform calculations on a set of rows related to the current row (e.g. ROW_NUMBER(), RANK(), LAG(), LEA...read more

The dataset consists of customer purchase history and demographic information. Difficulties faced include data cleaning and missing values.

• Dataset includes customer ID, purchase amount, purchase date, age, gender, and location.

• Difficulties faced include handling missing values in the age and location columns.

• Data cleaning involved removing duplicates and outliers to ensure accurate analysis.

• Normalization and standardization of data for model preparation.

Use SQL query with WHERE clause to pull data from a table based on a time interval.

• Use SQL query with SELECT statement to specify the columns you want to retrieve.

• Add a WHERE clause with the condition for the time interval, using appropriate date/time functions.

• Example: SELECT * FROM table_name WHERE timestamp_column BETWEEN 'start_time' AND 'end_time';

To maximize sales on a state level, focus on market research, targeted marketing strategies, strong customer service, and strategic partnerships.

• Conduct market research to understand the local consumer behavior and preferences

• Implement targeted marketing strategies based on the research findings

• Provide excellent customer service to build loyalty and attract repeat business

• Form strategic partnerships with local businesses or organizations to expand reach and customer base

Primary key uniquely identifies a record while candidate key can also uniquely identify a record but may not be chosen as primary key.

• Primary key is a column or set of columns that uniquely identifies each record in a table

• Candidate key is a column or set of columns that can also uniquely identify each record in a table

• A table can have multiple candidate keys but only one primary key

• Primary key cannot have null values while candidate key can have null values

• Example: In a tabl...read more

Approximately 500 paper cups may be used in a day in an average office.

• Consider the number of employees in the office

• Think about the average number of hot beverage drinkers

• Factor in the number of meetings and events held in the office

• Take into account the availability of reusable cups

• Estimate based on personal experience or observation

Calculated columns are static values calculated at the row level, while measures are dynamic values calculated at the aggregated level.

• Calculated columns are computed for each row in a table, while measures are computed for the entire dataset or a subset of data.

• Calculated columns are stored in the data model, while measures are calculated on the fly based on user interactions.

• Examples of calculated columns include age calculated from birthdate, while examples of measures inc...read more

A numeric value can be treated as a text value in Microsoft Excel if it precedes with an apostrophe.

• Precede the numeric value with an apostrophe (') to treat it as text.

• For example, entering '123 in a cell will display as text '123 instead of the numeric value 123.

• This is useful when you want to display leading zeros in a number without Excel automatically removing them.

I use tools like Python, SQL, Tableau for data analysis and visualization.

• Python for data cleaning and analysis

• SQL for querying databases

• Tableau for creating interactive visualizations

I have worked on projects involving customer segmentation, sales forecasting, and sentiment analysis using analytics.

• Customer segmentation: Used clustering algorithms to group customers based on their behavior and demographics.

• Sales forecasting: Utilized time series analysis to predict future sales trends and optimize inventory management.

• Sentiment analysis: Applied natural language processing techniques to analyze customer feedback and sentiment towards products or services.

The latest project consumed approximately 500 MB of data.

• The latest project consumed 500 MB of data.

• It is important to track data consumption for future optimization.

• Weaknesses can include lack of experience with certain tools or techniques.

• Weaknesses can also include difficulty in time management or communication.

Delete removes specific rows from a table, drop removes entire table structure, and truncate removes all rows from a table.

• Delete is a DML command, drop is a DDL command, and truncate is a DDL command.

• Delete can be rolled back, drop cannot be rolled back, and truncate cannot be rolled back.

• Delete triggers delete triggers, drop triggers drop triggers, and truncate does not trigger any triggers.

• Example: DELETE FROM table_name WHERE condition;

• Example: DROP TABLE table_name;

• Examp...read more

Tableau offers various types of graphs like bar charts, line charts, scatter plots, etc. for visualizing data.

• Bar charts: used to compare different categories or show trends over time

• Line charts: show trends over time or relationships between variables

• Scatter plots: show relationships between two numerical variables

• Pie charts: show parts of a whole or percentages

• Heat maps: show data density or relationships in a matrix format

Data science plays vital roles in contemporary world by enabling businesses to make data-driven decisions, improving healthcare outcomes, enhancing customer experiences, and driving innovation.

• Data science helps businesses make informed decisions by analyzing large datasets to identify trends and patterns.

• In healthcare, data science is used to predict disease outbreaks, personalize treatment plans, and improve patient outcomes.

• Data science is crucial for enhancing customer ex...read more

List of SQL languages

• MySQL

• Oracle

• PostgreSQL

• Microsoft SQL Server

• SQLite

Exception handling in Java allows for the handling of errors and exceptions that may occur during program execution.

• Java provides try-catch blocks to handle exceptions.

• The try block contains the code that may throw an exception.

• The catch block catches and handles the thrown exception.

• Multiple catch blocks can be used to handle different types of exceptions.

• The finally block is optional and is executed regardless of whether an exception occurs or not.

• Exceptions can also be thr...read more

Memory management in Java involves automatic garbage collection and manual memory allocation.

• Java uses automatic garbage collection to free up memory

• Developers can manually allocate memory using the 'new' keyword

• Java also has a 'finalize' method to clean up resources before garbage collection

• Memory leaks can occur if objects are not properly released

Company is a tech startup specializing in data analytics. Work culture is collaborative and innovative.

• Company specializes in data analytics for various industries such as e-commerce and healthcare

• Work culture is collaborative, with team members encouraged to share ideas and work together on projects

• Innovative approach to problem-solving, with emphasis on using cutting-edge technology and tools

• Regular team building activities and opportunities for professional development

Data analysis focuses on analyzing data to extract insights, while data science involves a broader range of skills including machine learning and programming.

• Data analysis involves analyzing data to extract insights and make informed decisions.

• Data science involves a broader range of skills including machine learning, programming, and statistical modeling.

• Data analysis is more focused on descriptive and diagnostic analytics, while data science also includes predictive and pre...read more

OOPs stands for Object-Oriented Programming. It is a programming paradigm based on the concept of objects, which can contain data and code.

• OOPs is a programming paradigm that uses objects to structure code.

• It focuses on data encapsulation, inheritance, polymorphism, and abstraction.

• Examples of OOP languages include Java, C++, and Python.

Convert Json Data to Pandas Dataframe

• Use the pandas library to import the json data

• Use the pandas.DataFrame() function to convert the json data into a dataframe

• Specify the required columns in the dataframe

Logistic regression model evaluation involves assessing its performance using metrics like accuracy, precision, recall, and F1 score.

• Evaluate model performance using metrics like accuracy, precision, recall, and F1 score.

• Use confusion matrix to calculate true positives, true negatives, false positives, and false negatives.

• Calculate accuracy as (TP + TN) / (TP + TN + FP + FN).

• Calculate precision as TP / (TP + FP).

• Calculate recall as TP / (TP + FN).

• Calculate F1 score as 2 * (pr...read more

A bevel gear is a type of gear used to transmit power between shafts at an angle.

• Bevel gears have conical shapes and are used to change the direction of rotation.

• They are commonly used in automobiles, airplanes, and power plants.

• An example of a bevel gear is the ring and pinion gear in a car's differential.

• Another example is the bevel gear used in a hand drill to transmit power from the motor to the chuck.

Exceptional handling in Java is a mechanism to handle runtime errors and prevent program crashes.

• Java provides try-catch blocks to handle exceptions

• Multiple catch blocks can be used to handle different types of exceptions

• Finally block is used to execute code regardless of whether an exception is thrown or not

Oops concepts are fundamental to Java programming and include inheritance, polymorphism, encapsulation, and abstraction.

• Inheritance allows a class to inherit properties and methods from a parent class.

• Polymorphism allows objects to take on multiple forms and behave differently based on their context.

• Encapsulation hides the implementation details of a class and only exposes necessary information.

• Abstraction focuses on the essential features of an object and hides unnecessary d...read more

The question involves calculating the probability of picking a specific colored ball from a set of balls.

• Calculate the total number of balls in the set

• Determine the number of balls of the specific color in the set

• Divide the number of specific colored balls by the total number of balls to get the probability

A data analyst is a professional who collects, processes, and analyzes data to provide insights and support decision-making.

• Collects data from various sources

• Cleans and processes data to ensure accuracy

• Analyzes data using statistical techniques and tools

• Interprets data to identify trends and patterns

• Creates visualizations and reports to communicate findings

Use a balance scale to compare groups of balls to find the heavier one.

• Divide the 9 balls into 3 groups of 3 balls each.

• Weigh 2 of the groups against each other. If one group is heavier, move to the next step.

• If both groups weigh the same, the heavier ball is in the remaining group of 3 balls.

• Take the heavier group of 3 balls and weigh 2 of them against each other.

• If one ball is heavier, that is the answer. If they weigh the same, the remaining ball is the heavier one.