Penna Cement Industries Data Analyst Interview Questions and Answers

Q1. Question relating to taxation
Add your answer
Q2. Question related to Accounting
Add your answer

Q1. Job roles and responsibilities
Add your answer

It was good and simple with basics

Q1. What is data science
Ans. 
Data science is a multidisciplinary field that uses scientific methods, processes, algorithms, and systems to extract knowledge and insights from structured and unstructured data.
• Data science involves collecting, analyzing, and interpreting large amounts of data to make informed decisions.

• It combines statistics, machine learning, data visualization, and computer science to uncover patterns and trends in data.

• Data scien...read more
Answered by AI
Add your answer
Q2. Explain linear regression
Ans. 
Linear regression is a statistical method used to model the relationship between a dependent variable and one or more independent variables.
• Linear regression is used to predict the value of a dependent variable based on the value of one or more independent variables.

• It assumes a linear relationship between the independent and dependent variables.

• The goal of linear regression is to find the best-fitting line that repres...read more
Answered by AI
Add your answer

Solving SQL problem on vehicle fuel theft finding

Q1. Designing end to end ETL and ELT for OLTP to OLAP
Ans. 
Designing ETL/ELT process to move data from OLTP to OLAP for analysis and reporting purposes.
• Identify data sources in OLTP database

• Extract data using ETL tools like Informatica or Talend

• Transform data to fit OLAP schema using SQL queries or data manipulation tools

• Load transformed data into OLAP database like Redshift or Snowflake

• Schedule regular updates to keep OLAP database current
Answered by AI
Add your answer

Q1. Why want to change and what was your expectations, and what you did best in past company.
Add your answer