• Votes for this article 2 people voted for this
  • Dashboard Insight Newsletter Sign Up

10 ways for SMBs to Capture Value from their Data

by Nicolas Raspal, We Are CloudMonday, July 5, 2010


When it comes to acquiring business intelligence (BI) capabilities, many small and medium-sized businesses (SMBs) have traditionally been at a disadvantage. They often cannot justify the large CapEx demanded of them, do not have the IT resources to run an on premise database and server system and are not sure that they have the breadth or depth of data to warrant such a system. Often their needs changed and evolved far faster than software could be developed and installed.

However, just as the prediction that there would never be more than a million cars in Britain due to the lack of chauffeurs is now laughable, the emergence of self service BI has blown these traditional problems out the water and opened up BI to millions of new companies.

Self service BI is all about empowering the end-user and removing the high barrier to entry, both in terms of CapEx and in-house expertise. The Software as a Service (SaaS) model not only breaks down this barrier, but also incorporates the flexibility to grow and evolve as smaller companies respond to their data and expand.

In this paper we explore the ten key considerations for SMBs setting up a BI project and explore some common mistakes to avoid.

  1. Set the business objectives

    Knowing what you want to achieve helps to ensure quick and tangible returns on your investment. Whether your intentions are to analyze historical data to realign your strategy, spot trends in today’s data and respond quickly or to create predictive models to optimize your sales; knowing the primary objective for adding value with your BI application will keep the project focused and on budget. Of course, the actual usage will likely outgrow original intentions but this should not stop you having a usage target in mind. Having business goals in mind will also avoid the age old BI pitfall of the solution becoming an IT project rather than a business initiative.

  2. Don’t reinvent the wheel

    Building a tailored solution is expensive and the chances are that your data are not that different from 99% of the other companies out there. It also brings the added cost of being inflexible and needing significant in-house expertise to handle it. Unless you have some unusual data formats or particularly off-the-wall analysis you want to do, there shouldn’t be any need to have a package built for you.

  3. Make it fast, make it relevant

    Good BI technology gives a better view of the business. Unprofitable product lines can be scrapped and resources can be moved to more profitable areas of the business. However, where SMBs differ from traditional users is that their markets and business can change and develop over a much shorter timescale. Business users cannot afford to wait weeks for BI experts to have the time to perform technical queries as in a traditional system. The data must be streamed directly from sources such as Excel or Salesforce and be easily manipulated by anyone in real time.

  4. Don’t weigh down your IT department...

    ... by making them responsible for day to day running of the service. This not only has the potential for significantly slowing down reporting , but also to prevent IT from doing their primary role effectively – supporting the business’ use of IT and planning its strategic development.

  5. Play with your data

    While well thought out and planned data visualizations are extremely valuable, the ability to play freely with your data, switch between displays and mix data sets can allow insights into your company that couldn’t be foreseen. It from this kind of analysis that some of the most powerful conclusions are made. Of course, this has to be facilitated by intuitive, easy to use software.

  6. Recognize your current BI investment

    Excel is everywhere and its value should not be underestimated, not only because it is an extremely powerful piece of data modeling software, but because almost everybody has at least basic training in using it and most users will not respond favorably to being separated from something they know and trust. Any solution must complement Excel, not replace it. Where Excel really does not perform is in data visualization, collaboration and access, so any solution must incorporate these features as a minimum.

  7. Scalability

    SMBs are looking to grow so you need BI designed to grow with you, whether that be more users, more data or more advanced analysis. This is an area that SaaS applications do best, with enterprise level functionality being licensed even for a single user and the ability to be rapidly scaled if desired. Paying a monthly subscription with no upfront costs also means you can scale down or shut down quickly with no loss of investment.

  8. Keep It Simple, Stupid!

    This one’s up on our office wall. Don’t get bogged down thinking about metrics and analysis that you might one day want, but are probably going to forget that you’ve got. Start with simple analysis that doesn’t require two days to work out how to perform and then build in complexity as required. BI users are often surprised by how much they learn in just 30 minutes playing with simple visualizations and mixing data sets.

  9. Share your findings!

    Make sure that it is easy to share and collaborate on data analysis and its findings. This avoids the repetition of work, allows people to copy each other’s best practices and allows discoveries from the data to be utilized across the company. It also fosters a sense of pride in data analysis and discovery.

  10. Use it!

    This one’s key. Once you have your system in place, there has to be significant endorsement by the senior management and a culture of trusting the data when making decisions. If people think that their analysis will end up read but ignored, they’ll give up looking for the data pattern that could make all the difference to a vital strategic decision.

Tweet article    Stumble article    Digg article    Buzz article    Delicious bookmark      Dashboard Insight RSS Feed
 Next Page
1 2
Other articles by this author


No comments have been posted yet.

Site Map | Contribute | Privacy Policy | Contact Us | Dashboard Insight © 2018