Bottom Up And Top Down Approaches To Estimating Costs For A Single BI Report

Boris Evelson

How much does it cost to produce a single BI report? Just like typical answers to most other typical questions, the only real answer is “it depends”. But let’s build a few scenarios:

Scenario 1: Services only. Bottom up, ABC approach.

Assumptions.

 

  • Medium complexity report. Two data sources. 4 way join. 3 facts by 5 dimensions. Prompting, filtering, sorting ranking on most of the columns. Some conditional formatting. No data model changes.
  • Specifications and design – 2 person days. Development and testing - 1 person day. UAT – 1 person day.
  • Loaded salary for an FTE $120,000/yr or about ~$460/day.
  • Outside contractor $800/day.

Cost of 1 BI report: $1,840 if done by 2 FTEs or $2,520if done by 1 FTE (end user) and 1 outside contractor (developer). Sounds inexpensive? Wait.

 

Scenario 2. Top down. BI software and services:

Assumptions:

  • Average BI software deal per department (as per the latest BI Wave numbers) - $150,000
  • 50% of the software cost is attributable to canned reports, the rest is allocated to ad-hoc queries, and other forms of ad-hoc analysis and exploration.
  • Average cost of effort and services - $5 per every $1 spent on software (anecdotal evidence)
  • Average number of reports per small department - 100 (anecdotal evidence)
Read more

Where architects are spending their time

Alex Cullen

Where do architects spend their time, and is this where they should be spending it? I participated in a webinar this week hosted by Architecture & Governance magazine, along with George Paras. We discussed ‘the state of EA in 2010’ and the transformation of EA from a technology focus to a business focus. During this webinar, I showed this data from Forrester’s annual State of EA survey.

Read more

Web Content Management and Portal: Together at Last?

Stephen Powers

Just got back from the Lotusphere conference in Orlando (which sure beats Boston these days in the weather department – thanks, IBM!). At one of the sessions, IBM execs gave their take on the Web content management (WCM) and portal markets. Or should that be market? IBM is betting that the WCM and portal markets will converge and cease to be separate markets, with vendors offering combined WCM/portals suites that have one administrative tool set, one presentation management structure, one repository, and so on. From a road map standpoint, IBM is also making it clear that they don’t have a “portal plan” or a “WCM plan”, but rather an “experience” plan that includes both portal and WCM.

Will it really happen? Certainly, many intranets and extranets rely on content/experience delivery via portals. Also, many companies utilize public-facing Web sites for customer self service – a good fit for portal delivery. Already, SharePoint has made some noise with WCM and portal functionality within a single product. And given many firms’ clunky customized WCM/portal integrations, IBM can look attractive with its combination of Websphere portal and Lotus WCM.

So what are the obstacles to total WCM / portal convergence?

  • A good chunk of customer experience sites that still don’t necessarily need the user-customization and application consumption capabilities of a portal.
Read more

Case Study #6: Cisco Consumer Business Group (Formerly Linksys) Builds the Business Case for Social Media

Consumer Business Group (CBG) — formerly Linksys — is a division of Cisco that offers a wide variety of consumer and small office voice over IP (VoIP) and networking solutions such as routers, switches, and storage systems under the Linksys by Cisco brand. CBG has long held a reputation for excellent technical support and has developed a number of innovative approaches to contain support costs while still offering responsive service. One key initiative was the introduction of an online customer support community.

Read more

Case Study #4: Can You Get a Little Satisfaction? You Don't Have to Be Mick Jagger - Yola.com Did! Customer Service Social Media

If you have been following this blog, you might remember that I posted this a while back. But with the new year here, I thought it might be good to repeat some of the case studies while adding new ones... just incase you missed them or incase you wanted a refresher as you start down the path of providing a solution to your company social media needs!

Remember that great song... "Can't get no... Satisfaction..." Some how I think that is the national anthem of most customers. Why is it so freaking hard to get satisfaction?

Read more

What Does $100 Million Buy You? A Semantic Search Engine That Works.

Leslie Owens

The technical folks behind Monster.com invited me to visit last week. I somehow couldn’t convince them to show me any Superbowl ads but they did demo their cool new search engine. It’s based on technology they acquired when they bought Trovix in 2008. What can it do?

  • Understand the meaning of words: The search engine knows the difference between “development” in the fundraising context and “development” in the software context.
  • Appreciate the relationships between words: A custom ontology fortifies the search engine. The ontology rolls up skills like auditing into the larger category of finance. It differentiates between a top ranked school and a lower ranked school. It understands that years spent working as a prosecutor should count towards a candidate’s overall legal experience.
  • Cut text-heavy resumes into nimble content components: Recruiters can use the power resume search to compare candidates side-by-side, because the search mixes and normalizes the information into simple, clean categories like “Experience,” “Education,” and “Skills”.
Read more

Forrester DataByte: Spending On Custom Software in 2010

Jeffrey Hammond

I fielded an inquiry from a client last week who asked what levels of investment Forrester is seeing in custom software development, and whether that investment remains significant compared to other activities in IT, especially given the downward pressure we've seen on budgets in 2009. The request was timely, as I've started to comb through the results of our annual Enterprise And SMB Software Survey.

Read more

IBM's Project Vulcan: A Blueprint For Business Inbox Next

Ted Schadler

I can't deny it. Gmail intrigues me. No, not the idea of Web-based email client. That's old hat. Rather, it's that Gmail gives me a box of tools that taken together are my personal command and control center. Everything I need to be connected, get to appointments, find a friend, stay in touch, locate stuff I need, and remain on task is in one spot.

It's convenient. It's my inbox next. It's my touchstone for personal communications.

But at work, I'm using an email client, an IM client, a calendar client, a task list client, a microblogging client, a browser client, and a bunch of other applications. Just getting from one to another gives me a headache.

So where's my business Gmail?

From where I'm sitting, that's the mission of Project Vulcan. Read Ed Brill's post for the official IBM description of the vision of a hyperlinked, rapidly-evolving, highly tailorable, multi-modal inbox. I've spoken with Alistair Rennie, Lotus's new GM, and Kevin Kavanaugh, VP and head of Notes & Domino, about this project.

My take is that Project Vulcan is nothing less than IBM's blueprint for the future of business messaging and collaboration. In particular, it will:

 

  • Build on Lotus's market and technology foundations.
  • Unify many kinds of communication media and apps into a single frame
  • Provide an anchor point for employees' information work day.
  • Use Web deployment to rapidly experiment and learn what works. (Yes, it's a code fork.)
Read more

Looking backward and forward, virtually

Jennifer Belissent, Ph.D.

Train for Success hosted a panel discussion today in Second Life to both look back to 2009 and forward to 2010 and discuss observations and trends in virtual worlds.  The other panelists — Sam Driver of ThinkBalm and Doug Thompson of Remedy Communications — are really the experts on virtual worlds and all that is developing in and around them.  I spoke primarily about the rise of virtual event platforms, which the other panelists referred to as “pseudo 3D” environments.  Despite the denigrating nature of the label, I accepted that the platforms that I have focused on are less rich, and less interactive than Second Life and other “real” virtual worlds.  However, as my previous blog post indicates, that richness comes with a downside.  The barriers to entry are just too high for the use cases that the “pseudo” virtual environments have specialized in.  When using a virtual platform (of any kind) for marketing purposes, targeting a large and diverse audience, the “real” virtual environments just aren’t there yet.

However, I did want to share some of the observations that I made on the panel.  My comments were really based on adoption and use cases for “pseudo” virtual environment as tools for B2B marketers. Looking back at 2009, what did you see as highlights, lowlights, and trends in the virtual platform enterprise market?

Read more

Case Study #3: InfusionSoft Uses Social Media to Reduce Customer Service Costs

If you have been following this blog, you might remember that I posted this a while back. But with the new year here, I thought it might be good to repeat some of the case studies while adding new ones... just incase you missed them or incase you wanted a refresher as you start down the path of providing a solution to your company social media needs!

Read more