MicroStrategy and the BI Breadth vs. Depth Debate - InformationWeek
IoT
IoT
Software // Information Management
Commentary
7/18/2007
09:19 AM
Cindi Howson
Cindi Howson
Commentary
Connect Directly
Twitter
RSS
E-Mail
50%
50%
RELATED EVENTS
[Cyberattacks] Using Data as Your First Line of Defense
Aug 10, 2017
Attend this webinar to learn how you can determine which threats pose the greatest danger to your ...Read More>>

MicroStrategy and the BI Breadth vs. Depth Debate

While much of the BI market has been busy expanding its solution breadth - acquiring or developing performance management capabilities - one vendor that has stayed focus exclusively on the BI front-end has been MicroStrategy... The company maintains that there is still a lot of work to be done to solve hard problems in the traditional BI space... problems such as impact analysis and regression testing.

While much of the BI market has been busy expanding its solution breadth - acquiring or developing performance management capabilities - one vendor that has stayed focus exclusively on the BI front-end has been MicroStrategy. Only time will tell if its strategy will pay off, but CEO Michael Saylor has long maintained that there is still a lot of work to be done in the traditional BI space, to solve some of the harder BI problems.

One of those hard problems is impact analysis and regression testing. When someone makes a change any where in the BI lifecycle, say a physical field in the data warehouse, identifying affected reports is often guesswork. A handful of BI vendors do "okay" in telling you which reports are impacted (see BIScorecard, architecture criteria for detailed scores); for most others, the reports will out and out break.At MicroStrategy's Symposium in New York this week, the vendor previewed Integrity Manager, due for release in September. Integrity Manager goes beyond simple impact analysis, providing full regression testing for any number of potential system changes (operating system change, VLDB settings, metric calculations, data warehouse load errors, and so on). Integrity Manager will do before-and-after report comparisons to tell an administrator the impact of the change, warning if there are differences in the data values, if the SQL generated is different, if the output format is affected. Not only will Integrity Manager tell you that there is a difference, it also highlights the differences in the numeric values, SQL, or display.

I have not seen anything near this capability in other leading BI suites. It's one of those details that few business users will get excited about, and yet one that can be a hot button for BI administrators. Integrity Manager can help these BI administrators know in advance which users and reports will be affected, and it can forewarn them when a change outside their area of control impacts BI.

As BI increasingly becomes an enterprise (vs. departmental) resource, such integrity checking and proactive alerting is important. Today, most BI administrators are left with either no testing or tedious, manual tests. MicroStrategy is definitely ahead of the market in this capability, showing that what it may not have in terms of breadth, it more than makes up for in BI depth.

Sincerely,

Cindi Howson Founder, BIScorecard product evaluationsWhile much of the BI market has been busy expanding its solution breadth - acquiring or developing performance management capabilities - one vendor that has stayed focus exclusively on the BI front-end has been MicroStrategy... The company maintains that there is still a lot of work to be done to solve hard problems in the traditional BI space... problems such as impact analysis and regression testing.

Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
IT Strategies to Conquer the Cloud
Chances are your organization is adopting cloud computing in one way or another -- or in multiple ways. Understanding the skills you need and how cloud affects IT operations and networking will help you adapt.
Video
Slideshows
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll