HR Analytics Week 2 NPTEL Assignment Answers 2025
Need help with this week’s assignment? Get detailed and trusted solutions for HR Analytics Week 2 NPTEL Assignment Answers. Our expert-curated answers help you solve your assignments faster while deepening your conceptual clarity.
✅ Subject: HR Analytics
📅 Week: 2
🎯 Session: NPTEL 2025 July-October
🔗 Course Link: Click Here
🔍 Reliability: Verified and expert-reviewed answers
📌 Trusted By: 5000+ Students
For complete and in-depth solutions to all weekly assignments, check out 👉 NPTEL HR Analytics Week 2 NPTEL Assignment Answers
🚀 Stay ahead in your NPTEL journey with fresh, updated solutions every week!
NPTEL HR Analytics Week 2 Assignment Answers 2025
1. What is the first step in data analytics?
- Data visualization
- Data cleaning
- Data collection
- Data interpretation
Answer : See Answers
2. What does HRMIS stand for?
- Human Resource Main Internet System
- Human Resource Machine Interface System
- Human Resource Management Information System
- High Resource Management and Intelligence System
Answer :
3. Why is beautifying a chart important?
- For Excel performance
- For aesthetic and presentation clarity
- To increase data size
- To track HR policies
Answer :
4. What is the correct order for using Excel for visualisation?
- Chart > Analyze > Collect Data > Report
- Report > Visualize > Collect
- Identify Questions > Variables > Data Collection > Visualization
- Format > Analyze > Research
Answer :
5. Which statement is FALSE about pivot tables?
- You must write formulas to use them
- They help create quick summaries
- They support count, average, and sum functions
- They are useful in report writing
Answer : See Answers
6. State True and False R and Data Studio are open-source visualisation tools.
- True
- False
Answer :
7. A good visualisation strategy should begin with understanding the _____________ asked by managers.
- Tools
- Software
- Questions
- Reports
Answer :
8. What is the main objective of visualising HR data in Power BI?
- To filter records
- To format text
- To generate insights and tell stories
- To create invoices
Answer :
9. In Excel, which feature gives automatic summary suggestions?
- Pie Chart
- Filters
- Recommended Pivot Table
- Conditional Formatting
Answer :
10. State True OR False The “Source of Application” variable helps understand where applicants are currently working.
- True
- False
Answer : See Answers
NPTEL HR Analytics Week 2 Assignment Answers 2024
1. What is the first step in the data analytics process?
a) Data Preparation
b) Data Collection
c) Data Analysis
d) Data Visualization
✅ Answer: b) Data Collection
Explanation: The data analytics process begins with data collection, which involves gathering relevant data from various sources before it can be cleaned, analyzed, or visualized.
2. What does Power BI stand for?
a) Business Intelligence
b) Business Insights
c) Business Integration
d) Business Innovation
✅ Answer: a) Business Intelligence
Explanation: Power BI is a Microsoft tool that stands for Power Business Intelligence, used for visualizing and analyzing data to gain business insights.
3. What is a common tool for creating data visualizations in Excel?
a) PivotTable
b) VLOOKUP
c) SUM function
d) Data Validation
✅ Answer: a) PivotTable
Explanation: PivotTables are powerful Excel tools used to summarize and visualize data interactively, often used for creating dynamic tables and charts.
4. What is the purpose of data preparation in the data analytics process?
a) To visualize data
b) To clean and organize data for analysis
c) To collect data
d) To present findings
✅ Answer: b) To clean and organize data for analysis
Explanation: Data preparation involves cleaning, transforming, and structuring raw data to ensure accuracy and reliability during analysis.
5. Which Excel feature is used to create visual representations of data?
a) Data Validation
b) Charts and Graphs
c) Data Bars
d) Pivot Tables
✅ Answer: b) Charts and Graphs
Explanation: Charts and graphs in Excel visually represent data patterns and trends, making it easier to understand.
6. True or False: Findings should not be presented in a clear and concise manner to facilitate decision-making.
a) True
b) False
✅ Answer: b) False
Explanation: Presenting findings clearly and concisely is crucial for effective communication and decision-making in any analytical process.
7. Which of the following is NOT a visualization best practice in Power BI?
a) Using appropriate color schemes
b) Adding too much detail to visualizations
c) Ensuring readability and clarity
d) Providing clear titles and labels
✅ Answer: b) Adding too much detail to visualizations
Explanation: Overloading visuals with details can confuse users. Simplicity, clarity, and focus are key best practices in Power BI.
8. True or False: Data collection can include importing data from online databases, Excel files, and CSV files.
a) True
b) False
✅ Answer: a) True
Explanation: Data collection often includes importing from multiple sources like databases, Excel, and CSV files to compile relevant information.
9. True or False: Data visualization does not help in identifying patterns and trends in the data.
a) True
b) False
✅ Answer: b) False
Explanation: Data visualization is essential for identifying trends, outliers, and patterns, which are crucial for making informed decisions.
10. One of the primary goals of data visualization is to make __________ easier to understand.
a) Decisions
b) Calculations
c) Data
d) Programming
✅ Answer: c) Data
Explanation: The goal of data visualization is to simplify complex data and make it more understandable and accessible to users.
