Thursday, February 17, 2011

Four Microstrategy 9 BI Examples You Can Use in uniPaaS

With only a little fanfare, Magic Software Enterprises demonstrated embedded Microstrategy 9 BI reporting inside a uniPaaS RIA application this week. To see it for yourself, along with all the other features of uniPaaS RIA, you can go to to see what a Rich Internet Application with embedded BI looks like. The uniPaaS RIA demo incorporates thirteen different Microstrategy 9 Business Intelligence reports. I’ll discuss the first four in this post and save the others for subsequent blog posts:

Enterprise Performance Management. The Enterprise Performance Management report shows a classic Enterprise Performance Dashboard with gauges for KPIs of Profit Margin, Revenue and Revenue Per Employee. In the demo, Profit Margin is gauged against an industry benchmark and current revenue is compared to the forecast. A bar chart displaying monthly revenue, forecast and variance is also displayed.
Retail Operations Balanced Scorecard. The second example provided is a Balanced Scorecard. This document shows a complete balanced scorecard for a typical retail organization, along with a graphical strategy map at the bottom of each month’s data recap. The targets for KPI's come from an external data mart and are incorporated using a report built in the Microstrategy 9 Query builder. The four perspectives of the balanced scorecard are: Financial Perspective, Customer Perspective, Internal Process Perspective, and Learning Perspective.
The financial perspective of the balanced scorecard is based on Growth as measured by the KPI of Revenue and Profitability as measured by the KPI of Margin. All of the KPIs are hot linked to a drill-down report showing monthly trends for that KPI. The Customer Perspective is based on Higher Satisfaction and a KPI of the percentage of orders shipped within a week is measured. A second KPI followed in the customer perspective is the percentage of customers who made a purchase, and this is considered an indicator of higher customer loyalty.
The sole internal process monitored in the Balanced Scorecard is Leaner Inventory which is tracked by a KPI of the number of inventory turns per month. The success of the Learning Perspective is based on Employee Sales Training which is associated to the KPI of Revenue Per Employee.

Within the display of all four perspectives in the balanced scorecard, a summary of current intitiatives, KPI targets and results is also included.
Performance By Customer Region. This document illustrates revenue and profit performance against forecast by customer region. A horizontal bar chart on the upper left shows revenue and forecast by region while a corresponding horizontal bar chart on the right displays profit and profit forecast by region. A table summarizing the region name, result, forecast, difference (variance) and percentage contribution (or regional share) is included below each chart.
Average, Maximum and Minimum Revenue per Customer. The next report included in the uniPaaS RIA demo of embedded Microstrategy 9 business intelligence (BI), is the report of average, max and minimum revenue per customer. This is essentially a product line analysis report as the report shows how much customer revenue is related to products from a particular supplier. The information is presented in a simple table of four columns showing vendor name and the three values. The Microstrategy 9 user level report tools are available in this example and allow you to choose between, grid, graph and grid+graph layouts. Various BI tools for report design, filtering, sorting, and so on can also be seen here.The vendor name is a hot link that drills down to a table showing each item or SKU from that vendor and the same three measures: average, minimum and maximum revenue per customer.
Is your business intelligent?
We'll have much more to say about business intelligence in the coming days. So "stay tuned" for more business intelligence and cloud computing good news.
Glenn Johnson is a Senior Vice President at Magic Software Enterprises, Inc. Active in the software industry since 1984, he frequently speaks at industry conferences and writes for numerous publications.