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 made at a glance. Business Processes and KPIs The key performance indicators (KPIs) of your dashboard will result from multiple business processes....

February 12, 2013

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, and product are dimensions all the other data elements are attributes of a dimension Dimensional models are typically represented using a star schema....

June 22, 2012