|
Product Overview |
|
Enabling Business Intelligence (BI) - OLAP
application for Microsoft®
SharePoint® that makes it very easy and effortless to analyze
your ever-growing SharePoint list data in multiple dimensional view,
and get useful insights and sense out of your lists,
appointments or tasks. |
 |
|
NOTE: The beta
testing of this product is over.
A new version 2.0 would be available by
mid-September 2010.
|
OLAP Statistics & Reporting for Microsoft®
SharePoint enables you to connect to a SharePoint list, task
or calendar and select fields of interest, and then explore
them in a multi-dimensional grid, pivot tables, filters,
graph or chart view. With the capability of complex
calculations, trend analysis and sophisticated data
modeling, and reporting, it helps you to
identify critical information on your SharePoint data.
You can run this OLAP exploration and analysis tool on
any
individual SharePoint list, task or calendar, with its own
unique set of desired fields. You can define any field as
the measure with different function - sum, count, distinct
count, maximum, minimum etc, against which statistics is to
be executed.
|
 |
Works with WSS 2.0, 3.0 and MOSS
2007 |
|
|
Support almost all data types used
in SharePoint list |
|
|
Choose your own fields
and set them as
measures or dimensions for OLAP representation |
|
|
Supports
the following functions for Measures
- Count, Distinct Count, Max, Min,
Average, Sum etc. |
|
|
Supports date fields to
be broken to year, month, day, week, hours,
minutes etc. |
|
|
Supports
drill down and slice |
|
|
OLAP Grid
and Charts |
|
|
Export
reports as PDF, HTML, JPEG, PNG |
|
|
Export
statistical data to Excel sheet, CSV
or XML |
|
|
Export raw
Sharepoint list data to Access
database |
|
|
Unicode
Support |
|
|
Version:
1.0 BETA
Released: 15th March
2010
License:
FREE
|
|
Have any questions? Email us: support@assistmyteam.net
 |
New!
Take a video tour
Watch 'OLAP Statistics & Reporting' in action in
this video tour and learn quickly
how to get started to analyze your
SharePoint data and extract useful
information! |
|
|
|
| How does it
work? |
| From the OLAP Statistics Manager, you can enter
the URL of your SharePoint site and then retrieve
all the available lists. You then select a
particular list of interest from the tree to show up
all the available fields defined for that list, in
this grid, as shown below.
Choose which fields
or dimensions to
include in the statistic. You can also select
functions for those numeric/currency fields to act
as 'measures' in the OLAP cube, such that,
statistics can be generated across other fields,
based on the value of the 'measure' fields. Selected fields
and defined functions are saved
for that specific SharePoint list (in the favorites) so that when you come back
to this SharePoint list next time, it will show the same
selected fields.
Once you have chosen fields and defined 'measure'
fields, click the 'Run Statistics'. This tool, as shown below, consists
of the Grid and Chart Views. On the left is
the Cube structure - measures and hierarchies as a
tree. The measures are grouped in the set, displayed
in the branch. All the rest of the tree nodes are
the dimensions that contain hierarchies. You
can then drag dimensions (fields) from the cube
structure to the Columns and Rows areas, and then
select a measure or two from the cube, and drag it
to the values area to generate the statistics.
You navigate through these dimensions by drilling
down, rolling up, or drilling across. You can drill
down to access the detailed level of data, or roll
up to see the summarized data. You can roll up
through the hierarchy levels of dimensions or to
specific characteristics or data elements (columns)
of the dimensions. You can also drill across
dimensions to access the data of interrelated
dimensions. In addition, you can set one of these
powerful computational functions such as sum,
averages, distinct count, maximum, minimum, median,
deviations etc. for the measure field. |
|
Why use this
tool? A lot of information can be revealed that would otherwise
be hard to attain, during inspection and visualization of
the data, in varying levels of granularity. Further, it
supports most common operations such as pivoting, drill
down/slice and dice and filtering. Given that the
generalization of information using the list 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 preserving
context eliminating all guesswork. OLAP Statistics is
perfectly suited for this purpose. Now it’s easier than ever
to spot new trends and discover unknown problems in your
data flow.
OLAP Statistics & Reporting for SharePoint provides you with an easy and
intuitive access to your SharePoint items data for
analysis:
|
|
Combine your data in any order they
desire, at any level of
summarization, and over several time
periods. You can design your queries
by clicking on the dimensions and by
selecting the desire data elements
for the analysis you need to
perform. |
|
|
Provide multiple views for data
access, from your manager's desire
to browse through summarized data
to, your need to perform complex
detailed analysis.
|
|
|
|
|
Some useful external links
related to this product:
 |
None |
|
|
|
