Pyramid Analytics

Pyramid integrates ChatGPT to revolutionize data-driven decisions

Pyramid Analytics has integrated ChatGPT's generative AI with its augmented analytics platform to enable users to seamlessly combine internal enterprise data with a vast array of publicly available datasets—such as demographics, economic indicators, financial and scientific data—via natural language prompts, thereby enhancing data-driven decision-making through enriched analysis, narrative generation, and advanced visualizations within a secure, governed environment.

Pyramid Analytics is bringing together the power of ChatGPT with augmented analytics in a single Decision Intelligence Platform. In their latest release, businesses can now enrich enterprise analytics with data sourced from ChatGPT natural language prompts.

Pyramid’s approach combines OpenAI’s generative AI engine with Pyramid’s existing AI engines, creating a unique way to analyze data for decision-making. This capability allows users to access a wide range of publicly available analytic content—such as demographics, financial indicators, time series, and economic indicators—directly within their analysis workflow in Pyramid. The integration aims to unleash creativity, improve productivity, and enable faster, better data-driven decisions within organizations.

Example Scenario

Imagine an analyst wants to estimate sales penetration by country. The internal dataset includes the number of customers by country but lacks population data. With Pyramid’s OpenAI integration, users can simply type a prompt to retrieve the necessary population data and derive metrics by combining publicly sourced data with internal data, all within a secure and governed platform.

Analysts can further extend their analysis by generating natural language narrative explanations that incorporate metrics from the enriched dataset, create data-driven ChatGPT narratives, and use Pyramid’s native AI engines for additional analysis and data visualizations.

With this approach, organizations can blend analysis of internal corporate data with thousands of datasets and metrics available via ChatGPT, including:

  • Statistical data (population figures, demographics, historical trends)
  • Economic indicators (labor force, employment, GDP, etc.)
  • Financial data (market data, stock prices, company financials)
  • Scientific data (datasets from physics, chemistry, biology, astronomy, etc.)
  • Algorithms and mathematical formulas, equations, units, and measures
  • Geospatial data (coordinates, maps, distances, geographic statistics)
  • Time series data (temperature records, stock prices, other time-dependent measurements)

These datasets can be used to enrich internal data or derive new metrics on the fly within Pyramid.

More Integrations with GPT in Pyramid

The latest OpenAI integration builds upon existing generative AI capabilities within the Pyramid platform. Previously, Pyramid integrated GPT AI technology from OpenAI throughout the platform, including data preparation, data science, storyboard, and publication design, as well as in business and decision modeling features like Tabulate and Solve.

Specifically, different types of users can benefit from the new OpenAI integration:

  • Data analysts can automatically generate syntactically accurate SQL, DAX, and MDX code for complex data extraction queries, saving time and reducing errors. (Data preparation)
  • Data scientists can automatically generate Python and R code for machine learning logic, allowing them to focus on high-level modeling rather than manual coding. (Data science)
  • Business analysts can generate designs for content and graphics for storyboarding and publications, streamlining content creation. They can also integrate ChatGPT into dynamic text driven by source data and create model attributes based on ChatGPT results. (Business analytics)
  • Business professionals can build spreadsheet formulas for business models, reducing the time and effort required to create complex models. (Tabulate/Solve)

This combination of AI technologies enhances Pyramid’s Decision Intelligence capabilities. Existing Pyramid NLQ (natural language query) engines, designed to analyze private enterprise data, are now further empowered by ChatGPT integrations. Features such as Chat Bot, Smart Insights, Smart Model, Auto Discovery, Fill the Blanks, and Explain are now more robust.

Pyramid’s platform-based approach to enterprise analytics has been recognized by industry analysts. Gartner placed Pyramid in its Visionary Quadrant in the 2023 Magic Quadrant for Analytics and Business Intelligence Platforms and ranked it highest for Augmented Consumer and Business Analyst Use Cases in the 2023 Gartner Critical Capabilities for Analytics and Business Intelligence report. Other analysts, including 451 Research, Ventana Research, and BARC, have also praised the platform.

The OpenAI integration is helping professionals involved in data analytics to be more productive and efficient. Pyramid continues to integrate AI-assisted capabilities where they provide real utility, making its augmented feature set more complete and impressive, with more innovations to come.