Sunday, August 25, 2019

Business Issues in Business Intelligence Essay Example | Topics and Well Written Essays - 500 words

Business Issues in Business Intelligence - Essay Example vels of a corporation to more simply access, identify, evaluate, collaborate, and perform operations on information, anywhere and anytime (TechTarget; Microsoft). Though, many business intelligence tools work fine and help organizations take better decisions. They provide exact targets, graphs, drill-through and drill-downs. However, a great deal of work in an operational data warehouse system entails processing of data collected from different operational systems into the data warehouse. In this process of decision making and making intelligible decisions, there exist many problems regarding ETL (extraction, transformation and loading). In other words, while collecting huge amount of data from different sources we can face many issues regarding ETL. These issues can also influence the overall quality of decisions and business operations. In addition, ETL can entail substantial complexity and significant operational problems those can take place due to improperly designed ETL systems that can eventually influence the performance of BI system’s working and operations (Scott). The successful implementation of BI requires plenty of data analysis and evaluation. In this scenario we need to assess the quality of data in predicting the results. On the other hand, data warehouses are normally assembled from a mixture of data sources with different formats as well as purposes. In this scenario, ETL is a key process to bring the entire data together in a standard and uniform structure. In case a problem happens to ETL process overall working and operations of the corporate decision support can be exaggerated. In addition, it will lead to ineffective and lower quality results. Moreover, major issues in ETL can include: (Kimball and Caserta; Kimball and Ross, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd Edition) The presence of any of the above listed issues can affect the implementation of business intelligence. These issues can also lead

No comments:

Post a Comment