Product Information: Logical Data Models

This is a table of contents of useful information about building logical data models using InetSoft's business intelligence software for dashboards, reporting, and data mashups, Style Intelligence:

How Data Management Professionals Can Manage Data Complexity - The role of data management professionals has become increasingly challenging with multiple audiences, multiple business units and departments, multiple tools and applications and multiple databases. In this Webinar we will look at these challenges and explore how organizations can better manage their data complexity. You will also discover how a consistent, integrated view of critical data assets can turn data complexity into information advantage. When both the business and technical stakeholders have a common view of information, they can visualize the power of their data...

Example of a chart built from a logical data model
Click this screenshot to view a three-minute demo and get an overview of what InetSoft’s BI dashboard reporting software, Style Intelligence, can do and how easy it is to use.

How Data Virtualization Supports Business Agility - Today, enterprise architectures need agility to support business initiatives, and data virtualization can play a key role in this. In this webinar we will provide insights on how data virtualization provides information agility to your enterprise architecture project to deliver business value and significant competitive event. The focus of this webinar is on how to think about different information delivery strategies to help enterprise architecture as a whole be very business focused. So while we will get somewhat technical to address some of the key challenges, the idea is really to provide the framework primarily, and we will talk about some of the other ways. Today what we will talk about is what is the evolution of this whole area of business and enterprise architecture. Obviously those are joined at the hip. There are different perspectives on this, and they are changing. Based on this context we want to think of what is the role of information in this coming together of business and enterprise architecture...

How to Best Utilize Your Data Visualization Tool - Mark Flaherty: With the tools of today, it’s not so hard to simply go to that trial and error process when mixing and matching data sets in Big Data. It works the best in business scenarios such as business analytics...

How to Find the Difference Between Dates - This section discusses several basic date functions: computing the difference between dates, computing a date in the past or future, formatting a date, and extracting date components. Use the 'dateDiff()' function to find the difference between two dates in terms of days, months, or years. Use the 'dateDiff()' function to find the difference between two dates in terms of days, months, or years. For example, if a table displays the column 'Birth Date', you can create a formula column to calculate the current age of an individual by subtracting the 'Birth Date' from today's date...

view demo icon
View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software.

How to Leverage Key Performance Indicators to Measure and Enhance Data Protection Effectiveness - In the modern business world, every organization collects some form of data. To make use of this data, it's important for businesses to implement effective data protection strategies to help protect sensitive information from loss, damage or corruption. The impact of data loss can be quite significant. Statistics show that 94% of organizations that experience severe data loss rarely recover. Because of this, businesses set up key performance indicators (KPIs) to help them gauge whether the data protection strategy in place is effective. These quantifiable metrics can help determine whether the company is performing optimally and areas that need improvement. In this article, we'll look at the different ways of measuring KPIs for effective data protection processes...

How to Manage Data Distribution Across the Enterprise - Now we have all sorts of different large scale inter-organizational requirements whether it's for customer relationship management, enterprise resource planning, whether it's for supply chain management, whether it's data warehousing, business intelligence, integrated analytics, complex event processing, a significant amount of repurposing and data reuse is now required and the data is being distributed across the organization. We don’t really have a good handle on our data investments, and that gives us a little bit of pause...

How to Map Business Terms to Data Elements - I am going to show a little bit of a picture here, because what we said is that we have got the same business terms that are being used. We have got the same structures that are being used or different structures, etc., but how do we map all these things together? And from a conceptual standpoint, the first thing that we might want to look at is, what are the business terms that are being used and what’s the context of those business terms? What’s the business term? How is it being used? What's its definition? How is that mapped with a data element concept...

How Much Data Can You Visualize In-Memory - That concludes the formal part of the webinar. We committed to stay over a little bit to answer questions. So we are going to pick up questions now, and let’s take a look at what we have? And, yeah, feel free to email additional questions to info@inetsoft.com. Here we have got one question about how much data can you visualize in-memory, which comes up every time. In-memory technology has expanded tremendously. Our compression algorithms are pretty good. We are fitting tens of millions of rows on a normal windows class machine whether it's a client or server, and we’re often pulling in 60, 80, 100 tables from something like an Oracle database on a nightly basis and linking and joining them and doing roll ups and whatever else we have to do. We are not going to put you of Wal-Mart transactions in-memory. But if you’re doing analysis you probably don’t want to look at that anyway you probably roll up the transaction level to the day level if you’re looking at three years of data. And if you are looking at products, probably you could roll up to the class or the sub class instead of the SKU...

view gallery
View live interactive examples in InetSoft's dashboard and visualization gallery.

IFrame Integration - The simplest way to integrate reports with a third party Web application is to present the reports inside an IFrame. A report embedded in an IFrame can be freely viewed and manipulated, even when the report engine runs in a separate container. This eliminates the need for a proxy. The basic syntax for integrating an individual report into an IFrame is shown below, where ReportName is the name of the desired report, and remotehost is the remote server name. The path should start with the username for a user scope viewsheet. Also, an identifier parameter can be provided in place of path, and an edit=true parameter can be used to load the viewsheet in the Visual Composer...

IFrame Integration Example - As a further example, the HTML markup below generates a simple Web page with two divs, the top div containing a heading and some text, and the bottom div containing an IFrame with embedded report. To run this example, replace “remotehost” below with the address of the remote server on which the report engine is running. IFrame integration is the recommended alternative to JSP-based integration, and there are several advantages that make IFrames the preferred approach in most cases: IFrames are easier to use, and Style Intelligence's report design architecture is geared toward IFrame integration...

Previous: Data Mashup Software