Data Retrieval and Analysis Resources
Data Retrieval and Analysis
Data Retrieval and Analysis is how businesses obtain insight into their operations before making critical decisions.
Businesses capture information across multiple dimensions of activity (e.g. sales, inventory, market research) over time. Capturing more information from more sources over time leads to exponential data volume growth. Data retrieval is the process of capturing these ever increasing amounts of information, transforming and formatting the data for its business needs, and loading it into the target data warehouse. This data retrieval process is often referred to as Extract, Transform, and Load (ETL).
While simple analyses can be performed on transactional data, greater value is derived from more sophisticated metrics applied to a broader scope of business activity. Rich and detailed analysis is easily conducted against information that has been retrieved and stored in a data warehouse.
Optimizing Data Retrieval and Analysis
Effective data retrieval for analysis strongly depends on the data’s timeliness, relevance, size and access speed. Solutions to this problem propose various methods of aggregating data. MicroStrategy recognizes each of these as valid and leverages them all to provide thousands of customers with high quality analysis on any amount of business data.
Data Retrieval and Analysis for Business Intelligence
Businesses derive great value by using MicroStrategy for powerful analysis of their entire Data Warehouse. MicroStrategy provides a unique way to apply superior metrics at any level of data and drill anywhere in the data warehouse (accessing all dimensions of data at all levels). This flexible analysis is rendered quickly using a powerful Business Intelligence Server – built on an optimized multi-pass SQL engine - to cache and manage the requests for information. The server capabilities are combined with a scalable and secure metadata to personalize data retrieval. Large user populations are provided with ad-hoc query and analysis of all of the data in the data warehouse without requiring knowledge of database languages (e.g. SQL) or table structure.
Maintenance of the Data Retrieval and Analysis System
As businesses derive value from their investments in data retrieval and analysis they require the business intelligence solution to automatically manage the aggregation and personalization of data. MicroStrategy provides this capability with an enterprise-class backplane of common administrative tools.