Course 55072-A: Visualizing Data with SharePoint 2013, Report Builder, PowerPivot & PowerView with No Code

Microsoft

Course 55072-A: Visualizing Data with SharePoint 2013, Report Builder, PowerPivot & PowerView with No Code

Share This Learning Path

What do we mean by no code ?, it is a matter of perspective. In todays world the successful software vendor needs to develop software that is easily customizable by casual users. In the realm of business intelligence that means offering a variety of tools to different types of users that, depending on their experience, they can utilize to rapidly create the visualization of data that suits their needs. Microsoft has produced a great array of such tools that target different users. These tools are various Wizards, Dialog Boxes, Forms, Web Pages Designers and so forth. In this course we utilize the built in tools and do not write a single line of code.

No Code visualization means using the data structures that exist already to get the job done. You dont have the time or maybe the inclination to learn how to code but you need answers. I.T., if you havent already noticed, is always working through a backlog but your business situation is dynamic and rapidly changing and will not wait for any backlog. In this course you will learn how to get those answers without submitting a request and waiting.

Audience Profile

The target audience of this course is for Business Analysts, Report Designers, Team Leads, SharePoint Administrators, Business Intelligence Developers and Project Managers that will be tasked with the implementation, support, management or training needed to rapidly empower the users to take advantage of the exploding world of Data V.

Prerequisites

Course outline

Module 1: Introduction

Module Overview

This module explains how the class will be structured and introduces course materials and additional administrative information. What you will get out of this module: Introduction to the instructor and your peers A review of what we mean by NO CODE How to work in the course environment.

Lessons

What does NO Code mean ?
How to get the most out of this course
The course setup
What is not covered ?

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Understand your course, classroom, classmates, facility and instructor.

Module 2: Data Visualizations

Module Overview

This module explains concepts of data visualizations.

Lessons

Data Visualization Fundamentals
The Microsoft Toolsets for Visualizations

Lab Sessions

Data Visualizations

Lab Lessons

Explore the Microsoft Toolsets

After completing this module, students will be able to:

Understand the concept of Data Visualizations.

Module 3: Dashboard Design Principles

Module Overview

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

Lessons

Successful dashboards
Quantitative relationships
Summary numbers
Tables or graphs ?
Types of graphs
Key performance indicators
Dashboard taxonomies
Pitfalls in dashboard design

Lab Sessions

Group Review of Design Problems

Lab Lessons

Design Problem 1
Design Problem 2
Design Problem 3

After completing this module, students will be able to:

Understand Dashboard Design Principles.

Module 4: Microsoft Business Intelligence Stack

Module Overview

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

Lessons

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

Lab Sessions

Tour of the Microsoft Business Intelligence Stack

Lab Lessons

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

After completing this module, students will be able to:

Understand the role of the Microsoft Business Intelligence Stack.

Module 5: Report Builder 3.0

Module Overview

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.

Lessons

Introduction to Report Builder 3.0
Report Builder 3.0 Wizards
Report Builder 3.0 Graphics
Intermediate Reports

Lab Sessions

Report Builder 3.0

Lab Lessons

Report Builder Wizards
Basic Reports
Intermediate Reports
Graphics

After completing this module, students will be able to:

Understand the role of the Report Builder 3.0.

Module 6: PowerPivot and PowerView

Module Overview

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! Well cover everything you need to know to get you up, running, and analyzing.

Lessons

PowerPivot
DAX
PowerView

Lab Sessions

PowerPivot and PowerView

Lab Lessons

Create a Pivot Table
Import Data
Create Relationships
Create Calculated Columns
Create Calculated Fields
Save to SQL
Create PowerView Reports
Deploy to SharePoint

After completing this module, students will be able to:

Understand how to use PowerPivot and PowerView

Module 7: SharePoint 2013 Excel Services

Module Overview

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.

Lessons

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

Lab Sessions

SharePoint 2013 Excel Services

Lab Lessons

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

After completing this module, students will be able to:

Understand SharePoint 2013 Excel Services.

Module 8: SharePoint 2013 PerformancePoint Services

Module Overview

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.

Lessons

New 2013 Overview of PerformancePoint Services
Dashboard Designer
Data Sources
Indicators
KPIs
Visual Reports
Filters
Scorecards
Dashboards

Lab Sessions

PerformancePoint 2013

Lab Lessons

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

After completing this module, students will be able to:

Understand SharePoint 2013 PerformancePoint Services.

Book Your Seat

Find Learning Paths

Course 20703-1-B: Administering System Center Configuration Manager

Join our community of certified professionals

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Policy for the Prevention and Combating of Violence and Harassment in the Workplace.

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Contact Us

International Computer Training Center