Businesses create more data than ever before. And even if you’ve not consciously set out to gather more information, your company probably has more statistics in more spreadsheets than you know what to do with.
There’s knowledge buried in that data. The challenge is getting at it.
One of the problems with trying to interpret data is that it can be overwhelming. Contained in a spreadsheet or a text document, the figures can be tremendously daunting.
How do you identify the meaning in a list of hundreds or thousands of numbers?
A good way to start is by finding a way to visualise that data. Graphs and charts make it easier for us to see the trends and patterns buried in figures.
(This doesn’t always work, mind you – just witness the flood of bad infographics that have peppered the web over the last couple of years.)
Still, it’s worth a try. And now a new tool has come along to make visualising data that bit quicker and easier.
Charted is an online data visualisation tool created by the people who run popular content platform Medium.
It’s not a fully-featured charting app — it’s nowhere near as flexible as Excel’s chart functions, for instance — but that’s kind of the point.
What it lacks in features, it makes up in ease of use. Creating a chart in Charted is exceptionally straightforward. All you need to do is give it the URL of a shared document.
This can be a file that you’ve saved and shared on Google Drive, shared on Dropbox – or uploaded to any cloud storage service that lets you share files.
Once you’ve shared the document, just go to the Charted website and paste the URL into the big box there. Then hit Go. You’ll see a clear representation of your data, along with a couple of options.
Charted is great for sharing visualisations, because you can just send the Charted link to anyone you like.
The chart automatically resizes to fit the window in which it’s displayed. And if your source data changes, so does the chart (it updates itself every 30 minutes).
It’s easy to give it a go, right here.
IT for Donuts is our regular feature where we explain a tech term or answer a question about business IT.
Today, we take a look at how to change Microsoft Word settings so text gets pasted automatically, without any formatting to mess it up.
By default, if you paste text into Word, all the formatting comes with it. Fonts, spacing, links and so on all get carried over. This can be quite annoying if you want to format the text in your own way.
We’ve explained before how to remove formatting when you paste into Word, and if you only need to do it occasionally, that’s still the best way.
However, if you find yourself pasting without formatting most of the time, you can change your settings so Microsoft Word does this by default.
It’s easy to set your default paste option to plain text. In recent versions of Microsoft Word for Windows, follow these steps:
For instance, if you want to paste text from websites without formatting, choose Keep Text Only for the Pasting from other programs option.
And that’s it – you’ll save yourself a couple of seconds every time you paste text into a Word document.
In the world of technology, 2014 has been full high-profile security breaches, wearable gadgets and new domain names.
And as the end of another year rolls around, we take a look at what’s been most popular on IT Donut. So, what did you miss while you were busy running your business?
Ever since 2013 — when the domain name system was changed — new domain name extensions like .london, .xyz and .technology have been tricking onto the market.
And in June this year, Stephen Fry became the first person to start using the short new .uk extension.
At the time, Nominet said: ‘Stephen Fry’s decision to switch from a .com reflects the appeal of shorter, sharper .uk domains.’
But if you search Google for Stephen Fry today, you’ll see the address that comes top is stephenfry.com. Sure, www.stephenfry.uk still works, but it’s not as if the actor has discarded his .com domain altogether.
A PR stunt? Surely not…
Building a good website is not easy. In July, we learnt that the new M&S website cost £150m, yet caused a dip in online sales when it was launched.
As we said at the time, it would have been easy to poke fun at this retail giant. But actually, this experience underlines how tricky it is to build a good website – even when you have a big budget and a powerful brand to draw on.
In fact, it’s very common for sales and traffic to drop when you launch a redesigned website. A soft launch and comprehensive user testing can help, but it’s usually best to stick with the status quo during busy periods.
In April, something called Heartbleed was big news. This was the name for a security flaw in OpenSSL, popular encryption software that protects hundreds of thousands of websites.
The breach could allow hackers to break into encrypted data while it was transferred online. OpenSSL underpins transactions and protects data on many big-name websites, so the danger was very real.
Website owners were advised to check if their own sites were affected, while consumers were warned to consider changing their passwords.
You can use the Heartbleed site checker to make sure your website isn’t still affected. Our Heartbleed advice is here.
We’ve long suspected that business owners struggle to create IT policies that are right for their companies. Those suspicions were confirmed when we relaunched our own set of free IT policy templates in May.
The set of downloadable documents includes policies covering data protection, internet and email use and social media. They’ve been downloaded thousands of times since.
A new iPhone is usually big news. And when iPhone 6 emerged in the autumn, Revivaphone — which offers a kit to resuscitate liquid-damaged phones — was determined to claim the title of ‘first iPhone 6 to be dunked in beer’.
Sure, it was a thinly-veiled PR stunt. But it was also an entertaining one. It prompted us to put together a quick guide to saving your phone if it’s been damaged by beer, water or another liquid.
Until recently, we were wondering if the term ‘intranet’ was going slowly out of date.
The language of technology changes fast, and like 'cyberspace' or 'Website' with a capital 'W', we thought 'intranet' might be passé in the mobile-enabled, cloud-powered world we live in.
As it turns out, we're wrong. Intranets are as popular as ever. In fact, new cloud technologies are making it easier for smaller companies to build versatile employee intranets that people actually like to use.
That’s why our information about creating intranets was some of our most popular in 2014.
So, how did your business find its technology in 2014. And what do you have planned for the year ahead?
You might not have heard the term 'technostress', but you might be familiar with its symptoms. People experience it when they struggle to adapt to new technologies in a healthy way.
You might experience technostress in any number of ways, from struggling to switch off when you get home, to compulsively checking Twitter and Facebook for updates every few minutes.
When you stop to consider how quickly we’ve made computers — and smart phones, in particular — a central part of our lives, it’s hardly a surprise that we sometimes struggle to use them appropriately.
20 years ago, people wouldn't have believed it would be normal to walk down the street while staring a small glowing rectangle. Yet here we are.
Technology has brought impressive benefits to both individuals and businesses. It’s created entire industries and enabled us to work in new ways. Yet it’s becoming harder to ignore the downsides.
According to some research, heavy use of computers and cell phones can be linked to increased stress, sleep disorders and even depressive symptoms in young adults.
Other scientists have warned that the light from mobile devices tends to be from the part of the spectrum that can disrupt our body clocks. And some pundits wonder if technology is leaving us with shorter attention spans.
As if that wasn’t enough to worry about, giving up technology can be stressful, too. Blimey.
If technology is part of the problem, can it be part of the solution, too? Well, perhaps, if a new wave of wearable gadgets and apps can do what they promise.
Leading the charge are gadgets like Pip, the ‘personal stress management device’ that uses sensors to measure physical changes that may indicate your stress level. As you hold Pip, it claims to capture ‘electrical changes at the surface of the skin caused by the release of sweat’.
It records this data using an accompanying smart phone app. When used regularly, the idea is you can build an accurate picture of your stress levels and start to understand what causes you to become more — or less — stressed.
Another trend for busting stress and keeping focus is mindfulness, a meditation technique that focuses on the present moment.
There are lots of apps to help you practice mindfulness and meditation, like Headspace, Buddhify and Mental Workout.
And it you want to stay de-stressed by spending your working days on track and focused, there are a number of tools and apps that can provide assistance.
Do nothing for two minutes is a super-simple idea, but if your thoughts are running in six directions at once, it creates a few moments of calm to get yourself back on track.
More forceful intervention can come from SelfControl (Mac only) and Focus Me. These programs can stop you accessing particular websites or software on your computer. Combine them with RescueTime if you want to see exactly where your time goes.
Finally, if you hit a point where technology is really getting on top of you, get out of there. Leave your phone on the desk and get outside for a walk. It’s not long-term solution, but half an hour of fresh air helps you see things from a new perspective and makes you feel better.
Recent research from networking firm Netgear suggests that most small companies consider workplace Wi-Fi critical for their business.
Of 500 companies surveyed, 75% said that having a wireless network has become essential for running their business.
Anecdotally, it’s easy to judge the popularity of wireless networks. Just see how many pop up on your smart phone as you walk down your street.
If you already have a wireless network, you’re bound to be familiar with its main uses. Being able to wirelessly connect to the internet or work on shared files can do wonders for your productivity.
But are you exploring all potential benefits of your Wi-Fi? Here are five ways to make your wireless network even more useful:
Presentations run more smoothly when you don’t have to faff about finding the right cable or digging out an adaptor to hook up your laptop to the company big-screen TV or projector.
You can use your existing wireless network to connect your laptop to a big screen, but you might need some extra equipment to do so.
If your projector or display doesn’t have wireless capabilities, you can add a ‘mirroring device’ that will mirror your laptop’s screen on your large display.
Good options include ChromeCast, the IOGEAR GWAVR (yes, that is its real name), and Apple TV (best for Mac users)
Visitors to your business will almost certainly appreciate the ability to connect to your company network. But rather than give them the password to your main wireless network, it’s better to create a separate network for them to use.
This guest network can provide unfettered access to the internet, so your guests can log on as normal. But as it’s separate from your other company systems, there’s less danger of visitors being able to access confidential information (whether by accident or design).
Many wireless routers now offer a guest network option, so you can effectively run both a public and private network from the same piece of equipment.
If your employees are in the habit of using their smart phones to make calls in the office, you could reduce calling costs by encouraging them to call via a VoIP app (like Skype), instead.
And if you already have a VoIP phone system, you might well be able to connect your smart phones to it over Wi-Fi. This means your staff will be able to make and receive calls from their main number while away from their desks.
Traditionally, getting ready to accept card payments has been quite a hassle. You needed to jump through hoops to get a merchant account — and then often had to pay a monthly fee to your provider.
That’s changed in the last couple of years. A number of companies — like Intuit — have introduced Chip & PIN readers that connect to an app on your smart phone and then authorise payments via Wi-Fi.
You usually have to pay £50 - £100 for the card reader, plus transaction fees of 2% – 3%. This makes these solutions good for occasional users who don’t want to pay a regular monthly charge or get locked in to a contract.
With mobile devices commonly used to review documents and emails, it’s no surprise that people want to print from them.
While it’s fair to say this is still trickier than it should be, it has got simpler. If your printer is connected to your network — either wirelessly or via a cable — there’s a good chance you’ll be able to print to it from your mobile device.
How you do this depends on the mobile device itself:
Do you use your wireless network in any unusual ways?
You need a hero. You're holding out for a hero 'til the morning light. And he's gotta be sure and it's gotta be soon…right?
You're not alone. When it comes to hero developers, everybody wants one. Whether it's a killer app that you can't get off the ground or the desperate re-build your site needs, demand for developers runs high. In fact, one of the most common questions I get asked when talking to small firms and start-ups is: "how can I find the right developer?".
My answer is simple – think of it like dating. Hiring a developer can seem at best slightly daunting and at worst a potential minefield (just like dating). However, when you apply certain strategies to narrow your search down to the right kinds of people, you increase your chances of success (also like dating). And finally, finding a developer can be done online (exactly like dating).
Here are six ways to help you find the perfect developer:
Whether you're creating a profile for match.com or writing a technical brief, clarity and details are important. Nobody responds to a dating profile that says "nice guy looking for nice girl". It's too vague, too generic and too dull. Ditto with developers. I often see briefs along the lines of, "I need a really smart app that will change the way people exercise. Must look really slick." No serious developer is going to give that the time of day and you'll just get generic proposals back from people who probably don't have the right skill set anyway.
Instead, take the time to work out exactly what you need and describe it in as much detail as you can. Explain what you're trying to achieve and the issues you've had so far – good developers love problem-solving.
If you don't have the technical expertise to write a really great brief your first job should be to find someone who can help you craft the brief before it even gets to a developer. If it isn't clear to you, it won't be to them.
As with dating, it pays to widen the search area. Matt Mullenweg, ceo of WordPress, says 99% of the talent in the world is outside the major hubs. If you can’t find the skills you need in your immediate vicinity that’s not a problem – lots of development jobs can be done remotely.
On Elance and oDesk there are around nine million freelancers working with more than two million businesses across the world – maybe your ideal match is in Chicago, Sydney or Dublin. Unlike with dating, distance need not be a barrier.
Good developers are in demand and can afford to pick and choose their projects. Naturally they will pick the ones that sound interesting, well thought out and that fit their skill set. Select carefully and explain why you have singled them out.
On Elance there is an option to post a job privately and invite specific freelancers to bid on it. Stipulate exactly why you would like that particular developer to work on your project. Was it something in their profile that you thought was relevant? Did you like the work they did on an app or a website? Be genuine. Woo them.
Turning up to first date shouldn’t require a new suit or designer dress but a little bit of effort goes a long way. The first contact with a new developer needs to create the right impression. Whether it’s an email, a Skype call or the proposal you are sending them online, first impressions count.
Be friendly (people always prefer to work with people they like), be professional and be excited and passionate about your business and what you’re trying to achieve. Getting any collaborator (developer or not) engaged in your project is half the battle.
Marry in haste, repent at leisure applies just as much for recruitment as it does for dating. When you first start working with someone, start small. You wouldn’t suggest a three-week holiday for a second date; equally don’t launch into an enormous technical project with someone you’ve never worked with before.
Break the job into component parts, set milestones and review as you go. Trust me, this prevents much heartache (not to mention unnecessary expenditure) down the line.
As in relationships and life, you’ll get what you give. Communicate clearly and frequently (although not every second of every day – no one likes a micro manager – or a stalker). Check in regularly and don’t leave your developer wondering what they should do next or whether you’re happy with what they’ve done. This is even more important when you hire online – there is an art to distance management and communication is the key to mastering it.
Finally, when hiring a developer try not to be too prescriptive. While you should always have a clear idea of what you want, be prepared to be flexible too.
You may think you need someone in your office 24/7 but perhaps your ideal match can only give you three days a week at the moment. Better to have the right person and compromise on the other stuff. Prioritise your wish-list into “must-haves” and “nice-to haves”. And be realistic. You can’t build a rival to Amazon with a £1,000 budget.
After all, you wouldn't write "must look like Brad Pitt" on a dating profile would you?
Copyright © 2014 Hayley Conick is country manager for Elance-oDesk in the UK & Ireland.
The run-up to Christmas is a key time for online retailers. In fact, today is the much-hyped Cyber Monday, often cited as the biggest day of the year for online shopping.
(You might recall that Amazon stole the show on Cyber Monday last year by announcing deliveries by drone.)
If you run an online retailer, there’s a good chance your annual performance hinges on the next couple of weeks.
It's important to capture as much consumer spending now, before 2015 starts and people’s wallets go back in their pockets.
Although the logistics of fulfilling orders can pose a headache, a Barclays survey reveals the main fear of 51% of retailers is the possibility of their website going down.
That fear is grounded in logic. If your online sales total £2,000 a day — and assuming those purchases mostly happen between 9am – 10pm — an hour’s downtime could easily cost you £100 - £150 in lost sales.
A major outage could be disastrous at this time of year, forcing customers to look elsewhere and potentially hitting your reputation and repeat business.
“The stakes are high during the holiday season, and retailers cannot afford to have their sites crash and burn,” confirms Paul Heywood, EMEA director at internet performance experts Dyn.
He says the best way to prepare your website for Christmas is to aim for optimum performance the whole year round:
“Providing a reliable online experience should be part of a long term, proactive approach.”
“Retailers are faced with the year-round challenge of fickle customer loyalty — if your website experience doesn't match their expectations or is too slow your customers will quickly turn to a rival brand.”
He's right, of course. Website uptime matters all the time. But it matters even more at this time of year. So to help your site remain available, it’s worth following these four tips:
Finally, if you don’t already have it, set up website monitoring. Various services will send you emails or text messages to alert you to problems. After all, you can’t fix an issue unless you know about it.