matthewmace.com

Dashboards in Action
Dashboards in Action

Creating effective metrics

I've had a few clients lately ask me about selecting the best metrics and KPIs for their organization.  My recommendation was to review the chapter on “how to create effective metrics” from
Wayne Eckerson's book, Performance Dashboards. There he lists the twelve characteristics of effective metrics/KPIs:


  • Aligned - to corporate strategy

  • Owned – by an individual or group

  • Predictive – measure drivers of business value

  • Actionable – populated with timely data so users can improve performance

  • Few in Number – focus users on high value tasks, not scatter attention on too ...
<< MORE >>

Microsoft BI Strategy Update April 2009: SharePoint, PerformancePoint and SQL Server

By now you've likely seen the announcement from Microsoft regarding its Business Intelligence platform, PerformancePoint. The company is reconfiguring its product mix and will now bundle PerformancePoint Server with SharePoint. We agree with Gartner's assessment that this is a smart move for Microsoft and has the potential to provide significant benefits for Microsoft --and our clients!

Here is what Microsoft said:
"Microsoft's strategy is to deliver BI to everyone in the organization through the broadly adopted tools of Microsoft Office SharePoint Server and Microsoft Office Excel, and build on the scalable Microsoft SQL Server BI platform. Based on customer feedback, we are moving the scorecard, dashboard, and analytic functionality from Microsoft Office PerformancePoint Server into Office SharePoint Server Enterprise, making these capabilities available throughout the organization at a lower total cost of ownership."

With this move, Microsoft is taking a major leap forward in terms of creating Collaborative Business Intelligence and making it affordable.

  • It allows us to fully mix monitoring & analytical components with traditional collaborative components such as discussion boards, task lists, document libraries, and more.
  • It creates "actionable dashboards" to help team members in an organization take immediate steps to solve an issue or take advantage of an opportunity presented by the information.
  • Millions of SharePoint Enterperise CAL license holders just gained instant access to BI capabilities through PerformancePoint. In other words, if you own SharePoint with eCAL licenses and Software Assurance, you will be able to start a BI initiative without purchasing additional software.

 

Future of Business Intelligence

At the keynote presentation of the Microsoft BI Conference 2008 this morning vendor sponsors including Accenture, Dell, HP, Hitachi, and ProfitBase discussed the future of Business Intelligence.  Several interesting ideas were raised about what BI might look like in 2010, including:


  • BI solutions will be built and managed by business users, not IT, as demands grow for new information, faster
  • Data Architects as we know them today will evolve into Information Architects, professionals who deeply understand the information lifecycle of the organization, from "birth to archival"
  • BI becomes core to the business, like ERP and email today, becoming embedded in everyday processes, ...<< MORE >>

Microsoft Business Intelligence Conference

I'm wrapping up my first full day here at the Microsoft BI Conference in Seattle.  It's the second annual conference and I attended the first one back in early 2007.  So far Microsoft is delivering as promised with loads of case studies, best practice examples, and great information on the complete "BI stack".  The sense is that Microsoft has arrived as one of the top four BI mega vendors with IBM, Oracle, and SAP - except that Microsoft has a major leg up in the "BI for Everyone" space.
 
The highlight of the day was the discussion around "Gemini", a new function of SQL Server 2008 to be released in 18 months or so.  Gemini will allow non-developer business users and analysts to build ad hoc OLAP cube environments through Excel.  The solution will really change the way we approach "starter BI" projects with specific departments or teams.  Instead of building a data mart, OLAP cube, and the UI, we'll instead start with Excel to pull together existing and new data sources to build new BI solutions without a lot of IT overhead. 
 
As a partner its exciting to see the progress that has been made since the last conference, and the number of customers who are solidly behind the Microsoft BI vision. 
 
I'm looking forward to the keynote tomorrow by Ben Stein who will address the economy and how BI can help.  http://blogs.msdn.com/bi/default.aspx

Ryder Cup 2008: Lessons from Paul Azinger


In case you missed it, the U.S. won the Ryder Cup of golf from the Europeans this past weekend – the first time in 10 years.  Much of the excitement was around U.S. Captain Paul Azinger’s change in the points system used to select the 12 players who would compete on the U.S. squad.  Which lead me to the question – is Paul Azinger the next Billy Beane?


Moneyball, by Michael Lewis, is one of my favorite books, first introduced to me by Andy Catlin of Metrics Reporting.  Andy would use the ...<< MORE >>

Design IQ Quiz

Any aspiring BI Application Designers/Developers out there?  How well do you understand the principles of good graph and table design?  Take this 10 question quiz from Stephen Few to find out.

http://www.perceptualedge.com/files/GraphDesignIQ.html

Communities of Practice

A constant challenge of implementing new technology is the time-to-productivity of its users. In the corporate arena this is exacerbated by the remoteness that technology enables. Be it Blackberry or internet café, two users of the same system can be - quite literally – a world apart. But there is solution. It’s called Communities of Practice. And they are popping up in BI-savvy organizations everywhere.

Many user-defined and driven groups emerged first on their own. Users developed methods for sharing both practical and applied knowledge gained through their information systems. Today, however, smart companies are latching on to the concept to the betterment of organizational performance. These structured communities increase the availability of and access to new information. And they continuously push best practices through the organization – whether they originate from the top down or bottom up. What’s more, these groups are enabling companies to leverage there information systems investments at an unprecedented pace.

The University of Michigan offers a best practice example of an organization that’s embraced Communities of Practice. The University developed a Business Intelligence strategy in 2004 when it recognized the far reaching implications of BI on the growth of the University. Like a lot of large and complex organizations, U of M wanted to ensure that its policy and visioning center – its central office - was in sync with the parts of the organization actually carrying out its mission.

A BI Leadership Center was created to establish BI as a core process that would bridge the efforts of the University’s central office, its individual colleges and the work of the Michigan Administrative Information Services (MAIS). MAIS was charged with creating, implementing, driving and supporting BI as a strategic component of the University.

Recently, MAIS announced its 2008 BI program with a series of events designed to teach the University’s information workers how to leverage data and learn from others on campus. The program includes a calendar of events anchored at a central information portal that is accessible to select users. Integral to this year’s program is a roster of lessons learned from last year’s program.

BlueGranite recommends this type of approach to its clients, and can help develop a Community of Practice for Business Intelligence within our client’s organizations.  The key is finding  a  champion within each department  or team . They should be excited about the new tools, a quick learner with computer technology, and willing to teach others and share. Organizations will find new levels of performance and success as team members uncover ways to use  Business Intelligence in their day-to-day approach to their job.

Recent Entries

  1. Creating effective metrics
    Wednesday, November 18, 2009
  2. Microsoft BI Strategy Update April 2009: SharePoint, PerformancePoint and SQL Server
    Friday, April 03, 2009
  3. Future of Business Intelligence
    Sunday, October 19, 2008
  4. Microsoft Business Intelligence Conference
    Sunday, October 19, 2008
  5. Ryder Cup 2008: Lessons from Paul Azinger
    Sunday, October 19, 2008
  6. Design IQ Quiz
    Sunday, October 19, 2008
  7. Communities of Practice
    Wednesday, October 15, 2008

Subscribe


Blog Software