|
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. |
|
| |
|
| 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:
 |
Seamless integration with Microsoft Outlook1 |
|
|
Support
almost all data types used in
Microsoft Outlook items. |
|
|
Supports
user defined custom fields as
well as built-in Outlook
fields. |
|
|
Supports
the following functions for Measures
- Count, Distinct Count, Max,
Min, Average, Sum etc. |
|
|
Choose your
own fields from the Outlook
folder/items and set them as
measures or dimensions for the OLAP
cube. |
|
|
Supports
most of the common OLAP operations
including slice and dice,
drill down, roll up, and
pivoting on the cube. |
|
|
Supports
date/time fields to be summarized or
broken down to year, month, day,
week, hours, minutes etc. |
|
|
Create your
own composite hierarchy.
Eg. Country > State > City |
|
|
Create your
own calculated member
involving computational
relationship. Eg. Total Sales = (UnitPrice
X Quantity) + Freight |
|
|
OLAP
Grid and Chart with
highly interactive, customizable and
user friendly interface. |
|
|
Save the
pivot details to file (*.olapreport)
to make it easy for later retrieval
and use without requiring to start
from scratch. |
|
|
Support
offline cube (to *.offlinecube
in compressed or uncompressed
format) for use in disconnected
mode. |
|
|
Complete
control over the export settings
of the grid/chart reports. |
|
|
Export
grid/chart reports as BMP, GIF,
JPEG, PNG, TIFF, TXT, CSV2,
PDF3,
HTML, XML, XLS4
|
|
|
Share
pivot details, reports, offline
cube, cube schema files among team
members to facilitate collaboration. |
|
|
Supports
POP, IMAP, Exchange mailbox and
Public folders, and even local
PST. |
|
|
Unicode
Support. |
|
|
Print
Preview tool. |
|
|
No
requirement of Microsoft Excel®
, Microsoft
Access®
or Analysis Server. |
|
|
Special
MSI installer available for
enterprise wide deployment (upon
request) |
|
|
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)
600
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
|
|
Represents Outlook fields
(including custom fields) as OLAP dimensions, which are naturally interrelated through
functional subject areas.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
Provides powerful
computational functions such
as sum, averages,
distinct count, maximum,
minimum etc. for the
measure field (when creating
the cube).
|
|
|
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.
|
|
|
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 |
|
