Title: CubeView is a browser based Business Analytical reporting tool OLAP Dashboard
1Business Analytical Reporting Tool OLAP Dashboard
CubeView is a browser based Business Analytical
reporting tool OLAP Dashboard
2What is OLAP Dashboard?
- The OLAP designation indicates that one or more
of the graphs or reports (sometimes referred to
as panes, in the dashboard) are based on an
Online Analytical Processing (OLAP) data source.
OLAP data sources are multi-dimensional, in that
they allow for reporting on several different
variables (also known as dimensions), sometimes
at the same time, with the flexibility to select
only a subset of the variables at a time. - Dashboards commonly include anything from basic
tabular reports, pie charts, bar charts, line
graphs, to more complicated reports with traffic
lighting and automatic threshold e-mail alerts,
maps, gauges, pyramids, spark charts and scatter
plots with trend lines. The options for reports
and graphs available in an OLAP dashboard may be
limited by the vendor.
3Generate two types of reports
- Tabular reports (from Database views)
- Analytical OLAP reports (from Cubes) Cross Tab
/ Graphical
4self service reporting on Microsoft SQL platform
- Reporting Features
- Reporting Benefits
- Dashboarding Features
- Dashboarding Benefits
- Publishing Features
- Publishing Benefits
- Cost Benefits
5How Browser based reporting tool Works?
- Connect to MS SQL Views or Cubes.
- Build reports (OLAP, Tabular, Cross-Tab and
Graphical). - Build dashboard page using templates.
- Insert Reports and define Page level Filters.
- Publish and circulate using dashboard viewer or
dashboard page URL. - Set access rights for dashboard pages.
6Structure Of OLAP Reporting Tool
7(No Transcript)
8CubeView user-friendly Web Based Dashboarding Tool
9Publishing and Circulation
Dashboard Viewer shows all the Dashboard pages
in menu form enabling users to select and
view any page. Insert Dashboard View URL in
intranet, website or MS SharePoint application.
Insert Dashboard View URL or Dashboard Page URL
in e-mails, to allow designated users access
to Dashboard Viewer or page. Easy
accessiblity on mobilephones and tablets
10Industry standard security features
- Single Sign for using Active Directory Feature
- Role based access to Dashboard pages for
business users. - Disable export to Excel file for selected roles
or users - Power users authorized to build, edit and
delete reports/Dashboard pages. - System Administrator authorized to
Add/edit/delete roles and users Connect to
Databases and Cubes Install/Uninstall
11Built using Microsoft technology
- ASP / dotNet
- SQL 2012 database and Analysis Services
- IIS
12Why CubeView?
- Meets the needs of organizations using Microsoft
SQL database. - Requires minimum IT support for installation and
system administration. - Reports presentable through dashboard pages or
viewer. - Offers variety of reporting formats.
- Publishing reports does not require any
specialized tool. - Dashboard viewer accessible using URL.
- URL linked dashboard viewer or pages can be
embedded in intranet, - website or e-mail.
13About C-BIA
C-BIA is a specialist BI solutions and analytics
services company. With more than 150 projects
executed successfully since 2004, C-BIA has
built expertise on Microsoft and SAS platforms
and worked on Oracle, Business Objects and some
open source platforms for client specific
requirement.
Behind the Design
CubeView is a web based Reporting and Analysis
tool created by Center for Business Intelligence
and Analytics (C-BIA), based on their vast
experience into designing and building Business
Intelligence (BI) solutions.
14Contact US
Center for Business Intelligence Analytics,
LLC 10685-B Hazelhurst Dr. 15378
Houston, TX 77043 USA Web
www.cubeviewtech.com