Download - Self-Service BI for the Masses
![Page 1: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/1.jpg)
Building Bridges:
Self-Service BI for the Masses
![Page 2: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/2.jpg)
Agenda
• PowerPivot as a great personal productivity tool
• Self-Service BI for the Masses with PowerPivot and Panorama NovaView
• Demo
• Live Q & A
![Page 3: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/3.jpg)
“High performance businesses are FIVE times more likely to use analytics than
lower performers.”
*Accenture survey of executives working at U.S. companies with annual revenues of $500 million or more http://www.information-management.com/issues/2007_56/10014969-1.html
![Page 4: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/4.jpg)
• Identify most profitable customers and offer them the right price
• Accelerate product innovation
• Optimize supply chains
• Find the true drivers of financial performance
Analytics Usage
*Accenture survey of executives working at U.S. companies with annual revenues of $500 million or more http://www.information-management.com/issues/2007_56/10014969-1.html
![Page 5: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/5.jpg)
Challenge: Business users still don’t use BI tools for data analysis
![Page 6: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/6.jpg)
So when they need data insights, they go to IT
![Page 7: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/7.jpg)
Which causes a lot of frustration for IT &
Business Users
![Page 8: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/8.jpg)
Microsoft PowerPivot
The ultimate platform for self-service BI
![Page 9: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/9.jpg)
PowerPivot integrates data from different places
Databases Excel Applications Web Services
![Page 10: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/10.jpg)
Why use PowerPivot
• Great for Personal and Team Productivity• Available in Excel 2010• Remarkable platform performance• An Open In-Memory platform
![Page 11: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/11.jpg)
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.
![Page 12: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/12.jpg)
PowerPivot Enterprise-Ready Needs
• Data Security Layer
• Powerful yet Simple Web-based Analytics
• Expanded Data Visualizations
• A Complete End-to-End BI Solution
![Page 13: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/13.jpg)
PowerPivot Enhancement # 1 – Security
![Page 14: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/14.jpg)
Enhance OLAP Security
• NovaView adds a missing 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
14
![Page 15: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/15.jpg)
PowerPivot Enhancement # 2 Self-Service BI tools for Business Users
![Page 16: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/16.jpg)
BI for Business Users
– Animated self-discovery features
– Zero training
– Interactive analysis
– Fully integrated into the NovaView
Dashboard and SharePoint
NovaView Flash Analytics
The most user friendly analytical client available today
![Page 17: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/17.jpg)
• 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
![Page 18: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/18.jpg)
BI for Business UsersNovaView Dashboards
• Translate data into synchronized, visually rich graphical elements which show multiple results together
• Provide at-a-glance views
• Self-Service Dashboards with personalized look and feel
• Drill-through for more detail from the dashboard level
![Page 19: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/19.jpg)
BI for Business UsersNovaView Spotlight
• Deliver interactive personalized insights to users in a simple and intuitive way
• Put insights where people work, in the most popular desktop applications
• Focus only on insights which are highly relevant for you
• From Insight to Analysis in one click
Personalized LIVE insights in Microsoft Outlook
![Page 20: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/20.jpg)
An End-to-End BI SolutionIntuitive & Interactive BI for Business Users
Analytics Reporting Dashboards
KPI’s Visualization Office Integration
Panorama NovaView is the only BI suite on PowerPivot today
![Page 21: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/21.jpg)
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
![Page 22: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/22.jpg)
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
22
![Page 23: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/23.jpg)
Live in SharePoint
![Page 24: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/24.jpg)
PowerPivot Enhancement # 3 – More BI Functionality for Power Users
![Page 25: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/25.jpg)
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
25
![Page 26: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/26.jpg)
Exec. Dashboards MS Office ClientsFlash Analytics Dashboards Smart Reporting
PowerPivot answers your ‘unknown’ questions
Spotlight
PowerPivot & Analysis Services
NovaView Server- Business Logic- Unified Data Security Model
Analysis Services answers your ‘known’ questions
![Page 27: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/27.jpg)
A few words about Panorama Software
![Page 28: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/28.jpg)
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
![Page 29: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/29.jpg)
“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 – Independently Verified
![Page 30: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/30.jpg)
BI Survey 8Business Benefit Index (BBI) by Product
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 customer investment.
Source: http://www.isreport.de/index.php?id=993 Featuring: The OLAP survey 8 by Nigel Pendse
#1
“Microsoft and Panoramaare clearly better together“
![Page 31: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/31.jpg)
Financial Services Manufacturing Healthcare Retail & Distribution Telecom, Media & Entertainment
Over 1,500 customers worldwide
![Page 33: Self-Service BI for the Masses](https://reader033.vdocuments.us/reader033/viewer/2022051313/54846372b4af9f51288b4836/html5/thumbnails/33.jpg)
• We have a PowerPivot session at the MS BI Conference- June 6-11, 2010 (New Orleans)
• How can I try Panorama NovaView?- www.panorama.com/trial
• 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
Live Q & A