|  Data Warehouse is not imune to changes on source systems, actually it is very vulnarable to them. If source systems have duplicate figures, Data Warehouse will also report duplicates. Here is an example from practice where guys made patch on CRM system to handle “urgent” marketing product without making any kind of communication toward reporting – DWH and Business Intelligence. Duplicated figures were in official reports for three months and caused significant deviations of core Key Performance Indicators. Unfortunatelly, reporting mistake was presented to the board members as Data Warehouse error. Continue reading Business Intelligence Example of Reporting Errors – Duplication of Figures [...]  Consider Data Mart as a small specialised Data Warehouse or independant unit (financial data mart, customer data mart, sales relation, customer support, technical data and similar) in Data Warehouse scheme. Continue reading Data Mart in Data Warehousing [...]  Whenever strategic management decision making process needs new data from existing company information systems it should be implemented quickly and information provided easily. But is it really so? Problem is that every new requirement for information details might face limitations in data models in production systems or data warehousing. Continue reading Data Model Limits [...]  BAD ROMANCE performed by IT not by Lady GaGa Well, you never know when will good solutions be spoiled. Here is the example. After DWH project was successfully finished, after DWH worked fine and justified investment, after users get used to it, after survival of negative critics after… Somebody in IT still found reasonable to do Continue reading Spoiling DWH quality [...]  Mapping issue between Data Warehouse and Management Information systems Management Information System (MIS) wants to take data from Data Warehouse and opens initiative to connect and to regularly import data from Data Warehouse. Sounds easy like piece of cake. Problem is who will take the obligation to maintain mappings between two systems. Does not sound like Continue reading Mapping issue, DWH and MIS [...]  There are 3 basic ways of report deployment in Data Warehouse. Each has benefits and risks. Here is the list of facts to be aware before choosing how to deploy reports. Continue reading ABC reporting deployment options [...]  People like to play on safe in uncertain world, so do companies. For companies safe is to use most used and solutions from biggest vendors. Companies also like to play on standard and mega business intelligence projects from profiled, big and established companies like SAP, SAS, Oracle, IBM and etc. Companies like people do like to play on safe. Continue reading Playing on Safe Business Intelligence Side [...]  If the ownerships has to belong to only one department it is a little bit risky decision. For example if IT is owner of DWH, they are just service providers without in deep knowledge what to do exactly with content. Perhaps better variant is to give ownership to finance, to be more precise to controlling. Reason for this decision is general view over definitions, external and management reporting. Controlling knows best what kind of products will be made upon DWH. Perhaps best solution would be to establish committee of experts from all business areas with lead from controlling and to give dwh ownership to this body. Continue reading Data Warehouse ownership [...]  Difference between data integration and unification is best to consider through Data Warehouse (DWH). It is widely used technology and it quite often being treated to help company with both crucial data quality issues. Data unification is something what Data Warehouse (DWH) does with ease since it is constructed to gather information from many sources with purpose to speed reports and to store data. All data are in same storage place customized for reporting processes. Continue reading Difference between data integration and unification [...]  Is it reasonable to include ERP reports in Data Warehouse and Business Intelligence or not? It is a thin line between wrong and good decision. Here are few thoughts what is about data transfers. Continue reading ERP reporting and DWH/BI [...] | It is all about...
Business Performance and Profit Boost!
...by understanding corporate information. |
