Business Sponsorship: Is there appropriate executive sponsorship, i.e., an identified and engaged steering committee and commensurate funding? DW/BI projects require strong executive sponsorship. Business Goals and Scope: Is there a …
OLAP – ROLAP, MOLAP and HOLAP
OLAP – Online Analytical Processing It is a technology, used to organize large business databases and supports to perform complex and multidimensional analysis, at high speeds on large volumes of …
Business Intelligence – Reporting and Analysis
Operational Reporting is the application of BI tools to analyze business trends, both short-term (month-over-month) and longer-term (year-over-year). Operational reporting can also help discover trends and patterns. Tactical BI Tool …
Data Warehouse, Data Lake & Data Vault
Data Lakes & Data Warehouses Data Lakes and Data Warehouses both act as repositories, but they are designed for very different purposes. Data Warehouses work best for specific projects with …
Data Warehouse Implementation – Guidelines and Principles
Focus on Business Goals: Make sure DW serves organizational priorities and solves business problems. Start with the End in Mind: Let the business priority and scope of end-data-delivery in the …
Data Warehousing and Business Intelligence (Momentary Look)
Requirements’ Understanding Define and Maintain the DW/BI Architecture Define DW/BI Technical Architecture Define DW/BI Management Processes Develop the Data Warehouse and Data Marts Map Sources to Targets Remediate and Transform …