Posts Tagged ‘report’

Information at your fingertips

April 26th, 2010

Do end-users really exist?

I am wondering about the definition of end-users. Regarding reporting or BI, I find it difficult to define these. Taken literally the word ‘end-user’ seems too static and out of date to get around a real description.

However based on our extended experiences of more than 12 years of report building, BI implementations and end-user training I feel the following types are close to what we experience in day to day’s engagements.

  1. Light users – The users who need static and reoccurring overviews. Real time information is not required and exploring data sets or ad hoc in-depth analyses neither. How? Static, free-of-charge pdf or html overviews. For managers and to support fixed and predefined arrangements on information sharing.
  2. Dynamic users – Those who need real time refreshable information. For example they want a real time status of the performance of department during a specific period. How? Reports which could be refreshed and prompt you for the data set you would like to see. For example the report will prompt you for department, region, classification, period … before it refreshes. Process owners, workgroup managers, team leads, business users …
  3. Explorers – Users who need to explore, navigate and visualize data themselves (googling your data). There are certain questions to be answered which need low profile data mining. How? Use a BI tool which provides you exploring data sources, the capability to define your data set by pointing/clicking and easily sharing your results (by iPhone)? It should be powerful, simple, intuitive and fast. Process owners, workgroup managers, team leads and your business for low profile data mining. But are you up for it? Mature enough yet to provide these access and responsibilities?
  4. Power users - The users which need slicing and dicing data for specific answers. To empower route cause analysis when dashboards are telling you, you are under performing as a group or at your process. So not for answering questions on how we are doing it, but why this is happening. How? Use easy to use slice and dice functionalities together with application configuration knowledge to get there. By the way these are your colleagues which provide you also the above 3 information sources.

Do you agree?

Step in the future and enjoy it now at:

http://westbury-it.com/media/product-demos/part-1-introduction-to-report-building

http://www.sap.com/netherlands/solutions/sapbusinessobjects/large/business-intelligence/search-navigation/explorer/index.epx

Martijn

Post to Twitter

Metric of the month – First Call Resolution

April 19th, 2010

At Metricnet the current metric of the month is First Call Resolution.

This metric is one of the metrics that’s in use at almost all of our customers and if your not measuring it yet, you should!

Check out http://www.metricnet.com/metric_month.html for their coverage of the metric.

Of course we ship a start up report around First Call Resolution with our SMI Suite product and we actually provide an easy to configure computed boolean as there are numerous variations in determining whether or not a ticket has been resolved at first call.

David vH

Post to Twitter

How to…

August 27th, 2009

“How to…” is quite a generic title for a post so no doubt you will fill in the blanks yourself. And think of something nice… only for me to disappoint you, because the “How to…”  I’m focusing on is… “How to build a good report”.

The first thing you need to keep in mind is that building a report is not that hard… and actually the definition of a report is the hardest part.  So to create a report – instead of just starting to build – you first need to think about a few important steps.

  1. Determine what information you need and who needs it
  2. Start building the report with selecting the data
  3. Manipulate the data (add calculations or other parameters)
  4. Create a final layout and broadcast it to your audience

The most important one of these is the first one, because based on the answer the following can be assessed. To determine which information you need you must think at several sub questions like:

  • What is the exact goal of the report, is it a simple overview,  detailed overview with calculations, or an in-depth view of performance per, let’s say, assignment group;
  • Number of Incidents per Assignment Group, Category and Priority
  • Who needs the information (management, a customer or is it for someone with in depth knowledge);
  • Management
  • How do they expect to receive the report (report with refresh possibility, PDF, Excel or HTML)
  • Report
  • How often should the report be broadcast (once, every day, weekly)
  • Every Monday morning at 8:00 am

Based on those answers you can start determining the source for you data, the answer on question 2. When you are using SMI Suite, and yeah you should,  the data will be available through several complete universes. Right now I’m taking the Incident process as an example so we need to select the Incident universe to get the data.

Once you’ve selected the objects you want to report on, that’s it… Business Objects will provide you with a default report with a tabular overview of the selected data.

tabularview

Then the last part kicks in, time to create some calculations like averages, sums, counts or percentages, and maybe create some variables that represent data in a more “jip en janneke taal” [Ed: this Dutch idiom translates to "in layman's terms", but it's cute so I didn't want to edit it out entirely]. I will add an percentage of the total number per category and priority shown per Assignment group.

Finally create the final layout and it can look like this. Because it is for the management I have decided to give exceptional high percentages a red color and “in the danger” percentages an orange color. In this case they can see at a glance the status and the possible issues.

fixed-view

Finally you can set up a scheduler, part of Business Objects, and publish the report in the desired format.

If you don’t think a report over and start building without thinking you will see that a lot of work is lost in adjusting everything.  So keep this list to guide you through the process or if you have a better guide please share!

In the next blog I will CHANGE the subject! You’re a real Sherlock if you know the subject, so surprise me!

Richard

Post to Twitter

The hidden costs of BI

August 19th, 2009

The Aberdeen GroupIn a recent report (registration required) the Aberdeen Group described the success rates of enterprise companies (which it groups into Best-In-Class, Average or Laggard) in Business Intelligence projects.  Some of the result are very interesting to share.

For example, the report identified the four top hidden costs of Business Intelligence as:

  1. Year-after-year budget increases: The typical best-in-class company sees a drop in year-after-year BI budgetary costs. Average and laggard companies, however, can witness increases in BI expenses that range from 2 percent to 9 percent.
  2. Cost per user: Best-in-class companies lower per-user costs by 4.3 percent whereas average performers and laggards often see increases ranging from 1 percent to 7 percent.
  3. Time to complete projects: Best-in-class achievers complete BI projects, on average, within 14 days. Average performers take nearly three times as long (approximately 39 days) to complete a project, and the typical laggard company takes more than 12 times as long (177 days).
  4. Modifications to BI software: Altering a BI program takes less than a day for best-in-class companies; three days for average performers; and up to eight days for laggard organizations.

Or as author David Hatch put it:

“The overall cost of ownership is not about the costs of purchasing the software,” Hatch says. “The real cost factors are the hidden or the soft ones that have to do with indirect and ongoing factors.” Hatch contends that a justifiable fear of such factors hinders adoption. “People are finding [that] the resources the company needs to acquire to properly implement, deploy, support, and maintain a BI solution are far greater than the solution providers lead [users] to believe or that [users] assume on their own.”

Interesting, because that is what Westbury has seen over the last years in dealing with BI projects for HP Service Management. But a report of the Aberdeen Group isn’t complete without some recommendations. On what areas should companies focus in order to improve the success rate of their BI projects?

Aberdeen suggests that investments in the following areas will maximize results from a BI initiative:

  • Data integration and cleansing: “Companies are finding it difficult to bring data together from multiple, disparate sources,” Hatch says. Investing in tools for data management can be of help in this regard. Best-in-class companies are twice as likely as their counterparts are to institute data integration and cleansing capabilities.

Westbury recommends: make sure the back end of your BI environment can be used by non-technical people

  • End-user requirements: “You really have to stop and think about why…so many companies have deployed tools that so many aren’t able to use,” Hatch says. Companies must understand that end-users — especially nontechnical, non-data-guru types — may need different approaches. Hatch advises companies to focus on end-user needs before deploying a solution.

Westbury recommends: make sure you talk the same language as your end-users

  • Training: Top performers are 37 percent more likely to invest in extensive user training on BI solutions and 40 percent are more likely to have formed formal user committees to encourage adoption. Additionally, best-in-class companies are twice as likely as laggards and average performers are to sign up for vendor-provided services.

Westbury recommends: the more accessible your BI solution is for the end-users, the better your processes should be around training

  • Operational BI: Successful users of BI use the technology on an everyday basis rather than merely getting a summarized spreadsheet version of performance and high-level trends. Hatch says that operational BI seems to be gaining traction as companies look to make comparisons over shorter time spans rather than just examine large-scale trends.

Westbury recommends: integrate your BI solution with the supported applications, so it is readily accessible for your end-users

Great to see our own own experiences in working with the HP Service Management software backed up with a solid research like this one from The Aberdeen Group.

Floris

Post to Twitter

Making data sexy. It is possible, and I have the proof!

July 27th, 2009

sexydataLast week, a ripple of excitement spread across the Westbury campus like a drunken Mexican Wave at a Red Sox game. No, Kaka had not decided he wanted to leave Real Madrid for Ajax – this was something far more exciting. Some Swedish dude had only gone and made data sexy.

You scoff, but I have the proof, in the form of a video of Hans Rosling, Professor of International Health and Director of the Gapminder Foundation, talking about stuff.

The stuff in question is all to do with child mortality rates around the world and variances in the data and lots of other interesting things that I didn’t sleep through, because Hans made it sexy!

So what?

Well, sometimes the usefulness of data can be obscured by its more… soporific qualities. If you give someone a list of data in a table form they will be less moved by it than they would by the same data in a graphical format. It’s just the way our brain works. One of the most important lessons you learn at school is that stuff is boring unless it’s brightly colored and conformed into interesting shapes.

At Westbury we pride ourselves on the fact that our solution is – in part – based around Business Objects, the industry leading Business Intelligence tool. We’re proud because we know that once you get your data out of Service Manager or ServiceCenter, the BO front-end will let you present it in a sexier way than a plain ol’ list, table or spreadsheet. We think that’s important, and you will too when you find your boss, asleep at his desk and drooling onto your latest workgroup performance report.

Anyway, the point of this blog entry was really to pay it forward with the sexy data video, so here’s Hans in all his sexy loveliness. Take it away, Hans!

Post to Twitter