Search
Twitter

Presentation Materials 

I love presenting! If you'd like for me speak at your user group or organization, please give me a shout by E-Mail.

 

Document Downloads:    

     Report Requirements
     Report Style Guide
     Report Unit Testing Checklist

Presentation Info & Slide Downloads:    

     The Lifecycle of a Reporting Services Report

     So You Want to Be a Rockstar Report Developer?

     Maximizing the Data Exploration Capabilities of Power View

     Tools and Techniques for Implementing Corporate and Self-Service BI

     Managing the "PowerPivot for SharePoint" Environment

     Dashboards ... How to Choose Which MSBI Tool?  

     Managed Self-Service BI

     


 

The Lifecycle of a Reporting Services Report

Description:  In this session we will discuss various tips and best practices as we follow a report through its lifecycle via an end-to-end demo. Beginning with a discussion of requirements and useful templates, we will progress to a review of good report development and standardization practices, followed by suggestions for testing and validation. Next we will consider alternatives for deployment, report delivery, and handling ongoing enhancements and bug fixes. The lifecycle will wrap up with a discussion of maintenance and administration of the reporting environment.  

Level:  Intermediate 

Slides:  Coming Soon

Presented at: 

     


 

So You Want To Be a Rockstar Report Developer?

Description:  You don't want to settle for being an average report developer, right? In this session we'll walk through an end-to-end demo as we discuss various development, standardization, deployment, and documentation practices that will make your SSRS development life easier, your output of higher quality, increase maintainability, and ultimately save you time. Audience participation and sharing of experiences is encouraged as we cover choices you have for datasets, sorting, grouping, filtering, calculations, parameters, deployment, and delivery. This session focuses primarily on SQL Server Reporting Services 2012, although some concepts may apply to other BI tools as well. ¬†Join us and take your reporting skills to the next level!  

Level:  Intermediate 

Slides:  So You Want To Be a Rockstar Report Developer?

Starter Templates:
   Report Requirements
   Report Style Guide
   Report Unit Testing Checklist

Presented at: 

     


 

Maximizing the Data Exploration Capabilities of Power View

Description:  Would business users in your organization love to get their hands on an interactive, visually-oriented, data exploration tool? If so, Power View may be a useful addition to your BI environment to handle certain types of self-service reporting requirements. In this session we will demonstrate the features and functionality of Power View including highlighting, cross-filtering, play axis, small multiples, tiles, cards, maps, filtering, and exporting.

We will identify which situations Power View is most suited for, as well as its strengths and limitations. Capabilities in SharePoint 2010/2013 vs. Excel 2013 will be reviewed, as well as restrictions on types of data sources allowed. We will also discuss how to prepare a dataset in order to maximize the usability and functionality of Power View. Join us for this session to discover how to get the most out of Power View!  

Level:  Introductory 

Slides:  Maximizing the Data Exploration Capabilities of Power View

Presented at: 

     


 

Tools and Techniques for Implementing Corporate and Self-Service BI

Description:  Business Intelligence requirements frequently change and having only a Corporate BI solution can result in slower delivery cycles and information backlogs. Yet the introduction of Self-Service BI introduces challenges around governance, change management, standardization, training, support, and access to unregulated data sources. In this session we will consider the benefits, obstacles, and techniques for integrating Self-Service and Corporate BI. Demonstrations of Microsoft BI tools will include Power Pivot, Power Query, Power View, Power Map, Excel, and SharePoint 2013.  

Level:  Introductory 

Slides:  Tools and Techniques for Implementing Corporate and Self-Service BI

Presented at: 

     


 

Managing the "PowerPivot for SharePoint" Environment

Description:  In this session we will discuss management of data models and reports stored in the PowerPivot Gallery document library. Data Refresh and security considerations will be reviewed in depth. The relational and SSAS databases present in a PowerPivot for SharePoint environment will be introduced, as well as options for reporting on usage and other key metrics. This session, which is applicable to SharePoint 2010 and 2013, will help you become prepared to tackle the support aspects of a PowerPivot for SharePoint environment.  

Level:  Intermediate 

Slides:  Managing the PowerPivot for SharePoint Environment

Presented at: 

   


   

Dashboards...How To Choose Which MSBI Tool?

Description:  The Microsoft Business Intelligence (MSBI) stack has a few choices for visualization.  We will explore options, flexibility, limitations, and ease of use for creating dashboards & scorecards with:

  • PerformancePoint Services 2010
  • Reporting Services 2008 R2
  • SharePoint Server 2010
  • PowerPivot
  • Power View

This session will be a fun one!  We will compare and contrast options available in each tool, such as:  charts, gauges, maps, indicators, sparklines, data bars, and decomposition trees. 

Goals:

  • Examine strengths of each tool related to meeting data visualization requirements
  • Compare and contrast common visualization options available in each tool
  • Conclude when you might choose one tool in the Microsoft BI stack versus another

Level:  Intermediate 

Slides:  Dashboards...How To Choose Which MSBI Tool

Companion Document:  MSBI Visualization Comparisons By Tool

Presented at: 

   


 

Managed Self-Service BI

Description:  

Traditional Business Intelligence is changing … you heard about the ambitious data analyst down the hall who created a mashup of data from the internal data warehouse + Excel + an Azure feed?  Empowering knowledge workers is Microsoft's vision of delivering "BI for the Masses."  In this session we will dismiss the hype & examine how this new world of "Managed Self-Service BI" complements Corporate BI in SQL Server 2012 and SharePoint 2010/2013. 

Goals: 

  • Provide overview of each Self-Service component and expectations for its use:  PowerPivot | Excel Services | Power View | Report Builder
  • Discuss techniques to successfully monitor, secure, & manage the Self-Service BI environment

Level:  Intermediate   

Slides:  Managed Self-Service BI

Presented At: