What is data consolidation What do you understand by what if analysis?

Data consolidation is the corralling, combining, and storing of varied data in a single place. It lets users manipulate different types of data from one point of access and helps turn raw data into insights that drive better, faster decision-making. The term sometimes is used interchangeably with data integration.

What is the purpose of data consolidation?

Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.

What are the three different ways to consolidate data?

4 different ways to summarize data

• Consolidate files by column headers.
• Summarize values by row labes.
• Merge and summarize data by row and column labels.
• Consolidate data by position in worksheets.

What is the purpose of consolidating data explain with an example?

Explanation: Data consolidation refers to the collection and integration of data from multiple sources into a single destination. During this process, different data sources are put together, or consolidated, into a single data store. Open all three workbooks.

What is data integration in Analytics?

What is data integration? Data integration is a group of technical and business processes — such as ETL, data replication and data virtualization — that combine data from disparate sources into a meaningful and valuable data set for business intelligence and business analytics.

What is the use of what-if analysis?

Overview. What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Three kinds of What-If Analysis tools come with Excel: Scenarios, Goal Seek, and Data Tables.

Why is what if analysis important for better decision making?

The What-If Analysis is a decision making method that helps to make the right decision and think about what effect it will have beforehand. It can also prevent that no single person can make a decision, but that a number of people are responsible for that.