panorama business intelligence solution
TRANSCRIPT
A Complete BI Solution for
Your Microsoft Platform
A few words about Panorama Software
1995 - Panorama’s first BI solution was created
1996 - BI technology sold to Microsoft, basis for Analysis Services & MDX
2003 - Redefine how Users Explore Data
2007 - Introduce the New ‘Dashboard’ in Office – ‘Spotlight’
2010 – Panorama makes PowerPivot ‘Enterprise Ready’
2009 – NovaView 6 brings together the best of SQL, Office and SharePoint
15 Years of Unbeatable Innovation
2006 - Partner with SAP, Advise on MDX
Panorama has recently been awarded silver in the
Best Business Intelligence and Reporting Tool
category by SQL Server magazine
A Strategic Microsoft Partner
“As far as third-party tools go Panorama is still the #1 vendor…”
*BI Survey 8 – review by Chris Webb: http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!4405.entry
BI Survey 8
BI Survey 8Business Benefit Index (BBI) by Product
#1
Panorama scores the highest compared to all other BI products when it comes to the business Benefits which the end users gets from the product – most value for your investment.
Source: http://www.isreport.de/index.php?id=993 Featuring: The OLAP survey 8 by Nigel Pendse
Financial Services Manufacturing Healthcare Retail & Distribution Telecom, Media & Entertainment
Over 1,500 customers worldwide
Value Proposition • Simple, self-service BI for the Information Worker• More power to the Analyst and the power user• Easy solution to deploy and maintain for the IT• Improved collaboration & team productivity
…on top of any data source
Top 3 challenges inBusiness Intelligence
today
Challenge #1: Business users still don’t use BI tools for data analysis
So when they need data insights, they go to IT
Which causes a lot of frustration for IT &
Business Users
This is why we designed & developed
Self-Service BI tools for End Users
BI for Business Users
– Interactive analysis
– Animated, self-discoverable features
– Zero training
– Fully integrated into the NovaView
Dashboard and SharePoint
NovaView Flash Analytics
The most user friendly, self-service analytical client available today
• Creates, formats and distributes high quality reports in one click
• Enables full integration with user data
–Supports all analytical capabilities within the report
–“Slice and dice” and search capabilities
–‘In Cell’ visualization, Bands
• “One-click” conversion to Excel and PDF
BI for End UsersNovaView Smart Reporting
One environment for analysis & reporting
BI for End UsersNovaView Dashboards
• Translate data into synchronized, visually rich graphical elements which show multiple results together
• Guided analysis for an intuitive user experience
• Self-Service Dashboards with personalized look and feel
• Open for 3rd party components
At a glance view of multiple results together
BI for End UsersNovaView Spotlight
• Deliver live, interactive insights to users in a simple and intuitive way
• Put insights where people work, in the most popular desktop applications
• From Insight to Analysis in one click
A personal dashboard inside MS Outlook
–Maintain direct interaction with data (“drill-down” and “slice and dice” capabilities)
–“One-click” charting and graphic tools provide users options for quickly modifying data
–Tree Maps (Heat Maps) for examining hierarchical data and finding correlation between two measures
• Sophisticated visual presentations of data analysis:
BI for End UsersNovaView Visuals
And if you need to collaborate with suppliers, partners & customers…
SharedViewsCollaboration Outside the Firewall
Challenge #2
Quick access to ALL data
Users are limited to pre-modeled data for analysis
Oracle SAP Microsoft
Data resides in different places
Databases Excel Applications Web Services
Panorama Universal Data ConnectorConnect to Any Data Source
Universal Data Connector (UDC)• Automatically transform dull data into
interactive and live insights
• Instantly connect to any data source with no IT involvement (Self-Service)
• Use the same familiar and powerful set of tools
• Completely web-based
• Leverage the Analysis Service (SSAS) power – stronger semantics and the power of multi-dimensional modeling
• Benefit from the unified platform, management and security
Panorama NovaView 6.2 Architecture
NovaView Server- Business Logic- Unified Data Security Model
Analysis Services Universal Data Connector
and / or
MS SQL
SAP Oracle Flat Files Applications Web Services
PowerPivot
and / or
Source, operational
raw data
Modeling, aggregations,
semantics
Intelligence Layer
End User Client
Smart Reporting
MS Office Clients
SpotlightDashboardsAnalytics
Complete BI Suite For All of Your Data Sources (Relational, OLAP & In-
Memory)
Analytics Reporting Dashboards
KPI’s Visualization(i.e. treemaps)
Office Integration
Challenge #3
While information workers want simple, analysts need more
power
• Real-time web access to the most powerful and intuitive analytical applications
• Identifies, investigates, and analyzes performance, drivers and trends
• Enables users to manipulate data, perform calculations and design complex analysis with intuitive “drag and drop” features
More Power to Your AnalystsNovaView Analytics
The most powerful analytical application
More Power to Your Analysts
• Instant calculated members
• Advanced exception handling
• Sliding filters
• Interactive Charting
• One click interactive reporting
• Geographic visualization
• Large dimension handling
• Sophisticated Ranking & Filtering
• Advanced MDX and DAX tools
• And much more
How we work together with Microsoft
Panorama Extends MS Platform
• The only BI tool specifically designed for the MS Platform
• Provides advanced analytical tools for the power users
• Gives the ability to spread BI to the masses through innovative interface & integration with Office and SharePoint
• Provides innovative ways to create and manage OLAP cubes automatically
• Natively supports MS PowerPivot, in-memory platform, and makes it enterprise ready
Panorama & Microsoft Transform BI as we know it
For the last 14 years, Panorama has been a strategic Microsoft partner and continually adds innovation on top of the Microsoft platform. This new release will bring to market an end-to-end BI solution that combines the best of Microsoft SQL Server, Office Excel 2010 and SharePoint 2010 with Panorama’s NovaView suite, and will ultimately transform the landscape of business intelligence as we know it.
Claude Lorenson, director of SQL Server marketing at Microsoft Corp.
http://www.panorama.com/news/news/archives/2010/first-bi-suite-for-powerpivot.html
Microsoft PowerPivot
The ultimate platform for self-service BI
Why use PowerPivot
• Great for Personal and Team Productivity• Available in Excel 2010• Remarkable platform performance• An Open In-Memory platform
PowerPivot Enterprise-Ready Needs
• Data Security Layer
• Powerful yet Simple Web-based Analytics
• Easy Way to Create Operational Dashboards
• Rich Data Visualizations (i.e. treemaps)
• A Complete End-to-End BI Solution
PowerPivot Enhancement # 1 – Security
Enhance OLAP Security
• NovaView adds a data level security layer
• Each user will only see his portion of the data
• Users can share confidential intelligence
• Make PowerPivot enterprise-ready
Make PowerPivot available for Teams, Departments and Enterprise
37
PowerPivot Enhancement # 2
Self-Service BI tools for Business Users
Business User DashboardsEasy way to create operational dashboards
BI for Business UsersNovaView Flash Analytics
The most user friendly, self-service analytical client available today
Intuitive & Interactive BI Suitefor Business Users
Analytics Reporting Dashboards
KPI’s Visualization(i.e. treemaps)
Office Integration
Panorama NovaView is the only BI suite on PowerPivot today
Same User Interface & multi-dimensional capabilities for all data sources (relational, OLAP, in-memory)
Complete Web-Based Experience
• No Installation
• Access from anywhere
• Intuitive & Interactive
Exec. Dashboards MS Office ClientsFlash Analytics Dashboards Smart Reporting
PowerPivot answers your ‘unknown’ questions
Spotlight
NovaView for MS Office 2010
NovaView Server- Business Logic- Unified Data Security Model
Analysis Services answers your ‘known’ questions
No other software, IT involvement or installations are requiredAll done by Business Users
Ultimate Self-Service BI
Connect
• Connect to any model• Create your own
interactive views
Analyze• User-friendly interface• Fully web-based• Same tools for Relational,
multi-dimensional (Analysis Services) and PowerPivot data
Publish & Share• Live in SharePoint• Share instantly and
Securely
44
PowerPivot Enhancement # 3 – More BI Functionality for Power Users
Advanced Analytics
• Give more power to the analysts:• Smart exceptions• Instant calculations • Additional data formatting• Fully interactive, with Slice & Dice and Drag & Drop• and much more!
• Optimized for PowerPivot models:• Efficiently handling flat and large dimensions• Innovative ‘Google/Bing-like’ instant data search for faster navigation
of the flat dimensions
Closing the gap to Analysis Services functionality
46
Demonstrationhttp://www.panorama.com/products/novaview-demo.html
“Businesses that are looking to extend their existing Microsoft data warehouse and BI solutions or make PowerPivot enterprise-ready should strongly consider NovaView. If you’re in the market for a third-party toolset to add functionality to Microsoft’s BI tools, your search is over.“
Derek Comingore, Microsoft SQL Server MVPhttp://www.sqlmag.com/article/type/Review-Panorama-NovaView-Suite.aspx
• Get in touch with us:[email protected]
• Follow us on Twitter:http://twitter.com/PanoramaSW
• Panorama Software on Facebook:http://www.facebook.com/pages/Panorama-Software/69503193948
• Panorama blog: www.panorama.com/blog
Contact Us