DATA MANAGEMENT - ACCESS - RETRIEVAL - ANALYSIS
Analyst Work Station (AWS) is MSA's proven data access and decision support tool. AWS combines an easy-to-use interface, with one of the fastest multidimensional OLAP databases in the industry, to provide an unparalleled solution for harvesting the value in your marketing and sales databases. AWS meets users' needs by offering complex functionality, complete flexibility, and detailed access to the data. Analyst Workstation was developed based upon our years of experience with CPG data and the users of that data. And it has evolved to meet the ever-changing needs of the industry. The LINQ (Large Interactive Network Query) add-on is a special feature designed to access today's extremely large store level databases quickly and efficiently.
Easy, Intuitive User-Interface
Analyst Workstation was specifically designed for analysts and business managers. Selections are represented in business terms instead of cryptic codes allowing even a novice user to quickly create a meaningful report. Features of Analyst Workstation include:
LINQ (Large Interactive Network Query)
Data sets have expanded exponentially from just a few years ago. It is now common for a marketing database to contain millions of records and several years of data. Users have become overwhelmed by the sheer amount of data available to them. Decision makers are ever challenged to find the quickest and easiest way to mine this vast data and produce actionable analytics.
The LINQ (Large Interactive Network Query) Add-on is a feature for specifically configured databases accessible through Analyst Workstation. LINQ queries are designed to access extremely large store level databases. Data that meets the criteria in the LINQ filter dialog is extracted from the database and returned to AWS to produce reports showing volumetric data and/or a store profile. The filters can be finely tuned to target a population or identify exceptions and opportunities.
With little effort, LINQ enables users to answer critical business questions such as:
LINQ provides counts and/or lists of identified items that satisfy the specified criteria. In addition, the lists can contain any of the associated store attribute information stored on the database such as store name and address, market and trade class identifiers, trade program participation level, call frequency, demographics, etc. The detailed lists can be printed or exported to Excel or other statistical packages for detailed analysis.
Use LINQ to:
Analyst Workstation employs OMNI, MSA's proprietary OLAP database developed and fine-tuned over a twenty-year period. OMNI specializes and excels in handling large amounts of time series data for market analysis. OMNI has a proven track record with syndicated third-party data providers such as AC Nielsen and IRI, as well as our client's internal sales and marketing data and MSA's Reseller Information Systems data.