Question

Descibe the term Data Consolidation. Explain with examples​

Answer 1

Answer:

Data consolidation is the corralling, combining, and storing of varied data in a single place. ... The term sometimes is used interchangeably with data integration. Data consolidation enables businesses to streamline their data resources, discover patterns, and look for insights in multiple types of data.

Answer 2

Explanation:

$\begin{gathered}\huge\star{\pink{\underline{\mathfrak{answer}}}}⋆ \\\end{gathered}$

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.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.The term sometimes is used interchangeably with data integration. Data consolidation enables businesses to streamline their data resources, discover patterns, and look for insights in multiple types of data.

Examples :- For example, in the cell B5 in the worksheet «Store» in the cell E8 on the sheet «Store», etc. If in the book is included to automatic calculation of formulas, when you change the value in the source ranges the merged table will be updated automatically.