Data Warehouse and Information Asset Experts

Tips, Tricks and Technology

Tips and Tricks to help you along in business intelligence and data warehousing.

MicroStrategy Dashboard Widgets – Interactive Bubble Graph

By on March 21, 2015 in Tips, Tricks and Technology with 0 Comments
MicroStrategy Dashboard Widgets – Interactive Bubble Graph

An Interactive Bubble graph widget helps visualize trends of three metrics for a set of attributes in the form of a bubble plot. It can be an apt replacement for a Heat Map if you need more interactivity. While Interactive Bubble Graph provides a time slider which adds to the interactivity level (explained below), Heat […]

Continue Reading »

MicroStrategy Dashboard Widgets – Microcharts

By on February 2, 2015 in Tips, Tricks and Technology with 0 Comments
MicroStrategy Dashboard Widgets – Microcharts

A Microcharts widget provides a visualization that helps users view a particular trend at a glance. These trends are generally for a metric overtime or comparisons with the targeted or forecasted values. These visualizations are compact and gives us a picture at a single glance. Minimum Requirements: Minimum of 2 attribute along the rows. The […]

Continue Reading »

MicroStrategy Dashboard Widgets – Heat Map

By on December 18, 2014 in Tips, Tricks and Technology with 0 Comments
MicroStrategy Dashboard Widgets – Heat Map

A Heat Map widget contains a combination of different colored rectangles that help analyze a lot of data in a single scan of an eye. Each rectangle refers to a set of attribute elements. It gives you the ability to analyze the impact of various parameters in one go. It can be an apt replacement for an Interactive […]

Continue Reading »

Freeform Comments – Text Fact or Dimension?

By on January 20, 2011 in Tips, Tricks and Technology with 0 Comments
Freeform Comments – Text Fact or Dimension?

Freeform comment fields are challenging.  Should they be modeled in a text fact or in a separate dimension?  The topic has been addressed in several books as well as Kimball Group’s Design Tip #55, yet remains a persistent area of debate.  Rightfully so.  This entry presents a gray area example and some considerations in choosing […]

Continue Reading »

Top