home | products | services | support | knowledgebase | contact


 
Product Overview
An add-in for Microsoft® Outlook® that provides a turnkey solution to OLAP requirement, making it very easy and effortless to analyze your ever-growing Outlook and Exchange data in multiple dimensional view, and get useful insights and sense out of your emails, appointments or tasks. Microsoft Office Marketplace logo
 
OLAP Statistics for Outlook enables you to select both Outlook and user-defined custom fields of interest, and then explore them in a multi-dimensional grid, graph or chart view with the capability of complex calculations, trend analysis and sophisticated data modeling, all from inside your Outlook.


The simplistic point-and-click interface ensures that you easily achieve the high-level views of information you require. Additionally, the OLAP client makes creating reports destined for different management levels a simple task - eliminating managers' dependence on IT personnel.

Highlights:
 

bullet

Seamless integration with Microsoft Outlook1

bullet

Support almost all data types used in Microsoft Outlook items.

bullet

Supports user defined custom fields as well as built-in Outlook fields.

bullet

Supports the following functions for Measures - Count, Distinct Count, Max, Min, Average, Sum etc.

bullet

Choose your own fields from the Outlook folder/items and set them as measures or dimensions for the OLAP cube.

bullet

Supports most of the common OLAP operations including slice and dice, drill down, roll up, and pivoting on the cube.

bullet

Supports date/time fields to be summarized or broken down to year, month, day, week, hours, minutes etc.

bullet

Create your own composite hierarchy. Eg. Country > State > City

bullet

Create your own calculated member involving computational relationship. Eg. Total Sales = (UnitPrice X Quantity) + Freight

bullet

OLAP Grid and Chart with highly interactive, customizable and user friendly interface.

bullet

Save the pivot details to file (*.olapreport) to make it easy for later retrieval and use without requiring to start from scratch.

bullet

Support offline cube (to *.offlinecube in compressed or uncompressed format) for use in disconnected mode.

bullet

Complete control over the export settings of the grid/chart reports.

bullet

Export grid/chart reports as BMP, GIF, JPEG, PNG, TIFF, TXT, CSV2, PDF3, HTML, XML, XLS4

bullet

Share pivot details, reports, offline cube, cube schema files among team members to facilitate collaboration.

bullet

Supports POP, IMAP, Exchange mailbox and Public folders, and even local PST.

bullet

Unicode Support.

bullet

Print Preview tool.

bullet

No requirement of Microsoft Excel® , Microsoft Access®  or Analysis Server.

bullet

Special MSI installer available for enterprise wide deployment (upon request)

bullet

Support for Office 2010NEW

 

1 Outlook® 2002, 2003, 2007, 2010
2 Comma Separated Values
3 Adobe Portable Document
4 Microsoft Excel Document
 

Version: 4.0

 

Have any questions?
Email us: support@assistmyteam.net

30 days trial

Personal License (Single Seat)
75
USD/~47 GBP/~72 AUD/~76
CAD
 

Country Enterprise License (Unlimited Seats)
6
00 USD/~390 GBP/~577 AUD/~608 CAD

Download brochure

License is valid life-time. However, technical assistance and free upgrades are bound to the validity of the Support and Maintenance Contract
 

Free license for Academic Institutions (Schools, Colleges and Universities) - Learn More...
50% discount for non-profit, non-academic organizations (e.g., Charitable trusts, hospitals,). Learn More...

 

Need for Business Intelligence

Though Outlook views are excellent way of presenting information in a more obvious way in folder, it does not give you the summarized data that one needs often, to see broader trends based on aggregation, and to see these trends broken down by any number of variables. Given that the generalization of information using Outlook views are constrained by a few fields (or dimensions) at a time, it is hard to fully evaluate a complex set of answers without the ability to inspect each dimension in detail, while at the same time, preserving context eliminating all guesswork.

 

OLAP Statistics & Reporting for Microsoft Outlook is perfectly suited for this purpose, and allows you to define any field as the measure with different function - sum, count, distinct count, maximum, minimum etc, against which statistics is to be executed. Real strength of this tool is its ability to examine and view data in ways not ordinarily possible. By allowing varying levels of granularity during data inspection and visualization, a lot of information can be revealed that would otherwise be hard to attain. Now it is easier than ever to spot new trends and easily answer many of the perspective information which otherwise are hidden

 

How does it work?

On every outlook folder, you will find the OLAP Statistics toolbar, containing two buttons. The first button enables you to choose which fields or dimensions (including user defined ones) to include in the statistic. It also lets you define which fields will act as 'measures' in the function column. Selected fields and other settings are saved for that specific folder so that when you come back to this folder next time, it will show the same selected fields.

As seen in the screenshot above, user-defined fields are distinctly highlighted for easy recognition. For example, ProjectCode, ProjectCost, ProjectCountry, ProjectManager, ProjectPoints are user-defined fields in this task folder. You can also add new OLAP fields - a composite (also known as hierarchy) or a calculated field, based on the existing member fields of Outlook. OLAP fields are also colored differently for easy recognition (e.g. green)
 

New OLAP composite dimension - E.g. Projects per Country

 

New OLAP calculated member - E.g. Projects Total Cost

 

Then you can run the statistics tool from the toolbar or from the fields selection dialog. Depending on the number of folder items, it might take a few seconds to generate the cube from the Outlook folder, before loading the OLAP Statistics and Reporting client tool, as shown below.


OLAP Grid view

 

OLAP Chart view

 

To put in perspective, OLAP Statistics & Reporting for Outlook
 
bullet Represents Outlook fields (including custom fields) as OLAP dimensions, which are naturally interrelated through functional subject areas.
 
bullet Provides an OLAP Grid view with support for a multi-dimensional table with expandable nodes. Unique features of control allows for building the OLAP-reports of the exceptional level of complexity.
 
bullet Provides an OLAP Chart view that allows representing the data graphically. This gives you a unique opportunity to analyze your business data visually, dealing with charts rather than numbers, which is much easier to perceive.
 
bullet Enables you to navigate through these dimensions by drilling down, rolling up, or drilling across - drill down to access the detailed level of data, or roll up to see the summarized data. Roll up through the hierarchy levels of dimensions or to specific characteristics or data elements (columns) of the dimensions. Drill across dimensions to access the data of interrelated dimensions.
 
bullet Provides powerful computational functions such as sum, averages, distinct count, maximum, minimum etc. for the measure field (when creating the cube).
 
bullet Allows you to save the current state of the statistics in the Grid/Chart working area to a report view file, with specific member fields on the pivot panels (Rows and Column areas) and measure fields in the values area. You can use this report view file in future, to retain back the same state of statistics.
 
bullet Supports exporting reports to a wide range of formats including Excel, Adobe PDF, XML, bitmaps or web pages.
 
 

For more elaborate and detail references, download the manual here

Similar and related products from AssistMyTeam SMB Solutions:
bullet OLAP Statistics and Reporting for Microsoft Access
bullet OLAP Statistics and Reporting for SharePoint

 

Some useful external links related to this product:

bullet What is OLAP?
bullet Wiki - Online Analytical Processing
bullet OLAP White Paper
 
   
Copyright © 2014 AssistMyTeam. All rights reserved.

privacy policy  | academic & non-profit license  | blog | about 

 
 

 

New! Take a video tour

Watch 'OLAP Statistics' in action in this video tour and learn quickly how to get started to analyze your Outlook data and extract useful information!

 

Looking for a Business Intelligence (BI) tool for Microsoft® Access®?

Try
OLAP Statistics
for Access

Analyze your Access data in OLAP Grid and Chart, perform trend analysis, modeling and reporting.

 

Looking for a Business Intelligence (BI) tool for SharePoint® List?

Try
OLAP Statistics
for SharePoint

Analyze your SharePoint list data in OLAP Grid and Chart, perform trend analysis, modeling and reporting.

 

Latest Blogs

latest news from
bahrurBlog
A better way of pushing your emails to SharePoint
A core issue that many IT administrators and power users face towards integration of Outlook/Exchange and SharePoint – the ‘incompleteness’ of the captured Outlook data in SharePoint... (8th December '13) 
 
Finally we’re there! Team Helpdesk with Outlook 2013 and 64 bit support
I am very excited with the plethora of features and enhancements possible with the new Team Helpdesk platform. And I hope to hear from you what you think of the new version in terms of features and usability..(14th Aug'13) 
 
Building solutions that work on both 32 bit and 64 bit native Office version
Today, 64 bit processors are found in most of our consumer and business systems. Because of its inherent capacity to support more virtual and physical memory than 32-bit ones..(18th Feb'13)

 
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.