One of my favorite sources of information for small business technology is SMB Group.  Laurie McCabe’s recent post about business intelligence and small business was right on point.  As compared to large enterprises, small and medium sized businesses have greater challenges when it comes to pulling business insight out of data that is in their disparate and unconnected applications.   In addition, according to the SMB Group study, many small business owners feel like business intelligence solutions are too complex and too expensive.  Unfortunately, missing on the insights and opportunities analytics can provide may end up more expensive in the long run.

I especially like the part in her post where Laurie McCabe lists “symptoms” of data analysis problems.  How many of these does your company suffer from?

About a year ago I wrote a post about some cloud-based analytics tools for small businesses.  I still think these tools are viable alternatives but for many small businesses they are still too expensive – small businesses look at them and fall back on the tried and true Excel spreadsheet.  Recently I’ve run across some less expensive tools that have connectors to applications that small businesses use like Highrise, Batchbook, Freshbooks, etc.  These include Easy-Insight and EazyBI.  Both can pull data from some cloud applications (though both could use more connectors in my opinion), from in house databases like MS Access or SQLServer, or from Excel spreadsheets.  Once the data is in one place it is much easier to see a complete picture of your business.  In addition, these tools can fill in important gaps in these applications.

Is it magic?  No, you have to understand data and how it connects to get truly good insights.  Some folks have a knack for this and do it every day in Excel – these tools just make it easier.  Others may need outside help.  Either way, these tools bear watching.  I would expect more tools to enter this market as well, making now the time for small businesses to take their data seriously.

  by  dougclow

Hi all and happy New Year!

  by  Creativity103

I read a good article today about things fast-growing professional services firms need to keep in mind as the expand.  The bottom line is that it is easy to move beyond paper, pencil and Excel into a world of processes and procedures that aren’t scalable and that will eventually hinder a firm’s growth.  The author’s did a great job listing the various functions that bog down earliest:

• resource utilization
• invoicing
• project estimation and delivery
• maintaining a resource database
• sales and marketing
• reporting and analytics

Didn’t get enough buzzwords last week?  Not to worry, I am here to fill the big gaping void in your week!  Here are more buzzwords that every small business owner should know.

Lets get started!

1. Business intelligence – CIO.com defines business intelligence or BI as “… an umbrella term that refers to a variety of software applications used to analyze an organization’s raw data”.  So what does that mean?   Generally it means going beyond straight transactional reporting to using data to  improve decision making, cut costs or identify new business opportunities.  It generally entails merging data from various sources and looking at data over time to identify trends, etc.  You use BI to answer questions like “who is my most profitable customer” or “which is my costliest route”.  I talked about BI in this post.
2. Cloud computing – there are lots of definitions but mine is this:  any computing resource that you use that isn’t on your desk or in your office.  For example, this blog is physically stored on a server that I think is in New Mexico.  Heck, I am not entirely sure where it is.  Where it is NOT is in Dunwoody, GA – hence it is in the cloud.  If you use Gmail, Evernote, Dropbox or any other software as a service (SaaS – another good buzzword) program you are “in the cloud”.  You can read more about the cloud here and here.
3. CRM – stands for customer relationship management.   It is a business function, usually supported by technology, designed to improve interactions with customers.   It allows a business to, in one place, keep track of interactions and communications with a customer like inquiries, complaints, phone calls, emails, and transactions.  It can help marketing, sales and customer service stay on the same page when dealing with customers and prospects.   I wrote a few posts about CRM you can read here and here.  If you go beyond traditional CRM that and start to keep track of a customer’s online behaviors thru social media like Facebook, Foursquare, LinkedIn and the like you are dabbling in Social CRM (see, another free buzzword for the price of one!).  There is a great article that describes social CRM here.
4. ERP – is the acronym for enterprise resource planning and it refers to an integrated system that manages most of the business functions of an organization.  It can include finance and accounting, HR, supply chain management, project management, CRM and more.  ERP solutions for small businesses include NetSuite, Microsoft Dynamics and a plethora of smaller niche applications.  There are so many choices it can be confusing – Laurie McCabe has a good article on how to choose the right business applications.

What does all this mean?

All of these buzzwords should be in your technology plan – if you aren’t using them now you will want to use them in the near future.  If you aren’t sure how to get started or don’t even have a technology plan, get help.  These are all tools to help your business grow and be effective.  And who doesn’t want that?

  by  revbean

Earlier this week there was an article on SmallBizTechnology.com about how the biggest problem small businesses have in using technology is lack of education.  I absolutely agree with the sentiment – who has time to learn about technology when they have a business to run?  In the article Ramon Ray recommended spending an hour or two a week learning about technology.  From there, however, he talked a lot about technology that boosts a businesses online presence – Facebook, blogging, Twitter and local search.  These are all important but there is so much more!

So what else should a small business owner educate themselves about?  There are so many topics that it can seem like a maze but if you take a look at this list you can concentrate on a few topics at a time:

• How can you make things easier for your customer?  (easy online access to content and services)
• How can you make things easier for your staff? (remote access, simple processes, collaboration tools)
• How can you touch more prospects, close more sales and increase revenue? (CRM, email newsletters)
• How can you streamline your internal processes and maybe save money? (better integration, fewer but more powerful systems, remote hosting, cloud services)
• How can you get a better handle on your business? (reporting, analytics)

So here is a short round-up of good sources for technology information – these are examples but they should give you somewhere to start:

• online technology magazines and blogs like smallbiztechnology.com and smallbusinesscomputing.com.  I also like Laurie McCabe’s blog.
• industry specific online sources like the Law Technology News section of Law.com or Techtips on TheProgressiveAccountant.com
• online communities like American Express Open and Biznik.com
• local blogs like atlantasmall.biz

What technology topics would you like to know more about?  Where do you go to get your technical education?

by  Search Engine People Blog

Quick, can you tell me which is your most profitable customer?

Or as the headline points out, pick the dimension or view of your company and tell me what, who, which is most profitable?  Or least profitable?  And can you tell me why?

There are typically three answers to this question:

Companies in the first group answer with a resounding “No way!”.  Why?   Likely the information they need to analyze these points is all over the place – in different systems that don’t talk to each other or worse not in any system at all.  Maybe some in an accounting application and the rest is in a spreadsheet somewhere.  Or maybe on a napkin in your sales managers pocket.  You know what I am talking about.

Companies in the second group answer with “of course”.   This sounds pretty good until you ask the next question which is something more complicated like “who are your top 5 most profitable customers by product line?”.  What I find at this point is these companies have some decent rudimentary analytics, likely manually extracted from various systems and housed in a spreadsheet.  This is not altogether bad – they know what metrics are important to their company and have a process for producing those metrics.  The problem is that this isn’t scalable – as soon as you want to change the question, even slightly, you’ll find the metrics are created in an inflexible way.  Someone has to go back and manually change the spreadsheet, maybe making another version, maybe disconnecting it from the base data.  The thing about analytics is that as soon as you know one thing you want to know something else about that thing – it never ends!    This means static spreadsheets, while  good for getting your feet wet, won’t last long.

Companies in the third group can answer with “of course” and then proceed to further analyze their business for key insights and trends.  In this case they have integrated their data from various systems and sources into a source for analytics and reporting using business intelligence tools.  These tools allow them to more easily change their questions without re-doing  bunch of spreadsheets.  Some of you have probably heard about business intelligence and business intelligence tools and dismiss them for use by small and medium sized businesses.  It is time to think again!

What has changed in BI tools?

Traditionally large enterprises have been able to leverage BI tools and data warehouses to gain tremendous insight into their businesses.  They can do things like predict what products you might like to buy after an initial purchase or tell a store how to most effectively position products on their shelves.  They can analyze service routes and call center performance.  There really is no end to what CAN be done – it just takes money.  A boatload of money.  Money on software and hardware and lots and lots of money for people (either employees or consultants) install, configure and make sure all the pieces work together.  In recent years this has started to change.  There are tools that run as a service (SaaS, in the cloud) that provide many of the capabilities that the large BI tools can.  These smaller, nimbler tools can pull data from your existing systems (even files and spreadsheets) and organize it in a way to be easily accessible for analytics and reporting.  Usually your expenses will be a monthly subscription for these tools and probably some initial consulting help to get you started (some of the vendors purport that you don’t need that but I’m dubious – at the risk of venturing into the realm of self-promotion I think that some consulting help at the beginning to define goals and metrics and help choose a vendor would save most businesses money in the long run.  But I digress.).

In short, what do these BI tools do?

They can  help you measure and manage your business, enabling what-if analysis and the easy ability to change the questions you are asking.  They make pulling the data together from diverse sources easier and less painful.   They create “one version of the truth”.  Some even package up solutions for function-specific analysis – pipeline analysis (sales), financial analysis (finance), cost analysis (operations) , or supply chain analysis (supply chain).

How do I get started?

There are a number of good vendors in this space.  They include (but are not limited to) Birst, Pivotlink, Gooddata, Easy Insight, Jaspersoft, and Zoho Reports.  Each of these has different features and integrates data in different ways.  If you have someone experienced with analytics and reporting on your staff you are in luck.  Otherwise your next step is to talk with your technology advisor to determine what your needs are and which product suits them the best.  Then you can put together a plan that lays out initial steps and associated costs.  Start with a plan, start slow and measure your progress (use metrics to measure your analytics!) and soon you’ll have greater insight into your business.