The world, and the businesses that run it, are becoming increasingly social. This has led to a dramatic increase in the amount of data available to us, thus making Business Intelligence (BI) more important than ever. One increasingly popular form of BI is the collection, analysis and use of social data. This is a relatively new idea that has many business owners and managers confused. Are you one of them?

Here's an overview of social data and three ways small business owners and managers can use it to make decisions.

What is social data? Social data is any data or information collected from the various social media sites available. The easiest way to define social data is to differentiate it from social media. Social media is content that a user has created, copied or linked with the idea of sharing it with other people using a platform i.e., Facebook. Social data is the information that is linked to this content, such as shares, likes, location, time posted, etc.

It is social data that powers analytics and social media monitoring, (how popular your content, profile, etc. is), and if utilized efficiently could go a long way in helping you make better business decisions and a more focused marketing strategy.

Because there is so much data relating to and generated by social media activities, it can be nearly impossible to track and analyze it all. But, it is quickly becoming an important part of Business Intelligence, and will continue to become even more so as the number of social media sites and users continues to expand. That's why many BI solutions are starting to integrate social data gathering and analysis tools. While you may be able to track and analyze this data, do you know what you can do with it?

Three uses of social data

• Competitor research - Many companies currently focus on data related directly to their content. Why not expand it and look at your competitors, such what they are posting and how their followers are reacting? If done properly, this can give you valuable industry insight and generate ideas as to what you could also be doing to better leverage your brand and position.
• Judge health of marketing campaigns and overall interest - The main use of social data should be to help you track how well your current marketing campaigns and content is doing. Being able to analyze this data will reveal what works and what doesn't, allowing you to tweak and fine tune your efforts. The best platforms can provide near instant results which allow you to update or change on-the-fly.
• Gauge current public opinion - Social media is like a stream. There's always content flowing by you, much of it potentially useful. If you can track what people are saying, sharing and commenting on, you can spot trends faster, enabling you to come up with even more relevant content for followers to share, thus expanding presence.

There are numerous uses for social data in organizations and many bigger companies have started to track and implement learnings in different departments such as marketing, human resources and even finance. This is a great way for you to better know and provide what your customers and followers want.

If you would like to learn more about social data and how your company can use it effectively, call us today for a chat.

Office 365 is Microsoft's cloud based version of their popular Office software. This pay per-user and month suite provides all users with the productivity software and support they need to operate. While there is a long list of features and programs available to subscribers, one of the more useful is Office Web Apps, for which Microsoft has recently announced some updates that should make it even better.

Here's an overview of Office Web Apps and the two upcoming updates for the platform.

What exactly is Office Web Apps? Office Web Apps (OWA) is a browser based version of Microsoft Office. OWA includes Word, PowerPoint, Excel and OneNote which users can access through almost any web browser. These apps are available free of charge to everyone with a Microsoft SkyDrive and most Office 365 users.

The beauty of OWA is that it allows users to open, edit, collaborate on, and store the most popular Office documents from a variety of devices. What this means is that as long as a user has a Microsoft Account and is connected to the Internet, they can access Office software without actually having it installed on their computer or device.

If you've used OWA, you know that it's great for opening Office documents, basic editing and creating basic documents. The major downside is, these web based apps are missing a number of more advanced features e.g., Find and Replace in Word. Microsoft has stated that they are committed to introducing more features, and have recently announced two that could make OWA an even more viable solution for businesses.

Real-time collaboration In the current version of OWA collaboration is possible. However a user will need to refresh the browser window to see changes made by another editor. This is hardly ideal, especially if you have more than two people working on the same document.

Microsoft aims to change this by introducing real-time editing. This means that if you and three other colleagues are working on the same document, you will see the changes as they are made; so there's no need to refresh.

This feature is currently being rolled out to PowerPoint users, and should be applied to the other OWA apps sometime in the near future (there has been no specific date set by Microsoft, but it should be by the end of the year).

Editing from Android tablets While OWA may not be the best choice for desktop users, especially since the vast majority already have Office installed on their computers, it's great for mobile users. At this time, only Windows 8 tablet and iPad users have been able to access OWA from their devices. The recently announced update will soon bring this functionality to Android tablets as well.

Microsoft has not set a date as to when Android tablets will be able to access OWA, but it should be before the end of 2013, possibly the end of the summer. They also noted that they are working to speed up the service for tablets, which will foster even more efficient collaboration.

If you are interested in learning more about OWA, Office 365 or any of Microsoft's other programs please contact us today to see how we can help.

In most companies, multiple applications support different functions and departments. Your sales team is using CRM, while the finance team uses ERP or an accounting system. The operation teams probably use line of business (LOB) applications that are specific to your industry. Each one of those applications comes with canned reports written for the “average” user.

The “average” user Reports generally allow you to specify ranges of dates, products, document numbers or some other parameter and then generate the report in a standard format. Data to populate the report is pulled directly from the application tables which were defined when the report was designed. The format, including columns and rows, are predetermined based on the expected needs of that “average” user.
But what if you need more than average information? There is undoubtedly information in your systems that is important to your business and that the canned reports don’t reflect.

Above average information A true Business Intelligence (BI) solution will consolidate data from all the applications across your organization. While a BI solution can still deliver “reports” to users, it also empowers the user to look deeper—past the high level information to find causes and solutions. With deeper information, every decision maker in your organization can look at data from new angles to make above average decisions.
In practical terms, BI allows the user to:

• access, build and save views of information that are more meaningful to the user,
• drill down from high level reports, dashboards or cubes to the transactional detail behind the numbers,
• create and distribute charts and graphs that provide information that team members and management can quickly comprehend,
• see only the information that is appropriate to his/her role.

Dashboards, charts and views can be manipulated to look at any combination of data points to provide new insights into causes, effects and solutions. All in real-time, enabling immediate response with more informed decisions.

The applications that you use to run your business, house information that will help you serve customers better. By replacing reports with business intelligence, you can tap that information to respond faster and stay ahead of the competition.

Let’s talk about how you can get above average results with better information from your business management solutions.

The Internet, still in its early phases, is seeing a dramatic increase in the number of users. Unfortunately, this growth has also seen an increase in the number of cyber criminals and attacks against websites. The latest major attack was perpetrated against LivingSocial. If you have an account with this website, you may want to pay attention.

LivingSocial is a daily deals website that focuses on bringing bargains and original deals to users based on their geographical location. In late April, news broke that the website had suffered a massive cyber attack with 50 million accounts being compromised.

From the reports we have seen, the attack targeted accounts world-wide with only account holders in Thailand, Indonesia, South Korea and the Philippines being unaffected. An email sent out by Tim O'Shaughnessy, LivingSocial's CEO shortly after the incident said, "We recently experienced a cyber-attack on our computer systems that resulted in unauthorized access to some customer data from our servers. We are actively working with law enforcement to investigate this issue."

The company assured users that their credit card data had not been compromised, as they are kept in another database. Account passwords were also encrypted, which means they are harder to crack but not impossible.

What should you do? If you have a LivingSocial account, we recommend that you go and change your password immediately. This can be done by:

1. Going to LivingSocial's forgot your password page.
2. Entering the email address you used to sign up for the account with.
3. Pressing Reset Password.
4. Checking your email for an email from LivingSocial and following the instructions in the email.

It is advisable to pick a new password, one that is as different as possible from your old password and, as always, the longer, the better.

Is there anything I can to do protect my company? If you are a business owner who has websites that encourage customers to sign up for updates, accounts, etc. you may be wondering how you can keep your user's information secure from cyber attack. In truth, you can't keep your important information 100% secure, if a hacker is committed enough, they will be able to get the information they need or wreak the havoc they want to. But what you can do is to make it as hard as possible for cybercriminals to get your information. This could be as simple as using multiple databases to store different bits of information, or as complex as using the latest encryption methods and systems.

Each business is unique, and the best way to ensure your valuable data is secure is to work with an IT partner who takes the time to get to know your security needs and develop a solution that is as near to 100% secure as possible.

If you are worried about the security of your systems, contact us today. We may have the perfect solution that will meet your needs and budget.

The computer has become such an invaluable tool to all businesses that it's hard to imagine life without one. While computers are important, many companies can't afford the latest and greatest and must make do with older systems. A problem with this is that older systems often run slower and can cause you to be counterproductive. However, there are steps you can take to keep your computers running as they should.

Below are four things you can do to keep your PC running smoothly.

1. Shutdown properly If you turn your computer off at the end of the day, or it freezes, it may be tempting to flick the off switch on the power bar, or press the power button until it turns off. This isn't ideal for your computer's health because when a computer is unexpectedly shut down, there could be damage to the operating system.

You may notice that when your computer crashes, it takes longer to reboot. This is because Windows is actually searching for, or trying to repair any damage that may have been done. There is a chance that powering down improperly could cause files to become corrupted which may make the system inoperable.

Therefore, you should follow proper shutdown procedures. If you need to shut down quickly, try pressing Control+Alt+Delete and selecting Shut Down from there.

2. Close unnecessary programs running in the background Some programs are written to be always running in the background. If you look in the bottom right of your screen, you should see programs running beside the clock. In truth, most of these likely don't need to be open. You should be able to right click on the icon and close them. This will save computing resources and make your computer run smoother.

A word of warning: It's best not to shut down the antivirus or security software as this will leave your computer open to attack. Also, don't shut down anything from NVIDIA or AMD as this is your video card software. Closing programs like this could cause your computer to crash.

3. Utilize Add/Remove on a regular basis Chances are high that you have installed a fairly high number of programs on your computer, some of which you may not use anymore. Those you don't use just take up valuable hard drive space, and should be removed on a regular basis. You can do this by:

1. Clicking on Start or the Windows Orb.
2. Selecting Settings followed by Control Panel.
3. Opening Add/Remove Programs.

It may take a few minutes to scan your system for programs, but a window will open with all the programs you have installed. Click on those you don't use anymore and remove them. We strongly recommend that you do not go into different files and delete programs, this could damage your system.

4. Use a malware scanner and antivirus program This may sound like a no-brainer, but it is still worth mentioning that having an antivirus program and malware scanner is a good idea. Many viruses and other malware often hijack system resources causing the computer to run slower, or crash. A regular scan can go a long way in minimizing this, which means your computer will likely run better for longer.

If you are looking for ways to keep your older systems running at their optimal levels, please contact us today to see how we can help you.

To many business owners, social media is one of the most important marketing tools at their disposal. It's true that a well executed social media strategy can make all the difference, while also giving smaller companies a way to compete with industry giants. What many may not realize is that social media can be much more than just a marketing platform.

Below are four non-marketing oriented uses of social media that businesses could benefit from.

Hiring LinkedIn is a social network dedicated to helping professionals and organizations connect and find jobs and new talent. Most social savvy companies will have a presence on this network and may even hire exclusively from here.

If you are looking for new employees, it wouldn't hurt to have a LinkedIn profile. To find the best talent, you need to forge and maintain connections (usually starting with people you know), and be somewhat active in groups and on message boards.

It's also important to not forget the other major networks when it comes to hiring. Tweeting a job opening on Twitter, or posting ads on Facebook could also help you find your next employee. Facebook can be particularly useful because you can pay to target ads (in this case, job openings) at specific demographics.

Internal communications Communication is an important part of business, and most people choose to communicate using email. You have probably seen emails with jokes, invitations to after work events, lunch orders, etc. sent to the whole company and also received the many replies that go with it. This can get very annoying, and also confusing.

Why not utilize social media for non-essential (aka. not related to work) communication. Set up a Facebook group where your employees can share content, invitations to lunch or after work gatherings, interesting stories, etc. That way you can limit email to more important, business-related aspects.

Using social media for internal communication is also beneficial for companies with younger workers. Most already see Facebook, Twitter, etc. as their main form of communication, some even feel more comfortable communicating over this medium as opposed to speaking out in meetings. Having a group portal or Facebook page could give less-empowered employees a way to voice their ideas, and maybe even improve on them with feedback from others.

Learning A common complaint of many business owners is that they have a tough time staying on top of ever-changing trends and what currently interests their customers. Using social media to connect with your customers can be a great way to learn not only hot trends but also about new ideas.

Customer service When it comes to social media, users will often complain publicly on their wall or through their tweets. This is bad for you, as the reach of this complaint can go a long way and make you look bad. Some companies have decided to confront this head on by having specific customer service accounts. If a customer complains, has an issue, or even compliments you, be active and respond using that account.

If done properly, over time, you will see more and more people reaching out to your customer service account through social media. This also gives you another way to please clients or turn around negative customer experiences.

Social media and the various platforms are not only great for marketing, but can be incredibly useful for other business functions. Do you have any other ways you use social media? Let us know. Or, if you would like to learn more about how it can help your company, then contact us today.

Lists are important part of any role in any company. Many lists are now composed in a word processor like Microsoft's Word. But have you ever struggled to create a numbered list in Word? Maybe lists start from one each time you enter a new one, or the numbers continue from previous list. This can be frustrating, but luckily there is something you can do to address it.

Below is an overview of how you can set up ordered lists to either continue numbered lists from where you last left off, or start at #1 with new lists.

Set up numbering for all future lists

1. Open a new Word document.
2. Go to the Home tab (Press Home at the top of the window)
3. Press the downward-facing arrow beside the numbered list button in the Paragraph group. (it's located on the right of the bullet point button)
4. Select Set Numbered Value... from the drop-down menu.
5. Click the numbering option you want from the pop-up window.
6. Press Ok.

When setting numbered values, you have three options to choose from:

• Start new list - If you select this option, new lists will automatically start at one.
• Continue from previous list - Selecting this option will continue numbering from previous lists in the same document. For example: If you have a paragraph and then a numbered list with three points, and type another paragraph then enter a new list, the list will start from four.
• Set value to: - Lets you set what number lists will start at.

Change the number value of individual lists If you have a document with numbered lists already in it, and want to change the number values of one list, you can do so by right-clicking on the first number of a list and selecting either Restart at 1 or Continue numbering.

Note that if you have a document with a continuous list that is separated by paragraphs and choose to reset one list to start at one, all subsequent lists will be changed to reflect the new ordering.

Stories about ERP implementations that take months and even years are enough to make any business owner avoid even thinking about a change. But in today’s competitive world, most businesses can’t meet customer expectations with a starter accounting system. An ERP system is a requirement to grow.

With smart planning, an ERP implementation doesn’t have to disrupt your business or take months to complete. Especially with cloud and hosting options, ERP can be up and running quickly to provide returns on your investment almost immediately.

Implement in phases

To set the stage for ERP project success, decide on the most important issues and tackle those first. In most systems, you don’t have to implement all the ERP modules at one time. If billing and collections are causing cash flow issues, make Invoicing and Accounts Receivables the first module you bring online. Phase in the rest of the modules as you are ready.

You probably have multiple systems, including Line of Business applications that keep your business running. You don’t have to replace all those systems with an ERP. There are many data integration options that you can investigate with an experienced technology partner. Either as a temporary or permanent solution, there is no reason you can’t design a system that suits you perfectly.

Change management

Make sure your team is ready for the change before you get started. Training and user adoption are usually the most time intensive parts of an ERP implementation. Help employees buy into the change so they won’t avoid training and slow down the project.

Plan to use your own data during training. Employees will understand the new system better if they see familiar terms and names that they can put in context.

Keep employees informed every step of the way. With open communication, you will help employees overcome resistance to change.

The right vendor selection

With clear priorities and change management processes in place, you can find the vendor that best matches your needs. Service partners should propose solutions that directly support your requirements and objectives.

Your customers expect a lot these days. Deliver on the promise with a modern ERP system. You can reap the benefits of an ERP system without disrupting your business.  Let’s talk about your priorities and get started.

Security is an important issue for many business owners and managers. Many work with their IT department or an IT partner to ensure their network and systems are secure from threats. But what about your email, social media and bank accounts? The weakest link of these online accounts is your password, hackers know this and that's what they target. Do you take steps to ensure that you have a strong password?

If you want to minimize the chances of your password being hacked, here are five things you should NOT do.

1. Don't pick short passwords

While short passwords are easier to remember, they are also easier and quicker to hack. The most common way to hack passwords is by using brute force: Developing a list of every possible password, then trying this list with a username.

Using a mid-range computer like the one many have on their desk, with a normal Internet connection, you can develop a list of all potential passwords astonishingly quickly. For example it would take 11.9 seconds to generate a list of all possible passwords using five lowercase characters (a,b,c,d,etc.) only. It will take about 2.15 hours to develop a list of all possible passwords using five of any computer character. Once a hacker has the list, they just have to try every potential password with your user name.

On the other hand, a list of all 8 character passwords with at least one special character (!,@,%,etc.) and one capital letter would take this computer 2.14 centuries to develop. In other words, the longer the password, the harder it will be to hack. That being said, longer passwords aren't impossible to hack, they just take more time. So, most hackers will usually go after the shorter passwords first.

2. Don't use the same password

The way most hackers work is that they assume users have the same password for different accounts. If they can get one password, it's as simple as looking through that account's information for any related accounts and trying the original password with the other accounts. If one of these happens to be your email where you have kept bank information, you will likely see your bank account drained.

It's therefore important to use a different password for every online account. They key here is to try and use a password that's as different as possible. Don't just add a number or character onto the end of a word. If you have trouble remembering all of your passwords, try using a password manager like LastPass.

3. Don't use words from the dictionary or all numbers

This article published last year on ZDnet highlights the 25 most popular passwords. Notice that more than 15 contain words from the dictionary, and most of the rest are strings of common numbers. To have a secure password, most security experts agree that you should not use words from the dictionary or number combinations that are beside each other (e.g., 1234).

4. Don't use standard number substitutions

Some users have passwords where they replace letters with a number that looks similar, for example: h31lo (hello). Most new password hacking tools actually have combinations like this built in and will try a normal word, followed by replacing letters with similar numbers. It’s best to avoid this.

5. Don't use available information as a password

What we mean by this is using information that can be easily found on the Internet. For example, doing a quick search for your name will likely return your email address and social media profiles. If you have pictures of your kids, spouse, pets, family, their dates of birth, etc. on your Facebook profile and have put their names in captions, it's possible for a hacker to see this (assuming the pictures are shared with the public).

You can bet that they will try these names as your password. You would be surprised with the amount of personal information on the web. We suggest searching for yourself using your email address(s), social media profile names, etc. and seeing what information can be found. If your passwords are close to what you find, it would be a good idea to change them immediately.

There are numerous things you can do to minimize the chance that your passwords are stolen and accounts hacked.

 

It's safe to say that email has become the primary communication tool for businesses all over the world. Its instant nature has also made communication infinitely easier. Despite all of the benefits of email, there are some drawbacks, with the sheer amount of emails we get on a daily basis being the biggest of them. If you inbox is a little unruly, there are steps you can take to reign it in.

Here are five tips on how you can better manage your inbox.

1. Address last Most people start an email by typing in the address of the recipient(s). While there is nothing wrong with this practice, it can lead to emails being sent before they are finished, which could mean more emails in your inbox asking for clarifications or you having to send a correction email.

To stop this, try writing the body of the email first and when you have finished, put the addresses of the recipients.

2. Merge social with email Sometimes it can be hard to know who you are writing or replying to in your email. Using an app like Rapportive, which brings social information into Gmail can help. This app puts a bar to the right-side of an email with information about the sender, including their social profiles, recent tweets and even links to their LinkedIn profile. You can look up your recipients and connect with them directly from the email.

3. Use links, not attachments With the increasing number of cloud storage and productivity apps like Microsoft SkyDrive and Google Drive which allow you to share files by sending people links, there's no need to attach files to an email. This is incredibly useful if you find yourself sending document versions back and forth on a regular basis and struggle to keep everything up to date.

These services use one version of the document that users you share it with have access to. Everyone sees the same document, which will cut down on the number of emails and confusion when it comes to version control of important documents.

4. Don't use email for everything Email is so quick and easy that we tend to rely on it for everything. However, there are certain situations when email is not the best form of communication. For example, if you have a tough problem, need to reprimand an employee, etc. it would not be a good idea to do so in email, it's just too impersonal.

As a rule of thumb: If there's any chance of human emotions entering into a response or being affected by an email, it may be a better idea to communicate face-to-face.

5. Cook all your bacn at once Bacn (pronounced Bacon) is solicited email; email you want, just not right now. Social media updates, newsletters, website update notifications, etc. are all forms of bacn. Checking these takes time and can be a distraction if you have work to get done. It would be a good idea to schedule a set amount of time where you focus on reading, deleting or archiving these emails.

Alternatively, you can unsubscribe from these alerts or set up a new email account that is just for this type of emails.

There are thousands of things you can do to make your email easier to manage. What do you do? Let us know. If you are looking for even more ways to manage your inbox, contact us today.