Annalect Interview Questions, Process, and Tips

VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.

• Used in Excel to search for a value in the first column of a table and return a value in the same row from another column

• Requires four arguments: lookup_value, table_array, col_index_num, and range_lookup

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10

Index match is a function in Excel used to search for a value in a range and return a corresponding value from another range.

• Index match is a powerful combination of functions in Excel used to perform lookups.

• The INDEX function returns a value from a specific row and column in a range.

• The MATCH function searches for a value in a range and returns its relative position.

• Index match is often preferred over VLOOKUP for its...read more

Built an end to end ETL pipeline in Alteryx for data processing and analysis.

• Extracted data from multiple sources such as databases, APIs, and flat files.

• Transformed the data by cleaning, filtering, and joining datasets to create a unified view.

• Loaded the processed data into a data warehouse or visualization tool for analysis.

• Used Alteryx tools like Input Data, Filter, Join, and Output Data to build the pipeline.

Transpose reorganizes data from rows to columns, while Cross Tab summarizes data in a tabular format.

• Transpose converts rows to columns based on a specified key field.

• Cross Tab summarizes data by grouping values from one or more fields into a tabular format.

• Transpose is used for restructuring data, while Cross Tab is used for aggregating data.

Answers to SQL questions on truncate, delete, syntax of truncate, and printing odd/even numbers.

• Truncate is a DDL command that removes all rows from a table, while delete is a DML command that removes specific rows

• Syntax of truncate: TRUNCATE TABLE table_name;

• Printing odd/even numbers in SQL can be done using a recursive CTE or a WHILE loop

• Example of recursive CTE: WITH RECURSIVE cte AS (SELECT 1 AS num UNION ALL SELEC...read more

I have a strong understanding of Datorama tool and its capabilities.

• I have experience using Datorama for data visualization and reporting.

• I am familiar with creating custom dashboards and reports in Datorama.

• I have worked with Datorama's data integration features to connect various data sources.

• I have used Datorama to analyze marketing campaign performance and make data-driven decisions.