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

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