10+ GD Goenka Public School Interview Questions and Answers

Yes, we can add extra row and pivot table in excel.

• To add a row, select the row below where you want to add the new row and right-click, then select 'Insert'.

• To create a pivot table, select the data range and go to 'Insert' tab, click on 'PivotTable' and follow the prompts.

• To add a new pivot table to an existing one, select a cell in the existing pivot table and go to 'Analyze' tab, click on 'PivotTable' and follow the prompts.

Find the dictionary with the highest count of keys in a list of dictionaries.

• Iterate through the list of dictionaries and keep track of the dictionary with the highest count of keys.

• Use a loop to count the keys in each dictionary and compare it with the current highest count.

• Return the dictionary with the highest count of keys.

Yes, I have experience in converting Python scripts to R.

• I have converted several Python scripts to R for data analysis projects.

• I am proficient in both Python and R programming languages.

• I can provide examples of projects where I have successfully converted Python scripts to R.

I have 3 years of experience in Python and 2 years in R.

• 3 years of experience in Python, used for data cleaning, analysis, and visualization.

• 2 years of experience in R, utilized for statistical analysis and data modeling.

• Proficient in using libraries like pandas, numpy, matplotlib in Python and ggplot2, dplyr in R.

I have worked on a project in R programming analyzing customer churn for a telecommunications company.

• Used R programming to clean and analyze customer data

• Created visualizations to identify patterns and trends in customer behavior

• Built predictive models to forecast customer churn rates

• Collaborated with stakeholders to present findings and recommendations

Find a string matching a specific pattern in a list of strings.

• Use regular expressions to search for the pattern in each string.

• Iterate through the list of strings and apply the pattern matching logic.

• Return the string that matches the pattern, if found.

• Example: List of strings - ['apple', 'banana', 'cherry'], pattern - 'ba' would return 'banana'.

I have worked on databases such as MySQL, SQL Server, and MongoDB.

• MySQL

• SQL Server

• MongoDB

To perform an exists query in SQL, use the EXISTS keyword followed by a subquery that returns at least one row.

• Use the EXISTS keyword in the WHERE clause of the main query

• Follow the EXISTS keyword with a subquery that returns at least one row

• The EXISTS query will return true if the subquery returns any rows, otherwise false

Lookup in Excel is a function that searches for a value in a range and returns a corresponding value in the same position from another range.

• Lookup function helps in finding specific information in a table or range of data.

• Common lookup functions in Excel include VLOOKUP, HLOOKUP, INDEX-MATCH, and XLOOKUP.

• Example: =VLOOKUP(A2, B:C, 2, FALSE) - this formula searches for the value in cell A2 in the first column of range B:C and returns the corresponding value from the second co...read more

DML stands for Data Manipulation Language in SQL, used for managing data in a database.

• DML is used for inserting, updating, deleting, and retrieving data from a database.

• Common DML commands include INSERT, UPDATE, DELETE, and SELECT.

• Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2);

I conduct data analysis by collecting, cleaning, analyzing, and interpreting data to derive insights and make data-driven decisions.

• Collect relevant data from various sources

• Clean and preprocess data to ensure accuracy and consistency

• Use statistical methods and tools to analyze data

• Visualize data using charts, graphs, and dashboards

• Interpret results and communicate findings to stakeholders

Excel is used for data analysis due to its user-friendly interface, powerful data manipulation capabilities, and ability to create visualizations.

• Excel allows for easy data entry and manipulation, making it accessible for users of all skill levels.

• It has powerful functions and formulas for data analysis, such as VLOOKUP, SUMIF, and PivotTables.

• Excel can create visualizations like charts and graphs to help analyze and present data effectively.

• It can handle large datasets and p...read more

Data analysis is the process of inspecting, cleaning, transforming, and modeling data to discover useful information, draw conclusions, and make decisions.

• Data analysis involves collecting and organizing data sets.

• It includes cleaning and processing data to ensure accuracy.

• Statistical analysis and data visualization are key components of data analysis.

• Data analysis helps in identifying trends, patterns, and insights from data.

• Examples include analyzing sales data to identify ...read more

DCL stands for Data Control Language in SQL, used to control access to data stored in a database.

• DCL commands include GRANT and REVOKE, which are used to give or revoke permissions on database objects.

• GRANT command is used to give specific privileges to a user or role.

• REVOKE command is used to take back privileges that were granted with the GRANT command.

DML commands are used to manipulate data in a database.

• DML stands for Data Manipulation Language

• Common DML commands include INSERT, UPDATE, DELETE

• Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2)

CSV stands for Comma-Separated Values.

• CSV is a file format used to store tabular data in plain text.

• Each line in a CSV file represents a row of data, with columns separated by commas.

• CSV files can be easily imported and exported in spreadsheet software like Excel.

• Example: 'name,age,city' on the first line, followed by 'John,25,New York' on the second line.

SQL stands for Structured Query Language.

• SQL is a standard language for accessing and manipulating databases.

• It is used to communicate with databases to perform tasks such as querying data, updating data, and creating tables.

• Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.