skills.rest
sorodriguezz
sorodriguezzCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

Using the Analyzer

Create and modify pivot tables with the InterSystems IRIS Business Intelligence Analyzer.

Updated Feb 2, 2026
Search Tags:#data visualization#reporting#data analysis#business intelligence#pivot table#intersystems iris
One-click install
npx skills add https://github.com/sorodriguezz/skills-objectscript --skill using-the-analyzer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Using the Analyzer
Source: https://github.com/sorodriguezz/skills-objectscript/tree/main/skills/using-the-analyzer
Command: npx skills add https://github.com/sorodriguezz/skills-objectscript --skill using-the-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a user-friendly interface for creating and manipulating pivot tables to analyze and visualize data from InterSystems IRIS® data platform Business Intelligence.

Core Features & Use Cases

  • Pivot Table Creation: Build pivot tables by dragging and dropping measures, dimensions, and other elements.
  • Data Exploration: Explore data through interactive pivot tables and charts.
  • Use Case: A business analyst needs to understand sales performance by region and product. They can use this Skill to create a pivot table showing total sales, grouped by region (rows) and product category (columns), with average profit margin as a measure.

Quick Start

Use the Using the Analyzer skill to create a new pivot table by dragging 'Patient Count' to Measures and 'Diagnoses' to Rows.

Frequently Asked Questions about Using the Analyzer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a pivot table to visualize InterSystems IRIS Business Intelligence data?▼

To create a pivot table in InterSystems IRIS Business Intelligence, use the BI Analyzer's drag-and-drop interface to place measures and dimensions into rows and columns. This aggregates and visualizes data for interactive exploration.

Can I drag and drop dimensions and measures to analyze data in BI Analyzer?▼

Yes, the BI Analyzer supports a drag-and-drop interface for data analysis. You can drag elements like 'Patient Count' to Measures and 'Diagnoses' to Rows to interactively explore and visualize subject areas.

What is the best way to group sales by region and product in a pivot table?▼

The best way to group sales data is using the BI Analyzer to create a pivot table. Set region as rows and product category as columns, then add average profit margin as a measure to visualize performance.

Does InterSystems IRIS support interactive data exploration through pivot tables?▼

Yes, InterSystems IRIS supports interactive data exploration through pivot tables and charts. The BI Analyzer facilitates data aggregation and visualization, allowing users to dynamically explore subject areas and pivot definitions.

How do I modify an existing pivot table definition in InterSystems IRIS?▼

To modify an existing pivot table definition in InterSystems IRIS, use the BI Analyzer interface to interactively drag and drop new measures or dimensions. This updates the data aggregation and visualization dynamically.

Related Skills

Explore More Data & Analytics Skills→
sorodriguezzsorodriguezz

Defining Models for InterSystems IRIS Business

Create and manage BI models with cubes, dimensions, and measures in InterSystems IRIS.

Community
Intermediate
run6270run6270
1

Excel Analysis

Analyze and manipulate Excel spreadsheet data with pandas and openpyxl.

Community
Intermediate
sorodriguezzsorodriguezz

Using Dashboards and the User Portal

Guide users through InterSystems IRIS User Portal dashboards and pivot tables.

Community
Intermediate
lazygopherslazygophers
4

office-xlsx-skills

Read, write, analyze, and convert Excel, CSV, and JSON files.

Official
Advanced