By using tdwi.org website you agree to our use of cookies as described in our cookie policy. Learn More

RESEARCH & RESOURCES

TDWI Checklist Report | Moving Beyond Spreadsheets: Six Steps for Enabling Small and Midsize Businesses to Gain Data Insights

August 1, 2014

Technology trends are moving in a favorable direction for small and midsize businesses (SMBs) seeking to improve their prowess in business intelligence (BI) and analytics. Tools are becoming easier to use for nontechnical users—that is, business users who may know their data but have neither the training nor the skills to write queries or provision their data. SMBs are generally defined as organizations with fewer than 1,000 employees and less than $1 billion in revenue. Most SMBs do not have the large and experienced IT functions found in most large organizations to manage data, build data warehouses, and develop BI and analytics applications. Thus, the evolution of BI and analytics tools and platforms toward greater ease of use and deployment has the potential to level the playing field for SMBs as they compete with larger organizations.

Currently, the most prevalent tools in use within SMBs for accessing, analyzing, reporting, and presenting data are spreadsheet applications and reporting tools embedded in point solutions for finance, sales, or other operations and business management. However, with analytics becoming a competitive differentiator for SMBs, leadership in these organizations must determine whether users’ current tools and platforms for data access, analysis, presentation, and management are adequate for meeting data-driven decision-making needs. Without the ability to interact with data effectively, SMB users are at a disadvantage, especially as business growth, change, and regulatory duties increase the size of (often scattered) data resources and the complexity of analytical demands.

Although some SMBs came into being with BI and analytics as part of their DNA, many firms are only now realizing that they need to reach higher levels of maturity in how they access, analyze, and share data. They are making plans to upgrade their capabilities. It can’t be done all at once; the best approach is to tackle goals gradually, keeping the deployment of new technologies and methods aligned with business objectives. To ensure alignment, enterprises need good communication and collaboration among business and IT leadership.

This TDWI Checklist Report details six areas where SMBs should focus as they move beyond spreadsheets to improve capabilities for gaining data insights.


Your e-mail address is used to communicate with you about your registration, related products and services, and offers from select vendors. Refer to our Privacy Policy for additional information.

TDWI Membership

Get immediate access to training discounts, video library, research, and more.

Find the right level of Membership for you.