The State of SQL and BI: Analyst and Executive Perspectives report (which surveyed more than 200 data analysts at the end of 2020) reveals a priority gap between data-dependent company executives and data/BI analysts and data scientists. Executives are most concerned with high-level issues such as data security (55%) and IT infrastructure (39%), while the analysts' biggest challenge is IT infrastructure quality. The report found, however, that the greatest disparity between the two groups is over cost and budget constraints – only 13% of executives are concerned by these as compared to 32% of the data analysts.
Additionally, the report found that nine-in-ten data analysts are seeking a BI platform that allows the user to create reusable data models using SQL syntax. According to Angshuman Guha, CEO and Founder of bipp, this means they’ve grown tired of rewriting queries for every question.
“BI analysts want their data models to be encoded forever and used across their entire companies. Ultimately, this means everyone is using the same language to represent critical KPIs and data,” he added.
- More than one-in-five data analysts report that collaboration limitations and lack of real-time data are major challenges of their business intelligence platforms.
- 75% of those surveyed reported using SQL databases most often for data analysis. Of this group, two-thirds (66%) are part of a dedicated analytics team within their organization and 80% have purchase-decision authority.
- 49% say that budgets for dedicated business intelligence would increase significantly in 2021.
- 63% state MySQL is the most frequently used database management system while 43% use SQL Server.
- 21% state that cloud analytics will have the greatest impact on their BI and analytics programs over the next two to five years.
“SQL-enabled BI platforms let power users better analyze and query data and save data analysts and business users' time while increasing the impact of their work. Using SQL natively can, however, be repetitive, and an unnecessarily complex way of managing data,” continued Guha. “Our survey shows a need for business intelligence platforms that bridge the concerns of both data analysts and executives. Modern platforms must be secure, include sophisticated data-modeling, provide high-quality visualizations, and be collaborative environments.”
The State of SQL and BI report was based on a survey of more than 200 hands-on data analyst respondents in the United States, with over 50% representing C-level/presidents/founders and vice presidents, directors, or managers. Data scientists and analysts represent 23% of all respondents queried.
Download the full The State of SQL and BI: Analyst and Executive Perspectives report, to access the complete and detailed findings.
BIPP Inc. is a business intelligence (BI) company that helps organizations use their data to make better and faster decisions. Our enterprise-grade, in-database, cloud BI platform was developed to save data and BI analysts' time and develop insights faster. It leverages SQL and is powered by the bippLang data modeling language, which supports collaboration, git-based version control, and re-usable data models.
Business users can use bipp to build and explore ad hoc reports on their own. They can slice and dice data and create visualizations, with updates reflected in real-time. Insights can then be easily shared across their organizations. To access bipp’s open beta, visit https://app.bipp.io/signup#!/