Article Evgeniy Potapov · Dec 30, 2022 8m read How to develop in Tableau and PowerBI Power BI Connecting to a Data Source To connect to AtScale, we will use the SQL Server Analysis Services database. Let's open it in the Power Query editor. To do that, select Transform Data on the Home. In the window that appears, go to the Home, expand New Source and select Analysis Services. #Adaptive Analytics #Analyzer #InterSystems IRIS #InterSystems IRIS BI (DeepSee) 5 2 1 241
Article Evgeniy Potapov · Nov 23, 2022 7m read How to develop in IRIS BI (also with change management) IRIS BI We offer you to embed business intelligence into your applications in order to give your users an opportunity to ask and answer sophisticated questions about their data. Typically, your application will include customizable dashboards that can provide insight into data from Business Intelligence models known as cubes. In contrast with traditional BI systems that use static data warehouses, Business Intelligence keeps being constantly synchronized with the live transactional data. #Analytics #InterSystems IRIS BI (DeepSee) 5 2 0 409
Article Evgeniy Potapov · Nov 15, 2022 6m read How to develop in Logi Today we will talk about InterSystems Reports. This is a BI system that provides you with tools to create static reports and export them to different file formats. We will see how it works using the DC Analytics public analytical sample as an example. In this article, we will examine how to familiarize yourself with the reports available in the repository, how to make a new report based on a ready-made data structure, and how to prepare a data structure from scratch. #Adaptive Analytics #Analytics #InterSystems Reports #Visualization #InterSystems IRIS BI (DeepSee) 3 0 0 310
Announcement Evgeniy Potapov · Nov 10, 2022 InterSystems Adaptive Analytics training in a focus group Developers, we have prepared a tutorial to get you started with InterSystems Adaptive Analytics powered by AtScale. In it, in addition to setting up AtScale and working with data cubes, we will also touch on methods of working with InterSystems Reports and other analytical systems. Now the course is ready and we want to conduct a pilot training course on a small group of volunteers (3-5 people). #Adaptive Analytics #InterSystems Reports #InterSystems IRIS BI (DeepSee) 2 1 0 215
Article Evgeniy Potapov · Nov 2, 2022 9m read How to develop an InterSystems Adaptive Analytics (AtScale) cube Today we will talk about Adaptive Analytics. This is a system that allows you to receive data from various sources with a relativistic data structure and create OLAP cubes based on this data. This system also provides the ability to filter and aggregate data and has mechanisms to speed up the work of analytical queries. #Adaptive Analytics #Analytics #InterSystems IRIS BI (DeepSee) 5 0 1 307
Article Evgeniy Potapov · Oct 3, 2022 8m read Automating the deployment of Adaptive Analytics When we work with IRIS, we usually have the ability to quickly deploy a ready-to-use infrastructure for BI (data, analytical cubes, and IRIS BI dashboards) using modules. When we start using Adaptive Analytics, we typically want to have the same functionality. Adaptive Analytics has all the tools that we need. The documentation contains a description of how to work with an open web API. All interactions between the user interface and the engine also occur via the internal web API and can be emitted. #Adaptive Analytics #InterSystems IRIS BI (DeepSee) 2 0 0 139
Article Evgeniy Potapov · Sep 13, 2022 5m read Comparison of drilldowns on various technologies (PowerBI, Tableau, IRIS BI) When we are at the starting stage of BI project development, we must remember that it is crucial to select the right tool for its implementation. Today we want to show you how one of the principal functionality of dashboards is implemented in different BI systems. Let's talk about drill down from both points of view: the dashboard development, and the convenience and clarity for the end user. We will touch on the applications of this technology in IRIS BI, Power BI and Tableau. #Adaptive Analytics #Analytics #Visualization #InterSystems IRIS BI (DeepSee) 3 1 0 270
Article Evgeniy Potapov · Sep 9, 2022 1m read DC Analytics Open Application InterSystems Developer Community analytics. Project made with InterSystems IRIS BI (DeepSee), Power BI and Logi Report Designer to visualize and analyze members, articles, questions, answers, views and other pieces of content and activity on InterSystems Developer Community. You can see your own activity, articles and questions. Track how your contribution changes developer community. #Adaptive Analytics #Analytics #Containerization #InterSystems Reports #InterSystems IRIS BI (DeepSee) Open Exchange app 2 0 0 200
Article Evgeniy Potapov · Sep 9, 2022 5m read Pitfalls when creating a drill through in Power BI connected to AtScale Power BI dashboards provide us with a good way to analyze aggregated information. We can even choose time periods for aggregation (you can find more details regarding it in our article about drill down). However, we might still be interested in a detailed look at specific data points. With the right data filling, we can display detailed data for any column of the chart with all filters applied to that chart. #Adaptive Analytics #InterSystems IRIS BI (DeepSee) 1 0 0 329
Article Evgeniy Potapov · Aug 16, 2022 7m read How to make drill down from IRIS DB to PowerBI via Adaptive Analytics 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. #Adaptive Analytics #Analytics #MDX #InterSystems IRIS 5 0 0 377