Bi (ETL-DW)

The company has been involved in the development of Bi projects for a period of time, but it is only developed as needed. This afternoon, the company will train you on the knowledge of data warehouses, let's hear about the two to three hours, what latitude, theme, and almost stunned. Finally, we demonstrated the Bi-based cost analysis system, which feels complicated, it is complicated for medical project services. The main purpose of this project is to be used by the implementer, and then the implementer teaches the customer to use the Custom reports (the data volume is large, and the tables are millions of data ), note: I have time to study the data warehouse.

To put it bluntly, we want to summarize and analyze data. If we do not use a data warehouse to directly query the database, a large number of joins are required, and a large amount of table data affects the database efficiency (we have heard of horizontal table sharding, it is not easy to use. Currently, it mainly creates temporary table storage, but the data volume is still large). Therefore, a data warehouse is created. At the same time, various hospitals have different cost analysis indicators, so the reports need to be customized by the customer. Therefore, SQL-solidified programs cannot be written directly, but at present we are solidified. (It takes 2 to 3 hours to publish a report each time ).

========================================================== ========================================================== ======================================