Over the last few weeks we’ve looked at how a range of social media tools can be used profitably. Now’s a suitable time to summarise the key ones relevant to business:
Twitter can be used to promote any business, especially B2C (business to consumer) if you can make it fun. You can just send messages, or include pictures, videos and links to web pages. Can be used for other purposes such as technical support. Try to converse with people, rather than just broadcast. See the “Twitter Away” blog for tips
Blogging tools such as Blogger (Google) and WordPress provide a place to self-publish articles on any topic relevant to your business. Comments from readers can produce a debate and engagement.
Facebook is where people play. Any business can take advantage, but again mainly B2C if you can make it fun. It is great to be interactive with followers/fans. The “Pages” function should be used for businesses, for example to distinguish your own posts from others.
FourSquare is one of several location-based systems, such as Gowalla, Facebook’s Places and MerchantCircle. Pubs, shops and other venues can provide linked incentives. Your business will usually be on there without you asking. You can welcome and encourage positive comments, but watch out for derogatory ones.
eCademy is more of a club for UK-based small businesses and solopreneurs. Useful if that is your market or you are looking for collaboration. Biznik is a US-based alternative
But LinkedIn has become the dominant place for professionals in industry and commerce. Other systems such as Plaxo and Fast Pitch trail behind.
MySpace provides specific functionality for musicians and other performance artists, such as gig lists, downloadable music and videos. Reverbnation is an alternative, or use both.
YouTube is great if video can play a part in your business. These can be embedded into websites and blogs, and linked from tweets on Twitter. Go for it!
There are many more, but that's enough to be getting on with!
.
For senior business management - looking at the benefits, issues and opportunities of business technology. We hope you find these articles useful and above all profitable!
Click here for further background Telephone +44(0) 7836 774439
Friday, 12 November 2010
Thursday, 11 November 2010
Escaping Excel Hell – Improving Month-End Reporting
It’s month end. Reports need to be produced. The finance team are ordering in pizza to get them through the evening. Why? The only way they can produce the information that Group and local management require is to download transaction data to a spreadsheet and reanalyse it. Sound familiar?
It’s not just at month-end. The same thing happens at other times of the month, whenever any other reports need to be produced. So-called “analysts” are spending too much of their time as “Excel jockeys” rather than using their business expertise to use the information they produce to drive business improvements. They are also more likely to move on quickly if they can, inevitably causing disruption that is best avoided.
Last week we asked whether databases were the ultimate Excel add-in. Whilst Excel’s pivot table capability can be very powerful, recently enhanced with PowerPivots in Excel 2010, Excel struggles with larger data volumes.
It’s times like this that a database comes into its own. It can be MS Access or MS SQL, which has multi-dimensional functionality in “Analysis Services”, or a multi-dimensional OLAP system. These can form the basis for far quicker and better analysis. In many cases (but not all) Excel can still be used as a front-end to take results and format them for presentation.
They key is that analysts need to be able to control their own system, and not have to wait for someone else to make any changes. This is why Excel is so popular. But most analysts are perfectly capable of building and maintaining the databases needed for reporting. Depending on the system used, this can also be used to improve budgeting and forecasting.
So why do so many businesses still only use Excel?
.
It’s not just at month-end. The same thing happens at other times of the month, whenever any other reports need to be produced. So-called “analysts” are spending too much of their time as “Excel jockeys” rather than using their business expertise to use the information they produce to drive business improvements. They are also more likely to move on quickly if they can, inevitably causing disruption that is best avoided.
Last week we asked whether databases were the ultimate Excel add-in. Whilst Excel’s pivot table capability can be very powerful, recently enhanced with PowerPivots in Excel 2010, Excel struggles with larger data volumes.
It’s times like this that a database comes into its own. It can be MS Access or MS SQL, which has multi-dimensional functionality in “Analysis Services”, or a multi-dimensional OLAP system. These can form the basis for far quicker and better analysis. In many cases (but not all) Excel can still be used as a front-end to take results and format them for presentation.
They key is that analysts need to be able to control their own system, and not have to wait for someone else to make any changes. This is why Excel is so popular. But most analysts are perfectly capable of building and maintaining the databases needed for reporting. Depending on the system used, this can also be used to improve budgeting and forecasting.
So why do so many businesses still only use Excel?
.
Wednesday, 10 November 2010
Strategic Business Planning - Turning Ideas into Reality
So you’ve come up with an idea for a business, within a corporate or independently. This may be into an established market, you may be planning to be disruptive by doing things differently in some way, or you want to market some new technology into a totally new market.
Commercialising technology is always interesting, whether it is what you are selling or what you are using to approach a market differently.
You’ve researched competitors, both direct and indirect, established there is a “pain” that produces a market worth pursuing, and identified the way you are going to approach it. You’ve clearly identified your customers or clients, and carried out segmentation of them to focus your efforts. Maybe you will focus on one town or region, or be looking to expand internationally.
If you’re in B2B (business to business), you’ve identified the roles of people, not just the businesses, and decided on which vertical markets (industries), horizontal (offering) and size you will target. Maybe you’re going for a niche which is the intersection of all three, if that market’s big enough. If not big enough, you’re spreading out on one of the three axes.
Maybe you’re looking at two seasonal businesses that between them cover most or all the year. Or some other combination, such as started Kent’s bus company, using the trucks to take farm produce to London markets overnight, and changing the body to take people to places in the day. Imagination counts.
You’ve got a first-cut marketing plan, your promotional mix, and reckon you can generate enough business from reasonable marketing spend to make it all worthwhile. You’ve looked at how you can leverage social media and other low cost techniques in addition to any major spend.
And now it’s time for the financials!
FINANCIALS
What is going to be your pricing? Would you be better off selling fewer at a higher price, or be more competitive and live off slimmer margins? The slimmer the margins, the tighter the systems need to be. Or is it a service where most of the costs are fixed, with the volume of subscriptions critical to success? Indeed what are the fixed and variable costs, and where is your breakeven point?
Will you be selling via retailers, resellers or other intermediaries? Can you get direct to end-customers via the internet or printed media, with a customer services team, or do you need a sales team on the ground? How much are you going to have to give away in sales commissions to agents or your own team, or how much margin will the wholesale/retail channel need? Will it be WIN-WIN for everyone? If not the business probably won’t succeed.
What staff and premises will you need? Can you work “virtually” with little or no business premises? How about associates and/or outsourcing rather than staff? If it’s a product, will you make it yourself or buy it in? Where does that leave you on patents and other intellectual property?
These questions are part of a set of 20 key aspects I recommend people to consider before launching a new business, as it either confirms what you are doing, or suggests you reconsider key aspects.
RAISING INVESTMENT
Inevitably a business will need some investment to get it off the ground. You’ll need to raise money internally, either from your own pocket or your company’s, or externally from banks and/or sources of equity capital. What about grants and other forms of government funding?
Putting the forecasts together is an art. You can use the back of an envelope or the seat of your pants if it’s your own money, and you can afford to lose it! But anything else needs a more formal approach. By setting up a model, you can vary aspects and see the effect on revenues, breakeven and cash needs.
A triad of P&L account, balance sheet and cash flow is best. Banks will often want to see a balance sheet, to identify assets that can be funded or used as security, and otherwise to identify the overall lending limit. Equity funders will be looking for substantial growth and how the cash needs change with different assumptions..
WHICH PLANNING TOOL?
A spreadsheet such as Excel can suffice for simple situations, otherwise a more sophisticated tool is best used to handle multiple contributors and/or multiple dimensions. There is now a choice of on-premise and cloud-based systems at a cost suitable for all sizes of business, as we discussed last week.
If you are planning the expansion of an existing business, then you’ll have historical information which is best forecast in a multi-dimensional tool. The alternative is a set of spreadsheets which will probably not add up correctly, however hard you try. The set will probably be “held together by sticking plaster” in the words of one of my clients who was trying to forecast a quoted group’s business through spreadsheets, and needed to do it differently!
NEXT STEPS
So before you go too far with your ideas, it’s worth assessing the business potential and to model the financials.
If you’d appreciate the help which Camwells can provide, do get in contact today.
Commercialising technology is always interesting, whether it is what you are selling or what you are using to approach a market differently.
You’ve researched competitors, both direct and indirect, established there is a “pain” that produces a market worth pursuing, and identified the way you are going to approach it. You’ve clearly identified your customers or clients, and carried out segmentation of them to focus your efforts. Maybe you will focus on one town or region, or be looking to expand internationally.
If you’re in B2B (business to business), you’ve identified the roles of people, not just the businesses, and decided on which vertical markets (industries), horizontal (offering) and size you will target. Maybe you’re going for a niche which is the intersection of all three, if that market’s big enough. If not big enough, you’re spreading out on one of the three axes.
Maybe you’re looking at two seasonal businesses that between them cover most or all the year. Or some other combination, such as started Kent’s bus company, using the trucks to take farm produce to London markets overnight, and changing the body to take people to places in the day. Imagination counts.
You’ve got a first-cut marketing plan, your promotional mix, and reckon you can generate enough business from reasonable marketing spend to make it all worthwhile. You’ve looked at how you can leverage social media and other low cost techniques in addition to any major spend.
And now it’s time for the financials!
FINANCIALS
What is going to be your pricing? Would you be better off selling fewer at a higher price, or be more competitive and live off slimmer margins? The slimmer the margins, the tighter the systems need to be. Or is it a service where most of the costs are fixed, with the volume of subscriptions critical to success? Indeed what are the fixed and variable costs, and where is your breakeven point?
Will you be selling via retailers, resellers or other intermediaries? Can you get direct to end-customers via the internet or printed media, with a customer services team, or do you need a sales team on the ground? How much are you going to have to give away in sales commissions to agents or your own team, or how much margin will the wholesale/retail channel need? Will it be WIN-WIN for everyone? If not the business probably won’t succeed.
What staff and premises will you need? Can you work “virtually” with little or no business premises? How about associates and/or outsourcing rather than staff? If it’s a product, will you make it yourself or buy it in? Where does that leave you on patents and other intellectual property?
These questions are part of a set of 20 key aspects I recommend people to consider before launching a new business, as it either confirms what you are doing, or suggests you reconsider key aspects.
RAISING INVESTMENT
Inevitably a business will need some investment to get it off the ground. You’ll need to raise money internally, either from your own pocket or your company’s, or externally from banks and/or sources of equity capital. What about grants and other forms of government funding?
Putting the forecasts together is an art. You can use the back of an envelope or the seat of your pants if it’s your own money, and you can afford to lose it! But anything else needs a more formal approach. By setting up a model, you can vary aspects and see the effect on revenues, breakeven and cash needs.
A triad of P&L account, balance sheet and cash flow is best. Banks will often want to see a balance sheet, to identify assets that can be funded or used as security, and otherwise to identify the overall lending limit. Equity funders will be looking for substantial growth and how the cash needs change with different assumptions..
WHICH PLANNING TOOL?
A spreadsheet such as Excel can suffice for simple situations, otherwise a more sophisticated tool is best used to handle multiple contributors and/or multiple dimensions. There is now a choice of on-premise and cloud-based systems at a cost suitable for all sizes of business, as we discussed last week.
If you are planning the expansion of an existing business, then you’ll have historical information which is best forecast in a multi-dimensional tool. The alternative is a set of spreadsheets which will probably not add up correctly, however hard you try. The set will probably be “held together by sticking plaster” in the words of one of my clients who was trying to forecast a quoted group’s business through spreadsheets, and needed to do it differently!
NEXT STEPS
So before you go too far with your ideas, it’s worth assessing the business potential and to model the financials.
If you’d appreciate the help which Camwells can provide, do get in contact today.
Tuesday, 9 November 2010
SaaS Cloud Computing – Selection Tips
SaaS cloud offerings vary greatly in standards. Depending on the specific application (app) and how business critical it is, it's worth carefully considering the following aspects of SaaS before you select a system:
Functionality – As with on-premise systems, establish overall context of a system and your key needs from it. Even if you can do free trials, assess breadth of functionality and other aspects of offerings carefully alongside trialing. Take nothing for granted. A formal specification is worthwhile, even if very brief, to provide the vision for selection and subsequent implementation
Time to Implement – Selection and acquisition can be quicker, but implementation itself is likely to be comparable to on-premise systems due to similarities in data conversion, change management etc. See selection and implementation processes.
Pilot Testing – SaaS is typically cheaper and easier, and less embarrassing to stop and try another system
Remote Access – It’s you as the customer that has responsibility to ensure adequate contingency arrangements for internet access at each location, including home workers. Is what you can arrange adequate for this application?
Backup, Recovery and Disaster Recovery – Typically far better with SaaS, but: (a) What backup exactly does provider do? (b) What is their policy for recovery? Can they just recover your/another's data if only yours/another's gets screwed, or does it have to affect everyone?
Location of Servers and Backup Servers - Establish current server locations, physical security, and provider's rights to change locations. Assess Data Protection Act and other legal/regulatory issues in each territory
System Availability - Any contractual SLAs (service level agreement commitments)?
Access Security - In addition to username + password, is there some extra method(s) such as PIN, memorable question, etc? If important to you, is access logged and auditable?
Encryption - Is data being sent to/from the server encrypted? Also consider whether data can be encrypted on the server, if you need it
Integration with Other Systems - Take nothing for granted - check need for integration, availability of capability in and out, and reliability
Configuration (using end-user functions) - Establish what you can change and what requires help from the provider e.g. VAT rate change
Customisation (additional custom-programming) – Not usually available within the app, but extras may be bolted on. If you require customisation now or possibly later, understand the options.
Upgrades - Is there any control over timing of upgrade? e.g. do you have a separate database, and/or are you given say 2 months to upgrade after new release becomes availabl
Upgrade Testing & Update of User Procedures - Does provider allow you to view/test a new release before it goes live? If so, can you use a copy of your data, to test transactions that are part-processed? How good are the release notes in detailing every change, not just new headline features?
Training Environment - Does provider allow additional space into which your live setup (and possibly data) can be copied for training purposes?
Purchase Cost – Typically monthly OpEx rather than up-front CapEx. But there may be a lump-sum payment up front, especially for the more sophisticated systems that require pre-sales consultancy
Adding Users – Usually easy but understand any minimum timescale commitment
Administration Time/Cost – Typically lower, but not zero. Still have admin of set-up such as leavers and joiners, plus fault resolution and management of provider
End Of Use (termination of contract) - Ensure you legally "own" data and there are tools to extract a copy in usable form whenever you require.
Supplier Financial Stability – Lower payments put additional financial strain on providers. Establish all parties in provider supply chain, back to hosting provider. Demise of any one of them could mean service withdrawn sooner rather than later. Check financial status of each party in supply chain.
If Provider Goes Out Of Business What safeguards does the provider offer, given the various members of the supply chain? Is it worth using two different systems in two parts of the business, with a tested transfer routine, so you can quickly switch systems if provider goes out of business? Or should you have a second system on stand-by on minimum subscription?
Control of Systems – It can be a relief to put your systems in the hands of an “expert” provider. But unless you are an important customer you will have little if any influence on commercial terms or day-to-day running. Understand sophistication or provider, and consider control issues.
IN CONCLUSION
As you assess each of these aspects, by comparison to equivalent aspects of any new or existing on-premise options, you can better assess whether each SaaS offering will be acceptable. Even an imperfect SaaS offering may be a lot better than the on-premise alternatives!
If in any doubt, do contact us.
.
Functionality – As with on-premise systems, establish overall context of a system and your key needs from it. Even if you can do free trials, assess breadth of functionality and other aspects of offerings carefully alongside trialing. Take nothing for granted. A formal specification is worthwhile, even if very brief, to provide the vision for selection and subsequent implementation
Time to Implement – Selection and acquisition can be quicker, but implementation itself is likely to be comparable to on-premise systems due to similarities in data conversion, change management etc. See selection and implementation processes.
Pilot Testing – SaaS is typically cheaper and easier, and less embarrassing to stop and try another system
Remote Access – It’s you as the customer that has responsibility to ensure adequate contingency arrangements for internet access at each location, including home workers. Is what you can arrange adequate for this application?
Backup, Recovery and Disaster Recovery – Typically far better with SaaS, but: (a) What backup exactly does provider do? (b) What is their policy for recovery? Can they just recover your/another's data if only yours/another's gets screwed, or does it have to affect everyone?
Location of Servers and Backup Servers - Establish current server locations, physical security, and provider's rights to change locations. Assess Data Protection Act and other legal/regulatory issues in each territory
System Availability - Any contractual SLAs (service level agreement commitments)?
Access Security - In addition to username + password, is there some extra method(s) such as PIN, memorable question, etc? If important to you, is access logged and auditable?
Encryption - Is data being sent to/from the server encrypted? Also consider whether data can be encrypted on the server, if you need it
Integration with Other Systems - Take nothing for granted - check need for integration, availability of capability in and out, and reliability
Configuration (using end-user functions) - Establish what you can change and what requires help from the provider e.g. VAT rate change
Customisation (additional custom-programming) – Not usually available within the app, but extras may be bolted on. If you require customisation now or possibly later, understand the options.
Upgrades - Is there any control over timing of upgrade? e.g. do you have a separate database, and/or are you given say 2 months to upgrade after new release becomes availabl
Upgrade Testing & Update of User Procedures - Does provider allow you to view/test a new release before it goes live? If so, can you use a copy of your data, to test transactions that are part-processed? How good are the release notes in detailing every change, not just new headline features?
Training Environment - Does provider allow additional space into which your live setup (and possibly data) can be copied for training purposes?
Purchase Cost – Typically monthly OpEx rather than up-front CapEx. But there may be a lump-sum payment up front, especially for the more sophisticated systems that require pre-sales consultancy
Adding Users – Usually easy but understand any minimum timescale commitment
Administration Time/Cost – Typically lower, but not zero. Still have admin of set-up such as leavers and joiners, plus fault resolution and management of provider
End Of Use (termination of contract) - Ensure you legally "own" data and there are tools to extract a copy in usable form whenever you require.
Supplier Financial Stability – Lower payments put additional financial strain on providers. Establish all parties in provider supply chain, back to hosting provider. Demise of any one of them could mean service withdrawn sooner rather than later. Check financial status of each party in supply chain.
If Provider Goes Out Of Business What safeguards does the provider offer, given the various members of the supply chain? Is it worth using two different systems in two parts of the business, with a tested transfer routine, so you can quickly switch systems if provider goes out of business? Or should you have a second system on stand-by on minimum subscription?
Control of Systems – It can be a relief to put your systems in the hands of an “expert” provider. But unless you are an important customer you will have little if any influence on commercial terms or day-to-day running. Understand sophistication or provider, and consider control issues.
IN CONCLUSION
As you assess each of these aspects, by comparison to equivalent aspects of any new or existing on-premise options, you can better assess whether each SaaS offering will be acceptable. Even an imperfect SaaS offering may be a lot better than the on-premise alternatives!
If in any doubt, do contact us.
.
Monday, 8 November 2010
News Update - Monday 8/11/10
Here's the pick of the last week's news stories that are likely to impact your business:
Bump or Grind – Options for digital business cards, or digitising others’ cards
The Growth of Mobile – commerce opportunities highlighted by Facebook
LibreOffice or OpenOffice – the consequences of Oracle’s acquisition of Sun
Poor broadband coverage – when you need better prime or contingency coverage:
Bump or Grind – Options for digital business cards, or digitising others’ cards
The Growth of Mobile – commerce opportunities highlighted by Facebook
LibreOffice or OpenOffice – the consequences of Oracle’s acquisition of Sun
Poor broadband coverage – when you need better prime or contingency coverage:
Labels:
BT,
bump,
libreoffice,
mobile,
openoffice,
virgin
Friday, 5 November 2010
Social Media - Profit from Twitter
Last week we looked at “How to Use and Abuse Twitter”. In the meantime an experienced CEO who is launching a new telecoms service emailed me ““I need to really understand the best use of Twitter, et al in business …. I believe it’s now a must do”.
The Twitter article, plus the broader one the week before on "How to Use and Abuse Social Media", both received very complementary reviews from people like comedian Ben Miller, who kindly tweeted about it..
But as I realised that neither article quite answered the CEO’s question, I used it as the inspiration for the next article I had been asked to write for "IT Counts", the online forum of the IT Faculty of the ICAEW (Chartered Accountants).
It’s fair to say that Twitter can be great fun at the personal level, with the chance to interact with famous people, as well as many other interesting people.
As the only cost at present is your time, it can also be profitable for a business when used in the right way. You can view the business-focused article on the Institute’s website here.
If you'd like to comment, and you are not a member of the IT faculty, please do so here.
.
The Twitter article, plus the broader one the week before on "How to Use and Abuse Social Media", both received very complementary reviews from people like comedian Ben Miller, who kindly tweeted about it..
But as I realised that neither article quite answered the CEO’s question, I used it as the inspiration for the next article I had been asked to write for "IT Counts", the online forum of the IT Faculty of the ICAEW (Chartered Accountants).
It’s fair to say that Twitter can be great fun at the personal level, with the chance to interact with famous people, as well as many other interesting people.
As the only cost at present is your time, it can also be profitable for a business when used in the right way. You can view the business-focused article on the Institute’s website here.
If you'd like to comment, and you are not a member of the IT faculty, please do so here.
.
Thursday, 4 November 2010
Escaping Excel Hell – The Ultimate Add-In?
It’s easy to outgrow Excel’s capabilities for a specific application. The only option is often to replace Excel with a system designed properly for the specific job.
There are other occasions where by using an add-in, such as gauges, you can achieve something valuable which you can’t do with Excel alone.
But often it makes sense for familiarity to use Excel linked to a database, for analysis and reporting of data, and sometimes for data entry, . This allows a system to be multi-user, or overcome some other restriction of Excel. A database of some kind is probably the ultimate add-in, as it can unlock a whole raft of possibilities.
At the simpler end of the spectrum you can link Excel to a Microsoft Access database, requiring skills that a typical systems accountant can master with a bit of training. At the other end are sophisticated OLAP systems where proper programming is required.
There are also a range of applications backed by a database, such as business planning, where you only need to configure them to achieve the results. Administration can be done by anyone capable of using Excel formulae and pivot tables.
So if you are finding that one or more of your Excel applications is stretched beyond reasonable limits, do take a look at the options available. Give us a call if you would like some help.
.
There are other occasions where by using an add-in, such as gauges, you can achieve something valuable which you can’t do with Excel alone.
But often it makes sense for familiarity to use Excel linked to a database, for analysis and reporting of data, and sometimes for data entry, . This allows a system to be multi-user, or overcome some other restriction of Excel. A database of some kind is probably the ultimate add-in, as it can unlock a whole raft of possibilities.
At the simpler end of the spectrum you can link Excel to a Microsoft Access database, requiring skills that a typical systems accountant can master with a bit of training. At the other end are sophisticated OLAP systems where proper programming is required.
There are also a range of applications backed by a database, such as business planning, where you only need to configure them to achieve the results. Administration can be done by anyone capable of using Excel formulae and pivot tables.
So if you are finding that one or more of your Excel applications is stretched beyond reasonable limits, do take a look at the options available. Give us a call if you would like some help.
.
Wednesday, 3 November 2010
KPIs – What’s Driving Your Business?
Sit down for your weekly business review and there is likely to be a page or screen full of numbers like revenue, order book and profit.
These are measures of results. But are you measuring what is driving your business? These are the true Key Performance Indicators (KPIs), or better called Key Performance Drivers (KPDs).
Depending on your business, these might be sales calls made, quote conversion ratio, credit notes, footfall, or staff turnover for example. Within business operations, there may be a whole set of performance measures like pickups per mile, absenteeism and success/error rates.
As CEO, it’s useful to consider the six top aspects driving your business that if measured, monitored and controlled will mean the right results will inevitably arise.
The same principle can then be applied to each director, and each manager across each aspect of the business. This hierarchy can be extended down as little or as much of the organisation as is relevant.
But it’s important to get the right measures to ensure they truly drive improved business performance. Ratios can be a real issue. For example revenue per employee will tend to arbitrarily drive down employee numbers rather than drive up revenue. The measure will encourage paying to automate or outsource activities that may actually be cheaper to do manually or in-house. There has to be a balanced set.
So what KPDs do you need to help drive your business in the right direction?
.
These are measures of results. But are you measuring what is driving your business? These are the true Key Performance Indicators (KPIs), or better called Key Performance Drivers (KPDs).
Depending on your business, these might be sales calls made, quote conversion ratio, credit notes, footfall, or staff turnover for example. Within business operations, there may be a whole set of performance measures like pickups per mile, absenteeism and success/error rates.
As CEO, it’s useful to consider the six top aspects driving your business that if measured, monitored and controlled will mean the right results will inevitably arise.
The same principle can then be applied to each director, and each manager across each aspect of the business. This hierarchy can be extended down as little or as much of the organisation as is relevant.
But it’s important to get the right measures to ensure they truly drive improved business performance. Ratios can be a real issue. For example revenue per employee will tend to arbitrarily drive down employee numbers rather than drive up revenue. The measure will encourage paying to automate or outsource activities that may actually be cheaper to do manually or in-house. There has to be a balanced set.
So what KPDs do you need to help drive your business in the right direction?
.
Tuesday, 2 November 2010
SaaS Cloud Computing – What Is It Really?
Whether you know what SaaS is, or are new to it, it’s worth taking a closer look. It's worth understanding the implications.
SaaS stands for “Software as a Service”. This is a type of “Cloud Computing” where the computing environment you use is run by a third-party “provider”.
A SaaS application (app) is accessed via an internet connection using a web browser such as Firefox, from any suitable internet-enabled device.
For applications (apps) where access is needed by customers or mobile staff, smaller businesses can get access to systems which they couldn’t possibly afford to run themselves. It can also be much cheaper for larger businesses, being OpEx rather than CapEx, and quicker to get started.
Examples of popular SaaS apps are internet trading (eCommerce), CRM (Customer Relationship Management) and any other apps used by staff on the move or from multiple locations. SaaS apps that could be run and used “on-premise” at a single location can also be used, where there are other cost or practical advantages.
“Software as a Service” means that rather than buy a licence to use software, which you install on your own systems, the hosting company runs it for you on their own servers. You typically pay a monthly fee, or a lump sum for a year or two. One downside implication is that if you stop paying, your access to the software will stop sooner rather than later.
Backup, Disaster Recovery, Location and Data Ownership
The hosting company will organise backup and disaster recovery. As the in-house procedures of many end-user businesses are poor or non-existent in these areas, SaaS can be a major upside advantage.
You should understand the location of the prime and backup servers, in terms of Data Protection or other regulations. After all, you remain responsible for your data.
Indeed, check that you “own” the data on the SaaS system, and have the means to extract it if you need, or preferably regularly as your own backup. Even Facebook has realised this and is now trumpeting their capability in this respect, as a SaaS provider of a social networking app.
Very often software authors will sub-contract the hosting aspect to a specialist hosting company. If you have bought the service via an intermediary, there can be quite a long “supply chain”. You need to understand all the parties involved, and carry out an appropriate level of due diligence especially financial, depending on the importance of the app involved. There are starting to be stories of hosting companies switching off end-users where the host hasn’t been paid by their own customer.
SaaS as a Software Package - Upgrades
SaaS apps are also “software packages”. They will typically provide configuration options similar to an on-premise package of equivalent complexity. If a supplier is saying it is simpler than on-premise package X, that probably means it is isn’t as powerful or flexible, much like a simpler on-prem package. Best to compare offerings in exactly the same way.
Software packages have to be upgraded. With SaaS, the package sits on one server so the author doesn’t have to worry about different server versions. With close access, they can also provide upgrades more frequently. Being smaller, the upgrades are easier to test, at least in theory. This translates into lower costs, and the savings can be reflected in pricing to end-users.
As a user, you don’t have to handle the upgrades. This situation is sold by SaaS providers as a major advantage. However there are some major drawbacks that are rarely written about, so worth a few extra words.
It is common for some or all user businesses to be sharing the same database and server(s). This means upgrades take place at one time, as suits the provider. That may not suit you, either because of events or financial calendars. You may also need to update working practices due to new or amended functionality.
New functionality can be a big problem if the first you can see of the new release is when it goes live. Does the SaaS provider let you view and possibly test each new release before it goes live? Can you set up a test/training environment? With set-up parameters and/or data copied from the live system?
Sadly bugs do slip through in any software change. Functions have also been known to disappear in a new release – from on-premise or SaaS software - the question is how important? Better to know in advance and have time to feedback to the provider, or at least plan around it in advance.
Indeed is there any choice of when your bit of the system is upgraded? Can the SaaS provider have two versions of the app running for a few days or weeks, and you choose when your data is transferred? That also means others can prove it before you use it.
A few SaaS providers, but not all, will offer to host the app on its own dedicated database, and possibly on a separate server which either they or you host. This can provide the flexibility you need on upgrades, and address any other concerns you have about sharing a database with other businesses. Obviously your preference all depends on the nature of the app and data, and its importance. Such options will always be more expensive, but possibly worth the investment.
Internet Access
Obviously an internet system will only work if you have access to the internet. Using only one method is a big risk. Contingency planning is something firmly in your court rather than the providers, and here are some tips.
Selection and Implementation
Many SaaS systems are sold as being simple and quick to implement. The simple ones are, but there are many similarities to traditional packaged software when it comes to aspects such as assessing suitability, and handling change management.
Here are comparisons of SaaS against on-premise for the two main phases:
In Conclusion
As indicated above, there is far more to SaaS than first meets the eye, plus a lot more I haven’t had chance to include here.
Whilst businesses will no doubt be tempted to do a DiY job, this can be very expensive if something important is overlooked or the wrong corner cut due to inexperience. The emergence of consultancies marketing themselves principally to re-implement well-known SaaS solutions is testament to that, much like on-premise apps.
Better and cheaper to get it right first time. If you’d like to discuss further, do give me a call on UK 01628 632914, or by email.
SaaS stands for “Software as a Service”. This is a type of “Cloud Computing” where the computing environment you use is run by a third-party “provider”.
A SaaS application (app) is accessed via an internet connection using a web browser such as Firefox, from any suitable internet-enabled device.
For applications (apps) where access is needed by customers or mobile staff, smaller businesses can get access to systems which they couldn’t possibly afford to run themselves. It can also be much cheaper for larger businesses, being OpEx rather than CapEx, and quicker to get started.
Examples of popular SaaS apps are internet trading (eCommerce), CRM (Customer Relationship Management) and any other apps used by staff on the move or from multiple locations. SaaS apps that could be run and used “on-premise” at a single location can also be used, where there are other cost or practical advantages.
“Software as a Service” means that rather than buy a licence to use software, which you install on your own systems, the hosting company runs it for you on their own servers. You typically pay a monthly fee, or a lump sum for a year or two. One downside implication is that if you stop paying, your access to the software will stop sooner rather than later.
Backup, Disaster Recovery, Location and Data Ownership
The hosting company will organise backup and disaster recovery. As the in-house procedures of many end-user businesses are poor or non-existent in these areas, SaaS can be a major upside advantage.
You should understand the location of the prime and backup servers, in terms of Data Protection or other regulations. After all, you remain responsible for your data.
Indeed, check that you “own” the data on the SaaS system, and have the means to extract it if you need, or preferably regularly as your own backup. Even Facebook has realised this and is now trumpeting their capability in this respect, as a SaaS provider of a social networking app.
Very often software authors will sub-contract the hosting aspect to a specialist hosting company. If you have bought the service via an intermediary, there can be quite a long “supply chain”. You need to understand all the parties involved, and carry out an appropriate level of due diligence especially financial, depending on the importance of the app involved. There are starting to be stories of hosting companies switching off end-users where the host hasn’t been paid by their own customer.
SaaS as a Software Package - Upgrades
SaaS apps are also “software packages”. They will typically provide configuration options similar to an on-premise package of equivalent complexity. If a supplier is saying it is simpler than on-premise package X, that probably means it is isn’t as powerful or flexible, much like a simpler on-prem package. Best to compare offerings in exactly the same way.
Software packages have to be upgraded. With SaaS, the package sits on one server so the author doesn’t have to worry about different server versions. With close access, they can also provide upgrades more frequently. Being smaller, the upgrades are easier to test, at least in theory. This translates into lower costs, and the savings can be reflected in pricing to end-users.
As a user, you don’t have to handle the upgrades. This situation is sold by SaaS providers as a major advantage. However there are some major drawbacks that are rarely written about, so worth a few extra words.
It is common for some or all user businesses to be sharing the same database and server(s). This means upgrades take place at one time, as suits the provider. That may not suit you, either because of events or financial calendars. You may also need to update working practices due to new or amended functionality.
New functionality can be a big problem if the first you can see of the new release is when it goes live. Does the SaaS provider let you view and possibly test each new release before it goes live? Can you set up a test/training environment? With set-up parameters and/or data copied from the live system?
Sadly bugs do slip through in any software change. Functions have also been known to disappear in a new release – from on-premise or SaaS software - the question is how important? Better to know in advance and have time to feedback to the provider, or at least plan around it in advance.
Indeed is there any choice of when your bit of the system is upgraded? Can the SaaS provider have two versions of the app running for a few days or weeks, and you choose when your data is transferred? That also means others can prove it before you use it.
A few SaaS providers, but not all, will offer to host the app on its own dedicated database, and possibly on a separate server which either they or you host. This can provide the flexibility you need on upgrades, and address any other concerns you have about sharing a database with other businesses. Obviously your preference all depends on the nature of the app and data, and its importance. Such options will always be more expensive, but possibly worth the investment.
Internet Access
Obviously an internet system will only work if you have access to the internet. Using only one method is a big risk. Contingency planning is something firmly in your court rather than the providers, and here are some tips.
Selection and Implementation
Many SaaS systems are sold as being simple and quick to implement. The simple ones are, but there are many similarities to traditional packaged software when it comes to aspects such as assessing suitability, and handling change management.
Here are comparisons of SaaS against on-premise for the two main phases:
In Conclusion
As indicated above, there is far more to SaaS than first meets the eye, plus a lot more I haven’t had chance to include here.
Whilst businesses will no doubt be tempted to do a DiY job, this can be very expensive if something important is overlooked or the wrong corner cut due to inexperience. The emergence of consultancies marketing themselves principally to re-implement well-known SaaS solutions is testament to that, much like on-premise apps.
Better and cheaper to get it right first time. If you’d like to discuss further, do give me a call on UK 01628 632914, or by email.
Monday, 1 November 2010
News Update - Monday 1/11/10
Here's the pick of the last week's news stories that are likely to impact your business:
Mobile Advertising Industry to Reach $24 Billion by 2015 Could your business benefit?
Rumours point to 2012 release date for Windows 8 With Windows 7 relatively new, it looks it will be at least a couple of years into 2012 before Windows 8 appears. But how about using Linux for the desktop?
BT broadband outage is fixed As some 20,000 homes and businesses were without BT broadband, a reminder about contingency options
Virgin cable offers 100MBit/s broadband BT cable only offering 40MBit/s. Remember to add BT line rental to monthly cost to compare
Mobile Advertising Industry to Reach $24 Billion by 2015 Could your business benefit?
Rumours point to 2012 release date for Windows 8 With Windows 7 relatively new, it looks it will be at least a couple of years into 2012 before Windows 8 appears. But how about using Linux for the desktop?
BT broadband outage is fixed As some 20,000 homes and businesses were without BT broadband, a reminder about contingency options
Virgin cable offers 100MBit/s broadband BT cable only offering 40MBit/s. Remember to add BT line rental to monthly cost to compare
Friday, 29 October 2010
How You Can Use And Abuse Twitter
Last week we looked at various aspects of social media. One of the “cons” was the need for CONversation. This is none more true than on Twitter, where you can tweet to the whole world, or send a tweet to one individual person.
It was @davegorman the comedian, if I remember rightly, who retweeted a few weeks ago that you should only ever tweet like you would talk to someone across the table in the pub or at a meal. That means being mindful how well you know that person.
When tweeting to an individual, especially someone who doesn’t know you, there’s no excuse for being rude. There’s also no excuse for overdoing the number of tweets you send to them. How would you react to receiving them? Overdoing it is just like the pub bore.
Public tweets are not like being on a stage, but rather like standing atop a table in the pub with a megaphone. What would you say? How would you say it?
How often is also important. Some followers will dip into the river of Twitter only occasionally, some are logged in permanently. You need to send the message at regular intervals to catch the occasionals, preferably in different words to avoid boring the faithful. It’s also best to mix up a number of different messages. There are a variety of tools that can let you pre-schedule tweets to be issued automatically, so some of your tweets can be pre-planned.
Every celebrity wants to tell people about their latest book, music track, TV or other public appearance. Every business wants to tell people about their products, services and latest offers. But people will only put up with this so long, unless you offer something else. Followers you've carefully attracted can so easily “unfollow” and then not see what you are saying.
For celebrities and businesses, what makes Twitter powerful is the ability to interact with your followers. Conversely anyone can interact with the people you follow. Those celebrities and businesses who take the time to reply to the tweets they receive, in suitable voice, will better thrive.
Genuine complaints are always an opportunity to build a closer relationship from the way the issue is fixed. (Maybe not like this: Robert Fripp of King Crimson received a complaint some years ago when he played from the wings at a gig that he had only been seen for a third of the time. So apparently he returned two thirds of the ticket price and told the person never to attend again! If you want notereity ....)
Conversely, receiving rude tweets can be a shock, and getting too many from one person can be a real pain. The more followers you have, the more nutters. You have to decide whether to block them. It’s a great sense of power when you do!
There’s also various ways of issuing tweets. For example Heikki Kovalainen the Formula 1 racing driver (@H_Kovalainen) has been keeping us posted about what’s happening over the Grand Prix weekend. This week he has sent out a competition posted on Facebook. He will select some of the people who enter and ring them personally. If they tell him the right passphrase, then he'll send them a signed poster. That’s engaging with fans in a way unthinkable just a few months ago.
The prize could also be a free book (if that’s what you are promoting), a free ticket, a free meal with you the celebrity (if you can stomach the idea!), or a whole host of other possibilities.
Businesses can educate or enlighten with the use of free tips sheets and articles, or any manner of other offerings. Surveys are another idea. Even if the response rate is low, the offer to converse shows a more positive attitude than just shout-tweeting at people.
Actually none of these underlying ideas are especially new. The usual rules of marketing are little changed. What has changed is the possibilities social media has to have much closer, much quicker, real-time interaction with fans and followers.
The great thing about Twitter and social media generally is there are no rules for what you can do, only a few for what you shouldn’t. Imagination can run riot. Enjoy!
.
It was @davegorman the comedian, if I remember rightly, who retweeted a few weeks ago that you should only ever tweet like you would talk to someone across the table in the pub or at a meal. That means being mindful how well you know that person.
When tweeting to an individual, especially someone who doesn’t know you, there’s no excuse for being rude. There’s also no excuse for overdoing the number of tweets you send to them. How would you react to receiving them? Overdoing it is just like the pub bore.
Public tweets are not like being on a stage, but rather like standing atop a table in the pub with a megaphone. What would you say? How would you say it?
How often is also important. Some followers will dip into the river of Twitter only occasionally, some are logged in permanently. You need to send the message at regular intervals to catch the occasionals, preferably in different words to avoid boring the faithful. It’s also best to mix up a number of different messages. There are a variety of tools that can let you pre-schedule tweets to be issued automatically, so some of your tweets can be pre-planned.
Every celebrity wants to tell people about their latest book, music track, TV or other public appearance. Every business wants to tell people about their products, services and latest offers. But people will only put up with this so long, unless you offer something else. Followers you've carefully attracted can so easily “unfollow” and then not see what you are saying.
For celebrities and businesses, what makes Twitter powerful is the ability to interact with your followers. Conversely anyone can interact with the people you follow. Those celebrities and businesses who take the time to reply to the tweets they receive, in suitable voice, will better thrive.
Genuine complaints are always an opportunity to build a closer relationship from the way the issue is fixed. (Maybe not like this: Robert Fripp of King Crimson received a complaint some years ago when he played from the wings at a gig that he had only been seen for a third of the time. So apparently he returned two thirds of the ticket price and told the person never to attend again! If you want notereity ....)
Conversely, receiving rude tweets can be a shock, and getting too many from one person can be a real pain. The more followers you have, the more nutters. You have to decide whether to block them. It’s a great sense of power when you do!
There’s also various ways of issuing tweets. For example Heikki Kovalainen the Formula 1 racing driver (@H_Kovalainen) has been keeping us posted about what’s happening over the Grand Prix weekend. This week he has sent out a competition posted on Facebook. He will select some of the people who enter and ring them personally. If they tell him the right passphrase, then he'll send them a signed poster. That’s engaging with fans in a way unthinkable just a few months ago.
The prize could also be a free book (if that’s what you are promoting), a free ticket, a free meal with you the celebrity (if you can stomach the idea!), or a whole host of other possibilities.
Businesses can educate or enlighten with the use of free tips sheets and articles, or any manner of other offerings. Surveys are another idea. Even if the response rate is low, the offer to converse shows a more positive attitude than just shout-tweeting at people.
Actually none of these underlying ideas are especially new. The usual rules of marketing are little changed. What has changed is the possibilities social media has to have much closer, much quicker, real-time interaction with fans and followers.
The great thing about Twitter and social media generally is there are no rules for what you can do, only a few for what you shouldn’t. Imagination can run riot. Enjoy!
.
Thursday, 28 October 2010
Escaping Excel Hell - Planning, Forecasting or Budgeting?
In marketing, there are a number of words that illicit a positive response. "Profit" "Free" and "New" are just three examples
So what reaction do you give to these three words:
But planning, forecasting and budgeting are all important. You may indeed use the same Excel model for all three. If you are you're likely to find:
.
So what reaction do you give to these three words:
- Planning?
- Forecasting?
- Budgeting?
But planning, forecasting and budgeting are all important. You may indeed use the same Excel model for all three. If you are you're likely to find:
- Issues with multiple users
- Difficulty in ensuring the models don't break
- Uncertainty whether the model calculates or adds up correctly, within a sheet or when sheets are added together
- Impossible to handle more than a few products or dimensions such as geographical areas
- Multiple versions that are soon out of control
- Needing to link P&L to balance sheet and cash flow, especially if funds need to be raised
- Far too much time spent overcoming these issues
.
Wednesday, 27 October 2010
Business Performance Management - Commentary in less than 140 Characters?
Management reporting can be figures, graphics and gauges. But to bring these figures into perspective, commentary helps. Why? Where? How? to go with the When? and What? of the figures.
It helps to keep the commentary short and succinct for busy readers. One great technique is to write "tweets" no longer than 140 characters.
The paragraph above is exactly 140 characters. Not on Twitter itself obviously, but 140C is a good length for a cell in Excel, a line on a dashboard, or a line in some other form of report. This doesn't have to be an absolute limit as with Twitter, but it's a useful target.
Expressing an idea in 140C or less is a skill to cultivate. Practice makes perfect!
.
It helps to keep the commentary short and succinct for busy readers. One great technique is to write "tweets" no longer than 140 characters.
The paragraph above is exactly 140 characters. Not on Twitter itself obviously, but 140C is a good length for a cell in Excel, a line on a dashboard, or a line in some other form of report. This doesn't have to be an absolute limit as with Twitter, but it's a useful target.
Expressing an idea in 140C or less is a skill to cultivate. Practice makes perfect!
.
Tuesday, 26 October 2010
SaaS Cloud Computing - Why oh Why?
SaaS Cloud computing (Software as a Service) offers many benefits. But like many things in life, it isn't perfect.
The key benefits of SaaS compared to on-premise packages include:
Further details are in previous articles.
.
The key benefits of SaaS compared to on-premise packages include:
- Faster implementation, due to differences in selection process and physical procurement. (Note: Implementation itself is little different for a system of equivalent complexity)
- Improved backup and disaster recovery (typically, by comparison to many organisations large and small)
- Remote access from anywhere in the world that offers internet access
- Reduced costs up-front, as OpEx rather than CapEx
- Potentially power admin costs and hassle through no need to have the staff to administer the system and database (although you'll still need basic app administration such as adding and removing users)
- Loss of management control, as with any outsourcing arrangement, unless you are a major customer of the app supplier and can exert superior influence
- Reliance on an internet connection, for which at least two types of connection at each location is recommended so one acts as a contingency
- Access security, especially for any apps that rely just on username and password (Why don't more SaaS systems offer at least an optional third level, such as an easily-memorable security question or numeric grid?)
Further details are in previous articles.
.
Monday, 25 October 2010
News Update - Monday 25/10/10
Here's the pick of the last week's news stories that are likely to impact your business:
Comprehensive Spending Review The dominant news story in the UK has been the coalition’s CSR. Apat from anything else, more opportunities for IT in government, to drive down costs?
Consumer technology trends - a 4-year view 4G, videos and privacy
Apple puts iOS functions from iPhone onto Mac Will this encourage iPhone and iPad users to move from PC to Macs?
Online spend still on increase Brighter outlook for e-tailers?
New IBM cloud consultancy Issues for corporates and SMEs alike. See the Cloud articles
Comprehensive Spending Review The dominant news story in the UK has been the coalition’s CSR. Apat from anything else, more opportunities for IT in government, to drive down costs?
Consumer technology trends - a 4-year view 4G, videos and privacy
Apple puts iOS functions from iPhone onto Mac Will this encourage iPhone and iPad users to move from PC to Macs?
Online spend still on increase Brighter outlook for e-tailers?
New IBM cloud consultancy Issues for corporates and SMEs alike. See the Cloud articles
Friday, 22 October 2010
How You Can Use And Abuse Social Media
Every now and then I hear a presentation that is spot on and extremely valuable.
This week I saw Mark Lee do a talk titled “How Accountants Can Use And Abuse Social Media”. But the talk could easily have been for anyone in business.
He looked at three leading US-based worldwide systems (LinkedIn, Facebook and Twitter) plus Ecademy based in the UK. He made a number of excellent observations from a business standpoint:
1. Understand where existing and potential customers, clients and partners “hang out”
2. Social Media is about building relationships, over time
3. So social media is unlikely to provide a quick business return, but can do sooner or later if used well. It’s easy to expect too much and give up too soon.
4. Social media is a “con”
5. To that end:
6. Bear in mind that people:
.
This week I saw Mark Lee do a talk titled “How Accountants Can Use And Abuse Social Media”. But the talk could easily have been for anyone in business.
He looked at three leading US-based worldwide systems (LinkedIn, Facebook and Twitter) plus Ecademy based in the UK. He made a number of excellent observations from a business standpoint:
1. Understand where existing and potential customers, clients and partners “hang out”
- Forums
- LinkedIn etc
2. Social Media is about building relationships, over time
- Firstly know,
- Then like (preferably),
- Then trust,
- Only then do business
3. So social media is unlikely to provide a quick business return, but can do sooner or later if used well. It’s easy to expect too much and give up too soon.
4. Social media is a “con”
- CONversation
- CONtent
- CONsistency
- CONnecting
- CONsideration
- CONgratulating
5. To that end:
- Enlighten,
- Educate
- Entertain
- Ask questions
- Answer questions on forums
- Reply to what you are sent
6. Bear in mind that people:
- “Use” LinkedIn for professional purposes
- “Play on” Facebook principally for friendship and fun, so more suitable for marketing B2C than B2B
- “Tweet on” Twitter for personal or business through separate accounts (though some people are successful doing both on one account)
- “Belong to” eCademy, typically if they are small businesses or solopreneurs
.
Thursday, 21 October 2010
Escaping Excel Hell - Unlocking Business Growth
Excel's a great way of making simple lists. So if you are trying to track sales orders or purchase orders, it's tempting to do it in Excel if you only have an accounting system.
Then the business grows a little. Two people are now trying to share a spreadsheet. That proves impractical so it is split into two halves. Then they are pulled together to report. Then a third person is needed ....
Before you know it there is a spider's web of spreadsheets, with links that sometimes work, and a whole raft of manual processes to control the business. Sound familiar?
That's what I found just before Christmas one year when I walked into a small quoted company's admin room to be greeted as if I were Father Christmas. The team leader had threatened to resign, and the Financial Controller had done their best without making any real progress (lack of time as much as a lack of experience).The Group Finance Director had spoken to a client of mine and had been given my name.
I had previously managed the implementation of an order processing system that had allowed the business to grow 10 fold with minimal increase in staff. This linked sales orders back to back with purchase orders. So when one supplier offered a discount for equipment supplied to certain cusetomers, it was simple to make the claim. £600,000 a year, doubling profits. Now that's a return on investment!
We worked with this second company to define their needs, including resolving disagreements between the senior management that an outsider could do far more effectively. The system implemented not only transformed the admin team, but meant that when the company was taken over, unusually it was this team and this system that was used by the enlarged group. The other team were made redundant. It could so easily have been the other way around!
There's nothing like happy clients!
.
Then the business grows a little. Two people are now trying to share a spreadsheet. That proves impractical so it is split into two halves. Then they are pulled together to report. Then a third person is needed ....
Before you know it there is a spider's web of spreadsheets, with links that sometimes work, and a whole raft of manual processes to control the business. Sound familiar?
That's what I found just before Christmas one year when I walked into a small quoted company's admin room to be greeted as if I were Father Christmas. The team leader had threatened to resign, and the Financial Controller had done their best without making any real progress (lack of time as much as a lack of experience).The Group Finance Director had spoken to a client of mine and had been given my name.
I had previously managed the implementation of an order processing system that had allowed the business to grow 10 fold with minimal increase in staff. This linked sales orders back to back with purchase orders. So when one supplier offered a discount for equipment supplied to certain cusetomers, it was simple to make the claim. £600,000 a year, doubling profits. Now that's a return on investment!
We worked with this second company to define their needs, including resolving disagreements between the senior management that an outsider could do far more effectively. The system implemented not only transformed the admin team, but meant that when the company was taken over, unusually it was this team and this system that was used by the enlarged group. The other team were made redundant. It could so easily have been the other way around!
There's nothing like happy clients!
.
Wednesday, 20 October 2010
VAT Rate Increase in January 2011 – Why's it Different?
With the “Comprehensive Spending Review” ringing in our ears, it’s easy to forget that there will be an increase of standard-rate VAT to 20% on 4 January next year.
This is no doubt painful for you if you live in the UK. But for businesses trading in the UK, it’s easy to think this is just a repeat of the last increase this last January. It’s not. There will be several different consequences for systems and commercial arrangements, such as: [...read more...]
This is no doubt painful for you if you live in the UK. But for businesses trading in the UK, it’s easy to think this is just a repeat of the last increase this last January. It’s not. There will be several different consequences for systems and commercial arrangements, such as: [...read more...]
Choice in Multi-Dimensional Planning and Reporting
There are a great number of multi-dimensional OLAP (OnLine Analytical Programming) software tools. These are changing all the time. At Softworld on Tuesday I was talking to various vendors to keep up to date with the leaders.
Cognos bought Applix and their TM1 OLAP tool just before Cognos was bought by IBM. Cognos already had a suite of planning and reporting tools they had brought together, including what was Adaytum Planning. Now they are taking the best of each to produce a new set of tools.
Microsoft's SQL Server database is commonly used in business packages, and is a popular tool for custom development. SQL has a facility called "Analysis Services" (AS) which provides multi-dimensional reporting. As each version of SQL appears, so AS improves.
Microsoft also had planning functionality in PerformancePoint. But that was lost virtually overnight when the product was rolled into SharePoint early last year, leaving users high and dry.
Other tools such as PowerOLAP (developed by a former TM1 reseller) also provides multi-dimensional reporting, but is better for planning than AS.
Whilst these tools can be used in SMEs and corporates, there are Business Intelligence tools priced for larger organisations that also provide multi-dimensional functions.
The right tool depends on use, the number of items in each dimension (such as the number of products) and the number of rows of data (such as sales transactions). Horses for courses!
.
Cognos bought Applix and their TM1 OLAP tool just before Cognos was bought by IBM. Cognos already had a suite of planning and reporting tools they had brought together, including what was Adaytum Planning. Now they are taking the best of each to produce a new set of tools.
Microsoft's SQL Server database is commonly used in business packages, and is a popular tool for custom development. SQL has a facility called "Analysis Services" (AS) which provides multi-dimensional reporting. As each version of SQL appears, so AS improves.
Microsoft also had planning functionality in PerformancePoint. But that was lost virtually overnight when the product was rolled into SharePoint early last year, leaving users high and dry.
Other tools such as PowerOLAP (developed by a former TM1 reseller) also provides multi-dimensional reporting, but is better for planning than AS.
Whilst these tools can be used in SMEs and corporates, there are Business Intelligence tools priced for larger organisations that also provide multi-dimensional functions.
The right tool depends on use, the number of items in each dimension (such as the number of products) and the number of rows of data (such as sales transactions). Horses for courses!
.
Tuesday, 19 October 2010
SaaS Cloud Computing - The Security Question
Earlier today I attended a session at Softworld about Cloud Computing. This had a panel of users and vendors (providers). What was clear when they contradicted each other was that even these "experts" don't know all they need to know about cloud computing - and I mean "need to know", if they (and you) are to gain the benefits without excessive pain at some stage.
That's not a criticism of these people, as the cloud is a relatively new fangled thing. However for those of us who have been using SaaS (Software as a Service) applications in front line business for over ten years, we have had our parts bitten, and know first hand what matters.
One of the comments that remained unchallenged was on the matter of security, in terms of access. This was along the lines of that old chestnut "We've been using internet banking for years, so SaaS is safe." We've also been using SaaS ervices such as Hotmail, and every now and again it and similar systems get hacked.
The difference? Like GoogleMail and many others, Hotmail relies only on a userid and password, where the userid is public knowledge - typically the email address. Many business SaaS systems similarly only use a userid and password. At the other end of the spectrum, the banks have at least one extra level of security, such as random digits from a PIN or second password, and/or the need for a physical device. Chalk and cheese.
So what does a confidential application like payroll use? Dennis Keeling gave the opening keynote address at Softworld this morning. Turns out he is an HR and payroll specialist, as part of a broad knowledge of the packaged software market. He tells me that for larger organisations, remote access to payroll services is typically by userid and password, but always in combination with a "private cloud" secure internet pipe. Without that, he would expect some additional level of security, such as random digits from a pin number (like some of the banks do).
For smaller businesses, here are a number of internet payroll services. These talk about various security methods, such as 128-bit SSL (secure socket layer) encryption, as is used by the banks. Nonetheless.here are some incidents of web payroll systems being hacked, to try and make immediate fraudulent electronic payments.
In an ordinary accounting system, there is often an equivalent mechanism for supplier and staff expenses payments. Good access security in these systems is therefore vital.
IN CONCLUSION
A simple user id and password is not as secure as the internet banking systems, nor as secure as the better payroll systems.
There will be many applications in a business where a userid and password combination is adequate, given the low potential consequences of unauthorised access. But there will also be applications, such as Accounts Payable, where some additional level of access security is a must.
For more "myth busting", see last week's article "SaaS Cloud Computing - The Hype, The Truth and The Wardrobe"
.
That's not a criticism of these people, as the cloud is a relatively new fangled thing. However for those of us who have been using SaaS (Software as a Service) applications in front line business for over ten years, we have had our parts bitten, and know first hand what matters.
One of the comments that remained unchallenged was on the matter of security, in terms of access. This was along the lines of that old chestnut "We've been using internet banking for years, so SaaS is safe." We've also been using SaaS ervices such as Hotmail, and every now and again it and similar systems get hacked.
The difference? Like GoogleMail and many others, Hotmail relies only on a userid and password, where the userid is public knowledge - typically the email address. Many business SaaS systems similarly only use a userid and password. At the other end of the spectrum, the banks have at least one extra level of security, such as random digits from a PIN or second password, and/or the need for a physical device. Chalk and cheese.
So what does a confidential application like payroll use? Dennis Keeling gave the opening keynote address at Softworld this morning. Turns out he is an HR and payroll specialist, as part of a broad knowledge of the packaged software market. He tells me that for larger organisations, remote access to payroll services is typically by userid and password, but always in combination with a "private cloud" secure internet pipe. Without that, he would expect some additional level of security, such as random digits from a pin number (like some of the banks do).
For smaller businesses, here are a number of internet payroll services. These talk about various security methods, such as 128-bit SSL (secure socket layer) encryption, as is used by the banks. Nonetheless.here are some incidents of web payroll systems being hacked, to try and make immediate fraudulent electronic payments.
In an ordinary accounting system, there is often an equivalent mechanism for supplier and staff expenses payments. Good access security in these systems is therefore vital.
IN CONCLUSION
A simple user id and password is not as secure as the internet banking systems, nor as secure as the better payroll systems.
There will be many applications in a business where a userid and password combination is adequate, given the low potential consequences of unauthorised access. But there will also be applications, such as Accounts Payable, where some additional level of access security is a must.
For more "myth busting", see last week's article "SaaS Cloud Computing - The Hype, The Truth and The Wardrobe"
.
Monday, 18 October 2010
News Update - Monday 18/10/10
Here's the pick of the last week's news stories that are likely to impact your business:
Cloud or Linux Chalk and cheese perhaps, but having started to run a Linux laptop with MS Office 2007 and other Windows apps, interesting that larger organisations are taking a shine to Linux rather than the cloud. The new Ubuntu10.10 release of Linux is getting good reviews
Using social media in the workplace Balancing social medai use with time-wasting and security issues
Facebook Credits (global virtual currency) How can your business leverage virtual currencies like this?
"Everything Everywhere" The new name for the combination of Orange and T-mobile in the UK, who have just amalgamated their voice networks (#importantbutstiflesyawn)
Windows Phone 7 launches I feel duty bound to mention this, even though Windows Phone 7 has nothing to do with Windows 7 for PCs . How well will it compete with Android, iPhones and the rest?
P.S. Apologies for the delay in this edition of the news update. I upgraded Norton AntiVirus on Sunday morning 17th, and with hours of technical help, finally got use back to the PC at 6pm Monday evening. I had to monitor what the technician was doing (and deleting!) on the PC, so couldn't do anything much else. In any case the reserve PC also suffered a similar but different problem with Norton 360. C'est la vie, or time for a change would you say?
.
Cloud or Linux Chalk and cheese perhaps, but having started to run a Linux laptop with MS Office 2007 and other Windows apps, interesting that larger organisations are taking a shine to Linux rather than the cloud. The new Ubuntu10.10 release of Linux is getting good reviews
Using social media in the workplace Balancing social medai use with time-wasting and security issues
Facebook Credits (global virtual currency) How can your business leverage virtual currencies like this?
"Everything Everywhere" The new name for the combination of Orange and T-mobile in the UK, who have just amalgamated their voice networks (#importantbutstiflesyawn)
Windows Phone 7 launches I feel duty bound to mention this, even though Windows Phone 7 has nothing to do with Windows 7 for PCs . How well will it compete with Android, iPhones and the rest?
P.S. Apologies for the delay in this edition of the news update. I upgraded Norton AntiVirus on Sunday morning 17th, and with hours of technical help, finally got use back to the PC at 6pm Monday evening. I had to monitor what the technician was doing (and deleting!) on the PC, so couldn't do anything much else. In any case the reserve PC also suffered a similar but different problem with Norton 360. C'est la vie, or time for a change would you say?
.
Friday, 15 October 2010
Social Media - Twitter Tips for Newbies, Noobs and the More Experienced
I’m often asked how to use Twitter. Carol Vorderman recently tweeted a question about who can see the messages ("tweets") she sends to specific people. So here are a few tips on this and other subjects.
These tips apply whether you are tweeting in a business or personal capacity, and are for the more experienced as well as for newbies:
(1) How long should a tweet be?
You probably know that each Twitter message or "Tweet" is not more than 140 characters. This is deliberately 20 shorter than SMS text messages, to allow SMS to be used with space for usernames and acronyms that start tweets, e.g. DM (direct message) and RT (re-tweet).
Tweets can therefore be sent from mobile phones using SMS, as was common originally. Now the smartphones have their own Twitter “apps” to view and send tweets.
But if you keep your tweets to 70-120 characters (leaving 20-70 characters spare). your tweets can more easily be re-tweeted by other people. This is because "RT" and your username is added to the re-tweet (see below).
(2) Views of the TimeLine
Whichever app you use, the tweets you see are just a selection from the master list of tweets called the “timeline”.
Using Twitter is like looking at the master timeline through a grill. Change the grill slightly, by changing the people you follow or by doing a search, and you’ll see a different set of tweets.
(3) Direct Messages
If you start a tweet “DM @someone” then only the someone will see it. Unlike "replies", DMs do not show in the public list of tweets for your account, nor in searches.
“DM” can be typed manually, as long as it is at the very start, or by using a “Direct Message” facility. (In “New Twitter” it is just called “Message”.)
You can only DM to an account (person) which is following the account you are using at the time.
However when they reply to you, depending on the app they use, it may come back as a DM or a public reply. Indeed they can copy and paste it into a new tweet. So best to assume that anything tweeted, by any method, is in the “public domain”. (The same of course applies to emails – I’m amazed at what gets forwarded to me, further down the email, that the original author certainly didn’t expect to go beyond the original recipient !)
(4) Replies and public messages
If you start a tweet "@someone", as happens automatically with a "reply", then normally only that person will see it. However there are two exceptions to this:
Note that if you put one or more characters (such as a space) before the @username, then all your followers will see the tweet.
When replying, consider copying some or all the original tweet into your reply, so the reply makes sense to the original tweeter.
Some apps have a “See Conversation” button which links a tweet into an intelligible series of replies.
(5) Re-tweeting
If there’s a tweet you’d like to copy to your followers, (as it’s funny, informative or whatever), then you can “re-tweet” it. This adds “RT” and the original tweeter’s username at the start.
As mentioned above, it is therefore worth keeping your own tweets to 70-120 characters (leaving 20-70 characters spare).so your tweets can more easily be re-tweeted by other people.
Some apps let you edit the re-tweet and add comments. Or you can copy and paste it into a new tweet, together with the author's username, and manually start it "RT".
(6) Usernames
The username you use to login is fundamental to your Twitter existence. As far as possible keep the username the same as you “real name” which is also part of the set up.
The username is your address, whereas your real name displays against each tweet. Tweets from you show your real name, tweets to you only show your username. So best to keep the two names similar or the same, otherwise you are expecting people to remember two names for you.
When setting up your username, it’s therefore worth keeping it short so that characters are not wasted for Retweets and any other tweets sent to you. So @carolvorders is better than @carolvorderman, but @carolv or @carolvord are shorter and would therefore have been better (if either had been available).
You can change your username and real name at any time. However changing the username is like changing your telephone number – it causes all sorts of issues. Best to get ithe username right first time, if you still have the chance.
In registering the username, it is case-specific. So register "CarolVorders" and it will always appear in tweets as @CarolVorders. However:
(7) Blocking and Unfollowing unwelcome people
If someone sends tweets to you that you find really annoying, perhaps because there are too many tweets, there is the option to “block” them.
Likewise if you follow someone that becomes boring or annoying, then simply unfollow them.
(8) Celebrities
Remember celebrities are actually real, if not ordinary people. Some have a big ego, some don’t. If you send tweets to them, they will usually respond much like you would:
(9) Tweeting Frequency
Tweets have a natural life of no more than around an hour. After that tweets tend to pass beyond the view of anyone looking at their Twitter feed occasionally. So this means re-tweet rates plummet after about an hour.
So if you’re trying to get a message across to your followers, and the world in general, then tweet fairly frequently during the day. However simply repeating the same message, even with different words, will infuriate your followers who are reviewing their tweets regularly. They may then unfollow you. Find different ways of saying it, and only tweet as often as you would tolerate if you were following yourself all day.
The other issue is to avoid tweeting in blocks. If you retweet, send a public tweet or even reply to people so that you are sending tweets in quick succession in blocks of more than 2 or 3, then you will saturate the screens of some of your followers. This can be very annoying for them if it happens too often. I find I simply don’t read blocks of tweets from the same person, and will then unfollow persistent offenders.
This issue. is especially relevant to sending automated tweets. Space the tweets out a bit in time so other people's tweets are likely to appear between them.
If you are tweeting for an audience in a different time zone, then spacing tweets may still come through as a block to your followers, given the absence of tweets from other people they follow. Worth considering:
If you look at tweets through Twitter’s own apps (either the old, new or mobile versions), then you can see what app and possibly device is being used.
For example you can see Philip Schofield uses Twitter’s own app on his iPhone and iPad. Carol Vorderman has an iPhone but also uses Twitter “via web”, probably on her PC. Dave Gorman tends to use Tweetdeck,.plus Twidroid from some type of android mobile phone.
Tweetdeck is very common, and it’s worth knowing it has three columns for “Direct Messages”, “Mentions” (where their username is somewhere in the tweet) and their main “Timeline” for people they follow. TweetDeck also lets you add customised columns for searches etc. As “Direct Messages”, “Mentions” are more obvious to Tweetdeck users, they tend to see and respond to Mentions more than people using other apps. Other people typically have to click a button periodically to see their mentions.
Hootsuite is another common tool, which also allows you to handle Facebook, LinkedIn and other social media within the one app.
There are many other options. The apps are usually free, sometimes sponsored by adverts. So see what other people are using (as above), find out a bit about the apps from the websites, and try them out.
One word of warning though. Watch put for any app that you can set to automatically download tweets every few minutes. It can be downloading thousands of tweets a day, each of which has an “avatar” (photos etc) of the tweeter. Depending on the app's design, it can download the same avatars repeatedly. This can consume vast amounts of your precious megabytes if you are using a phone, 3G dongle or otherwise have a limited monthly data allowance. It can get very expensive left on overnight!
(11) Multiple accounts
It is possible to have multiple accounts, such as for yourself and your business. But Twitter doesn’t encourage multiple accounts, and their own apps don’t cater for them. You’ll need to use another app, most of which do handle multiple accounts. Just try a few, as above.
(12) Lots more to say, but one last thing for now – Apps for Photos, Videos , Soundbites and longer tweets
If you want to write more than 140 characters, or add a photo, soundbite or video, then there are a number of apps like @twitlonger and @twitpic.. Again look at what other people are using, and see whether you like how they look to your readers, and the way they work
You typically use these apps by logging in whilst already logged into a Twitter account, and the app automatically connects to Twitter, If you have multiple accounts, then it is the account you are logged into at the time. Just check you are posting to the right account each posting!
These tips apply whether you are tweeting in a business or personal capacity, and are for the more experienced as well as for newbies:
(1) How long should a tweet be?
You probably know that each Twitter message or "Tweet" is not more than 140 characters. This is deliberately 20 shorter than SMS text messages, to allow SMS to be used with space for usernames and acronyms that start tweets, e.g. DM (direct message) and RT (re-tweet).
Tweets can therefore be sent from mobile phones using SMS, as was common originally. Now the smartphones have their own Twitter “apps” to view and send tweets.
But if you keep your tweets to 70-120 characters (leaving 20-70 characters spare). your tweets can more easily be re-tweeted by other people. This is because "RT" and your username is added to the re-tweet (see below).
(2) Views of the TimeLine
Whichever app you use, the tweets you see are just a selection from the master list of tweets called the “timeline”.
Using Twitter is like looking at the master timeline through a grill. Change the grill slightly, by changing the people you follow or by doing a search, and you’ll see a different set of tweets.
(3) Direct Messages
If you start a tweet “DM @someone” then only the someone will see it. Unlike "replies", DMs do not show in the public list of tweets for your account, nor in searches.
“DM” can be typed manually, as long as it is at the very start, or by using a “Direct Message” facility. (In “New Twitter” it is just called “Message”.)
You can only DM to an account (person) which is following the account you are using at the time.
However when they reply to you, depending on the app they use, it may come back as a DM or a public reply. Indeed they can copy and paste it into a new tweet. So best to assume that anything tweeted, by any method, is in the “public domain”. (The same of course applies to emails – I’m amazed at what gets forwarded to me, further down the email, that the original author certainly didn’t expect to go beyond the original recipient !)
(4) Replies and public messages
If you start a tweet "@someone", as happens automatically with a "reply", then normally only that person will see it. However there are two exceptions to this:
- If someone is following both you and the recipient, then some apps will display such messages
- Anyone looking at your profile will see all your tweets except DMs
Note that if you put one or more characters (such as a space) before the @username, then all your followers will see the tweet.
When replying, consider copying some or all the original tweet into your reply, so the reply makes sense to the original tweeter.
Some apps have a “See Conversation” button which links a tweet into an intelligible series of replies.
(5) Re-tweeting
If there’s a tweet you’d like to copy to your followers, (as it’s funny, informative or whatever), then you can “re-tweet” it. This adds “RT” and the original tweeter’s username at the start.
As mentioned above, it is therefore worth keeping your own tweets to 70-120 characters (leaving 20-70 characters spare).so your tweets can more easily be re-tweeted by other people.
Some apps let you edit the re-tweet and add comments. Or you can copy and paste it into a new tweet, together with the author's username, and manually start it "RT".
(6) Usernames
The username you use to login is fundamental to your Twitter existence. As far as possible keep the username the same as you “real name” which is also part of the set up.
The username is your address, whereas your real name displays against each tweet. Tweets from you show your real name, tweets to you only show your username. So best to keep the two names similar or the same, otherwise you are expecting people to remember two names for you.
When setting up your username, it’s therefore worth keeping it short so that characters are not wasted for Retweets and any other tweets sent to you. So @carolvorders is better than @carolvorderman, but @carolv or @carolvord are shorter and would therefore have been better (if either had been available).
You can change your username and real name at any time. However changing the username is like changing your telephone number – it causes all sorts of issues. Best to get ithe username right first time, if you still have the chance.
In registering the username, it is case-specific. So register "CarolVorders" and it will always appear in tweets as @CarolVorders. However:
- Registering "CarolVorders" prevents anyone else registering any variations such as Carolvorders
- The login process to Twitter is not case sensitive, so Carol can log in as CAROLVORDERS
(7) Blocking and Unfollowing unwelcome people
If someone sends tweets to you that you find really annoying, perhaps because there are too many tweets, there is the option to “block” them.
Likewise if you follow someone that becomes boring or annoying, then simply unfollow them.
(8) Celebrities
Remember celebrities are actually real, if not ordinary people. Some have a big ego, some don’t. If you send tweets to them, they will usually respond much like you would:
- They will re-tweet the funny, the oddball, or the worthy
- They will especially re-tweet if you offer praise for a book, show or whatever else they have done (but don’t over-do these re-tweets celebs!)
- They will reply to your sensible questions, at least when they have the time and inclination
(9) Tweeting Frequency
Tweets have a natural life of no more than around an hour. After that tweets tend to pass beyond the view of anyone looking at their Twitter feed occasionally. So this means re-tweet rates plummet after about an hour.
So if you’re trying to get a message across to your followers, and the world in general, then tweet fairly frequently during the day. However simply repeating the same message, even with different words, will infuriate your followers who are reviewing their tweets regularly. They may then unfollow you. Find different ways of saying it, and only tweet as often as you would tolerate if you were following yourself all day.
The other issue is to avoid tweeting in blocks. If you retweet, send a public tweet or even reply to people so that you are sending tweets in quick succession in blocks of more than 2 or 3, then you will saturate the screens of some of your followers. This can be very annoying for them if it happens too often. I find I simply don’t read blocks of tweets from the same person, and will then unfollow persistent offenders.
This issue. is especially relevant to sending automated tweets. Space the tweets out a bit in time so other people's tweets are likely to appear between them.
If you are tweeting for an audience in a different time zone, then spacing tweets may still come through as a block to your followers, given the absence of tweets from other people they follow. Worth considering:
- Separate Twitter accounts for the domestic and overseas audiences, and/or
- Automating tweets, perhaps to repeat tweets but at a different time of day to suit each audience
If you look at tweets through Twitter’s own apps (either the old, new or mobile versions), then you can see what app and possibly device is being used.
For example you can see Philip Schofield uses Twitter’s own app on his iPhone and iPad. Carol Vorderman has an iPhone but also uses Twitter “via web”, probably on her PC. Dave Gorman tends to use Tweetdeck,.plus Twidroid from some type of android mobile phone.
Tweetdeck is very common, and it’s worth knowing it has three columns for “Direct Messages”, “Mentions” (where their username is somewhere in the tweet) and their main “Timeline” for people they follow. TweetDeck also lets you add customised columns for searches etc. As “Direct Messages”, “Mentions” are more obvious to Tweetdeck users, they tend to see and respond to Mentions more than people using other apps. Other people typically have to click a button periodically to see their mentions.
Hootsuite is another common tool, which also allows you to handle Facebook, LinkedIn and other social media within the one app.
There are many other options. The apps are usually free, sometimes sponsored by adverts. So see what other people are using (as above), find out a bit about the apps from the websites, and try them out.
One word of warning though. Watch put for any app that you can set to automatically download tweets every few minutes. It can be downloading thousands of tweets a day, each of which has an “avatar” (photos etc) of the tweeter. Depending on the app's design, it can download the same avatars repeatedly. This can consume vast amounts of your precious megabytes if you are using a phone, 3G dongle or otherwise have a limited monthly data allowance. It can get very expensive left on overnight!
(11) Multiple accounts
It is possible to have multiple accounts, such as for yourself and your business. But Twitter doesn’t encourage multiple accounts, and their own apps don’t cater for them. You’ll need to use another app, most of which do handle multiple accounts. Just try a few, as above.
(12) Lots more to say, but one last thing for now – Apps for Photos, Videos , Soundbites and longer tweets
If you want to write more than 140 characters, or add a photo, soundbite or video, then there are a number of apps like @twitlonger and @twitpic.. Again look at what other people are using, and see whether you like how they look to your readers, and the way they work
You typically use these apps by logging in whilst already logged into a Twitter account, and the app automatically connects to Twitter, If you have multiple accounts, then it is the account you are logged into at the time. Just check you are posting to the right account each posting!
Thursday, 14 October 2010
Management Reporting – “SparkLines” and “Tweets” to Deliver Concise Information (in one cell & in one hundred and forty characters or less).
Senior management want relevant information quickly, clearly and concisely. Graphics are a great way. A picture can paint a thousand words.
A dashboard with graphs can convey so much. But a single screen view? Aren’t a few words needed to explain the “why” to go with the “what”?
“SparkLines” are a great way to get certain information across. These are tiny graphs that sit in a single cell. There’s a range of styles.
There are basic Sparklines in Office 2007, with a better set in 2010. You can also get Excel add-ins that work in 2003, if you use that.
This comparison between standard Excel and add-ins gives a good idea of what can be achieved. The danger then is using too many of them!
There’s also “Gauges”. These are ideal for a clear idea of a specific KPI target, such as sales conversion rate, versus a target or range.
But no matter how many graphs and graphics you use, sometimes a few words of explanation are needed. Hence maximum 140 character “Tweets”.
The idea here is to express the commentary so concisely, each point fits into a single cell. That is quite an art. Practice makes perfect.
If you’re wondering what that looks like, count the characters in the headline and paragraphs above (or copy into Word and use “Word Count”!)
A dashboard with graphs can convey so much. But a single screen view? Aren’t a few words needed to explain the “why” to go with the “what”?
“SparkLines” are a great way to get certain information across. These are tiny graphs that sit in a single cell. There’s a range of styles.
There are basic Sparklines in Office 2007, with a better set in 2010. You can also get Excel add-ins that work in 2003, if you use that.
This comparison between standard Excel and add-ins gives a good idea of what can be achieved. The danger then is using too many of them!
There’s also “Gauges”. These are ideal for a clear idea of a specific KPI target, such as sales conversion rate, versus a target or range.
But no matter how many graphs and graphics you use, sometimes a few words of explanation are needed. Hence maximum 140 character “Tweets”.
The idea here is to express the commentary so concisely, each point fits into a single cell. That is quite an art. Practice makes perfect.
If you’re wondering what that looks like, count the characters in the headline and paragraphs above (or copy into Word and use “Word Count”!)
Wednesday, 13 October 2010
Business Performance Management - Forecasting and Reporting with SaaS
Recently I attended a seminar about a cloud SaaS-based planning, budgeting and forecasting system.This has been built by people from a background with leading systems such as Hyperion and Cognos Planning. Potentially very valuable, for businesses that can't afford such tools, or want something more flexible.
There were a number of general points made at the seminar:
Whilst there have been a whole string of systems that leave control in the hands of the users, these have tended to come and go as technology has changed. The power of Excel has killed off many of them, despite Excel's shortfalls. Just one or two of the other systems of note remain.
A good planning system will provide, especially by comparison to Excel:
The cloud opens up additional possibilities.:
With a 3-user system around £2500pa (or £1500 for 1 user) for the basic version, this entry point means the power of a full corporate-grade planning system is now available to even a reasonably small business. It can also cope with many more users than that, and payment only follows need.
Whilst it is not sold principally as a reporting tool, it does include actual vs budget reporting, including dashboards. With the correctly-structured database behind it, you can drill down not only into budget detail but also the transactions behind the actual numbers.
If you would like to talk about this and other planning / forecasting system solutions, do contact me by email at challisc @ camwells.co.uk or by phone on +44(0)1628 632914
There were a number of general points made at the seminar:
- For a start-up business, flexibility in design of the financial model is key. But as the business becomes established and grows, very soon having a rigid structure becomes more important (subject to the next point).
- However forecasting needs and business structures tend to change, such as with re-organisations. The modeling system must be able to cope
- Whilst Excel provides ultimate flexibility, its drawbacks are significant - difficult to use in a multi-user situation, easy to get formulae wrong, difficult to roll up a consolidation, and needing constant checking (to name a few)
- Would you use Excel for an HR or CRM system? So why for one of the most important functions of a business, its financial planning?
Whilst there have been a whole string of systems that leave control in the hands of the users, these have tended to come and go as technology has changed. The power of Excel has killed off many of them, despite Excel's shortfalls. Just one or two of the other systems of note remain.
A good planning system will provide, especially by comparison to Excel:
- Automatic consolidation roll-up (of regions, departments, business units etc)
- Multiple dimensions (customer, territory, etc) that is just impractical in spreadsheets
- Formulae applied consistently, such as working out employee on-costs
- Clear data input sheets that won't break Excel
- Easier version control
- What-if on multiple scenarios, far quicker than using Excel
- Overall a substantial reduction in cycle time and cost, where the analysts spend less of their time on administering the system and more on planning and review
The cloud opens up additional possibilities.:
- One system that can be accessed for input and review worldwide, wherever there is an internet connection
- Encryption of the data and/or definitions, so that the "picture" can be kept confidential (no need to email Excel around for review on unsecure email)
- Strong backup and recovery potential - often lacking when using Excel
With a 3-user system around £2500pa (or £1500 for 1 user) for the basic version, this entry point means the power of a full corporate-grade planning system is now available to even a reasonably small business. It can also cope with many more users than that, and payment only follows need.
Whilst it is not sold principally as a reporting tool, it does include actual vs budget reporting, including dashboards. With the correctly-structured database behind it, you can drill down not only into budget detail but also the transactions behind the actual numbers.
If you would like to talk about this and other planning / forecasting system solutions, do contact me by email at challisc @ camwells.co.uk or by phone on +44(0)1628 632914
Tuesday, 12 October 2010
SaaS Cloud Computing - The Hype, The Truth and The Wardrobe
Last evening I had a long chat with the MD of a SaaS (Software as a Service) business. His company specialises in Service Management for larger businesses with 20-500 engineers out in the field. If his SaaS system goes down, thousands of engineers would be left twiddling their thumbs. His customers' businesses would literally grind to a halt. That's "business critical"!
He had taken his company's on-premise solution and converted it to run in the cloud. His customers have the luxury of sitting down with their SaaS provider to cover the service in minute detail. With customers that demanding, he knows absolutely what is needed for "business critical". He talked about "4 9s" and "5 9s" uptime, where unplanned downtime is essentially non-existent. We talked about what else is involved in running a business critical system.
We also talked about a number of other SaaS solutions he's involved with. At the other end of the scale is a system that typically cuts 30-40% off the freight costs of a distributor reliant on parcel courier firms. Whilst this can mean millions of pounds of savings to the distributor, a delay in processing isn't a big issue.
Two key conclusions from this:
When choosing a SaaS app, the vendors will do their best to persuade you that what they are offering is "safe". "You won't need to worry about that", "We've covered that", etc, etc.
But how? In many cases you are well advised to delve that little bit deeper on certain issues, depending on the specific app and its business criticality.
Here are a few of the statements I've heard from SaaS vendors and cloud advocates that are worth a little further thought:
(1) “Security is not an issue” / “Security should not be an issue”
“Security” means different things to different people. I tend to regard it in two distinct parts:
Security is an issue for most new users, before they understand what goes on. Whilst it should not be an issue, the security standards in different parts of the SaaS cloud industry vary widely. If you are thinking of putting an app into the cloud, where the data and/or the processing is business critical, be sure to review providers carefully.
(2) “There has NEVER been a documented case of catastrophic data loss with a cloud service”
Keeping to the security theme, this phrase could relate to failure in access security or data recovery.
For data recovery, yes there has been at least one documented case sadly. About a year ago US telecoms carrier T-Mobile halted sales of the Sidekick cellphone after a server caused millions of customers to lose personal data
I also know of another unpublicized incident where the hosting provider hadn’t spotted that the backup had stopped working due to data volumes breaching a limit, so no backups were available when a recovery was required. There are undoubtedly more cases that have not been publicised.
Nonetheless cloud providers, through economies of scale, can usually provide a more robust computing environment than businesses can do for themselves on-premise, at least for smaller businesses. Many businesses do not have a disaster recovery plan, and if they do, how often is it tested? But equally what are the SaaS provider’s arrangements and testing frequency?
For loss of data from the database, it is not usually known for organizations to publicise such losses – indeed they probably don't know it has happened. However it’s also true that on-premise systems are often leaky. Customer databases are notorious, so moving to the cloud may even be an improvement in this respect. But you need to consider the specific app, and how SaaS compares to existing or potential on-premise systems.
(3) “We’ve had online banking for years, so SaaS security is OK”
Thinking of access security, the banks all have a different approach. Some use physical devices to generate codes and/or random letters, others random letters from passwords. In all cases the access mechanism is more sophisticated than just username and password.
Username and password is the typical level of security for remote access to on-premise systems. But there’s often a second stage to access each specific application. Depending on the app you are considering, is one level of username and password in a SaaS system sufficient?
(4) “Encryption for privacy of data will slow the system down too much”
Would you want someone working at the cloud provider seeing your data and taking a shine to it? Maybe sell the data to a competitor? There are at least two ways to adequately encrypt a database so that unauthorised access “through the back door” won’t work:
Encryption is also more commonly applied to the data being transmitted to and from the server. Do you require this?
(5) “SaaS relies on multi-tenanted databases” / “There’s no security risk with multi-tenanted systems”
Many SaaS offerings are only available where some or all customers (“tenants”) share the one database. This makes it easier to manage, and therefore cheaper to provide.
But Sod’s Law says if it can go wrong it will go wrong. How long will it be before a report is produced with a mix of everyone’s data?
What techniques are the SaaS provider using to ensure this doesn't happen. Do they offer physical segregation on a separate server ? Some systems are available as single tenancy (at a price), or indeed to run on an internet server in-house.
(6) "Providers make sure they get things right, as their business depends on it"
So they should. However examples like those above and situations like BP in the Gulf of Mexico, show there can be incompetence or cost-cutting that jeopardises best intentions.At the very least you need to establish what the SaaS provider is officially doing, and not just take their word for it.
(7) “No consultancy is required for configuration, implementation or training” / “SaaS has a more modest implementation cost”
It’s certainly true that many, but not all, cloud systems are trying to make configuration as easy as possible. They are also trying to make the user screens intuitive. But so are the better on-premise systems. For a system of equivalent complexity, the experience of what set-up works best is equally relevant to cloud as to on-premise. The time and expertise needed is comparable.
Then there are all the implementation issues around change management, and specifics like data conversion. It is easy to get this all wrong. Once the system has been selected and configured, there is little if any difference between SaaS and on-premise for implementation.
Whilst many providers are encouraging you to do a DiY job, it’s best to assume an equivalent amount of professional help for SaaS at each stage as with on-premise. This is subject to the differences highlighted in these two articles on selection , where a quicker project can mean lower professional fees for SaaS, and implementation where similarities mean very similar professional involvement for SaaS and on-premise.
(8) “How many examples would you like for on-premise failures? SAP just settled with Waste Management on a $100 million failed project WM claimed cost them $350 mill on revenue etc.”
There’s no question that there are substantial failures with on-premise projects. This is typically because short-cuts are taken, and/or the people involved are inexperienced.
The same will undoubtedly be true with cloud computing, not least because the providers are telling buyers they can cut costs by cutting corners.
We’re already seeing specialist re-implementation consultancies for SaaS products used by larger businesses.. Unlike most computing, SaaS is working up into corporates from smaller businesses. As the projects get bigger, the cloud project disasters will start to happen. Not because it is cloud, but because of poor implementation technique.
(9) “Upgrades are smaller and easier to test. Nothing will go wrong”
This is often true, up to a point. But like on-premise software, there have been major problems where an upgrade has not been handled sensibly. Also the changes can be quite significant if the functionality of a relatively lite launch version is being expanded rapidly into a fully-fledged application.
In particular, any packaged software needs beta testing by members of the user community. Does this happen for the specific SaaS app? Can you take part in end-user "beta testing", to check the new app still works in a way appropriate for your business? Sadly critical problems have been known to slip through when there's been inadequate testing by end-users.
It also helps if the company has senior management experience of application development, rather than a hosting company getting into apps.
(10) “Cloud is Pay-as-you-go monthly billing”
As discussed in the earlier article, monthly billing is common, but is not always the case. It also varies whether you have to make a minimum commitment, such as a year, or can stop at any point.
Pay as you go billing can be a major issue for the IT providers, which in turn can become a major issue for you. Lump-sum payments for 1, 2 or 3 years may become more commonplace.
Depending on the app, there can also be scope for "gain share" agreements, where the SaaS provider earns according to savings provided, with or without a monthly fee.
(11) “SaaS offers a richer user experience and productivity”
This area is very much a matter of comparing one software product against another. There is no inherent advantage of cloud SaaS systems, except that they tend to be newer systems that may better use more modern technology, However that means they are less well proven than established offerings. You take your pick.
(12) “Utility computing models inherent in SaaS leads to more innovation”
Why? How? The innovation may come from the fact that new entrants tend to have less functionality than established offerings, and need to be developed to catch up. New entrants can also select new technology, rather than being constrained to decisions made some years ago. But as above, new means unproven. You have the option.
(13) “Data centre location is NOT an issue”
This is an issue in at least two respects, and if in any doubt seek legal advice:
You can certainly scale up easily. Some systems let you adjust back down monthly. But many systems require a 12-month commitment to any increase, which makes scaling back down more difficult.
IN CONCLUSION
There’s no doubt that SaaS cloud computing can provide significant benefits. It’s just a pity that some of the SaaS advocates are trying to hoodwink you into using the cloud by using misleading statements.
Nonetheless, by working with the right SaaS providers, in the right way, these and other risks can be tackled and the benefits realised consistently.
So what’s next for your systems?
.
He had taken his company's on-premise solution and converted it to run in the cloud. His customers have the luxury of sitting down with their SaaS provider to cover the service in minute detail. With customers that demanding, he knows absolutely what is needed for "business critical". He talked about "4 9s" and "5 9s" uptime, where unplanned downtime is essentially non-existent. We talked about what else is involved in running a business critical system.
We also talked about a number of other SaaS solutions he's involved with. At the other end of the scale is a system that typically cuts 30-40% off the freight costs of a distributor reliant on parcel courier firms. Whilst this can mean millions of pounds of savings to the distributor, a delay in processing isn't a big issue.
Two key conclusions from this:
- There are a vast array of SaaS applications out there, and plenty new ideas on their way. It is like opening a wardrobe full of great clothes - but you still need to choose the right app for the job..
- What each SaaS application needs to provide can be quite different. For example if you are looking at CRM (customer relationship management), accounting and a front-end business process like service management, different issues will be important. Comparison to the quality of any existing on-premise system is a key factor. It's a matter of "horses for courses" and "choosing the right cloud"
When choosing a SaaS app, the vendors will do their best to persuade you that what they are offering is "safe". "You won't need to worry about that", "We've covered that", etc, etc.
But how? In many cases you are well advised to delve that little bit deeper on certain issues, depending on the specific app and its business criticality.
Here are a few of the statements I've heard from SaaS vendors and cloud advocates that are worth a little further thought:
(1) “Security is not an issue” / “Security should not be an issue”
“Security” means different things to different people. I tend to regard it in two distinct parts:
- Access security, to stop unauthorised access either to view, take or damage data
- Backup and disaster recovery
Security is an issue for most new users, before they understand what goes on. Whilst it should not be an issue, the security standards in different parts of the SaaS cloud industry vary widely. If you are thinking of putting an app into the cloud, where the data and/or the processing is business critical, be sure to review providers carefully.
(2) “There has NEVER been a documented case of catastrophic data loss with a cloud service”
Keeping to the security theme, this phrase could relate to failure in access security or data recovery.
For data recovery, yes there has been at least one documented case sadly. About a year ago US telecoms carrier T-Mobile halted sales of the Sidekick cellphone after a server caused millions of customers to lose personal data
I also know of another unpublicized incident where the hosting provider hadn’t spotted that the backup had stopped working due to data volumes breaching a limit, so no backups were available when a recovery was required. There are undoubtedly more cases that have not been publicised.
Nonetheless cloud providers, through economies of scale, can usually provide a more robust computing environment than businesses can do for themselves on-premise, at least for smaller businesses. Many businesses do not have a disaster recovery plan, and if they do, how often is it tested? But equally what are the SaaS provider’s arrangements and testing frequency?
For loss of data from the database, it is not usually known for organizations to publicise such losses – indeed they probably don't know it has happened. However it’s also true that on-premise systems are often leaky. Customer databases are notorious, so moving to the cloud may even be an improvement in this respect. But you need to consider the specific app, and how SaaS compares to existing or potential on-premise systems.
(3) “We’ve had online banking for years, so SaaS security is OK”
Thinking of access security, the banks all have a different approach. Some use physical devices to generate codes and/or random letters, others random letters from passwords. In all cases the access mechanism is more sophisticated than just username and password.
Username and password is the typical level of security for remote access to on-premise systems. But there’s often a second stage to access each specific application. Depending on the app you are considering, is one level of username and password in a SaaS system sufficient?
(4) “Encryption for privacy of data will slow the system down too much”
Would you want someone working at the cloud provider seeing your data and taking a shine to it? Maybe sell the data to a competitor? There are at least two ways to adequately encrypt a database so that unauthorised access “through the back door” won’t work:
- Encrypt the whole dataset
- Encrypt just the definitions, and leave the incomprehensible data un-encrypted
Encryption is also more commonly applied to the data being transmitted to and from the server. Do you require this?
(5) “SaaS relies on multi-tenanted databases” / “There’s no security risk with multi-tenanted systems”
Many SaaS offerings are only available where some or all customers (“tenants”) share the one database. This makes it easier to manage, and therefore cheaper to provide.
But Sod’s Law says if it can go wrong it will go wrong. How long will it be before a report is produced with a mix of everyone’s data?
What techniques are the SaaS provider using to ensure this doesn't happen. Do they offer physical segregation on a separate server ? Some systems are available as single tenancy (at a price), or indeed to run on an internet server in-house.
(6) "Providers make sure they get things right, as their business depends on it"
So they should. However examples like those above and situations like BP in the Gulf of Mexico, show there can be incompetence or cost-cutting that jeopardises best intentions.At the very least you need to establish what the SaaS provider is officially doing, and not just take their word for it.
(7) “No consultancy is required for configuration, implementation or training” / “SaaS has a more modest implementation cost”
It’s certainly true that many, but not all, cloud systems are trying to make configuration as easy as possible. They are also trying to make the user screens intuitive. But so are the better on-premise systems. For a system of equivalent complexity, the experience of what set-up works best is equally relevant to cloud as to on-premise. The time and expertise needed is comparable.
Then there are all the implementation issues around change management, and specifics like data conversion. It is easy to get this all wrong. Once the system has been selected and configured, there is little if any difference between SaaS and on-premise for implementation.
Whilst many providers are encouraging you to do a DiY job, it’s best to assume an equivalent amount of professional help for SaaS at each stage as with on-premise. This is subject to the differences highlighted in these two articles on selection , where a quicker project can mean lower professional fees for SaaS, and implementation where similarities mean very similar professional involvement for SaaS and on-premise.
(8) “How many examples would you like for on-premise failures? SAP just settled with Waste Management on a $100 million failed project WM claimed cost them $350 mill on revenue etc.”
There’s no question that there are substantial failures with on-premise projects. This is typically because short-cuts are taken, and/or the people involved are inexperienced.
The same will undoubtedly be true with cloud computing, not least because the providers are telling buyers they can cut costs by cutting corners.
We’re already seeing specialist re-implementation consultancies for SaaS products used by larger businesses.. Unlike most computing, SaaS is working up into corporates from smaller businesses. As the projects get bigger, the cloud project disasters will start to happen. Not because it is cloud, but because of poor implementation technique.
(9) “Upgrades are smaller and easier to test. Nothing will go wrong”
This is often true, up to a point. But like on-premise software, there have been major problems where an upgrade has not been handled sensibly. Also the changes can be quite significant if the functionality of a relatively lite launch version is being expanded rapidly into a fully-fledged application.
In particular, any packaged software needs beta testing by members of the user community. Does this happen for the specific SaaS app? Can you take part in end-user "beta testing", to check the new app still works in a way appropriate for your business? Sadly critical problems have been known to slip through when there's been inadequate testing by end-users.
It also helps if the company has senior management experience of application development, rather than a hosting company getting into apps.
(10) “Cloud is Pay-as-you-go monthly billing”
As discussed in the earlier article, monthly billing is common, but is not always the case. It also varies whether you have to make a minimum commitment, such as a year, or can stop at any point.
Pay as you go billing can be a major issue for the IT providers, which in turn can become a major issue for you. Lump-sum payments for 1, 2 or 3 years may become more commonplace.
Depending on the app, there can also be scope for "gain share" agreements, where the SaaS provider earns according to savings provided, with or without a monthly fee.
(11) “SaaS offers a richer user experience and productivity”
This area is very much a matter of comparing one software product against another. There is no inherent advantage of cloud SaaS systems, except that they tend to be newer systems that may better use more modern technology, However that means they are less well proven than established offerings. You take your pick.
(12) “Utility computing models inherent in SaaS leads to more innovation”
Why? How? The innovation may come from the fact that new entrants tend to have less functionality than established offerings, and need to be developed to catch up. New entrants can also select new technology, rather than being constrained to decisions made some years ago. But as above, new means unproven. You have the option.
(13) “Data centre location is NOT an issue”
This is an issue in at least two respects, and if in any doubt seek legal advice:
- Data held outside of the European area is a Data Protection issue unless there is a special arrangement such as the US “Safe Harbor” scheme
- Any data held in the US is subject to the Patriot Act, amongst others. This give the US government powers of access to data that means the UK government, for example, is not prepared to hold UK citizens’ data in the US.
You can certainly scale up easily. Some systems let you adjust back down monthly. But many systems require a 12-month commitment to any increase, which makes scaling back down more difficult.
IN CONCLUSION
There’s no doubt that SaaS cloud computing can provide significant benefits. It’s just a pity that some of the SaaS advocates are trying to hoodwink you into using the cloud by using misleading statements.
Nonetheless, by working with the right SaaS providers, in the right way, these and other risks can be tackled and the benefits realised consistently.
So what’s next for your systems?
.
Subscribe to:
Posts (Atom)
























