![Page 1: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/1.jpg)
Business Intelligence Platform for Success
Our Commitment in Life Sciences
![Page 2: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/2.jpg)
Infinity Info Systems: Our Approach
SM
Industry Focused Practice Areas
CRM Analytics MobilityWeb Collaboration
Consulting Implementation Training Support
RAPID Sure Step Methodology
![Page 3: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/3.jpg)
Importance of Dashboards & Analytics
“Some companies have built their very business on their ability to collect, analyze, and act on data”
“If you can’t measure it, you can’t manage it”
- Lord Kelvin, W. Edward Deming, Peter Drucker
http://www.infinityinfo.com/CompetingOnAnalytics
![Page 4: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/4.jpg)
Key Business Issues Gartner - Consistent themes for last 5 years…
Gartner Survey of 400 attendees at the North American and European Gartner Business Intelligence Summits
![Page 5: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/5.jpg)
Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions
Self Service ReportingEnd-User AnalysisAdvanced AnalyticsBusiness Performance ManagementOperational Applications
Embedded Analytics (CRM)
Microsoft Business Intelligence Vision
![Page 6: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/6.jpg)
Microsoft Business Intelligence Offering Delivered through familiar
interface Self-service access & insight Data exploration & analysis Data & contextual visualization
Business Productivity Infrastructure
Dashboards & Scorecards Excel & PerformancePoint Services Collaboration Search Content Management LOB Data Integration
Data Infrastructure & BI Platform
Analysis Services Reporting Services Integration Services Data Mining Data Warehousing
Data infrastructure and BI platform
Business collaboration platform
Business user experience
![Page 7: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/7.jpg)
Microsoft BI Components PowerPivot – End user viewer of dashboard in Excel or
SharePoint Also provides analysts ability to create/change dashboards and
data models Power View – browser based viewer of dashboards and
analytics, available in Excel, SharePoint, and IIS (requires SQL Server 2012)
Also provides analysts ability to create/Also provides analysts ability to create/change dashboards and data models
Reporting Services – traditional reports and print focused output, has some drill down capabilities Use Visual Studio (technical user) or Report Builder (non-technical user)
Analysis Services – used to create data cubes (OLAP) Integration Services – used to create data integration,
ETL, data cleansing, master data management & workflow SharePoint – used to provide access and collaboration of
the above (platform for accessing reports, dashboards and analysis)
![Page 8: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/8.jpg)
Microsoft BI PrinciplesMake it affordable with lower TCO
Centers around belief that today’s BI tools are specialized and expensive.
Leverage the Microsoft investment already made by clients End-to-end solution leveraging Microsoft SQL Server™, Microsoft
Office®, and Microsoft Office SharePoint® Server.
Focus on the end-user’s experience with Microsoft Office and the desire to “Stop Building Tools for Analysts.”
Long-term Commitment “We are dead serious about BI,” Steve Ballmer, CEO, Microsoft
![Page 9: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/9.jpg)
Microsoft BI: A Leader
“Microsoft's BI Tools revenue growth is growing at more than twice the rate of the overall market. …Microsoft's impact on the BI tools market cannot be overemphasized.”
Dan Vesset, IDC
Gartner – Magic Quadrant
![Page 10: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/10.jpg)
Power View Dashboard in CRM
![Page 11: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/11.jpg)
CRM Dashboards
![Page 12: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/12.jpg)
Mobile CRM Dashboards Add Win8 App screenshots here.
Windows 8 iPad
![Page 13: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/13.jpg)
PowerPivot
![Page 14: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/14.jpg)
Power View
![Page 15: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/15.jpg)
Landing page of your Dashboards
Click the dashboard you are interested
in
![Page 16: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/16.jpg)
Point and click
on elements to select or “drill”
There are 3 pages in this dashboard
![Page 17: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/17.jpg)
Point and click
on elements to select or “drill”
There are 3 pages in this dashboard
![Page 18: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/18.jpg)
Point and click
on elements to select or “drill”
View all pages in dashboard, select the one
you want
![Page 19: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/19.jpg)
Analysts can edit in browser, all server based processing
![Page 20: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/20.jpg)
SharePoint Scorecard
![Page 21: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/21.jpg)
PowerPivot CRM Example
![Page 22: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/22.jpg)
PowerPivot CRM Example
![Page 23: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/23.jpg)
PowerPivot CRM Example
![Page 24: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/24.jpg)
PowerPivot CRM Example
![Page 25: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/25.jpg)
PowerPivot CRM Example
![Page 26: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/26.jpg)
Product Demonstration Report Builder/Reporting Services
(design–build–deploy) Excel (familiar world) / PowerPivot Power View SharePoint/PerformancePoint
![Page 27: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/27.jpg)
Power View Power View is a way for the average business user
to create Silverlight dashboards and presentation-ready reports, change them at will, and make them (and the underlying data models) available to others on the SharePoint platform.
Power View dashboards and reports (which look a lot like PowerPoint slides) use Power Pivot as their data source.
![Page 28: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/28.jpg)
PowerPivot Power Pivot enables you to bring together multiple
data sources into a single pivot. The data model you create in Power Pivot then becomes available through the SharePoint Power Pivot Gallery not only to Power View but also to other tools such as SQL Reporting Services (SSRS), Report Builder, and other Excel workbooks.
![Page 29: Infinity Microsoft Business Intelligence Overview](https://reader036.vdocuments.us/reader036/viewer/2022062319/55632f1fd8b42a5c7b8b4c1f/html5/thumbnails/29.jpg)
PowerPivot in SharePoint With the PowerPivot extensions installed in
SharePoint, once you upload a PowerPivot workbook to the Power Pivot Gallery, you can then leverage the Power View online report creator to create highly-interactive visualizations.
Just click the PowerView icon to get started. You can drag and drop fields from your pivot to the presentation area and select from a variety of chart and table options. Drop on fields as filters, and by default they control all the charts in your view. You can also just click on a chart element to filter the rest the data in your view.