making better decisions with self-service bi & sharepoint
DESCRIPTION
Presentation given by Dan Hare & Aonghus Fraser in March 2012 in Jersey and Guernsey "Our presentation will include a number of examples of how the historically specialist realm of Business Intelligence and reporting can now be brought to the whole organisation, reducing costs and improving efficiency. We will also provide an insight to where the market is moving whilst demonstrating how you can make a difference now.The following topics will be covered during the briefing:· Using SharePoint to present SQL Reports with integrated Reporting Services· PowerPivot · Power View· Data Driven Workflows· The BI Semantic Model· Data warehousing· SQL 2008 R2 and SQL 2012· Secure Extranet options C5 Presenters: Dan Hare (Director & BI Lead) & Aonghus Fraser (SharePoint Lead Consultant) Format: Breakfast & PresentationTRANSCRIPT
www.c5alliance.com
Making Better Decisions with Self-Service Business Intelligence & SharePoint
Dan Hare & Aonghus Fraser
C5 Client Base
Agenda
Introduction Decision Making: A Brief History of Business
Intelligence Common Scenarios & Problems What can we do now? What can we do in the (very near) future? Demonstrations Q & A
The C5 Alliance Teams
60+ highly skilled, qualified and experienced consultants Operational locations Jersey, Guernsey, London.
A Brief History of BI
1958: Journal of Research and Development
An automatic system is being developed to disseminate information to the various sections of any […] organization.
[…] flexibility of such a system in identifying known information, in finding who needs to know it and in disseminating it efficiently either in abstract form or as a complete document.
What does “Business Intelligence” mean today?
Management Information, Business Insight, Data Warehousing, Data Processing…
Examples: Remove duplication and reduce manual input Improve quality of information and decisions Collect and contextualise data from different sources Gain insights from existing data Self service end user reporting Analyse past data Predict future behaviour
Purpose of Business Intelligence
Make Better Business Decisions:
Visualise meaning and knowledge hidden in your data
The right information
At the right time
In the right format
Common Scenarios – BI Report Creation
Complex Excel Workbooks Cut & Paste / Data Integrity Risk Dependency on highly skilled workforce Developers customising reports Dreaded month end operation
What can we do now?
Microsoft SQL Server BI Stack
Get dataIntegration Services
Relational data SQL Server Cube data
Analysis Services Present data Reporting
Services Analyse data Excel
2007/2010 Present data SharePoint
2010 ...anything else T-SQL /
C#.NET
Microsoft BI Platform Gartner rating
In the Magic Quadrant for Business Intelligence Platforms
• Gartner is the undisputed authority on IT industry ratings
• Microsoft is in the “Magic quadrant”
• Market leader in the “ability to execute”
Source: Gartner (January 2011)
SharePoint Business Services
PerformancePoint Services
Visio Services Excel Services
Self-service “Insights”
Access to information Rich analytics Visualisation Simplified navigation Simplified administration
What can we do in future?
SQL Server 2012 – from April 2012
Power View- Self Service Reporting
Mobile Device Support – 2nd Half 2012
Support for Windows Phone, iPad,
Demonstrations
Thank You!
Any Questions?