Lithium Urban Technologies Data Analyst Interview Questions and Answers

Q1. Q1/- How to extract data from database
Ans. 
To extract data from a database, one can use SQL queries or programming languages like Python or R.
• Use SQL queries to extract data from a database

• Use programming languages like Python or R to extract data from a database

• Connect to the database using appropriate credentials

• Identify the tables and columns from which data needs to be extracted

• Write the query or code to extract the data

• Save the extracted data in a desired
Answered by AI
Add your answer
Q2. Q2/- What are the Tableau Datatypes
Ans. 
Tableau has 14 datatypes including string, integer, float, date, boolean, and more.
• Tableau has 14 datatypes

• String, Integer, Float, Date, Boolean, and more

• Data types can be changed in Tableau

• Data types affect how data is displayed and aggregated

• Examples: String - 'John Smith', Integer - 25, Float - 3.14, Date - 01/01/2021, Boolean - True/False
Answered by AI
Add your answer

Q1. Q1/- Related company example along with Excel
Add your answer
Q2. Q2.- Vlookup() copy record from one sheet to another sheet
Ans. 
Vlookup() is a function in Excel that can be used to copy records from one sheet to another based on a common identifier.
• The Vlookup() function searches for a value in the first column of a table array and returns a corresponding value in the same row from a specified column.

• The common identifier used in the Vlookup() function should be present in both the source and destination sheets.

• The Vlookup() function can be use...read more
Answered by AI
Add your answer

Q1. All about excel and about your previous work experience
Add your answer

All about analytical and excel

Q1. Just salary discussion
Add your answer