Documents & Diagrams:
Presentation Info & Slides:
Power BI: Architecture, Integration Points, Implementation Options
In this session we will review Power BI V2 architecture and integration points with corporate data sources, SaaS services, Azure, and third party apps. We will examine and demonstrate key capabilities in the Power BI web-based service, Power BI Desktop, Excel, and mobile apps. Implementation options for Power BI involving cloud, on-premises, and hybrid approaches will be explored. Finally, the concept of "Bimodal BI" will be introduced with use cases for how Power BI might be utilized for both self-service BI and certain corporate BI initiatives.
Level: A fast-moving introductory session
Target Audience: Technology professionals seeking to understand the system components
- SQL Saturday, Charlotte - 10/17/2015
- SQL Saturday, Kansas City, MO - 10/2/2015
- Midlands PASS Chapter, Columbia, SC - 6/11/2015
- Spark Conference, Charlotte, NC - 6/4/2015
- SQL Saturday, Atlanta, GA - 5/16/2015
- MVP Virtual Conference - 5/14/2015
- Charlotte BI Group (CBIG), Charlotte, NC - 2/3/2015
- Carolina IT Professionals Group (CITPG), Charlotte, NC - 1/13/2015
This session has evolved and was previously known as Power BI: Architecture, Use Cases, Strengths, and Shortcomings
Administering and Managing the Power BI Environment (V1 - Power BI for Office 365)
Power BI for Office 365 is Microsoft's new self-service BI offering. Just because it emphasizes self-service doesn't mean a system administrator isn't an important role! In this session we will discuss the overall system components and how a Power BI site in SharePoint Online differs from an on-premises SharePoint BI site. We will walk through how to best handle setting up connectivity to data sources, when a gateway is needed, and what data refresh capabilities exist. We will also consider how and when to create OData feeds from your corporate on-premises data sources and how those OData feeds affect Enterprise Data Search functionality.
Level: A fast-moving introductory session
Slides: Administering & Managing the Power BI Environment <--Applicable to V1 (Power BI for Office 365)
Power BI Architecture & Functionality in SharePoint Online (V1 - Power BI for Office 365)
Power BI for Office 365 is Microsoft's new business intelligence offering which utilizes SharePoint Online and Office functionality. In this session we will discuss and demonstrate the key components of this hybrid cloud environment and what the prerequisites are for a Power BI site. Some key differences between a Power BI site in SharePoint Online versus a SharePoint BI site will be explored. We will conclude with a review of data connectivity options to be aware of.
Slides: Power BI Architecture & Functionality in SharePoint Online <--Applicable to V1 (Power BI for Office 365)
- SharePoint Saturday, Charlotte, NC - 9/20/2014
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!
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.
Slides: Lifecycle of a SSRS Report
- New Zealand Business Intelligence User Group, Webcast - 11/29/2013
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.
- Triad SQL BI User Group, Winston-Salem, NC - 6/25/2013
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!
Managing the "Power Pivot for SharePoint" Environment
Description: In this session we will discuss management of data models and reports stored in the Power Pivot Gallery document library. Data Refresh and security considerations will be reviewed in depth. The relational and SSAS databases present in a Power Pivot 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 Power Pivot for SharePoint environment.
Managed Self-Service BI
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.
- 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
Slides: Managed Self-Service BI
- Triangle SQL Server User Group, Raleigh, NC - 1/15/2013
- PASS Summit, Seattle, WA - 11/7/2012
- SQL Server Innovators Guild, Greenville, SC - 8/7/2012
- PASS Data Warehousing and Business Intelligence Virtual Chapter - 7/12/2012
- SQL Rally, Dallas, TX - 5/10/2012
- Carolina Code Camp, Charlotte, NC - 5/5/2012
- SQL Saturday #111, Atlanta, GA - 4/14/2012
- Midlands PASS Chapter, Columbia, SC - 4/10/2012
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
- 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.
- 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
Companion Document: MSBI Visualization Comparisons By Tool