Business Intelligence Data Warehousing

The Challenge of Dashboard BI Projects

If the goal of your business intelligence project is to deliver a dashboard, you should have warning bells going off in your head. What is a Dashboard An easy to read graphical presentation of the current status and historical trends of an organization’s key performance indicators (KPIs) to enable instantaneous and informed decisions to be …

Continue reading The Challenge of Dashboard BI Projects

Business Intelligence Data Warehousing

Data Quality and Business Process

So you think you have a data quality problem, or you have been told that you have a data quality problem. Let me tell you, you don't. Even with the fanciest data quality tool, etl engine, or business intelligence application; your data quality problems are not going to go away. In Reengineering the Corporation, Hammer …

Continue reading Data Quality and Business Process

Star Schema

What is Dimensional Modeling

Dimensional modeling is a data modeling technique in data warehouse design. Dimensional models use facts and dimensions to describe data for the business. Facts are typically numeric values that are additive (can be aggregated). Dimensions are descriptive elements used for grouping, labeling, and filtering facts. In the schema below: units_sold is a fact date, store, …

Continue reading What is Dimensional Modeling