Resources
BNET Resources
- sort by:
- Relevance
- Date
- Popularity
- Refresh Connected (Imported) Data
- A cell range, Excel table, PivotTable report, or PivotChart report can all be connected to an external data source. You can refresh the data to update data from this external data source. Each time you refresh data, you see the most recent version of the information in the data source,...
- White papers
- Synchronize Excel Reports With A Single data source
- The analysts needed to take existing year-end financial reports and summarize, group, and chart the data in various ways to present to their organizations' business decision makers. Data analysts rely on Microsoft Excel to connect to, display, and format data. However, copying and pasting data between cell ranges or between...
- White papers
- Bio-Terrorism Early Warning Syndromic Surveillance
- The foundation of optimum bio-terrorism event management is early warning. A key epidemiological tenet is that the detection and reporting process must occur faster than the speed of the spread of the biological agent to make any difference in outcome. The emergency department is an ideal data source area upon...
- White papers
- Linking To External data sources In An Access Project
- The Link Table Wizard is a new feature of Access 2002. If your Access project is connected to a Microsoft SQL Server version 7.0 or later database, or to a SQL Server 2000 Desktop Engine running on your local computer, you can easily link to various OLE DB data sources....
- White papers
- Connect To (Import) External Data
- The main benefit of connecting to external data is that you can periodically analyze this data in Microsoft Office Excel without repeatedly copying the data, which is an operation that can be time-consuming and error-prone. After connecting to external data, you can also automatically refresh (or update) your Excel workbooks...
- White papers
- Refresh External Data In Excel Services
- Data in a Microsoft Office Excel workbook that has been displayed in Excel Services can come from two different locations. The data may be stored directly in the workbook, or it may be stored in an external data source, such as in a database or in an Online Analytical Processing...
- White papers
- Filling Gaps in the U.S. Commodity Flow Picture: Using the CFS With Other data sources
- The U.S. Commodity Flow Surveys (CFS) provide a wealth of data on the movement of freight within the country, by mode of transportation, dollar value, annual tonnage, door-to-door shipment distance and shipment size. Yet gaps in CFS coverage and a lack of spatial and commodity detail limit the value of...
- White papers 2005-06-08
- ITT New Global Vault Achieves Their Vision of a Single data source
- ITT Industries is a multi-billion dollar enterprise with manufacturing operations throughout the world. ITT faced the challenge of integrating a diverse set of CAD solutions, messaging tools, and other applications. While standardization was clearly required, making the transition would require overcoming cultural issues and revising many business systems. ITT standardized...
- Case studies 2005-01-11
- Delivering Multi-Vendor Product Information to Facilitate Customer Purchase Decisions: Evaluating the ROI of CNET Channel DataSource
- To succeed in the highly competitive IT and consumer electronics e-commerce world, online resellers need to differentiate their offerings, increase revenues, and reduce operating costs. Many online resellers depend on their online product catalogs to both generate revenue and differentiate their offerings. And while product catalogs are frequently considered only...
- White papers 2004-12-01
- Effects of Trial Design on Participation and Costs in Clinical Trials With an Examination of Cost Analysis Methods and data sources
- This paper comprises a series of studies conducted as part of the Cost of Cancer Treatment Study (CCTS). The specific aims include exploring theoretical issues concerning the problem of representativeness in trial design with an explicit investigation of the causes of the under-representation of older adults in clinical cancer trials;...
- White papers 2004-10-21
- Schema Evolution In Data Warehousing Environments
- In heterogeneous data warehousing environments, autonomous data sources are integrated into a materialised integrated database. The schemas of the data sources and the integrated database may be expressed in different modelling languages. It is possible for either the data source schemas or the warehouse schema to evolve. This evolution may...
- White papers 2004-09-19
- Zero-Latency Data Warehousing for Heterogeneous data sources and Continuous Data Streams
- In this paper, a framework for building an overall Zero-Latency Data Warehouse system (ZLDWH) is provided. Such a ZLDWH requires tasks such as data changes detection, continuous loading and updating of new data, autonomous analysis and the execution of actions to be completed in the Data Warehouse (DWH). The continuous...
- White papers 2003-08-29
- Using Automed for Data Warehousing
- A data warehouse consists of a set of materialized views defined over a number of data source, collects copies of data from remote, distributed, autonomous and heterogeneous data sources into a central repository to enable analysis and mining of the integrated information. Data Warehousing and On-Line Analytical Processing (OLAP) are...
- White papers 2003-04-07
- The Contribution of Market Intelligence to Tactical & Strategic Business Decisions
- One of the drivers of both strategy and success in the marketplace is the role of market intelligence. Samples a broad cross section of firms regarding their level of MI activity; MI data sources and MI accountability. Regarding MI activity and its value to consumer/ competitive intelligence, two thirds of...
- White papers 2000-01-18
Additional Resources
- Implementing or Upgrading SAP Solutions? Don't Forget the Data
- Download this white paper to learn how you can minimize the five most common data migration challenges associated with SAP implementations: Identifying and analyzing source data Accessing source data Addressing data quality in legacy applications Preparing and loading data into SAP Supporting...
- White papers 2006-01-01
- An Improved Approach in the Data Warehousing ETLM Process for Detection of Changes in Source Data
- In the Data Warehouse (DW) area, a well-known issue consists of the detection of changes in source data. This problem arises when the data source does not possess or does not provide the information about the changes that have occurred. The main scenarios in which this problem is found may...
- White papers 2003-08-30
- Modifying The Row Source Of A List Box On A Data Access Page In Access
- When you add a drop-down list box or list box to a data access page by using a wizard, Access sets the ListRowSource property of the drop-down list box or list box to the table or query you selected as the control's data source. A ListRowSource is the name of...
- White papers
- 25 Easy Pivot Table Reports
- Having trouble visualizing how to use a PivotTable report to analyze your data? While you can use these techniques for just about any type of source data. To work directly with these PivotTable reports, download Excel 2002 Sample: PivotTable Reports, the companion workbooks. This paper gives information of how to...
- White papers
- About Calculations And Formulas In Pivottable And Pivotchart Reports
- PivotTable and PivotChart reports provide several types of calculations. Data fields use summary functions to combine values from the underlying source data. You can also use custom calculations to compare data values, or add your own formulas that use elements of the report or other worksheet data. This paper explains...
- White papers
- Four Ways To Publish External Data Ranges To The Web
- An external data range is data from a separate source, such as a Microsoft Access or SQL Server database, that you've brought into Microsoft Excel. You can format the data in Excel and add formulas in adjacent columns to perform calculations on the data. You can publish an external data...
- White papers
- << Previous
- page 1 of 1
- Next >>
Content Types
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
