Question

题目求解，如何用ETL工具把EXCEL表格提取转换加载到数据仓库并生成报告？

老师出了个方案题目，要我们把一个从现存数据库导出的excel表格.xls格式的，通过ETL工具弄到数据仓库中，并生成报告；请问下这个怎么写啊？小弟雪地裸体跪求答案啊！

现在我手头有一堆xls表格，我应该怎么弄？要下载什么软件？或者去什么网站有具体的设计过程？谢谢啊
老师还要求要用多维方式的数据仓库，支持开源的Postgres

Answer 1

Supermarkets in the experience of the data from the management model gradual transition to the use of modern information technology management, has accumulated a large number of commercial service data, the data extraction on the future development of marketing strategies play an important role. The establishment of the supermarket data warehouse system will enable the management of the supermarket more scientific, efficient, and to support management in the decision-making process.
Papers to discuss two main lines: the first data warehouse on some of the basic theory, then under the basic theory, to complete a supermarket sales of database management, further elaborated the specific data warehouse decision support system for the important role. Of course, the integrity of data storage systems supermarkets owned by large data, also made the all-inclusive decision-making, such as the sale of decision-making, decision-making products, financial management decision-making. Supermarket sales in the data management process, in order to illustrate the problem, the paper target sales of the decision-making function to achieve. The design of a large database SQL Server 2000, the first data warehouse modeling, according to supermarket data to the operation of theme, the dimensions and size, measure, the fact sheet and peacekeeping, etc.. This was followed by the use of data warehouse ETL tool in scheduling, from converters, such as loading for the realization of the data extraction, conversion, cleaning, loading, which will be useful to decision-making, after cleaning up the data stored in data warehouses. Finally, the use of data warehouse OLAP data analysis tools to achieve the multi-dimensional analysis, and generates statements for policy makers to formulate the right marketing policies to improve efficiency.