InetSoft Product Information: Data Manipulation & Mash-Up

Style Intelligence provides sophisticated capabilities for data manipulation and mash-up through its easy-to-use graphical Data Worksheets. With Worksheets, administrators and power-users can rapidly combine information from different data sources into meaningful and reusable Data Blocks. \

The following example shows how to construct, manipulate, and save a new Data Block. For information on how to create more complex assets, please refer to the Data Worksheet Guide.

View a five-minute Flash demo to get an overview of what InetSoft's business intelligence software, Style Intelligence, can do and how easy it is to use.

 

 

 

 

 

Constructing Data Blocks

There are many different ways you can construct Data Blocks. In this example, you will build a Data Block by pulling together several attributes from a single data model.

1. In a Windows environment, open the Asset Composer from the option on the Windows Start Menu, Start → All Programs → Style Intelligence → Asset Composer.

2. Click on the ‘New WorkSheet’ button in the top toolbar to open a new data worksheet.

3. In the left pane of the Asset Composer, expand ‘Query’, then the ‘Orders’ data source. Also expand ‘Order Model’ and ‘Order’.

4. Select and drag the ‘Date’ field from the tree to an empty cell on the data worksheet grid.

This creates a new table with the title “Order,” the name of the parent entity from which the ‘Date’ field was drawn.

5. Next, expand the ‘Product’ entity, and drag and drop the ‘Category’ attribute over the right side of the ‘Date’ column in the data worksheet. The table now includes both fields.

6. Using the same procedure, add ‘Total’, from the ‘Product’ entity, to the data worksheet.

7. Now, right-click the table title, and select ‘Properties’ from the context menu. This opens the ‘Table Properties’ dialog box.

8. In the ‘Table Properties’ dialog box, rename the table by entering “MonthlySales” into ‘Name’ dialog box.

9. Click ‘OK’ to close the dialog box. You have now created a “MonthlySales” data block that you can use in further data manipulations.

 

InetSoft Viewpoint

"You actually use more business intelligence capabilities. So in between the execution phase and the final evaluation, you’re constantly tracking and monitoring your performance so you can tune your execution. That’s where business intelligence with dashboards for analysis and monitoring come in. And in between the evaluation phase and incorporating your learnings or findings and adapting your strategy, you need to do some in-depth analytics. That’s the more traditional forecasting or predictive analytics as well as things like data mining. So there is a piece that is more business intelligence as it relates to the management system, and then there is a piece that is more performance management, and you couple them together. After some months of active use of the platform, go back to the users and find out where they get value out of the system, what they’ve been using it for, and start to use those thought leaders, the folks that have been the most aggressive users getting this value out of it. Use them, perhaps, as a way to add the additional performance management capabilities into the organization." - Mark Flaherty, CMO, InetSoft

 

 

 

 

 

 

 

 

 

Previous: Virtual OLAP Models

Next: Manipulate Data Blocks

More Resources:

		OLAP Overlay and Multidimensional Analysis
		OLAP Server Setup
		InetSoft's BI Partners
		InetSoft's BI News