Visualizing Data with SharePoint 2013, Report Builder, PowerPivot & PowerView with NO CODE

The course setup

What is not covered?

Explore the Course Environment

This module explains concepts of data visualizations.

Data Visualization Fundamentals

The Microsoft Toolsets for Visualizations

Explore the Microsoft Toolsets

This module is an introduction to successful design principles for Dashboard design.

Successful dashboards

Quantitative relationships

Summary numbers

Tables or graphs?

Types of graphs

Key performance indicators

Dashboard taxonomies

Pitfalls in dashboard design

Design Problem 1

Design Problem 2

Design Problem 3

This module covers the Microsoft Business Intelligence stack including SQL 2012, Extract-Transform-Load, Reporting Services, Tabular Data, Analysis Services and SharePoint 2013.

Microsoft Business Intelligence Overview

Business Intelligence in three ways

SQL Integration Services ETL

Reporting Services

Master Data Services

Data Quality Services

SharePoint 2013 Business Intelligence

Run a prepared ETL Package

Create a SQL Server Analysis Services Cube

Create a Tabular Database

Examine Master Data Services

Examine Reporting Services as a native install

Examine Reporting Services as an integrated SharePoint install

The SharePoint 2013 Business Intelligence Template

This module explains Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters and report expressions, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts and sub-reports.

Introduction to Report Builder 3.0

Report Builder 3.0 Wizards

Report Builder 3.0 Graphics

Intermediate Reports

Report Builder Wizards

Basic Reports

Intermediate Reports

Graphics

In this module, we will explore PowerPivot and its analytical capabilities. PowerPivot is a data analysis add-on for

Microsoft Excel that allows large amounts of data to be collected, aggregated, and analyzed in one workbook. Sounds

powerful? It is! We’ll cover everything you need to know to get you up, running, and analyzing.

PowerPivot

DAX

PowerView

Create a Pivot Table

Import Data

Create Relationships

Create Calculated Columns

Create Calculated Fields

Save to SQL

Create PowerView Reports

Deploy to SharePoint

In this module, we will go over all the new 2013 Excel Services features, and we will explore the core components of Excel Services. We will cover Excel Web Access and its capabilities along with any differences you may encounter in the browser as opposed to the desktop client. There is coverage of the Power View add-in for Excel, and then lastly we will explain the save and share process and have a look at best practices.

New 2013 Excel Services Features

Core Components

Excel Web Access (EWA)

What Excel Web Access is Not

Differences in the Browser vs. Desktop

SharePoint Libraries to Store Workbooks

Power View Add-in for Excel

The Save and Share Process

Excel Web App

Best Practices

Creating a Library to Hold Excel Workbooks

Exploring the Power View Add-in for Excel

Save and Share an Excel Workbook to a SharePoint Document Library

Add an Excel Web App to a Webpage

In this module, we will give you an overview of the new 2013 PerformancePoint Services features. Dashboard Designer is explored along with many of the objects and connections available within.

New 2013 Overview of PerformancePoint Services

Dashboard Designer

Data Sources

Indicators

KPIs

Visual Reports

Filters

Scorecards

Dashboards

PerformancePoint Services Dashboard Designer Introduction and Data Source Configuration

Standard or Blank KPI Demonstration

Leaf KPI Demonstration

Objective KPI Demonstration

Visual Reports

PerformancePoint Filters

PerformancePoint Cascading Filters

Time Intelligence Filters

Scorecard Settings

Scorecards Filtered Using the Wizard

PerformancePoint Dashboards