Session Abstracts

Here are the content details for this event's available sessions.
     All Sessions   |   Room 1

  • Configuration of SharePoint as a Business Intelligence Platform
    SharePoint is made up of many different components, each of which needs to be setup correctly. In this session, Mark will go over configuration of the Secure Store Service for storing authentication details, PerformancePoint services for creating dashboards, Excel Services to enable users to publish their excel documents to the web and the intricacies of configuring SharePoint to support PowerPivot.

    Session Length: 35 minutes
  • Structuring a SharePoint Site for Supporting Self-service Business Intelligence
    In this session, Mark will explain how to structure a SharePoint structure in a way that empowers business users to create self-service analytic applications.

    Session Length: 40 Minutes
  • Introduction to PerformancePoint Dashboard Designer
    Mark Stacey will introduce PerformancePoint Dashboard Designer, and go through the steps to create Key Performance Indicators and then combine them in scorecards to present a unified view of the business. He will also cover analytic chart and grid creation, explaining how these tools can provide for ad hoc analysis by a user. The session finishes off by showing techniques used to deploy PerformancePoint dashboards from one environment to another.

    Session Length: 56 minutes
  • Additional PerformancePoint Features
    PerformancePoint goes beyond just scorecards and charts. In this session, Mark will show how to present a strategy map, made famous for its use in the Balanced Scorecard, and also to create more complex connections between PerformancePoint components.

    Session Length: 27 minutes
  • SQL Server Reporting Services in SharePoint
    Many people are aware of Reporting Services, but few have successfully integrated it with SharePoint. Mark explains how to create a report without opening Visual Studio, how to publish this report and connect it to other components within SharePoint.

    Session Length: 24 minutes
  • Choosing a Microsoft Business Intelligence Technology
    The Microsoft Business Intelligence stack has a myriad of technologies, each of which has its own place. So, choosing a tool can be difficult. In this session, the choices and the reasons for those choices are clearly laid out by Mark.

    Session Length: 25 minutes
  • Excel and Excel Services
    Excel is the most powerful self-service Business Intelligence tool, but the challenge has always been to have one version of the truth, while still supporting user-driven analysis. In this session, Excel Services is setup to support self-service Business Intelligence, and some key Excel techniques for reporting from a cube are shown.

    Session Length: 40 minutes
  • Introduction to PowerPivot
    PowerPivot is one of the more powerful technologies to come out of Microsoft in recent years, allowing users to combine multiple data sources themselves. Students are introduced to it in this session.

    Session Length: 38 minutes
  • Class Hijack! Overview of Project “Crescent” with Brian Knight
    Brian Knight, SQL Server MVP and founder of Pragmatic Works, hijacks Mark’s class to provide a brief overview of Microsoft’s SQL Server Project "Crescent” with Sam Brace, community manager for SSWUG.ORG. He demonstrates how easy it is to use this immersive ad-hoc visualization tool that is part of SQL Server Code Name "Denali" Reporting Services.

    Session Length: 19 minutes
  • SharePoint as a Data Source
    Not all data is stored within the data warehouse. In this session, Mark shows how to surface data from SharePoint within dashboards.

    Session Length: 18 minutes
  • Using SharePoint for Unstructured Content alongside Business Intelligence Information
    Many executives prefer paper-based reports to electronic ones, as they can attach documents and make comments. In this session, Mark demonstrates how to use the capabilities of SharePoint to provide the same utility.

    Session Length: 28 minutes
Panel Bottom