Mo Bigger Data

Losing valuable business data is a terrible thing. It is worse when it’s done on purpose. Every business faces changes in accounting or operational systems over the lifetime of the company and these changes more frequently than not include losing data of some type. And that means losing business intelligence.

The frustrations of changing business systems are compounded the further into the business life cycle the change comes. Much of the historic intelligence of the business is derived from the earlier days of operation. This is data which reflects the stages and activities of the business over time. When a business reaches a point where data volume or list sizes force a systems change, much of that early historic data is ultimately abandoned. There is so much data to load into a new system that the task often proves too daunting for the company, so valuable historic detail information is lost and summary information is loaded into the new system.

As a business matures, and for the business to mature in a healthy manner, specific and detailed information must be captured and analyzed. Software addressing a broad view of the business, offering only generalized functionality and basic process support, will not provide a growing business with the operational support and resultant business intelligence needed at this level.

For example, a manufacturing business needs to fully understand and manage the manufacturing processes and materials supply chain to ensure profitability and consistent product quality. A retailer needs to know which products sell in which markets to ensure product stock and availability to key customers. And all this information is time-critical if the business is to make necessary adjustments in time to benefit from them.

In the end, it is the demonstration of well-defined processes, deep insight into the business operational metrics and financial performance, and the ability to effectively and accurately report on this information that creates a basis for provable business value.

Mendelson Consulting understands how important it is to not just collect the right data to support various processes, but to use that data to better understand operational and financial performance. As operations grow, so does the need to collect data from a variety of possible sources, from phone systems to time clocks and more. Even getting data out of the accounting system can be a challenge, but there is tremendous value in having transparency of business data.

From data warehouses to data lakes, Power BI and data visualization, we help businesses access their information and develop reporting that not only informs but helps deliver greater insight which leads to improvements in performance and profitability.

When information is power, we help owners and stakeholders gain mo power by being mo better informed.

jm bunny feetMake sense?

J

Big Data, Analysis and Business Intelligence

Big Data, Analysis and Business Intelligence

big dataThere is a lot of talk among IT professionals of “big data”, and discussions at many business conference tables center on how the organization might find greater benefit and advantage from the intelligence buried in the business systems and information.  It is a two-part problem, where the collection and the analysis each play essential roles in developing real business intelligence.

“So what’s getting ubiquitous and cheap? Data.

And what is complementary to data? Analysis. ..”

Hal Varian, Chief Economist at Google and emeritus professor at the University of California, Berkeley
“Hal Varian Answers Your Questions,” February 25, 2008 (http://www.freakonomics.com/2008/02/25/hal-varian-answers-your-questions/).  BUSINESS INTELLIGENCE AND ANALYTICS: FROM BIG DATA TO BIG IMPACT; MIS Quarterly Vol. 36 No. 4, pp. 1165-1188/December 2012

The information technology and systems in a business support the operation.  Software and computers help people do their jobs, and the information collected in and generated by those systems becomes the foundation for developing business “intelligence”.   Today, businesses must reach beyond their own direct operational support systems and consider the full realm of data to be collected, including IoT sensor data or social media data.

Business intelligence is gained from the analysis of the critical business data – analysis which helps owners and managers make better and more informed decisions which are based on an understanding of the business and market.   Business intelligence was a term popularized in the 1990s, but the key was the analytical component (business analytics), which gained focus in the late 2000s. Today it is big data and big data analytics, where organizations are working with massive data sets not previously even imagined.

“…one of the most significant challenges facing enterprise IT teams today is how to efficiently support and enable the “science” of big data, while providing the confidence and maturity of more traditional (and often better understood) infrastructure services.”

http://www.datacenterknowledge.com/archives/2015/05/26/hadoop-big-data-storage-challenge-overcoming-science-project/

The volume and velocity of information collection is ever-increasing even in the smallest of businesses, creating a great need for tools which can structure and correlate data so that it might render some insight.  Simply storing and managing these huge and growing data sets has become a challenge, and there isn’t one right way.

Once the business has the data, then it must find a way to analyze the data, which generally involves also applying visualization tools. Many IT departments are feeling pressured in the development of new skills and capabilities around data collection and management, yet it is more frequently the business user who provides the analysis and applies visualization tools to the task.

“Data collected by the Aberdeen Group, found that employees in organizations that used visual data discovery were more likely to find the information they need, when they need it. These same companies were able to scale their use of scarce IT skills more effectively.”

http://www.tableau.com/learn/whitepapers/visualization-set-your-analytics-users-free#0vXrkWZbizxyutw

The use of business intelligence and advanced analytics continues to grow in every segment of the market – from small business to enterprise – and plays an increasingly important role in supporting business success.

Until this point, most businesses didn’t have the technology or the data to enable significant quality or business transformation, but the times are changing and deployments of data collection, analysis and visualization software and tools are expanding with it. This is a fundamental aspect of business digital transformation and fuels the next step, where intelligence is applied to conditions revealed in the data and activities are automatically performed guided by that intelligence.

jmbunnyfeetMake Sense?

J

Trusted Advisor is About the Work, Not the Title

Trusted Advisor is About the Work, Not the Title

Many accounting professionals believe they are THE trusted advisor the client comes to for advice and guidance on business financial matters.  Having fully bought into the messaging about the value of the accounting and tax work, these professionals are feeling pretty relaxed about their client engagements.  They believe the client will come to them with questions and provide the opportunity to deliver advice or work.  And each year  many clients return to get their taxes prepared or financial statements produced, and even new clients may appear.  But the work remains largely the same – financial statements and tax returns, and addressing additional needs only when the client brings it up, which isn’t all that frequently.

happy_clientOn the other hand, there are professionals who recognize that a proactive approach to helping clients results in better and richer client engagements and better-performing client businesses.  These professionals are truly the business advisors to the client – the trusted partners who understand the variety of conditions which impact business performance and care to make sure they are properly addressed.  This advisor not only reports but makes recommendations and provides guidance on certain situations or processes which are essential in the business model.  These professionals recognize that the bookkeeping and operational information collection is not simply a means to an end; these professionals understand that these foundational processes and the information they encompass are the important details which reflect the true performance of the business… details which no summary report can fully describe.

Having more direct participation in clients’ financial systems is a highly successful component of practice building, helping the firm to mine opportunities that may be hidden in current or new client engagements.  This does not mean that the accounting professional becomes part of client operations or workflows.  Rather, it suggests that the accounting professional understand these aspects of client operations and assist in the development of necessary controls and processes involving data collection or validation.  It may include the implementation of KPI and benchmarking solutions to help identify problems and map improvements, or it may involve the installation of a solution to improve the importing of orders and other transactions into the system, improving the efficiency in processing the information while at the same time reducing the potential for manual data input errors.

Regardless of the depth of direct involvement in client systems, professionals can more fully benefit from every client engagement by providing some level of training, consulting or supporting service in addition to compliance and reporting work.  Services may be aligned toward helping clients set up or support their own in-house bookkeeping and controllership responsibilities, or they may be more suited to providing real-time guidance and review of client business performance data. Either way, the quality of the financial information derived is generally far better and requires less work to adjust and report on.

The key is recognizing that the work involved – whether it is through training, regular process and data reviews, or more direct participation – is not intended to simply streamline reporting on outcomes.  The work the trusted advisor performs is intended to help the client save money and improve business and financial performance, and the practice is rewarded with higher value billable services and a much increased opportunity to engage the clientele in other efforts.

jmbunnyfeetMake Sense?

J

Audit or Advice? Small Accounting Firm Practitioners and Small Business Clients

adviceortaxesWhen a small business owner needs advice about running the business or strategizing on financial matters, one would think that the business owner would engage their accountant in the discussion.  Following along with that logic, many small firm practitioners believe that their small business clients will ultimately engage with them for this advisory work and move beyond statutory audit and compliance work.  For a great many firms, however, there remains a struggle to achieve more work and greater opportunity from client engagements; the firm remains relegated to performing mechanical functions of accounting and reporting and fails to gain the additional work which is truly desirable. There are a number of elements which present themselves in this discussion – considerations that the small firm practitioner may not be addressing – and which are likely contributing to the firm losing the opportunity to deliver more and deeper services to the client.

First, let’s consider why small business owners initially engage with their accounting professionals.  More than with larger businesses, smaller businesses tend to rely more heavily upon the involvement of outsourced accounting professionals simply because the business isn’t able to justify the cost of staffing the position full-time.  Needing office managers and bookkeepers or data entry operators is often a more evident need to the business owner, where assistance with daily operational and information management processes are more urgently required.  Functions considered to be “accounting” could effectively be outsourced to a 3rd party and handled in more of an after-the-fact basis.  For many small business owners, accounting is something which can be performed after all the real work is done, and presents the information necessary for payment of taxes, processing of payroll reports and the like.  The accounting professional is typically engaged because the business owner knows this work must be done by somebody, and believes the selected practitioner to be competent and trustworthy, and they’re also probably local.

With the convergence of market environment changes, regulatory and jurisdiction conditions, as well as changes in behaviors (cultural, sociological, technological), a new level of demand has been created for business and financial advisory services. Yet small business owners often remain reticent to approach their local small firm practitioner for the service. Why is it that the client doesn’t often approach their small firm practitioner with requests for advice and advisory services?

Part of the problem is perception.  Small business owners often believe that their needs require specialized knowledge and experience to address, and that the skill and experience can only be derived from a larger firm. Particularly if the smaller firm is not presenting itself in a manner that suggests that business advisory services are not only offered but are a specialty, the firm may simply lose to competitors who communicate the ability more effectively (something larger and more established firms are able to do via referral and reputation as well as through marketing).

A possible way to address the competency and perception issue is partnering, where firms join to collectively deliver solutions to the client.  Where one firm may specialize in an aspect of the engagement and the other firm addresses other areas, the delivery of full service to the client is ultimately the goal, and sharing the work and the revenue is often a more agreeable approach than losing out on the engagement altogether.

Another factor presenting itself in the equation is the “entrepreneurial spirit” from which many small businesses are fueled.  A small business owner is often somewhat of a superman, taking on multiple roles and performing a variety of functions in the business.  It is this DIY (do-it-yourself) attitude that contributes to the business growth and success, but it is also sometimes the barrier to achieving a higher degree of success. Believing more in the personal power of critical thinking than in the reliance on the professional’s education, experience and insight, the business owner simply refrains from asking for advice because they don’t think they need it.

Frugality is another factor playing into the small firm/small business relationship.  Small business owners may want advice, but they don’t want to have to pay for it.  Anyone selling products or services to small business recognizes that there is a certain amount of consulting and advice that accompanies most sales.  For some, this is simply a part of the sales process; helping the customer determine that this is the best choice and they should buy it.  It’s not so simple with accounting and finance, however.  There’s a big difference – and perhaps large risk associations – in giving advice versus performing accounting and compliance work.  Certainly, advisory services aren’t something the firm would elect to give away, so it becomes essential that the value of the advisory service be expressed in a way that the client can understand and believe.

 I once heard a financial planner address this same argument, where a prospective client suggested that they couldn’t really afford to pay for the advice.  The financial planner countered with the argument that a good financial plan will increase the return, which then recoups the cost of the advice.  If you pay $100 for the advice, and you earn $500 more than you would have without the advice, then it kind of feels like you’re getting paid to get advice because you gain more than you spend.  It’s the same with accounting, finance and business advisory services: sound advice should improve the rate of return, which would more than compensate for the cost of the advice.  The trick is getting the client to view the service as something real and valuable and not as snake oil, and to make a commitment to following the advice.  Real value must be communicated and tangible results measured and delivered, not smoke and mirrors.  Otherwise, the client return isn’t there, and the advice proved valueless.

As regulatory requirements increase – and become increasingly complex – the demand by small business for outside help also increases.  It is this ever-expanding demand which represents opportunity for small firm practitioners to capture more (more interesting and more profitable) work from their small business clients.  But competition is also growing from new providers and systems delivering advice, forcing adjustments to how the small firm must present its offerings and services, as well as change how they deliver and support those offerings.Whether through partnering and referral models, the development of new competencies and capabilities, creation of new workflows and methods, or some/all of the above, small firm practitioners must adapt in order to get that opportunity.

While the small firm practitioner may recognize that the small business client is greatly in need of advisory services, what they may not recognize is that the traditional approach has turned around, and it has become more likely that the client will seek advice first and statutory audit work second. For small firm practitioners, it is time to recognize that relationships are changing and how business is done must evolve to meet and advance that change.

jmbunnyfeetMake Sense?

J

The CPA for Small Business: Proactive, Responsive, and Helps Paint a Beautiful Picture

chartI once read an article written by Doug Sleeter which describing the findings of a published report titled What SMBs Want from Their CPA.  The report was a summary of results from a study conducted by The Sleeter Group, and was intended to help accounting professionals understand the factors in the market which influence business use of professional accounting services.  While adoption and use of technology was not named as the top item on the list, capabilities which can be rendered only if such adoption occurs were.  In short, it’s not the technology that clients demand, but the level of service that professionals can only deliver by embracing advancements in technology and applying them to the client engagement.

The report and article placed a specific focus on trends relating to technology adoption and use in the professional practice, and establishes a foundation for firms to understand why technology is and always has been a key factor in the success of the CPA-client relationship.  It’s not that the accounting professional must become a skilled technologist and promote high technology to the client.  Rather, the success factor rests with the firm’s motivation to implement technologies and tools which will improve their ability to deliver more (and more valuable) service to the client in a more direct and timely manner.

The survey’s two critical questions posed to small business owners who use the services of a CPA were 1. What factors played a role in your decision to leave your former CPA?, and 2. What types of services would you like to receive from your CPA?   Both questions are pretty straightforward, and the top responses from surveyed SMBs were equally unambiguous.

To the first question (factors playing into a decision to leave former CPA), the top two answers indicated that reactive and/or unresponsive are the problems which ultimately cause a small business owner to change accounting professionals.  The top response was “Former CPA didn’t give proactive advice, only reactive”.  The close second response was “Former CPA had poor responsiveness”.

Unfortunately, these responses more than accurately describe many professional firms and their approach to client service.  These firms are perfectly content with waiting for clients to deliver after-the-fact information, delivering reports long after their relevance has past, and providing no sense of urgency in helping clients address business issues facing them here and now.  These firms are content to work with their write-up and trial balance solutions, depreciation and amortization and tax products – and give little consideration to how they could adjust their operation to a better, more relevant and rapid delivery of service and insight to the client.

The second question, “What services do SMBs want from their CPAs?”, was met with the same responses professionals have been hearing for years; small business owners need help with business planning and business strategy and they wish the help would come from their CPA.   It is surprising how many accounting professionals list business planning and strategy among the services they promote on their websites, and then just sit back and wait for clients to ask.  Communication with clients remains relegated to annual reminders for tax information, or maybe slightly more frequent notes about other tax or compliance work to be done.  It may be a bit unfair to place all the blame on the professional.  Regulatory and reporting impacts on business are increasing and are increasingly complicated.  Many professionals find it challenging enough simply to keep up with changes relating to the services they currently and regularly provide.

This is where practitioners should seriously take notice, and accept that the ability to meet changing market and customer demands is by intelligently leveraging technology to accomplish what people and process cannot do alone.

  • It takes information technology to speed up the bookkeeping, accounting and reporting processes; technology is required to help turn information into useful and relevant data;
  • technology facilitates the faster collection of information from and the delivery of information to clients;
  • technology is applied to reflecting numbers as pictures and helping users visualize the meaning of the data, and
  • technology enables the collection and analysis of “big data”, which leads to AI advancements and greater intelligence delivered through the applications businesses use.

The Sleeter Group report clearly demonstrated that small business owners continue to need and want more than just tax returns and post-facto reports from their accounting professionals, and that the lack of attention in these areas pose a direct threat to the small business/CPA relationship.  Professionals can remove the threat by working closer with their small business clients, applying technology and process controls to get better information in a more timely manner, and returning the result with greater insight.  Be proactive and be responsive, and apply the necessary technologies and business philosophy to get there before the client base looks for satisfaction elsewhere.

I’ve said before that small business owners don’t care about the numbers, they care about the picture the numbers paint, and they care about getting to a place where the picture is absolutely beautiful.  With the right tools in place, their CPA can help guide them there.

jmbunnyfeetMake Sense?

J

Surprise! Consumer apps get IT approval in small businesses: GIGAOM.com

Surprise! Consumer apps get IT approval in small businesses: GIGAOM.com

In a recent article on GigaOm, author Barb Darrow discusses the findings of a survey of small businesses in the US, UK, Canada, Australia and New Zealand, where it was found that the use of “consumer” information technology is being more widely accepted for use in small businesses, and that many of these selections are happening without the knowledge or participation of the IT department.

“Employees are driving business apps selection in many small and medium businesses, according to new research. A good percentage of productivity, social and collaborative apps now sanctioned by IT in SMBs were brought in by workers without IT knowledge.“

Reporting that small businesses are adopting “consumer” IT, and that it is OK with IT departments, isn’t a surprising finding.  Small businesses have begun leveraging mobility and cloud solutions to their benefit, being able to take advantage of powerful technologies that previously only enterprise IT departments could enjoy.

 “.. the line between personal and workplace technologies has become all but invisible. That poses real challenges to IT departments that have to deal with all sorts of technology coming in over the transom. But it also opens up opportunities for vendors that design easy-to-use consumer apps to enter the business realm as well.”

The cloud introduces new agility and capability for all businesses, not just small business. For IT departments in larger businesses, this is a big IT management issue. For smaller businesses, the IT manager is often the business owner or an occasionally contracted on-site technician.  When faced with IT needs in the business, many small business owners will at some level rely upon the solutions they also use in their personal lives – in many cases, there simply isn’t a budget for both.  The line between business and personal has always been “blurry” for the small business owner.

Make Sense?

J

Read more: Disruptive Trends = Emerging Opportunity: Adapting to a changing technology and business environment

What will my business be worth, when I need it to be worth a lot?

bodeguy

Business Enlightenment

Get on the path…

  • Read more about how accountants need business intelligence, too
  • Read more about how there’s no fear and loathing in accounting
  • Read more about the pressure on accountants to deliver more value and intelligence to their clients
  • Read more about Data Warriors: accounting in the cloud