business intelligence and sharepoint 2010 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Business Intelligence and SharePoint 2010 PowerPoint Presentation
Download Presentation
Business Intelligence and SharePoint 2010

Loading in 2 Seconds...

play fullscreen
1 / 9

Business Intelligence and SharePoint 2010 - PowerPoint PPT Presentation


  • 130 Views
  • Uploaded on

Business Intelligence and SharePoint 2010. Steve McDonnell. Agenda. Options for BI in SharePoint 2010 Solution Overview Pre-Reporting Tools Integration Services – SSIS Analysis Services – SSAS Reporting Tools Reporting Services – SSRS PerformancePoint. Demo: Process Overview. Raw Data.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Business Intelligence and SharePoint 2010' - latham


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
agenda
Agenda
  • Options for BI in SharePoint 2010
  • Solution Overview
  • Pre-Reporting Tools
    • Integration Services – SSIS
    • Analysis Services – SSAS
  • Reporting Tools
    • Reporting Services – SSRS
    • PerformancePoint
demo process overview
Demo: Process Overview

Raw Data

Data Cubes

Database

Reports and Dashboards

methods and technologies u sed
Methods and Technologies Used
  • SQL Server Integration Services (SSIS)
    • Allows you to bring disparate data into one central location
    • Can perform complex transformations while moving data
    • Allows you to build a Data Warehouse or Data Marts
  • This stage can be the most time consuming process in a BI Project
methods and technologies u sed5
Methods and Technologies Used
  • SQL Server Analysis Services (SSAS)
    • Used to build data cubes (or OLAP cubes) that enables dynamic, real time, analytical processing and advanced reporting
    • Data cubes pre-calculate aggregations to enable real time analytics
    • Data cubes are n-dimensional
methods and technologies used
Methods and Technologies Used
  • SQL Server Reporting Services (SSRS)
    • Report Writing Tool built into SQL Server
    • Integrates with SharePoint
      • Permissions to reports are controlled from within SharePoint like normal documents
      • Users can create new reports from within SharePoint
    • Users can set up a scheduled delivery of reports via email
methods and technologies u sed7
Methods and Technologies Used
  • PerformancePoint Services
    • Microsoft’s high end dashboarding product
    • Interactive Charts and Reports work with Multi-dimensional data
    • End users can easily create new reports from within SharePoint
    • This product used to cost more per user than SharePoint 2007 Enterprise
      • Now included as a Service in SharePoint 2010