BIAnalytix Tip Summary: Comparing Pull Analysis versus Push Reporting

As a result of the information that users obtain from their Media BI Portal, it is common that they will want to export the analysis to an Excel spreadsheet. There are two ways that the data can be captured in Excel. One type of export results in a spreadsheet with a “snapshot” of the numerical data values, while the more powerful option results in a spreadsheet that is still fully connected to the analysis data source in the data warehouse. The first “snapshot” option is often the best when the business numbers are to be used with additional offline Excel calculations because active pivot tables relocate the data. With the second option, the Excel spreadsheet can continue to be changed, drilled, and filtered to evolve into a new analysis that can then be re-published to the portal for others to use. Either export type can be useful when the analysis is to be encapsulated into a Word, PDF, or PowerPoint document.
The users that are provided full Business Intelligence interactive analysis are sometimes restricted to senior executives or power users often for sound corporate reasons. Consequently, a push delivery of important predefined analysis by e-mail or specific portal folder would be appropriate for all users who do not have full interactive BI capability. Analysis reports can be formatted and pushed as a classic text report, a HTML page, a PDF or an Excel spreadsheet.

BIAnalytix is a data warehouse and business intelligence system from Decentrix which includes all the advanced tools necessary for both pull and push analysis.

© Copyright 2011, Decentrix Inc. All rights reserved.
Decentrix Inc. 1200 17th Street, Suite 200, Denver, Colorado, 80202 Phone: 303-899-4000  
 
 Decentrix Website Solution & Collaborative Intranet Tools   |   DishOnTheWeb.com by Decentrix, Dish Network Retailer Solutions
Afftraq Affiliate Sales Tracking Solution   |  HotDesk, Superior Website & Intranets for Small to Medium Size Business

Home Products Website Solution Collaboration NetAnalytix e-Commerce Technology Overview Architecture Quickcentrix Quickcentrix Integration Kit Consulting Web Analytics Consulting e-Commerce Consulting Business Intelligence Analytics Decentrix Process Online Marketing Site Visitors Search Engines Register With Yahoo Register With Google Search Engine Ranking Becoming Visible Online Collecting Prospect Lists Checklist Target Market Tours Website Solution Tour Collaboration Tour NetAnalytix Tour BIAnalytix Tour Clients News Press Releases e-Newsletters Contact Support Sales Company Vision Management Team Careers