#Analytics

In this article you will have access to the curated base of articles from the InterSystems Developer Community of the most relevant topics to learning InterSystems IRIS. Find top published articles ranked by Machine Learning, Embedded Python, JSON, API and REST Applications, Manage and Configure InterSystems Environments, Docker and Cloud, VSCode, SQL, Analytics/BI, Globals, Security, DevOps, Interoperability, Native API. Learn and Enjoy!

Machine Learning

Machine Learning is a mandatory technology to build advanced data analysis and automate manual activities with excellent efficiency.

One of the most important tasks of dashboards is, on the one hand, to help you perceive data in an aggregated form, and, on the other hand, not to lose the depth of immersion in the data if you need this. One of the tools that help us achieve this result is drill down. It enables us to display several hierarchical levels of data, from aggregated to detailed.
Our task is to make an analytical dashboard that will be able to drill down by time periods:  from months to weeks and days in each chart.

Hi guys,

Does rebuilding of Data Quality Manager cubes affect patient index linkage definition data?

What I want to understand is, does DQM have any negative impact on the data each time you rebuild the cubes. 

Additionally, if I make changes to the cube and rebuild it..will this have any impact on the original data?

When we collect temporary data (the number of purchases in the store, the number of comments on the post), it may happen that there is no data for a certain period of time. In this case, this time period (hour, day, month) is not represented in the database, that is, there is not a single row for this period. In other words, there are no rows in the database for this period.

When we start building analytical reports based on data from IRIS or Adaptive Analytics cubes, a visualization problem appears.

I am receiving Mirroring updates to an IRIS for Health async reporting server and need to pause the mirroring journal processing to periodically quiesce the database to rebuild cubes and custom staging tables.

What API or web service can I use to quiesce the reporting server and then later initiate catch up?

Hi,

I have 3 simple tables:  Encounter, Patient and Immunizations.  Encounter makes  a reference to Patient, and Patient contains a list of Immunization objects.  

I've tried using PowerBI to access IRIS (using ODBC connector, not InterSystems BI connector),  PowerBI reports the error:

Expression.Error: The column 'Patient' of the table wasn't found.
Details:
    Patient

it does this for two of the three tables I need only (Patient and Encounter), but not for Immunization IRIS table.. 

Anyone know why and how to fix  ?

Thanks - Steve

Hey Developers, 

New video is already on InterSystems Developers YouTube channel:

⏯ InterSystems HealthShare Analytics Solution: Create & Deliver Real-Time Insight at Scale

Hi All,

I am looking for a reporting tool (Analytics purpose) which can be built using cache object script/MUMPS. Basically my requirement is to find a tool where I can implement cache code to report data for my application.

I am unaware of DeepSee and how it works. Please assist for the same.

Hi Community,

New session recording from Global Summit 2019 is available on InterSystems Developers YouTube Channel:

⏯ Performing Analytics on FHIR Data

I was using PowerBI to create regular display data obtained from one popular web sourse with hundreds of thousands of visitors per month and a big number of users.

At the beginning of that visualisation development, I was using direct connection from Power BI to Adaptive Analytics powered by AtScale. Adaptive Analytics is useful for cached data, aggregates and fast data sources switching between development and stage phases. The “AtScale cubes'' connection method was used:

The Problem 

Power BI is an enormously popular business intelligence platform with rich visualization and reporting

See what's new in InterSystems Learning Services! In the March 2022 newsletter, you will: 

• Get an overview of the new documentation search features.
• Find content to help you prepare for certification as an HL7 Interface Specialist.
• Learn the latest on Embedded Python. 
• See how to start performing analytics in InterSystems IRIS® data platform.

InterSystems IRIS Business Intelligence allows you to keep your cubes up to date in multiple ways. This article will cover building vs synchronizing. There are also ways to manually keep cubes up to date, but these are very special cases and almost always cubes are kept current by building or synchronizing.

What is Building?

The build starts by removing all data in the cube.This ensures that the build is starting in a clean state.The build then goes through all records specified by the source class.

Hi Community, 

New video is already on InterSystems Developers YouTube:

⏯ Poor Man's Analytics with Rich SQL

Is there any open source tool like Power BI or Tableau that works well with IRIS? Thx!

i'm trying to extend both the MemberEnrollment and the MedicalClaim objects in HS.  The CareProvider is perfect for some of my extensions (Operating provider, referring provider, third-party insurer), but the documentation says https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.U…:

I need something that is just like a CareProvider, and I will be using the CarePRoviderType as a CodeTableDetail.  

Why is CareProvider excluded?

When designing a hierarchy in DeepSee, a child member must have only one parent member. In the case where a child corresponds to two parents, the results can become unreliable. In the case where two similar members exist, their keys must be changed so that they are unique. We will take a look at two examples to see when this happens and how to prevent it.

Example 1

There are a handful of states with a city named Boston. In my sample data, I have records from both Boston, MA and Boston, NY. My dimension is defined as:

City and State are simply strings in my case.

Hey Community,

See how cubes are constructed for use in business intelligence, and learn about SQL and MDX query languages. Physical and virtual cubes are used in InterSystems IRIS® Business Intelligence and Adaptive Analytics:

⏯ Introduction to Cubes in Business Intelligence

We have been using DeepSee which has been the integrated Analytic Dashboard built over Cache Cubes. It works fine but it's visual capabilities are limited and most probably is getting phased out.If I am not wrong, Tableau is the suggested alternative to DeepSee .

I have an SDA feed from an Edge server that eventually is fed into HSHI / Analytics. This edge server is loading up patient demographics (in the Patient object), which feeds the HSAA.Patient table in HSHI / Analytics.  

However, we have other edge servers also feeding into the same HSHI database, and these other edge servers have better demographic information.  

HSHI appears to use the most recent demographic information from all edges.  What's the best way to de-prioritize patient demographic information from this particular edge (or this particular Facility) when feeding it into HSHI?

I'm

* In-Platform Agent-Based Simulation of a Connected Factory Cluster

Author: Sergey Lukyanchikov, InterSystems

1. Purpose

In this paper we prototype and explore how multiple agent-based models of robotic factories connected to other robotic factories (represented by their respective models) can be orchestrated using an all-purpose data platform – thereby simulating descriptive and predictive properties of a group of factories (a factory cluster). For the underlying prototype, NetLogo suite was used to do factory agent-based simulation (re-using “Robotic Factory” model [1]) while InterSystems IRIS 

Did you catch an Experience Lab at the 2021 Virtual Summit? Head over to the InterSystems Learning site to access all four of these hands-on exercises, and get up to speed on:

I'm happy to share with the community a web server log dataset from our longtime customer, an operating company.

Their webserver operates on Apache webserver and contains data which can be useful to analyse a load and search engines activity.

After installing the project, you will get the data for a few months that can show a typical load and activity of clients, robots and also you can see how it depends on day of week, holidays and time of a day.

The Cube is also included in package.

So you can use my previous project (Promjet-Stats) and see dataset in dashboards.

To make that you shoud install

A full cycle project, from initial data initialization, daily update products from the official website, a service for sending a course on request and receiving a schedule for any period.

After installing the project, we will get a table of ruble exchange rates against the main currencies of the world established by the Central Bank of the Russian Federation for 2016-2021. Launching the product service with default settings will allow you to receive daily new exchange rates for the current day. If necessary, you can load the missing data with the product service by changing the parameter CountD

Hi Community,

In a hard work of data curation and data quality, the Health Dataset application deploy to you the above datasets.

These datasets can be used in your ML applications/models, AutoML and analytics projects. See more details here:

Installation

1. Clone/git pull the repo into any local directory

$ git clone https://github.com/yurimarx/automl-heart.git

2. Open a Docker terminal in this directory and run:

$ docker-compose build

3. Run the IRIS container:

$ docker-compose up -d

4. Do a Select to the HeartDisease dataset:

SELECT 
age, bp, chestPainType, cholesterol, ekgResults,

Hi Community,

We're pleased to invite you to the upcoming webinar in Spanish called "Self-Service Analytics & Reporting"!

Date & Time: November 17, 4:00 PM (CET)

Speaker: @Alberto Fuentes, Sales Engineer, InterSystems Iberia

The webinar is aimed at Data Analytics or Business Intelligence professionals.

Hi, does anyone know how to add a LINK to an ANALYTICS DASHBOARD? I'm getting an error and until now I could not find anyhing in documentation. 

thank you for help.

to be more specific: I need to figure out how to create a .LINK type of entry into a folder so I can add it to the dashboard.

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ iKnow: Open Source NLP in InterSystems IRIS

I really love documentaries! Last weekend I was watching a Netflix documentary called This is Pop, because it was Analytics Contest time and I thought: Why not creating a pop song analytics with InterSystems Iris?

The first challenge was the database. I found on Data World project a CSV file with the Billboard hot 100 songs from 2000 to 2018, created by "Michael Tauberg" @typhon, that fits perfectly.

I was talking to @Henrique Dias and he gave me the idea of using Microsoft Power BI for good looking report with charts.

Which genres were most popular between 2000 and 2018?

Which artists had more songs

Have you heard about some restrictions in cookies for tracking visitors to your sites?

One of our clients asked me about how to know really count of visitors.

Their site works on WordPress framework, hosted on classical NAMP hosting.

They can see some statistics from Yandex Metrika conter, but we was not sure about full coverage.

We gave him the AWStats, it takes data from Apache log files on hosting.

But there were no filter of robots and hearbeat systems such as UptimeRobot or Search Engines indexing robots.

After that we decided to get data in IRIS BI for two reasons:

- make dashboards with

Hi Developers!

We had a set of technology bonuses for the InterSystems IRIS Analytics contest.

And here is how projects collected it: