Blog

April 10th, 2013

SocialMedia_April09_ASocial media has been around, in one form or another, for more or less a decade now. It's kind of hard to believe the change it has brought, some even find it hard to live without. While many services have come and gone, there are a few that have real staying power. The newest being Pinterest, which has recently been redesigned. This redesign also introduces two new features businesses could benefit from.

Here's a brief overview of the new features introduced with Pinterest's recent layout changes.

How to get the new layout

Before you can use these features, it would be a good idea to upgrade to the new layout. While, like other social media services, this will be happening automatically over time. Unlike other platforms, the new layout is available for all users to switch to when they feel ready, however when you switch to the new layout, you will not be able to go back to the old one. Here's how you can switch:

  1. Log in to Pinterest.
  2. Hover your mouse over your profile/business name at the top-right of your profile.
  3. Click Switch to the New Look.
  4. Select Get it Now. Note: If you press this, you likely won't be able to switch back to the old layout.
  5. Press Okay from the Welcome to your new look! pop-up window.

When the new layout loads, you'll notice that the pins are bigger, the category button has been moved to the left side of the profile beside the Search bar. You'll also notice that the comment button has been moved from the pins, you can access it by clicking on the image. On top of cosmetic changes, two useful functions that businesses will find beneficial.

Discovery

Now, when you look at an individual pin (click on the image), you will notice a number of changes.

  • You can see all pins on the same board.
  • You'll also see pins from the same website. For example if you pin something from a restaurant, you'll now see similar pins from the same website.
  • Most importantly, you'll now be able to see what other people have pinned along with the same image.

This will make it easier for users to discover what other people are pinning. For your business this means potentially higher exposure. Think of this as something similar to the way Facebook works: If a person likes you, the chances of this like showing on their friend's profile, and that friend visiting your Page is higher. It's kind of like easy brand exposure.

Analytics

Arguably the most useful feature added recently is Pinterest Analytics, which allows you to see if your pins are being clicked on or shared, and the general success of your activities. This will go a long way in helping you determine the overall success of your Pinterest oriented efforts.

The main caveat with this is that your profile/business's website needs to be verified and connected with your profile. If you have an unofficial Pinterest account, you can change it to a business one by:

  1. Logging into your Pinterest account and going to business.pinterest.com.
  2. Pressing Convert your existing account and choose your type of business.
  3. Entering the relevant account information like the name of your business, address and website.
  4. Agreeing to the new Terms of Service.

If you would like to have a new username or account simply go to http://business.pinterest.com/ and press Join as a Business. You will be asked to set your account information, username, etc. You will need to verify your account which will involve you having to download a file and upload it to the server that hosts your website. We, or your web hoster can help you with that.

After your account is verified, you will notice that if you hover your mouse over your account name a drop-down list should pop up with Analytics being about half way down. Click on that to be taken to the section.

This section will display a bunch of graphs including:

  • The number of daily pins and pinners on your site.
  • The number of re-pins you have done.
  • How many times your content has been repinned.
  • The number of clicks and website visits.
  • The most clicked and repinned pins.
  • The number of times your pins have been seen.

Overall, Analytics is a useful tool that will give you a clear picture of what is working and what isn't. If you pinned a picture of a dog and noticed that it got zero pins while another got hundreds, it may be a good idea to create/look for more similar content.

If you are looking to integrate Pinterest into your business's social media strategy or would like or learn more about how to use the service, please contact us today.

 

Published with permission from TechAdvisory.org. Source.

Topic Social Media
April 5th, 2013

ERP_April03_AHow many spreadsheets do your employees depend on to keep the business running smoothly? Five, twenty, sixty? If you were to poll your employees you would probably be surprised how big the actual number is.

That poll could also provide a wake-up call when you saw the type of information that employees are tracking in an unsecured document. For example, some of the most common uses of spreadsheets include:

  • Payroll and employee information,
  • Customer contact data,
  • Inventory, including warehouse locations,
  • Delivery and service schedules,
  • Project timelines and due dates,
The list goes on and on. For many companies, many of the most important functions of the business are tracked in Excel.

Risky business

People use spreadsheets because they are comfortable with them. Spreadsheets are easy to learn and becoming more powerful with every version release. But overuse poses a significant risk to the business, including:

  • Incorrect formulas that could lead managers to make poor decisions,
  • Version mix-ups are common, especially when more than one person works on a file,
  • Unsecured information that lands in the wrong person’s email or is on a disgruntled employee’s hard drive,
  • Lack of backups for documents on local hard drives – especially in the face of a natural disaster.
Unsecured information puts your business at risk and dispersed information wastes employees time.

Centralize and share

To build a foundation for your company to grow, you need to centralize and share the information your employees need to complete their tasks efficiently.  The most effective method for building that foundation of centralized data is with an ERP system.

An ERP system will allow you to provide role-based access to information – securely opening up the data that people need to do their jobs no matter where they are. Employees will spend more time doing their job and less time figuring out whether they have the latest spreadsheet.

Let’s talk about your company’s spreadsheets and find a better way to do business.

Published with permission from TechAdvisory.org. Source.

April 4th, 2013

Productivity_April03_AIn today's technology first world, email has taken center stage as the medium of communication used by businesses the world over. While there is little doubt as to its popularity, many of the billions of emails sent each day are written poorly. This can impact your overall productivity as you will have to spend time either clarifying previous emails, or asking for clarification.

Here's six tips that can help ensure that the emails you send get your message across. By writing quality emails, you could see your productivity increase as you will have more time to do your work instead of clarifying sloppy emails.

1. Have a clear decision or action 99% of the emails you send are to ask someone to take an action, make a decision, reply etc. So, before you write any email pause for a minute and ask yourself: Why am I writing this and what do I want the recipient to do with this email?

If you can't provide a clear answer to these two questions, you may want to try contacting the recipient through another medium, or take some time to think and come up with an answer.

2. Write it backwards Once you know why you are writing your email, the actual writing becomes a lot easier. Because you will most likely be asking the recipient to do something, why not start with the request. Simply write down, in clear English, what you want done.

It's important to be as clear and direct as possible to avoid any confusion and potential follow up emails that will distract you. Once you have stated what you want, then you can provide justification to your request, or background information.

The reason this works is because many business owners/managers/employees are busy, they don't have time to read a whole report's worth of information that ends with a request. Most of the time they will just skip to the end anyways, so why not put the most important part - the action that you want them to take - at the beginning.

3. Use lists Many poorly written emails aren't actually poorly written. They are just formatted in an inefficient manner. In most English classes, students are taught to develop their ideas or arguments through logical paragraphs, while having only one point to each paragraph. Pause for a minute and think: If you get an email asking you to make a decision on what product to buy with five paragraphs each talking about a benefit or reason, would you actually read the whole email? Chances are the answer is no.

To be more efficient, break your ideas/reasons/arguments into a list. You can usually summarize the majority of main ideas of each paragraph into a single sentence. This makes them easier for you and the recipient to read.

4. KISS We don't mean you should kiss your monitor. In this context, KISS stands for Keep It Simple and Straightforward. You shouldn't have long essays or arguments with lots of padding. Get to the point immediately and provide the essential information.

If you find yourself writing an essay or long report, email is not the medium you should be using. Instead put your thoughts into a word document that you attach to the email. In the email itself put a brief overview along with the most important points and tell your recipient to check the attachment for more information.

5. Have a relevant subject line The subject of your email is like the title of a report or news article. Without a solid subject, the chances of your email being opened and read are low. It would be a good idea to write your whole email first, then the subject.

A good subject line can A) Interest the recipient enough to get them to open it and B) Provide enough insight so the reader can infer what you want. If you look over a subject line of an email you are about to send and see that it doesn't make sense or reference the email itself, it would be a good idea to re-write it.

6. Proofread everything This may make sense now, but we are all guilty of writing an email and pressing send without reading the content over. Once you hit send, the damage is done, you won't be able to get the email back. That's why it's a good idea to read over your email after you finish.

You should look for any obvious spelling and grammar errors along with ensuring that the content makes sense. If you think it's ok, then you can probably go ahead and send it. If you are the least bit hesitant, walk away from it for a few minutes then come back and read over it again. You will likely be able to see a couple of changes.

There are many options at your disposal that allow you to enhance your and your company's productivity. Contact us today to see how our systems can help.

Published with permission from TechAdvisory.org. Source.

Topic Productivity
April 3rd, 2013

HealthcareIT_2013April03_ACongressional hearings on mobile health-care application regulation suggest the future is bright for this technology, say mHIMSS executives Tom Martin and David Collins.

The hearings, held March 19-21, considered the importance of allowing innovation to flourish vs. the importance of regulation for patient safety.

Discussed in the hearings were the dangers of strict FDA oversight and the potential threat of Obamacare taxes on apps—concerns that were dismissed by most witnesses.

According to Martin and Collins, "While a few developers are waiting on the FDA’s final medical app guidance before submitting apps to the market, many developers are bringing innovative products to market, and venture funding for healthcare startups is at an all time high."

Moreover, although a very small segment of the app marketplace could be subject to the excise tax on medical devices, most app categories would not, say Martin and Collins.

This likely gives app developers the confidence to bring new apps to the market, and that could lead to an explosion if mobile health-care technology.

Published with permission from TechAdvisory.org. Source.

March 29th, 2013

ERP_March27_AAs you consider the options for the future of your organization’s IT management, there are many factors to consider. Should you move applications to the cloud to reduce IT burden? If so, which applications?

There is a growing trend to add ERP (Enterprise Resource Planning) to the list of applications that should be moved to the cloud. ERP support likely consumes a large chunk of time from your IT staff. Whether hosted or SaaS (software as a service), cloud-based ERP can significantly ease the burden on an overworked IT staff.

Five decision points

Of the many factors to consider in moving ERP to the cloud, five stand out as the most common first issues to address, including security, cost, accessibility, integration and transportability.

  • Security of cloud-based ERP. While many business owners feel strongly that their data is more secure if it is under their own roof, that is often a misconception. The security and disaster recovery of a professionally managed data center is probably far more secure than the server room of most companies.
  • Cost savings from moving ERP to the cloud. Cloud based ERP eliminates the need to purchase and keep current the hardware and software required to keep ERP software running at peak performance. With most hosting and SaaS ERP offerings, upgrades are included in the fees to significantly cut IT support costs.
  • Access for employees working remotely.  According to recent studies, most companies now have employees who work from home or in the field. Keeping those employees connected to the information they need to respond to customers and complete their work is essential. Since cloud-based ERP solutions are designed to be accessed via the internet, remote workers will have the same experience as those workers in the office.
  • Integration with other business applications. Most businesses rely on many applications to serve customers and create value. The integration tools of today make connecting applications easier than ever. Many companies are using a hybrid approach, where some applications are hosted or SaaS and some are housed and supported internally.
  • The ability to change. Change is part of business, which makes it imperative to ensure that the ERP cloud provider that you work with will support your decision if your decide to move on. The ability to migrate your data to a different platform, should the need arise, is an important discussion to have early on in the decision process.
A unique decision

Every organization is unique and your decision to move applications to the cloud will be based on your requirements. Take the time to evaluate carefully and ask the questions that will ensure your organization’s success. If you would like more information to help evaluate your cloud options, let’s talk soon.

Published with permission from TechAdvisory.org. Source.

March 28th, 2013

BI_March27_AData can be defined as a set of values that belong to a set of items. If you were to look at a series of numbers stored in a spreadsheet, without any labels, you would have a hard time guessing what it is. Only through analysis will it become useful to us. Because there is often so much data around us, it can be tough to actually analyze it and turn it into useful information. It doesn't have to be so hard though.

Here's a brief overview of five data analysis tools that you could use in your business.

BigML

One of the more common uses of data is to help a business manager make predictions. We all know predictions are among the hardest things to do. Enterprises hire staff and invest in systems solely with the aim of making predictions. If you're a small business, you likely don't need expensive software that is hard to use.

Enter BigML. How it works is you define and upload a set of data and format it. BigML will then take that data, help you to create a prediction model which you then can apply 'what-if' variables to and have it generate predictions. The site runs on credits; you pay for a set amount of credits and each part of the process - dataset, model and prediction - is worth a certain amount of credits. Prices start at around USD$6.50 for credits, which gives you 10MB of data, 5MB worth of models and 10K predictions based on this data.

Wolfram|Alpha's Facebook Reports

WolframAlpha is a search engine that collects data and uses algorithms to interpret it. One feature of this site is that you can develop reports, one of the more useful being Facebook Reports. You can access the report feature by clicking here. Alternatively, you can go to the WolframAlpha website and search for Facebook.

This report provides users with a glimpse into their Facebook Page's information. It provides you with information on who are the most active posters, how many shares/likes, etc. you get and other useful information in easy to read charts and graphs. The key here is that the report can show you how customers access your Page and where they come from. You could use this information to see what posts users liked and didn't like, and provide more engaging content.

The basic version of the report is free. More advanced controls and data analysis is available for USD$4.99 a month.

Many Eyes

Many Eyes is a data analysis and visualization tool developed by IBM Research. If you already have data sets then you can upload them to the website and use one of the many different visualization tools to create charts, graphs, etc.

A cool feature of this site is that it has the ability to analyze written documents. Say for example you are writing new content for your website, you can copy and paste the content and get a visual representation of the words you use, how you connect words, etc. If you have a set of keywords you would like to use for SEO and search purposes, you can manually compare them with the visualization. If you notice that an important keyword is missing, or not represented enough, you can go through and re-write the copy a bit.

Best of all, it's free.

Tableau Public

If you have an idea about Business Intelligence, or have worked with data on a regular basis and have sets that are structured, Tableau Public is probably the most powerful free analysis tool available for small businesses.

While powerful, it isn't the most user-friendly of options. To get the most out of this program you are going to need to know the basics behind data analysis. If you feel comfortable with the basics, you'll be creating dashboards, charts, interactive graphs, maps, etc. that look great and can be embedded on your blog or website. Oh yes, did we mention it's free?

Excel

Big data is all the rage these days, it's hard not to hear techies and data specialists talk about it. While it is an important part of many large businesses' data analysis practices, the truth is many small businesses don't need big data just yet. If you have simple data you need to analyze e.g., how many hours have your five employees worked this month? Why not stick with simple spreadsheets like Excel or Google Spreadsheet.

As long as you have data entered in a logical way, you can easily create graphs and charts that can help you visualize and analyze your data.

If you would like help establishing a system that can help you track and analyze your data, please contact us today, we may have a solution that works for you.
Published with permission from TechAdvisory.org. Source.

March 27th, 2013

Office_March26_ALike it or not, there will be a time when you have to give a presentation. Most people will use Microsoft PowerPoint to create it and will generally do a good job of setting up the presentation. Where some stumble is if they have to input information or a graph from an Excel spreadsheet into the presentation. This can be a frustrating experience, but there are ways to make it easier.

Here's how you can take data from spreadsheets in Excel and turn it into graphs and charts in PowerPoint.

Before you start

Before you can transfer data from Excel, you should take a look at the spreadsheet. If you have a ton of data and only want to take a certain chunk to make your graph, it would be best to copy and paste it into a new Excel workbook. This way, you can get the data from Excel to PowerPoint easily and turn into a graph or chart.

The key idea here is that you don't want to do a data-dump - putting every single number, most of which could be useless - into a slide. You want to take only the most relevant information from the spreadsheet. It's easiest to do this on a slide-by-slide basis, after you have setup the presentation outline. Copy the information only pertaining to that one slide. If you're not sure whether it will be useful or not, it likely isn't, so don't take it.

Create the graph/chart

Once you have only the data you are going to need for the chart, you can switch over to PowerPoint and go to the slide where you will put the chart. This can be done by:

  1. Clicking on the slide's body field - where you enter the main text of the slide, below the title.
  2. Selecting the Insert tab from the top of the screen and clicking on Insert Chart. Note: This will only work if the slide's layout supports Content. To change the layout of the slide, right-click on it and select Layout, then pick one that says Content.
  3. Choosing the type of graph that's relevant to your data from the window that pops up and pressing OK.
  4. Deleting the information in the dummy Excel spreadsheet that comes up by left-clicking and dragging over the content. It will be highlighted and pressing Delete will get rid of it.
  5. Copying and pasting the information from the Excel spreadsheet you setup earlier into the window in PowerPoint. Be sure to click on A1 before you paste it.
  6. Renaming the chart by double-clicking on the title above the cells.

You can click back to the slide to look at the chart. Often times the data will be opposite. For example, the date will show on the X axis, when it should be on the Y. If you click on the chart, and select Switch Row/Column in the ribbon above the slide, you will be able to re-arrange the information.

Time to format

It's highly unlikely that the graph you placed into the slide is formatted the way you want, or even optimized for your audience. Here are four tips to help you format it so it not only looks good, but can be seen when you give your presentation.

  1. Don't get too flashy - Yes, there are a large number and variety of charts available. No, they are not all good for presentations. It's best to pick a simple layout - stick with the classics: Pie, Bar and Line. Don't pick 3-D charts as they are hard to read and can confuse the audience. Also pick colors that can be seen. For example, light green, yellow, grey, etc. can hardly be seen on most projectors.
  2. Use big text - It may look big enough on your screen, but you can be sure it isn't going to be big enough for your audience. Use the biggest font size possible, and limit any explanation text.
  3. Remove Gridlines - But Gridlines make it easier to determine amounts don't they? Yes, on reports. But this isn't a report, it's a presentation, so it's ok to be general. Gridlines will just confuse your audience, and make graphs look cramped. Remove them by clicking on any grid line in the middle of the graph, and pressing Delete on your keyboard.
  4. Test it - Before you give the presentation, it would be a good idea to test the presentation on a screen that is similar to the size you will be presenting on. If that's not possible, get a colleague to look over it. They will likely be able to point some changes out - if need be.

Having attractive graphs in your presentations can go a long way in keeping your audience engaged, and it could increase the chances of your message sinking in. If you would like to learn more about how you can leverage PowerPoint or any of Microsoft's other programs in your office, please contact us today.


Published with permission from TechAdvisory.org. Source.

March 27th, 2013

You are working in Dynamics GP and you pick a field with a date. You want to put in a really old date, maybe for the start of a reporting period or for the start of your time using GP, but you don’t feel like keying it. You pick the date icon. You could use the arrow keys to keep scrolling back months or…

Click on the header that contains the month. You’ll get a list of months for the current year and the arrows will now show years making it easy to go back.

Capture (2)

Click on the header again (it now has the year in it) and you get a list of years. Click the header a third time you’ll get a list of decades.

Capture1

March 27th, 2013

The Account Maintenance window in Dynamics GP has four user defined fields on it. Nobody really uses them but there’s a good reason to use them.

Pick one of the UDF fields and use it to identify the employee responsible for reconciling that account. For cash accounts this is the person responsible for bank rec and reconciling to the GL. For other balance sheet accounts it’s the person preparing the monthly roll forward.

This makes it easy to run a COA based on the user defined field and get a reconciliation checklist for month end.

Topic Articles
March 23rd, 2013

Hardware_March20_AThere are many tools that business managers will consider to be an integral part of their job. One tool most will agree on is the computer. Simply put, many of us would not be able to do our jobs without them. While they are indispensable, many users don't know much about their trusty desktop or laptop. There is no doubt that the modern computer is a complicated machine. However, it could help to know a bit about the hardware you use on a daily basis.

Here's a basic overview of the seven essential hardware components of the modern computer that businesses rely on. These components are found in nearly every computer, and now many tablets and smartphones too.

1. Motherboard Think of the motherboard as the backbone of nearly any technological device. It holds all the major components of the computer, including the hard drive, processor, memory and peripheral ports like the USB. Most motherboards in computers, and to some extent laptops, are called expandable. This means that you can replace components as long as they are compatible. For example, you can take out a hard drive and replace it with another that has more storage capacity.

If you can't take parts out, you may see the term mainboard used. This term is usually applied to devices like TVs, washing machines, refrigerators, and so on.

2. Networking cards Networking cards, or network interfacing cards, may be separate cards or integrated into the motherboard. Their purpose is to provide a way for your computer to connect to the network and Internet.

Many new computers will have the network card integrated into the motherboard, along with other components. If you own a laptop, you can connect to Wi-Fi networks through a Wi-Fi card which is usually close to the outer edges of the device. Most desktops don't have this card, but you can purchase them if you want to be able to connect to Wi-Fi.

3. Graphics card A graphics or video card can come in two varieties - integrated or expansion. An integrated video card is connected directly to the motherboard and is usually found as a part of the processor. An expansion video card is a separate card that is connected to another part of the motherboard called an expansion port. The job of the video card is to create the graphics and images that can be shown on a monitor. Without one of these, we would not be able to visualize the data, and computers would be useless.

4. Processor The processor - also known as a Central Processing Unit or CPU - is the brain of the computer. Its job is to carry out the instructions of computer programs that are stored in the computer's memory.

The speed of a processor is measured in MHz or Megahertz. This measurement indicates how fast a processor can read electrical pulses. For example, a 100MHz processor can read 100,000,000 pulses of light in one second. As a reference, most mid to high-range computers have processors with speeds around 3.0GHz.

5. Hard drive The hard drive is where programs and files are stored. More traditional drives are called Hard Disk Drives (HDD) and are comprised of a series of magnetized disks which store the data. These disks spin under a magnetic arm which can read and write data.

Newer hard drives are called Solid-state Drives (SSD) and use electrical circuits to store data. These are much faster than traditional HDDs and are starting to be found in more and more computers.

6. USB ports The Universal Serial Bus, or USB, is a standard that covers a certain type of cable, connectors and communication. It is a standard way for computer components like mice, keyboards, phones, etc. to be connected to the computer. Nearly everything that is not a physical part of the motherboard or internal computer is connected using a USB connection.

The cool thing about the USB is not only does it allow you to use your computer as a communication device, but it also allows the connected device to draw electrical power from the computer, essentially transforming your computer into an electrical outlet. That's why you can charge your phone, or run an external hard drive simply by plugging it into your computer's USB port. This standard has become so popular that many computers now come with multiple ports - some with as many as eight!

7. Monitor ports Computers are great, but without monitors, they would be largely useless for everyday use. Monitors come in many sizes and varieties. Newer monitors can connect to your computer through HDMI or VGA ports. HDMI - High-Definition Multimedia Interface - is a newer format that can display high-definition images, while VGA - Video Graphics Array - is typically found in older monitors.

As technology advances, you will see fewer VGA monitors and connections in use, with many manufacturers offering monitors that only use HDMI.

This was just a basic overview of the essential components of a computer, if you would like to learn more about the machine you use on a daily basis, please contact us. We would be happy to sit down with you and give you a more detailed tour of the inside of your computer.

Published with permission from TechAdvisory.org. Source.

Topic Hardware