BluSmart 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. Past experience
Add your answer
Q2. Current responsibilities
Ans. 
As a Senior Engineer, my current responsibilities include leading a team of engineers, overseeing project timelines, and ensuring technical excellence.
• Leading a team of engineers

• Overseeing project timelines

• Ensuring technical excellence
Answered by AI
Add your answer

First round is self video describe round and later I interview for simple and little technical details

QUant, aptitude, english all in one hour

It was about the road curves and what kind of material we can use for the long durability of road

Related Job Profile Timing Something 1 Hours above.

Q1. HR Round is very Simple. Some question related job
Add your answer
Q2. Some discussion at HR Round for salary related
Add your answer

Q1. What is your experience
Add your answer

Q1. Core resposibulities
Add your answer

Q1. Salary discussion
Add your answer

Q1. What CBR Test and how it is important for Highway Construction.
Ans. 
CBR test is a laboratory test to determine the strength of subgrade soil for highway construction.
• CBR stands for California Bearing Ratio.

• It measures the strength of subgrade soil by comparing the pressure required to penetrate the soil with a standard material.

• CBR values help in designing the thickness of pavement layers for highways.

• Higher CBR values indicate better soil strength and require less pavement thickness.

• F...read more
Answered by AI
View 1 more answer
Q2. Difference between Embankment and Subgrade
Ans. 
Embankment is the raised structure built with earth or other materials, while subgrade is the natural ground level beneath the pavement.
• Embankment is man-made, built with materials like soil, rock, or concrete to raise the road level above the surrounding terrain.

• Subgrade is the natural ground level beneath the pavement, prepared to support the road structure.

• Embankment provides stability and support to the road, while...read more
Answered by AI
View 1 more answer
Q3. Mis Design of Bituminous Mix
Ans. 
Misdesign of bituminous mix can lead to premature pavement distress and reduced pavement life.
• Improper selection of aggregate gradation

• Incorrect binder content

• Inadequate compaction during construction

• Poor quality control measures

• Lack of proper drainage design

• Failure to consider traffic volume and loadings
Answered by AI
Add your answer
Q4. Basic Irc and Is codes
Add your answer

Q1. What is colur code of RJ 45
Add your answer
Q2. What is LAN,WAN,MAN, topology
Add your answer

Q1. What salary expectation
Add your answer
Q2. How many years experience
Add your answer