Category: Azure

Posted on

Fix the Data, Then Let AI Scale It

For SMB’s Using Solutions like QuickBooks Online, Service Titan or Jobber, High-Quality Data Is Critical for AI

Many small and mid-sized businesses now run on a combination of operational and financial tools. A typical stack might be QuickBooks Online (QBO) for accounting plus Service Titan or Jobber for field operations. Noobeh helps these businesses centralize their data, making it available for analysis and AI.

What we increasingly find is that various AI vendors promise AI-powered forecasting, automation and insights, but AI does not create clarity on its own. When data across these systems is inconsistent or poorly structured, AI simply automates confusion. To get real value from AI, SMBs must first ensure their data is accurate, aligned, and trustworthy.

The Reality of Disconnected SMB Systems

For these small businesses, each system serves a different purpose. QuickBooks tracks financial transactions, revenue, and expenses, where Service Titan or Jobber manages the jobs, customers, technicians and billing. There may be problems lurking in these various systems, and it is often revealed when the data is centralized and made ready for reporting and AI-enabled analytics.

These problems arise when the same business concepts—customers, jobs, revenue, costs—are represented differently in each system. Common examples of this include jobs marked as complete in Service Titan or Jobber but not fully invoiced in QBO, or customers duplicated or named differently across platforms, or any situation where manual spreadsheet adjustments are needed to make the reports work.

Imagine training your AI on this data. It isn’t going to resolve the data issues or repair them, it will repeat them at scale.

A Practical AI-Ready Data Path for SMBs

Before deploying AI features across QBO, Service Titan or Jobber, our consulting teams help our clients focus on making sure the data is ready by cleaning and standardizing QBO financial data and ensuring jobs, customers, and invoices align across systems. Our cloud services team leverages Azure platform services to create automation and eliminate manual spreadsheets and workarounds. Then we centralize the data in Microsoft Fabric, creating a single source of truth allowing reports to be validated prior to laying AI on top. This approach turns AI from a grand experiment into a dependable business tool.

Trust Is the Real Measure of AI Success

AI only delivers value when business owners, finance teams, and operators trust the outputs. That trust comes from seeing numbers that reconcile, reports that make sense, and predictions that align with reality. When this alignment occurs through high-quality data, AI forecasts become credible and insights are explainable. Decision-making improves consistently.

Fix the Data, Then Let AI Scale It

AI can help SMBs compete with much larger organizations—but only when it’s built on a strong data foundation. QuickBooks Online, Service Titan, Jobber, and Microsoft Fabric form a powerful stack, but their value depends on data quality and alignment.

For SMBs, the winning strategy is clear: fix the data first, then let AI scale what’s already working.

jm bunny feetMake Sense?

J

Posted on

AI FOMO and Your Business

“AI FOMO” (Fear of Missing Out) has become a major force behind business adoption of artificial intelligence.

Rather than pursuing AI with a clear strategy, too many organizations are investing because of competitive pressure, media buzz, and fear of falling behind. This reactive approach often leads to rushed, expensive, and poorly executed initiatives that fail to create real value—and can even spark internal friction.

Surveys show that a large share of IT leaders and executives—sometimes more than 60%—acknowledge that FOMO significantly influences their AI adoption decisions. This fear is fueled by rapid technological change, assumptions that competitors are gaining an advantage, and limited understanding of what AI can and cannot actually do.

Implementing AI without thoughtful planning or alignment to business needs often results in wasted investments in tools that don’t address real problems. Projects may stall in the early stages or fail to produce any measurable benefit or return on the investment.

Among the biggest challenges with AI centers on data and trust.

When a business puts speed of development above quality and security, it can lead to data errors, AI “hallucinations” and just plain wrong answers that diminish trust in AI systems. Workers may already feel threatened or undervalued, which creates anxiety and slows tech adoption, so care must be taken to not prematurely introduce AI that may further erode trust in the technology.

I’ve always understood that technology isn’t just a tool, it can be a strategic advantage helping businesses gain in ways not previously available. The key is to move away from fear-based adoption and toward a deliberate, value-driven approach.

Start with identifying the real business problem. With AI, figure out what problems you need the technology to solve for you rather than asking what AI can do. Just because AI can do something doesn’t mean you want it to do it for you, or that it will deliver any real value to your process or operation.

Change for the sake of change makes no sense, so it is essential to understand if there is actually a problem that AI may be able to solve and that the benefits of the solution outweigh the cost to develop and the risk potentially introduced. Start small and have pilot projects in low-risk but high-impact areas of the business where the organization can learn and refine before scaling.

Among the most important aspects of AI in business is the data the AI works with. This is where many businesses fail in their initial attempts with AI development, due largely to the fact that data is siloed or segregated and completely unclassified or categorized.

For AI development to deliver effective business benefit, high-quality, organized data and solid data infrastructure are essential.

AI systems learn directly from the data they are given. If the data is incomplete, inaccurate, inconsistent, or poorly managed, the AI’s performance will reflect those flaws. AI models are only as good as their data because AI systems—especially machine learning and generative AI—identify patterns and make predictions based on training data.

Poor-quality data results in biased, unreliable, or incorrect outputs. High-quality data supports accurate, trustworthy, and consistent results. If an AI is trained on inaccurate or inconsistent information, it will learn (and repeat) those errors.

    Shift from a fear of missing out to a fear of missing the advantages of AI.

    The focus should be on maximizing AI’s potential to create a competitive advantage, taking strategic risks that are aligned with the business goals. Replace fear-driven decision-making with thoughtful, goal-oriented planning and turn AI into a meaningful source of long-term value and differentiation rather than an anxiety-inducing trend to chase.

    Noobeh cloud services works on the Microsoft Azure platform, creating data platforms and delivering services that fuel and support AI development. Let us create the dynamic data infrastructure your business needs to develop the intelligence to propel you forward.

    jm bunny feetMake Sense?

    J

    Posted on

    Unlock KPIs and Improve Reporting with QuickBooks

    It is surprising how many businesses still keep boxes of 3×5 ledger cards with customer and vendor information on them. More likely than the card box, the business may be storing its essential customer billing and vendor product information in the accounting system because that is the system they have.

    These growing businesses need a better system to capture more information that delivers greater detail for accounting and reporting purposes. Just as likely, the business has other information it should and possibly could be capturing but isn’t sure about what steps to take next.

    When details that inform a process are not part of an integrated system, it creates greater potential for lost or inaccurate data. The larger the volume, the more difficult and error-prone managing the information becomes.  

    Business needs more detailed information about… everything.

    Businesses may need to track time for payroll or jobs or both, job tracking may be a requirement, inventory tracking or more detailed inventory management may all be areas for greater attention. Mendelson Consulting can help develop these capabilities by making sure the business is using the right software, and then enabling the functionality needed to support the workflow and capture more and better data.

    No data means no KPIs.

    More and better data means more information to fuel KPI reporting. Key performance indicators can reflect operational performance in a variety of areas and may help identify where improvements are required.

    Using data from the accounting and operational systems, businesses of all sizes measure their effectiveness using KPIs to evaluate the successes – or failures – of their processes and activities.

    Mendelson Consulting’s team of QuickBooks Enterprise Experts and ERP consultants provide guidance, implementation and training, and report development to get beyond bookkeeping to proper processes that result in good accounting data. Mendelson’s cloud services team – Noobeh – sets it all up on Microsoft Azure, where data connectors, data warehouses and Microsoft Fabric weave it all together.

    Whether just starting out or an enterprise or franchise expanding at a national or global level, we help businesses do more with their systems and software. We understand each stage of business and how to help our clients reach their next best level.

    jm bunny feetMake sense?

    J

    Posted on

    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

    Posted on

    Preparing Your Business for Technology Outages

    There is a lot of discussion today about how our children are growing up in a world where high technology is simply part of life and lifestyle.  I even read an article about how people are evolving because of the availability of information; evolving to the point where we no longer store and retrieve information, but store information on how to get information.  The article cited an example of someone who couldn’t recall the name of an actress in a movie they had seen, so the immediate response was to search for the answer on Google.  In the past, people relied upon memory and found various ways to mentally associate and store information so it was able to be recalled.  Now, there’s an app for that.

    Are we losing our ability to effectively store and recall information?  Are we forgetting how to do things before we had technology to help us?  It might even make one wonder about how technology-dependent society has become. Consider the ruins of past civilizations where seemingly impossible structures are found. These structures cause questions about the technology available at the time as we wonder how they came to be.  The knowledge was there at some point but is now lost to time.

    Is your business at risk from a similar fate?  Loss of business institutional knowledge and operational intelligence is often a problem, especially as a business grows. Too many companies fail to consider critical issues such as knowledge management and sustainability.  Finding ways to capture business knowledge and protect it is essential in every organization, whether small business or large enterprise.

    Small businesses are often centered on an owner who started the operation, and who just knows how things are done.  The primary goal in this situation is to capture that knowledge and turn it into process.   Only through this approach may a business begin to reduce its reliance upon a single individual, a critical step in creating both sustainability and continuity in the business. In larger enterprises, process and structure are essential to keep the various parts and participants moving in the same general direction and toward the common goal.

    Once those processes are established, generally using technology to support or facilitate them, is that the end of the task? 

    Many businesses believe that establishing software-supported workflows and standard processes is sufficient to keep the company operating. If a major system or technology failure occurs, workers are left standing around unable to get their jobs done.  In the worst cases, there isn’t anyone in the business who really understands how to pull things back together or there is no longer access to electronically stored information necessary to continue operations. 

    How would you handle things if your systems – your computers and software and systems – were no longer available to you?

    While GPS and autopilot systems can bring tremendous efficiencies to the process of flying, they also can give a false sense of security that encourages complacency. If something goes wrong, the autopilot will adjust and the computer will tell you where to go, won’t it?

    Here is where technology has the ability to distract pilots–and entrepreneurs–from asking themselves if they’re both focused on and capable of solving the right problems. inc.com

    Every business must consider how they would address a severe information technology outage and should take steps to protect and preserve business knowledge so that there is some hope of recovery from such an event. 

    Mendelson Consulting and the Noobeh cloud services teams help businesses implement efficient workflows, consistent and effective processes, and technology to secure, support and maintain operational readiness. No matter how redundant the tech is or how thorough the planning is, there is always a possibility of an outage. Owners and managers should understand how to continue operations and handle business in the event the technology fails unexpectedly.

    jm bunny feetMake Sense?

    J

    Posted on

    Write it Once – The Value of Integration

    It’s amazing how much time and energy continues to be spent on duplicate data entry and re-keying information generated by one system into another.  Human-based data entry is prone to errors, takes time, and carries with it the burdens of employee costs and resources.  It is a problem that businesses of all types have battled for years even though enabling solutions have been around for a while. 

    Methods of integrating applications and data have existed for quite some time, and in recent years these methods have expanded to include a wide variety of platforms and more open standards-based approaches.  Even in the small business world, business owners using traditionally limited software products can enjoy sophisticated extensions and integration of their applications and business data.

    To provide a simple example of the problem: when an individual writes a check, that check must be recorded for several purposes including the recording of the cost or expense as well as the reduction of funds in the bank account.  When a product is sold to a customer, inventory is relieved, sales are increased, accounts receivable or cash is increased, costs of goods sold are experienced, and customer activity is captured.  All of this information must be recorded, and the activity accounted for throughout the financial and operational systems and can represent a tremendous burden if not automated. This also means that data exists in a variety of places, increasing the challenges of information collecting and reporting.

     Cloud-based integration and infrastructure services such as DBSync and Microsoft Azure enable seamless collection, transformation, aggregation and storage of business data. Whether linking accounting with sales CRM or pushing financial and operational data to an Azure data warehouse for analytics, Noobeh and DBSync provide the data engine and the infrastructure to put it all together.

    A small business owner’s situation offers a direct illustration. He sells computer parts through an ecommerce website.  Orders from this website are emailed to his order operators, who then turn around and re-key the orders into their accounting system where the inventory is also tracked.  Because of the increasing number of sales orders and product purchase orders to enter on a regular basis, there were three operators working in the department responsible for making sure website orders make it into the accounting system. Orders were frequently missed or misplaced, entry errors caused problems in accounting and product delivery, customer satisfaction went down, and the cost of handling web orders was increasing.

    By implementing a single software solution, the company was able to not just address the current problem, but was set up to seamlessly increase business without increasing headcount. The solution was a system which takes transaction data from the ecommerce system and imports it into the accounting/ERP system. This single step allowed the business to reduce and redirect personnel costs, improve accuracy and timeliness of data entry, and increase customer satisfaction as well as overall business performance.

    In even a small company, one piece of information may be used in a variety of ways and in a variety of systems. This complexity is found in simple business models as well as larger and more complex enterprises, revealing the value of integration solutions and automation tools at every level of operation.

    Mendelson Consulting and Noobeh cloud services recognize that every business needs the right information at the right time to operate effectively. Our expert teams help businesses implement the solutions which bring business data together, empowering workers to be more productive and giving stakeholders the decision-support tools they need.

    jm bunny feetMake Sense?

    J