CubeView is a browser based Business Analytical reporting tool OLAP Dashboard

1
Business Analytical Reporting Tool OLAP Dashboard
CubeView is a browser based Business Analytical
reporting tool OLAP Dashboard
2
What 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. 

3
Generate two types of reports

• Tabular reports (from Database views)
• Analytical OLAP reports (from Cubes) Cross Tab
  / Graphical

4
self service reporting on Microsoft SQL platform

• Reporting Features
• Reporting Benefits
• Dashboarding Features
• Dashboarding Benefits
• Publishing Features
• Publishing Benefits
• Cost Benefits

5
How 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.

6
Structure Of OLAP Reporting Tool
7
(No Transcript)
8
CubeView user-friendly Web Based Dashboarding Tool
9
Publishing 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
10
Industry 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

11
Built using Microsoft technology

• ASP / dotNet
• SQL 2012 database and Analysis Services
• IIS

12
Why 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.

13
About 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.
14
Contact US
Center for Business Intelligence Analytics,
LLC 10685-B Hazelhurst Dr. 15378
Houston, TX 77043 USA Web
www.cubeviewtech.com