Smart Insights on ANY Data Source

While a good report turns data into information, artificial intelligence (AI) has the potential to transform information into insights—without human intervention. Analysts spend an inordinate amount of time ploughing through reports and dashboards. After endless slicing, dicing, drilling, and pivoting, they gather insights to piece together a paragraph to be inserted in board reports, presentations, emails, and more. The dual task of ensuring the data is valid while providing valuable and accurate insights is often too time-consuming and taxing to be worth the effort to deliver the insights that management demands.

The problem

Providing valuable insights requires a solid understanding of the business, data analysis skills, reliable data sources, and a huge amount of effort. Using predefined templates to generate text is not always functional, takes a lot of time to design, and offers only a limited method for finding diverse insights.

Complicating this further, different scenarios require varying levels of detail depending on the audience and the content of the presentation. While several BI tools offer smart, natural language-generated insights, they are limited to insights on proprietary data engines, and the feature doesn’t work on other databases. What’s more, their insights are often limited in scope and range. To be effective, broad insight generation must include multiple types of analyses including pareto, trends, outliers, and relationships.

Pyramid’s solution

Pyramid’s Smart Insights are used to generate AI-automated natural language analysis of a given visualization or dashboard, with valuable information about the data presented in readable text. Insights are dynamically generated by performing a variety of statistical and analytical methods to produce different sets of analyses based on the query selections. Smart Insights can provide: light metric analyses without covering categories, categorical analyses, or advanced, in-depth metric analyses.

Smart Insights are generated on any supported data source (SQL or MDX)—they are not constrained to Pyramid's own data engine. They are not affected by the structure of the data or its size.  Further, Smart Insights can be focused on a single visualization, a composite analysis across an entire slide of visuals (or dashboard), or it can be set to analyze an entire data model. In addition to basic analyses, Smart Insights can produce pareto, trends, forecasts, outliers, and relationships in narrative form.

Finally, Pyramid’s Smart Insights are live and dynamic, regenerating in real time to reflect any manipulations or changes to the query.

Business case

Diana, the CFO for D&R Retailers, is using Pyramid to perform analytics on her Redshift data warehouse. She has used Pyramid’s Natural Language Query Chat Bot to answer questions while browsing dashboards and viewing reports. Diana is looking for the “gold nuggets” from her dashboards without having to sift through the data and compile insights.

Diana opens a dashboard that analyzes revenue and returns over the last three years. To gain “smart” insights, she clicks on the Smart Insights button (appearing as a wizard’s crystal ball) on her dashboard.


 Diana has immediate access to insights on the dashboard with varying levels of detail. The “light” option offers a wealth of useful insights. It performs a pareto analysis on the data, reviews relationships between measures, and produces a forecast based on historical data using a best fit forecasting algorithm. No sifting through data or writing of complex code required.

Diana then selects the advanced option to gain deeper and more detailed insights. She views additional details such as outliers and deeper insights into forecasting, standard deviation, and more


Next, Diana views a grid that displays net profit and returns for all occupations according to different promotions. Here, Diana selects the categorical option and sees how the various categories compare with one another in terms of rankings and percentage differences. 


With the help of Pyramid’s Smart Insights, Diana once again appears like a “pro.”


A critical outcome of analytics is the time-consuming task of providing business insights. Predefined templates do not alone provide a sufficient mechanism for producing diverse insights. Far worse, they simply take too much time to create.

While various BI tools offer natural language insights capabilities, the features typically only operate on the proprietary data engines—not on all databases—making their use highly limited.

In contrast, Pyramid’s Smart Insights use a variety of statistical and analytical methods to dynamically generate AI-automated natural language analysis of visualizations on any database. The tools also provide users with that ability to produce analysis with varying levels of detail—light, categorical, or advanced  in-depth formats—generated in real time.


This post originally appeared at https://www.pyramidanalytics.com/blog/details/blog-smart-insights-for-any-data-source


Other Resources

1 reply

    • samuel_alma
    • 3 yrs ago
    • Reported - view

    What I like about the Pyramid smart insights - and missed by so many other tools - is that it works on every database we have without needing to copy the data into a special format or model. It also seems to work on almost every query type, regardless of what our users do to the visuals and dashboards.

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 68Views
  • 2 Following