Not all outsourced IT options are the same

I thought the linked article below was interesting because it draws attention to the fact that not all cloud computing environments are the same.

http://infoworld.com/d/cloud-computing/the-rise-and-risk-the-composite-clouds-954?source=rss_infoworld_top_stories_

In fact, as the author (David Linthicum)  illustrates it is becoming more and more common for a provider to cobble together several different cloud computing environments to provide the customer a complete solution.

On the surface it’s not a bad idea, many of the business books that I’ve read support the notion that outsourcing non-core functions can free up people time and money that can be refocused on activities that contribute to an organization’s competitive advantage.

But it overlooks a fundamental risk. Outsourcing an application to a cloud operator cedes control. If the operator in-turn outsources part of the required infrastructure, it will also cedes some of its control. The net result is multiple points for performance issues and the potential for lots of finger pointing.

Outsourced IT doesn’t have the hype of Cloud Computing right now, but just like the cloud computing vendors in this article, many of the local outsourced IT providers in the Bay Area have sought out partnerships that allow them to offload functions such as help desk or routine server maintenance to other outsourced firms. Sometimes they even send the work off-shore to India or the Philippines.

And just like the cloud operators in this article, they are also creating multiple points in their delivery model that are ripe for error. It’s not a question of ability or capabilities; it’s a flaw in the delivery model that’s best illustrated by the saying, “Too many cooks in the kitchen.”

A leveraged approach forfeits one of the key benefits of an outsourced IT firm, namely is its ability to aggregate services such as help desk & network operations and then to take on sole responsibility for providing those services . Having complete control of the people, process and delivery technology eliminates the potential for finger pointing between software vendors, integrators and technology partners.

If an outsourced IT firm “partners” to provide reactive support, that means that some other firm has ultimate control over service delivery and it opens the door wide open to confusion and finger pointing. That’s why Endsight chose to keep help desk and network operations in-house. Its core to what we provide and it’s what our clients count on us to do for them.

The disposition of an Outsourced IT firm’s service organization is only one of the criteria that should be considered when evaluating a partner. I’ve included a link to a good article that list 14 questions to ask a potential technology partner.

http://www.managedservicesdirectory.com/information-technology-outsourcing/14-questions-to-ask-a-potential-technology-partner/

If you’re considering your options for computer system support, we’d very much like to hear from you. The best way to evaluate Endsight would be to set up an on-site visit. To set up an appointment click here.

Make sense of your data with pivot tables

I’ve used Microsoft Excel for years as a way to analyze a sales pipeline or as a way to clean up customer lists. I’ve even used many of the rudimentary functions and calculation tools to help me total the cost of a marketing budget or to calculate percentages. But that has really been the extent of my use of this tool.

I don’t think I’m alone in this. In fact, I’d bet that most of us only use a small percentage of the features and capabilities available in this tool. But as Endsight’s outsourced IT businesses has grown, it has become more and more important for us to analyze our business data and use that analysis to help us make good business decisions based on what we know instead of what we feel.

For example, as a sales and marketing professional it’s important for me to know where our best new business leads are coming from. On the surface that seems like a pretty simple question, but the answer requires a detailed analysis of Endsight’s historical sales and marketing data. My traditional methods for sorting and filtering data were inadequate and so I set out to learn some of the more advanced features available in Microsoft Excel. The feature that really helped me with my specific issue was pivot tables.

Pivot tables allow me to organize long lists of incomprehensible data into a concise dashboard view. It took me a few hours to learn how to create a pivot table, but once I got it down I’m certain it literally saved me days of work.

I found a web video on YouTube that was really helpful in teaching me to create pivot tables. I’ve included the video in his posting. You can also link to it by clicking here: http://www.youtube.com/watch?v=HVa7PIDfi5A

If you have a difficult question that you need to answer and you suspect some key insight to the question might reside in your historical business data, A pivot table could be useful in helping you smoke the answer out. If you feel like you might benefit from a more intensive training on Microsoft Excel it might make sense to consider signing up for a training class.

Endsight does some simple end-user training but it does not do intensive, classroom-based training for advanced users. We do however work with some great partners that can provide that service. If you’d like an introduction, e-mail me at jclause@endsight.net and I’ll be happy to connect you.

Related articles by Zemanta

• Excel data analysis with pivot tables, charts and slicers (techblissonline.com)
• PowerPivot for Excel 2010 - The ultimate data analysis add-in (techblissonline.com)