|
Yes it is possible to do so. A good data warehouse system ETL should be able to:
- Extract data from excel sheets.
- Allow you to upload the excel sheet data manually into the staging area.
- Allow you to manually enter the data into the staging area.
Depending upon you context, you can also have following options if your tools allow it.
- Instead of entering your data into a data warehouse platform, you can have your OLAP server pick-up the data. Therefore you are bypassing the data warehouse, and directly going to OLAP.
- You can bypass both Data Warehouse and OLAP and enter the data directly into your analytics tool.
The above paths are recommended, if the excel based data is a one time need, or data is not that production critical or it does not have huge volumes. If none of these scenarios is true, then you have a bigger issue. This means that your core data is lying in excel sheet, which is a fundamental data management risk. You may start looking at making this data being part of your IT systems ASAP. |
