How To Preview Data When Building a Live Dashboard
To preview a table, right-click the table title bar, and select 'Preview' from the context menu. This opens the Preview tab, which displays all visible columns of the table.
You can only preview one table at a time. In the table preview tab, click the table to see table information, including the record numbers being displayed. Click outside the table to see information about the Worksheet.
A new table by default displays only metadata. However, the table can also display “live data” drawn from the database. This often provides a useful alternative to Preview.
For a large table, before entering Live Data mode, you should set the 'Max Display Rows' in the 'Table Properties' dialog box to a reasonable value. Note that for Live Data mode, filtering conditions are only applied to the sample data retrieved from the database, which is limited by the 'Max Rows' and 'Max Display Rows' settings (as well as by the global 'Design mode sample data size' and administrator-set limits). Therefore, Live Data may not accurately represent the results of table filtering.
To view live data in a table, follow these steps:
- Click the 'Show Live Data' button, located in the upper right corner of the table.
- Drag the bottom border of the table downward to display more rows.
- To scroll the table, move the mouse over the arrow symbol in the last column.
This displays the scroll bar, which you can use to scroll the data. The indices of the rows currently displayed in the table are shown in the information bar at the bottom of the screen.
To toggle the table back to Meta Data mode, click the 'Show Meta Data' button in the upper right corner of the table. You can also toggle Live Data mode from the 'Table Properties' dialog box.
More Resources and Articles about InetSoft's Live Dashboard Product
Airports This Analytical Map - Rather than discuss this some more let's just take a look at Style Intelligence in action. Airports are geographical entities so map is a logical way of summarizing airport information. By using the latitude and longitude information of airports this analytical map now has marked the location of all the airports in my data...
| #1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index |
|
Read More |
Analytics Tool for the Utility Industry - Nowadays more and more data is collected than can be easily analyzed with traditional analytical tools. Daily operational dashboards become outdated when they cannot be easily updated or connect to new data. InetSoft's business intelligence software offers the ability to create wide-ranging reports, attractive visual utility dashboards and real-time interactive dashboards. The interactive dashboard shown is just one example of how data can be used to visualize essential information...
API for Graph Data - InetSoft provides an API for developers to control every aspect of chart generation and user interfaces. This example below illustrates how the JavaScript-like API can be used to draw a chart dynamically... Call Display Visualization Tool /business/solutions/categories_of_data_visualization_tools/ - So on those two axes we can start plotting categories of data visualization tools. And the first category is what I would call display visualization tool. And this are what I would say are very simple dashboards that divide one or two layers of data, that will allow objects on the screen to synchronize with each other, update each other...
Choosing the Best Data Visualization Tool - What do business decision makers look for when choosing the best data visualization tool for their company? Factors to consider are the ability to mashup different types of data sources, the ability to import data, integration with data warehousing, options for prototyping new data, accessibility, and user-friendly features that speed up decision making...
Cloud-Native Dashboards - Cloud-Native Technology, Easy-to-Use Dashboard. Cost-Efficient, Cloud Computing Expense Aligned Pricing. Explore the Live Dashboard Gallery in the Cloud. InetSoft's cloud flexible business intelligence solution delivers the benefit of cloud computing and software-as-a-service while giving you the maximum level of control. In terms of software-as-a-service, BI software is unique because it inherently depends on the data not being embedded in the application...
Creating a BI Data Model - Once a data source is defined, you can proceed to creating a data model. Data models are logical abstractions of database schemas, similar to Entity-Relation Models. The full Style Intelligence data model includes the following four components: Physical view, comprising database tables, fields, and joins Logical model, a logical mapping to meaningful business units Virtual private models, data-level security for controlled access OLAP overlay hierarchical model, a mapping to dimensions/measures...
Creates Live Data Dashboard - This Covid-19 tracker mashes up data from a few different sources to give views that aren't found in the other dashboards already available. Especially helpful is the inclusion of the number of tests performed with detail down to the state level. Data from Italy is also included, to provide a comparison to the western location that is chronologically in the forefront of fighting the curve. https://www.inetsoft.com/info/us_covid_test_tracker_dashboard/...
Data Management Problem - Here is something we've found frequently with our larger enterprise customers. They choose our software with a certain dashboarding project in mind driven by business need. They install our business intelligence platform on premise and create their pilot dashboard in a matter of hours. As they prepare to roll it out and ask us about best practices, we find that their data environment and usage profile could lead to challenges. They have a data management problem that they hadn't realized until they embarked on this project...
Dashboarding Tool for FreshBooks - Looking for a good solution for FreshBooks dashboard reporting? InetSoft's pioneering BI application produces great-looking cloud-based dashboards with an easy-to-use drag-and-drop designer. Mashup your finance data with other enterprise sources for a complete picture of performance. View a demo and try interactive examples. InetSoft's solution is true Software-as-a-Service for hosted and self-hosting, not a combination of client developer tools and a web-based delivery platform. All new clients and partners get free one-on-one business intelligence expert help to accelerate deployment...
Data Modeling Plus Viewing - A data driven business needs to empower everybody, from C-level executives to frontline workers, with intelligence from data to make smart business decisions. Recent advances in business intelligence (BI), particularly the wide adoption of visualization technology, have greatly expanded and simplified accessibility of data. However, visual dashboards are still just one step forward in the pursuit of self-service BI because they are limited to pre-designed interactivity for end users...
Delivering Mobile Business Intelligence Dashboards - With one BI application, serve mobile business intelligence dashboards to iPhones, iPads, Android-based tablets, smartphones, as well as full dashboard reporting to PCs, Macs, and laptops. Since 1996, InetSoft has been delivering mobile business intelligence and reporting solutions to developers and enterprises worldwide. As a server-based solution, requiring only a browser to access interactive dashboards and drill-down reports, InetSoft's Style Intelligence has always been mobile friendly...
Documentation About a Dashboard Table Query - InetSoft's award-winning dashboard software gives users sophisticated table query controls that help to enhance the creation of reports and creates a truly custom user experience. View the example below to learn more about the Style Intelligence solution. You can change various properties of a Data Table, such the table description, maximum number of rows retrieved and displayed, and the handling of duplicate rows. To change table properties, follow these steps...
Dozen Key Business Questions - We like to say that this stuff helps key business people see stories and solve problems. So back to Mark and Rich, this involves you to have a defined problem somebody is trying to solve and then second, we like to make sure we understand the half a dozen, dozen key business questions that are trying to be answered. But then the third thing is, we also like to try to understand why those questions can't be answered today and there is usually a reason. But when those things align, it's a very, very powerful tool and helps people make better decisions...
 |
Read what InetSoft customers and partners have said about their selection of Style Report as their production reporting tool. |
Enterprise Data Management Plus Dashboards - Looking for enterprise data management software? InetSoft offers Web-based BI software that includes a powerful and flexible data mashup tool with direct access to disparate data sources of almost any type. Below are articles related to InetSoft's software. Data Provides Insight into Forecasting - As far as other companies, yes, I do think that all of that historical data provides insight into forecasting. We have used the information that we are pulling in for planning and not only for your typical annual budgets or your cash flow forecasting, but we have used it to really look at the products that we are offering and determine what the best strategy will be for the upcoming year. So for instance...
Education Dashboard Software Example - Searching for education dashboard software with automated data monitoring and report generating functionality to use with existing systems? InetSoft's dashboard software is easy to deploy and use and offers a highly interactive and customizable design. InetSoft's dashboarding software is robust enough to...
Flexible Enterprise Data Management - Looking for an enterprise data management application that also includes dashboards and reporting? InetSoft offers Web-based BI software that includes a flexible data access engine. No need for a data warehouse with direct access to disparate operational data sources of almost any type. Below are articles about InetSoft's software. Structured and Free-form Queries - Queries are written for specific data access purposes and contain logic beyond the generic data model. Queries typically utilize advanced or proprietary database features. The idea is similar to relational database views, except that queries are normally not generic enough to be created as permanent database objects or views. In the Data Modeler, queries can be quite flexible...
Focus on Which BI Tools - The only other mega BI vendor I want to single out there is probably SAP with MIRO. So they are trying to build out a visualization and memory-based data discovery tool called Lumira. You will probably see it at SAPPHIRE which is next week, SAP's major conference. You will probably see Lumira focused on very heavily. Probably the biggest only concern here many people already complain that there are so many tools in the Business Objects and SAP portfolio, and there's been some shifting focus on which tools to use in which situations...
 |
Read what InetSoft customers and partners have said about their selection of Style Scope for their solution for dashboard reporting. |
Free Dashboard Evaluation - Evaluating dashboard solutions for your organization's internal use or to embed in a commercial application? Deploy a small-footprint, easy-to-use Web-based data dashboard application from InetSoft. As an innovator in reporting software since 1996, InetSoft has pioneered the evolution from static reporting towards interactive visualization of data via dashboards...
How to Embed a Dashboard Table - The award-winning InetSoft dashboard software application offers embeddable dashboard solutions that lead to high end user adoption and significant increases in productivity. View the example below to learn more about the Style Intelligence solution. To convert a regular Data Table to an embedded table, follow these steps: 1. In the table title bar, click the 'Show Live Data' button. This will populate the table with data. 2. Right-click the title bar of the table, and select 'Convert to embedded Table'...
InetSoft Powered Dashboards for Agribusiness - While some AgKnowledge clients are happy with simple reports that they can filter and export raw data from, AgKnowledge's more involved clients enjoy learning how to build their own agribusiness dashboards. This hands on approach is enabled by the InetSoft data worksheet interface. Data tables in the Agknowledge database often have an overwhelming number of fields, with names that are not very descriptive. DID data scientists rectify this issue by creating data worksheets with only columns included that the client will want to use, with descriptive names assigned to the columns...
Make the Most of Visualization Software - And that kind of gets back to these slider bars, which I always find to be the most -- some of the most compelling, at least because you can get that, you can put one of those dimensions on the slider, right, you can even put two dimensions or more I suppose on a slider. I guess for closing comments, let's go around the room and just offer our best advice to folks. Mark, what's your most useful advice you can offer to people to make the most of their data visualization software...
 |
Read how InetSoft saves money and resources with deployment flexibility. |
Many Key Performance Indicators Examples - Below are key performance indicators examples displayed in dashboards designed using InetSoft's drag and drop dashboard solution, some of which can be tested with the free downloadable evaluation copy of Style Intelligence, while others can be seen in the free visualization tool, Visualize Free. Many SaaS BI vendors have created a cloud platform where you must transfer and update all data. This can create severe new issues because of bandwidth limits and updating-logic complexity. Even though some might offer a traditional install-your-own option, you will lose the benefit of SaaS that offloads the infrastructure management to the BI vendor. InetSoft's BI allows you to choose the platform and the location that is best suited for you...
Old Model of BI - And so the old model of BI was this publishing, saying, well here it is and then PowerPoint and Excel and things like that became the means to deliver it. And that environment was really great for explanation. It was great for things where you have known bounds because the exploration was already done for you by some IT analyst, who modeled the data and built a metadata layer in a particular way so, the known question, known bounds of the data for the answer. Then we get into the exploration which you didn't really touch on there where visualization can enable that. And then you explore it. You explain it. You have got to educate people going from here it is to here is how it works and why we need to take an action, to persuasion: to this is the action I think we should take...
Project Metrics Dashboard Example - Looking for tools to build a dashboard to track project metrics? InetSoft offers Web-based dashboard software with a drag and drop designer to create whatever dashboard you need. View a demo. Embedded Dashboard Table - InetSoft's dashboard software offers an embeddable dashboard table that facilitates the creation of interactive multidimensional reporting. Instead of creating a regular table from a query or data model, you can create a Data Table by manually typing values into the Worksheet. Such a table is called an Embedded Table...
Pre-aggregate Dashboard Filtering - Using InetSoft's award-winning dashboard software, users can unite complex and disparate data formats into one cohesive report by performing advanced dashboard data filtering. View the example below to learn more about adding filters to dashboards with the Style Intelligence solution. To specify conditions on both pre-aggregate and post-aggregate data, as well as group rankings, use the 'Advanced Conditions' dialog box. Advanced conditions can additionally be joined using both 'AND' and 'OR' operations. If you only need pre-aggregate conditions and 'AND' operations, you can use simple conditions instead...
Real Estate Agent Dashboard Example - Though real estate agents serve under a broker, their day-to-day work - i.e., networking, generating leads, working with clients - is carried out independently. When you take on this role, you're not only working as an agent but as a one-person digital marketing team. A dashboard is a data hub that takes all of your important analytics and presents them in the form of graphs, tables, and charts. This allows you to keep the wide view - we're talking big picture growth - even as you work one-on-one with your clients in the here and now...
Report Bursting Monthly Statements - In a large enterprise reporting deployment, it is important to handle both a large amount of data and a large number of users. Imagine a scenario where a single report such as a monthly statement needs to be delivered to thousands of users. The same queries are run multiple times, taxing the database, and the same report is regenerated for each user to ensure data security...
Restaurant Chain Dashboards - The management dashboard shows the crucial data expected to deal with an association in a single place. The dashboard mainly lists the objects, important actions, projects and items that need action. A restaurant manager can use a preferred dashboard vendor to help him or her get the right information consistently. The solution to this is the use of a sales dashboard that visually represents all the restaurant's sales information. The sales information is stored in the dashboard and can be retrieved anytime when there is a need...
Sales Opportunity Discovery Dashboards - Management and sales professionals normally depend on professionally-built visualization dashboards and reports for their known business needs. However, no design can anticipate all business questions. Flexible interactivity and ad hoc customization by end users becomes essential for quick business decisions. InetSoft's solution allows not only visual manipulation but also governed access to underlying data...
Scaling Up for Accessing Massive Databases - So this is the label we're giving to the technology that we're introducing in this release to deliver performance improvements and establish a path for scaling up for accessing massive databases while we're providing service to a large number of simultaneous users, and Byron's going to add a little more description to this for you. Traditionally, our software has always defaulted to accessing your operational data sources directly. We really espoused the idea of traditional BI, where you're required to build a data warehouse. The only problem with that, and it only comes up some of the time, is that operational data sources tend to be attuned more for data entry and writing...
Scripting for Controlling Data Tables - Below you will find scripting instructions for controlling data tables. With InetSoft's flexible data intelligence software, casual end users can drag and drop a data table onto a visual report or dashboard, and power users and developers can control virtually every aspect of a data table. Tables offer a number of special properties that allow you to access the data values from script, and to add visual style to rows, columns, and individual cells. The following sections explain how to use these properties...
Semantic Layer BI Tool - The Data Modeler is used to connect to various data sources, define semantic layers, and create queries. These semantic layers (logical models) and queries are atomic data blocks that can be manipulated and combined in a data worksheet, InetSoft's term for where database fields are selected and transformed. Data Block architecture makes InetSoft's approach to meta-data modeling different from other business intelligence platforms. Instead of focusing on pre-purposed business intelligence needs, we concentrate on designing data blocks that represent data in a way that is understandable to business users. These data blocks can then be assembled for different needs as those needs arise...
Several Database Dashboard Examples - Is your business using database dashboards? These dashboards offer companies a unique way of representing their data. From sales projections, to employee statistics, and even inventory stock, database dashboards are able to easily represent all of the numerical data that your company can hold, into a visually appealing dashboard. Dashboards come in various different styles and presentations, and choosing the correct one can greatly affect your business. All dashboards will be able to present your data in some well formatted visual display, but database dashboards can integrate specific data from your company database that you need to present to employees or clients...
Show More Dashboards - Let me show you some more dashboards. These are our services, and this is what they are right now. They are all running perfectly. Let's look at our downloads for our software packages. What we are looking at here. This is product page hits, basically people shopping. What are they looking at? This is actual downloads...
Trucking Management Dashboards - The purpose of a dashboard in the trucking industry is to provide real-time results and showcase logistics performance. These real-time results become the key performance indicators (KPIs), which helps you streamline the operations, especially logistics and travel based plans. As a result, you get the chance to simplify processes and make them more manageable. To make operations more streamlined and effective, trucking companies prefer to reach out to a well-recognized software development company for creating internal dashboards. These dashboards help them to manage their operations effectively...
Try InetSoft's Key Performance Indicators Software - Looking for key performance indicators software? Since 1996 InetSoft has been making KPI dashboard software that is easy to deploy and easy to use. Build self-service oriented dashboards quickly. View a demo and read customer reviews...
Using a Dashboarding Product - Learn to use dashboarding tools that make multidimensional data simple to view. View the example below to learn more about the Style Intelligence solution. In this example, you will use a Spinner control to display only values in a table that exceed the specified Spinner value. 1. Create a new Worksheet. 2. In the following steps, add a new Embedded Table containing a single numeric data cell...
 |
Read why choosing InetSoft's cloud-flexible BI provides advantages over other BI options. |
Utilize Non-Relational Data for BI - In today's business environment, data is stored in many different formats. Java Objects and EJB are present in legacy systems, but Web Services and XML are the new standards for sharing information over the internet, and Excel is a popular data analysis and manipulation tool. With InetSoft products, you can leave this data in its native format and still utilize it for BI purposes...
View a Dashboard Web App - Looking to view and/or build dashboards via a web app? InetSoft's dashboard web application can be installed either on-premise or in the cloud, on a remote server provided by Amazon web services or any other provider A dashboard is a visual display of the most important and relevant information in reference to one or more objectives, displayed on one screen so it can be viewed easily at a glance. Dashboard software has been proven to be a highly effective business intelligence tool for business users and casual users alike. Whether examining future business trends or looking for a way to analyze...