relational data – Page 2 – Cooper Mann Consulting

February 13, 2018February 13, 2018

Every Business Deserves a Chance to Be Better

Every business owner or manager wants to see growth in revenue and profits, and sustaining a high level of performance requires that the business operate smoothly and without breakage or imbalance. When workers know their jobs and do them well, and when workload performance is regular and timely, the business operation glides.

Yet few organizations fully understand how all of their processes weave together to form the operation, or how changes in workloads and task performance will impact the bottom line. Growing or shrinking workloads, supply chain interruptions and other conditions influence the flow of work in the business, which is why a clear understanding of the workflows and the dynamics of the processes they connect is so essential.

It really comes down to a “degrees of success” question: how much better could the business be?

It is said that the only constant is change, and businesses must find a way to effectively and cost-efficiently meet changing demands and conditions in order to survive. What frustrates many business owners is that change is generally disruptive to the business, representing a significant challenge when it comes to the development of internal processes, procedures and the workflows which bind them. At issue is the understanding that proven, structured and repeatable processes help to improve efficiency, yet changing conditions often require changes to these processes.

Creating agility and sustainable value in the organization suggests that guidance for workers, processes and controls, business and system policies, activities and agents and resources all be brought together to form a complete picture of the business and operation. With this in hand, the business is better able to communicate to each member what is expected of them and when, and to make adjustment or enhancements to how the work flows in order keep moving toward the stated goal.

Informed workflows guide smarter processes, and smarter businesses are more resilient.

Smarter business is built from knowledge and understanding not just of the systems and actors in the enterprise, but of the higher level goals motivating the activity. In a global economy, where competitive pressures are increasing every day for even the smallest of businesses, making process improvements and creating sustainability become as much a focus for the business as growth once was.

Developing strategies for retaining profit margins, improving cash flows, solidifying supply chains and streamlining operational processes is essential when designing the business to handle the stresses of a changing economy. The foundations of such strategies are the people, processes and knowledge in the business, and the workflows which tie them together into a cohesive, high performance enterprise.

What comes as a surprise to many businesses is that their efforts to structure the work – defining the activities which string together to form the process, or connecting the processes in a workflow – often reveals why certain things are done the way they are. Where process and workflow modeling most frequently addresses the “what” and “how” of the business, less often is the “why” question directly approached. The discovery of “why” is sometimes a revelation which comes unexpectedly, providing insight into areas of the business where change could be made, leading to improved process performance and moving the operation closer reaching its goals.

With the popularity and proliferation of online applications and cloud computing, many businesses have transformed how they manage activities, people and resources.

The adoption of individual apps to support specific business activities and processes is increasing, where solutions are often loosely connected, integrating or syncing only selected data used for a particular purpose. The Internet-connected marketplace has introduced both opportunity and challenge for businesses of all sizes, and much of the focus has been placed on the management and control of digital documents and data.

Centralized electronic document management has been commonly used in business for many years, yet has not always been viewed as an essential technology to apply in the context of organizing and structuring the workflows in the business.

Particularly in situations where apps and activities are not always directly connected to their dependent or resultant processes, electronic document management and integration of external data elements become critical to structuring the flow of work.

In structuring workflows and documents systems which support the various business processes, the organization will find that it has developed the means to collect and memorialize the business and operational knowledge owned only by individuals in the business.

Gathering together the “tribal knowledge” from users in the business – investing the learning and experience of individuals into the DNA of the business processes and organization of work– is an essential element in crafting meaningful workflows which capture the human-based considerations that are often overlooked.

When individual knowledge becomes business knowledge and is turned into documents, systems and structured processes which guide the operation, results are able to be reproduced more consistently and reliance upon individuals is reduced significantly.

Business processes are now considered to be corporate assets which require consistent and ongoing management and review.

Because business is not stagnant, processes and workflows will necessarily evolve as conditions change. Managing these processes and the workflows which attach them is an iterative process that must be actively pursued in order to ensure that evolving approaches don’t fail to support higher level business objectives.

While an electronic document management solution may address many of the challenges involved in working with large volumes and varieties of documents and data, there are few DM products on the market which can approach the full realm of business workflows and how they are impacted by business or data-driven events or by the availability of people or resources to facilitate the process.

Businesses must not only structure their documents and data, but also their workflows necessary to support the various processes and should seek to normalize those workflows as much as possible. Through a standards-based approach to workflow development, businesses are able to develop a consistent and methodical approach to the work which results in more predictable and consistent outcomes.

The workflow “engine” is truly the workhorse in the business, connecting the people, activities and information required to fulfill each required task.

Fueled by stored documents, data and business policy, workflows inform the organization on the effectiveness of applied resources, events and agents. Not only providing a basis for measuring process effectiveness, structuring all workflows in the business often reveals why certain previously unrecognized processes occur.

Sometimes referred to as “process mining”, activity monitoring and regular workflow and process evaluation allows the business to develop greater understanding of the rationale it must apply to detect or diagnose processes which deviate from the desired path and cause the business to track away from its strategic goals.

Exact Synergy is the workflow engine which powers global businesses and drives performance.

The business fundamental framework of Synergy allows organizations to structure the entire realm of business activities and provide digital workflows and automation to enhance productivity and ensure accuracy at every step. The core of Synergy connects and tracks the entities, transactions and documents associated with every aspect of the business.

Recognizing that business happens with people, systems and processes, Synergy is the tool organizations use to describe the various entities, actions and requests involved in performing the business, guiding process performance with meaningful workflows which clearly communicate to each participant what is expected from them, when it is expected, and even how to perform.

While essential business needs are met with the initial installation, Synergy is extensively configurable and customizable, considering all areas of the enterprise and offering functionality to support a vast array of requirements. A business may use the solution in a limited capacity, guiding certain HR and other back-office functions, or it can be applied to the entire business and operation, spanning departments and locations, joining processes and acquiring data which might otherwise remain unmanaged and disconnected.

Synergy helps businesses keep actions and decisions aligned, sharpening the competitive edge.

Synergy’s framework combines entity management, process governance and strict security and data controls with a presentation which allows for everyone in the business to view and manage their workloads quickly and directly. Synergy provides each user with the information they need to get their job done without complication or interference, providing the views and access to increase process effectiveness and supporting the most efficient flow of work through the business.

If actions and decisions inside a company aren’t aligned, processes are disrupted and the competitive edge gets lost. With a more intelligent approach to enabling and managing the work flowing through the enterprise, businesses can be smarter and introduce new value for those involved with them.

Make Sense?

Read the Introduction: Fringe to Foundation: Aligning Business Goals and Lifting Business Performance through Digital Workflows

January 30, 2018March 28, 2018

Fringe to Foundation: Aligning Business Goals and Lifting Business Performance through Digital Workflows

You Deserve To Know About Things That Will Make Your Business Better

Every business in the marketplace, from freelancer and entrepreneur to the largest of enterprises, is facing tremendous pressure to change how they do business. Workers demand more options for balancing business with personal life; consumers demand more and different modes of interaction; and business stakeholders continue to demand positive performance even as the pace of change increases.

Digital, social and mobile aren’t fringe considerations in business any more.

People use their phones all the time to do all sorts of things, and a lot of the time those “things” impact the business. From apps and processes that support how work gets done to the policies that guide various aspects of operation and interaction, businesses are discovering that embracing digital workflows and emerging operating models is the new imperative. Every interaction is a transaction, and there are many possible actors collaborating on each one. How well understood is this activity within the business?

From within and without businesses are forced to react to various influences shaping user and consumer behavior, adjusting their processes and creating new core workflows to address digital data, online, social and mobile models that were once considered to be more fringe than foundation. Few businesses, particularly those smaller companies where only one or a few participants do all the work, have a central framework in place to support the vast array of processes and tasks they perform, and even less to help adjust to changing business requirements.

Relying more on individual knowledge than documented processes and structure, small businesses are generally able to retain their agility only as long as they also retain their small size.

What is usually missing in the small business is a foundational workflow system and framework which sets the table for future improvements within the business, and establishes the flexibility to support faster execution while saving costs and reducing investment.

Most business owners don’t consider a workflow-driven system to be an imperative, focusing more on the solutions which address specific operational tasks and activities. This approach may meet business needs for a short time, but the sprawl and distribution of business data and activities enabled with the bolt-on “app” approach often fragments things rather than tying them closely together.

Doing things right in the beginning saves time, effort and money compared to fixing things later.

Businesses should create an organizational structure and employee culture that is “process aware”, developed and built on the solid foundation of structured workflows. This gives the entire organization a visible basis for improvement at any level, allowing a focus on work attitude and operations that are positive and healthier for the company.

It has been proven time and time again that implementing a flexible framework for structuring workflow within the business will help the enterprise improve performance, undertake efforts to support better decision-making, and achieve a competitive advantage. The structure, crossing all functional boundaries and taking a holistic view of the processes, helps ensure that stakeholder perspectives are aligned, makes sure that everyone has a clear understanding of how processes are undertaken and why, and ultimately focuses all organizational efforts towards the right goal.

This is the introductory article in a series which will discuss the values of a structured workflow solution applied to small and growing businesses and why every business large or small should immediately implement such a system.

The discussion focuses on a solution which I believe presents the framework and extensibility required to address the essential needs of business process management along with the flexibility in design to address more unique and sophisticated flows and integrations.

Meet Exact Synergy Enterprise.

The series will discuss WHY businesses must consider implementing workflow and process management and how Synergy meets those needs. Further, we’ll take a look at a successful QuickBooks consultant and developer who implements Synergy internally and for their clients. That article explores how their Synergy-founded professional time and billing solution works with QuickBooks, addressing time and resource management requirements that other solutions couldn’t provide.

The discussion then addresses how bookkeepers, consultants and other QuickBooks advisors can quickly and easily implement a structured workflow solution that delivers immediate value to the business. With out-of-the-box functionality to address essential business processes and activity management including CRM, document management, human resources management and more, there is little or no configuration required making the solution useful on the first launch.

The final article takes a look at Synergy implemented in a business, demonstrating the extensive ability for the system to be custom configured directly by the customer. It is the ability to be customized easily, meeting specific process requirements and connecting to the applications and data that round out the operations that makes Synergy particularly powerful and a key component to enabling a successful transformation into an agile, high performance business in the digital age.

syn·er·gy

the interaction or cooperation of two or more organizations, substances, or other agents to produce a combined effect greater than the sum of their separate effects.

cooperation interaction, cooperation, combined effort, give and take

Make Sense?

January 2, 2018

The nasty surprises hackers have in store for us in 2018

“Hackers are constantly finding new targets and refining the tools they use to break through cyberdefenses. The following are some significant threats to look out for this year.

More huge data breaches

The cyberattack on the Equifax credit reporting agency in 2017, which led to the theft of Social Security numbers, birth dates, and other data on almost half the U.S. population, was a stark reminder that hackers are thinking big when it comes to targets. ..

Ransomware in the cloud

… The biggest cloud operators, like Google, Amazon, and IBM, have hired some of the brightest minds in digital security, so they won’t be easy to crack. But smaller companies are likely to be more vulnerable, and even a modest breach could lead to a big payday for the hackers involved.

The weaponization of AI

This year will see the emergence of an AI-driven arms race. Security firms and researchers have been using machine-learning models, neural networks, and other AI technologies for a while to better anticipate attacks, and to spot ones already under way. It’s highly likely that hackers are adopting the same technology to strike back…”

Source: The nasty surprises hackers have in store for us in 2018

June 21, 2017June 21, 2017

Improving the Business of Art: Making Beautiful Business Decisions

There is a lot more to managing and maintaining an art collection than simply collecting. In the art business, knowing where something came from, how it got to where it is now (and what it cost to get there), and keeping track of it thereafter requires software and systems to store and manage the information. A professional art collection management solution will do much more than simply keep an inventory list of items. This solution must store all the relevant information about the work as well as gather information while facilitating the various business processes relating to activities around the work. The first step to improvement is ensuring all the processes are being facilitated.

Acquiring the item, transporting the item, preparing the item, showing the item, maintaining the item, selling the item… all of these business activities performed must not just be accounted for, they must relate back to the work of art and become part of its historical record. Art tends to move around. Traveling from collector to collector or to different galleries, works of art may change location and ownership or custodial care frequently. The origin of a work and the tracked purchase history, as well as the history of placements is among the critical information to be stored with each item. This most valuable data is part of the legacy of the work that any professional system should address. If information is power, then better retention and management of information regarding a work makes the entire collection stronger.

The location or exhibition of a work, its purchase history, the related museum and contact records – all this and more must be maintained and managed with each and every item in a collection. Essential data such as provenance, condition and value is certainly kept for each work, but the key to making a truly useful system for collectors and artists both is the ability to get all the needed data in a single view or report.

Having the inventory information available for invoicing and reporting is one thing, but also being able to connect or identify individual works and collections with relevant contacts is surprisingly valuable. Tracking other information items like costs associated with shipping or framing, or storing both an appraised value as well as an insured value, provides for a comprehensive record of the work and its properties and makes forms and documents preparation not only more accurate but more efficient and useful, too.

Art businesses are like many other “product”-based businesses in that they have e-commerce needs, they build websites to show off their catalogue, they use mobile applications to display items, and they find much higher efficiency and agility when the websites and mobile applications work with the same real-time inventory data that the rest of the system works with. The goal is to achieve measurable results through improved efficiencies, and that comes from improved information management and integrated systems. Centralized computing models and connected cloud services establish the foundation.

Cloud hosting, remote access and mobile technologies, and location-based solutions are all part of the package for businesses involved in the business of art these days. Implementing a hosting solution which enable anytime/anywhere access to business applications and information is often the first key to unlocking the better and more efficient art business.

Whether it is collecting, selling or showing, users involved in the business of art need secure access to all their information whether they’re in the office or not so they have the data needed to support making beautifully intelligent business decisions when it matters most. The rest is just pretty pictures.

Make Sense?

January 3, 2017July 7, 2017

Big Data, Analysis and Business Intelligence

There 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.

jmbunnyfeet Make Sense?

January 26, 2016February 3, 2016

No REST for QuickBooks Desktop Integration Developers

Intuit, the maker of QuickBooks small business accounting software (among other things), is discontinuing service for the REST API and the Sync Manager on March 1, 2016 [1]. Developers with applications which integrate with the desktop editions of QuickBooks using this method must change their approach right away or risk having their integrations simply stop functioning. It’s not that Intuit will DO something on March 1^st. Rather, they’ll stop doing something – like handling Sync Manager integrations.

There are a lot of different types of businesses in the world, and each of them produces and consumes a lot of information. From sales to human resources; from operations to finance – every business generates and manages information to support the various processes which make up the business activities. Computer systems and software represent the tools businesses use to develop and manage information, and often become foundations for structuring the information which flows through the organization. Just as there may be different people in the business, each with their own responsibilities and job functions, there are likely software applications which are similarly oriented to support different processes within the business. Integrating or connecting different applications and processes within the business helps the organization be more efficient with information usage, generally increasing the quality of access and reporting throughout the business while at the same time reducing or eliminating redundant data entry and the potential for errors. Software integrations are a big thing to many businesses, which is why the discontinuation of Intuit’s Sync Manager for QuickBooks Desktop editions is a big deal.

Intuit’s Sync Manager was the big thing just a few short years ago. Providing developers with a seamless method for accessing QuickBooks company data and passing it to/from web-based and other applications was a boon to the online application model and paved the way for many disk-based integrated solutions to migrate to SaaS offerings instead. Developers who saw success operating in Intuit’s QuickBooks marketplace as recognized add-ons were encouraged to use Sync Manager so that they would be able to seamlessly market to, subscribe and onboard new users who purchased QuickBooks products. Whether or not the developer participated in Intuit’s application marketplace, the Sync Manager and the REST API provided them with some very important capabilities and supported new methods now recognized as “standards” for development of web-based solutions and services.

The World Wide Web has succeeded in large part because its software architecture has been designed to meet the needs of an Internet-scale distributed hypermedia system. The modern Web architecture emphasizes scalability of component interactions, generality of interfaces, independent deployment of components, and intermediary components to reduce interaction latency, enforce security, and encapsulate legacy systems. http://dl.acm.org/citation.cfm?doid=337180.337228

In order to integrate a solution with QuickBooks desktop products, there are two essential problems to solve. First, there must be access to the QuickBooks data. Few products are able to directly access the data in a QuickBooks data file; generally, the QuickBooks program itself is used to ‘broker’ access to the company file. So, developers need a way to work inside of QuickBooks to use it to access the data their applications need. Second, the data must be transported (via the Internet) to allow for data to come from QuickBooks into another app, or to allow data from the other app to come to QuickBooks. The REST API and the Sync Manager addressed both of those problems and provided developers with the mechanisms required to facilitate the data integration as well as transport the data.

REST (representational state transfer) is “the software architectural style of the World Wide Web [2]” and represents a standard for creating scalable, distributed system interactions. Using this method, developers were able to make their online solutions access, read and write data in QuickBooks desktop products because Intuit had first sync’d the data to its servers, so developers needed only to reach the Intuit servers to reach the data. The Sync Manager provided the transport, carrying the data to/from the desktop installation where the Sync Manager service was running. And, because the Sync Manager was basically built-in to QuickBooks, there was no additional software to install and maintain on the computer because it was all part of the QuickBooks installation.

Intuit did a fantastic job of getting developers to move to the API integration method, positioning all those lovely 3^rd party solutions for linkage via an Intuit.com account and, now, to QuickBooks Online. Intuit is clearly favoring the QuickBooks Online edition and the API integration method available with that platform, and is telling developers that they must convert their customers to QBO in order to retain the easy connective ability they had with the desktop editions via Sync Manager.

Now that Intuit has announced the discontinuation of the REST API and the Sync Manager, what options do QuickBooks integration developers have, and how can customers using 3^rd party integrations keep using them? Options do remain, and they aren’t all that bad. In fact, the options which remain continue to be the methods of choice for certain developers. These developers recognized early on that Intuit’s somewhat “lightweight” methods couldn’t handle the complexity or full functionality of their integrations facilitated their solutions using the SDK and never looked back (and still don’t). For this community of developers – many of whom likely never considered trying to market their solutions in the Intuit app marketplace – the elimination of the REST API and Sync Manager don’t really matter. They didn’t bother with them in the first place, just as they aren’t bothering with QBO. Those solutions don’t fit their customers, anyway.

The QuickBooks desktop SDK (Software Development Kit) has been around for years, and using the SDK developers have been able to craft tight integrations between their solutions and the QuickBooks desktop products. From payment plug-ins to fully integrated sales, customer relationship, inventory and manufacturing solutions – a broad range of integrated applications built with the SDK have been successfully deployed to QuickBooks customers all over the world. Many applications which integrate with QuickBooks desktop solutions are desktop products themselves and are designed to work within the same desktop and network environment as QuickBooks, so there is no need to worry about “transport” of the data over the Internet.

For other solutions, such as online applications and services, there may be a need to exchange data via the Web. The QuickBooks Web Connector has also been a very popular solution for developers of applications that integrate data with QuickBooks. The Web Connector is just what its name implies: it is a way to connect QuickBooks to the web and vice versa. With the Web Connector application and a web connector configuration file, developers could provide a method of exchanging data between QuickBooks desktop and another solution fairly simply. While the Web Connector is quite useful in providing a means to transport integrated data to/from the QuickBooks desktop to an external system (like an online application), it only allows access to whatever data Intuit decides. For this reason, many developers use both an SDK application and the Web Connector so their applications can access all data required and also have a web service available to transport it.

There are numerous implications relating to the sunset of QuickBooks REST API and Sync Manager, and another among them is the impact in hosted environments. For customers who are (or might) benefit from hosted QuickBooks delivery models, what does the end-of-life of the Sync Manager mean? Since the Sync Manager was basically built into QuickBooks desktop editions, it meant that there wasn’t any extra software to install or manage when a company wanted to adopt a Sync Manager-based 3^rd party integrated solution. In a hosting environment, this means that the customer could easily add integrated applications to work with their hosted QuickBooks and the service provider might never even know it was being done. There would be no additional software to install on the host servers; so many providers would simply be unaware that their customers were using these other solutions.

As developers return to SDK and Web Connector implementations in order to integrate with QuickBooks desktop, customers will ask their hosting providers to install the QWC (QuickBooks Web Connector) and/or integration software in their service. In shared service delivery models, this may be virtually impossible to do without potential compromise to existing customers using those servers or other applications resident on the systems. Hosting customers will not always understand that a “simple plug-in” actually represents installable software that must be secured, maintained, managed, and kept from improperly interacting with other software in the environment. Some providers may not even be willing to work with the new integration software, while others may allow it but will not take adequate precautions to ensure proper and secure function.

Intuit has said to many constituent groups that its focus on desktop editions of QuickBooks will continue, and new certifications and benefits for desktop ProAdvisors (and continued development of interoperability with other solutions, like the Revel POS integration for QuickBooks desktop) give support to those statements. Yet developers who support integrations with QuickBooks desktop are once again adjusting to the not infrequent changes Intuit makes to developer programs and philosophies. The push to QBO and connected apps may be the focus for QuickBooks marketing dollars, but there are still quite a number of (very busy!) developers supplying solutions to businesses who don’t shop inside their QuickBooks software.

Joanie Mann Bunny Feet Make Sense?