Tag: business intelligence

Posted on

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

Posted on

Taking Action to Expand Overtime Protections | whitehouse.gov

The Department of Labor is finalizing a rule to update overtime protections for workers. “In total, the new rule is expected to extend overtime protections to 4.2 million more Americans who are not currently eligible under federal law, and it is expected to boost wages for workers by $12 billion over the next 10 years.”

Source: Taking Action to Expand Overtime Protections | whitehouse.gov

This is a difficult subject for everyone involved – workers and business owners alike. Increases in minimum wage, increases in employee health care costs, and adjustments to wage and hour regulations all serve complicate and cost businesses more.  Fair payment for time worked, a living wage, and protections for workers from employer abuse are things that are expected – deservedly so – by employees.   Definitions vary, as do circumstances, so a one-size rule never really fits all and someone, somewhere, feels the burn.

A USA Today article on the subject describes Labor Secretary Thomas Perez as saying “the salary threshold was originally intended to exempt high-paid executives but instead has denied overtime to low-level retail supervisors and entry-level office workers who often toil 50 to 70 hours a week.”

On the other hand Dan Bosch, head of regulatory policy for the National Federation of Independent Business, was described as saying that “many small businesses can’t absorb the added cost and will instruct employees to work no more than 40 hours a week, bringing on part-time workers to pick up the slack”.  From Trey Kovacs, policy analyst with the Competitive Enterprise Institute: “The Obama rule puts a huge cost and regulatory burden on employers, who will face pressure to cut back on benefits and full-time employees”.

A bill was introduced on Thursday by Republican congressional leadership hoping to block the proposed overtime rule. The proposed legislation, Protecting Workplace Advancement and Opportunity Act, is intended to ensure that the Department of Labor takes a “balanced and responsible approach to updating federal overtime rules.” Sponsors of the legislation include members of the Senate Committee on Health, Education, Labor, and Pensions and the House Committee on Education and the Workforce.

Part of the bill’s consideration may be the burden of record keeping and information management that just keeps growing ever larger.  The current DOL changes, for example, now suggest that businesses must keep time and attendance records in detail for their salaried employees who might qualify for overtime compensation.  Getting employees to keep time cards or complete timesheets  may not be an easy thing to do, yet punching a timeclock and tracking their hours may become their new normal.  Some employers, on the other hand, will elect to simply raise workers’ base pay to the new threshold, avoiding paying the overtime and skirting the need to keep detailed time records.

logo-we-heart-employees

The extension of overtime protection to another 4.2 million Americans, and boosting wages by $12 billion over the next 10 years is the expectation for the new rule’s impact, although opponents suggest that employment (and employers) will suffer, reducing their workforces while absorbing costly HR management processes just in order to comply.

The rule is likely to touch nearly every sector of the U.S. economy, with the most notable adjustments occurring with nonprofits, retailers and hospitality (hotel and restaurants), as these are the industries generally having management-level workers whose salaries are at or below the new threshold.  Whether the outcomes of the rule will be as expected remains to be seen, but it is certain that many businesses must now put in place software, systems and processes which will help not just help them comply with new wage and hour rules, but deliver enough intelligence to support better personnel management, employee scheduling and labor cost containment.

jmbunnyfeetMake Sense?

J

 

Posted on

Accounting for Custom Manufacturing

Accounting for Custom Manufacturing

Accounting and bookkeeping is a part of every business large and small, yet there are myriad details to work with and a multitude of possible approaches to addressing the requirement.  From a summary perspective, there are standards which are fairly easily met, providing the basics of sales and expense tracking and income reporting sufficient for basic tax and compliance work to be performed.  Yet accounting may go much deeper into the operational processes of the business, delving into the details of productivity and profitability in order to find and expose areas where the business might improve both.

mfgManufacturing, particularly custom manufacturing or ETO (engineering to order) is among those industry types that could benefit tremendously from a more intimate and detailed approach to accounting.  Unfortunately, it is often difficult to find experienced professionals with not simply a competence in working with manufacturing industry sector clients, but specifically with ETO process.  Building to order is one thing, but finding the way to improve efficiency and profitability when every job is a custom encounter takes additional skills and a lot of data.  Accounting professionals with these skills are needed to help these custom manufacturers grow, transform their businesses and make the overall operations more efficient and sustainable.

It seems logical that manufacturing and ETO space businesses are ripe for the same bridging of technology and analysis that the accounting industry started broadly approaching some years back.  With bookkeeping processes being more frequently outsourced to non-accountants, the accounting professionals saw increased pressure to find more efficient ways of doing things and had to find new value to deliver to clients.  Technology, data collection and analysis became the foundations for delivering on that new requirement.  With the established model and philosophy, bringing more operational aspects of client systems into the mix and extending the model end-to-end just makes sense.

It takes a combination of systems – from the core accounting solution to the manufacturing control or other operational systems, through to the analytical tools.  Leveraging hosting technologies and cloud service, businesses are finally able to bring the multiple work locations – shops, warehouses and business offices – together in a single software and technology platform, and collect the level of detail necessary to provide a comprehensive and true picture of the business.  The analytical tools then provide the means to explore the details and identify where improvements might be made or where previously unrecognized risk exists.

QuickBooks desktop editions remain among the most popular financial systems used by manufacturing and job shop applications, largely due to the effectiveness of connecting the operational applications to an accounting solution which proves highly workable and which has strong industry support.  Even with the emergence of QuickBooks Online (and the push by Intuit to get customers to adopt this web-based alternative to desktop-based software) the QuickBooks desktop edition products continue to provide more functionality and application support for these working models, as the ability to fully manage the information in the solution exists more in the disk based products than it does in a multitenant web-based application.  Accounting “mechanics” are able to see, access and work with all the data rather than simply view reports where only half of the transaction is visible – making detailed accounting and data analysis more readily available.

 

The key is to leverage the accounting professional, the right software tools, and the platform and delivery environment that allows it all to work in concert for the entire organization.  Add the QuickBooks hosting service so the participants can work more closely together.  Enabling the accounting professional and bringing them closer to their clients (and client systems) allows the deeper move into operational issues, creating the basis for both to receive new and more value from the relationship.

jmbunnyfeetMake Sense?

J

 

 

Posted on

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

Posted on

State of the Union: The Irrelevance of Good Accounting?

State of the Union: The Irrelevance of Good Accounting?

financeI’m a little concerned, and any professional in accounting and finance who works with small businesses should be just a little concerned, too.  Why?  Because there is a belief out there that some nifty software and Internet Of Things (IoT) approach to finance will ultimately eliminate the need for a small business to work with skilled, trained accounting professionals.  Remember the marketing slogan introduced by Intuit with QuickBooks – the one that suggested that, “if you can write a check, you can do your own books”?  Most accountants will tell you that it is not true, and the ability to operate a product like QuickBooks does not magically turn poor accounting and bookkeeping information into good business data.  In fact, it most frequently enables bad information to turn into bad business decisions – quickly.

DIY bookkeeping solutions have been around for a while, so why the distress about it now? Up until this point, it hadn’t been so overtly stated to small business owners that having less-than-great accounting data is very much OK, and that the role accounting professionals play in small business finances is more of a burden than benefit.  Consider the statement made by President Obama in his recent State of the Union address:

“Let’s simplify the system and let a small business owner file based on her actual bank statement, instead of the number of accountants she can afford”

If I’m an accounting professional, I am pretty steamed up about that statement because I know how screwy business accounting data gets when the work is done by folks without the proper training.  Incorrect or improper accounting treatment can make a big difference when it comes to filing those taxes mentioned…. and not in a good way.  That transaction on the bank statement… Is it a cost of goods sold or a regular business expense? Is it an asset or supply item? Is it a reimbursement or revenue?  Is the payroll deduction before or after taxes?  Is that even a viable payroll deduction item?  These questions and more arise frequently in a small business, and the treatment for these items is improper as often as not.

There is a big value in what a trained accounting professional can offer a small business owner, and the value often translates to eliminating unnecessary tax burdens and the delivery of accurate reporting – both of which are really important when it comes to actually trying to grow a healthy and sustainable business.

Small businesses are often considered to be the fuel powering our economy.  Doesn’t it make sense for us all to recognize that smarter businesses are likely to be more successful, and that more successful small businesses means growth in the economy?  The importance of good fiscal and financial management and reporting – in business and in government – is not something to minimize, and suggesting that it takes no intervention or skill to do the job properly reflects poorly not only on the person saying it, but on the entire establishment.

jmbunnyfeetMake Sense?

J