Understand the spreadsheets
Understanding spreadsheets:
within spreadsheets, the data can be arranged in any format. This ease of use within the spreadsheets results in data been
arranged in a way that it cannot be consolidated easily. For example the end client could have a need for consolidating the
following 2 spreadsheets.
The consolidated view in MS Excel
has to be generated manually in the following manner:
In order to automate such a process, we need to map the spreadsheet data onto
the database. The process of mapping the spreadsheet data onto the database is called “Data Modeling”.
