- 55072 Visualizing Data with SharePoint 2013, Report Builder, PowerPivot & PowerView with NO CODE
CLASS DATE(s):
6/22/2020 - 6/26/2020

COURSE LENGTH: 5 Days

COURSE COST: $2495.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

What do we mean by no code? It is a matter of perspective. In today’s 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.

AUDIENCE AND PREREQUISITES

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.

 

vendor course description

*Course Cost listed does not include the cost of courseware or lunch, required in your registration. Please refer to your Enrollment Sales Order or Invoice for the additional cost. If you have any questions, please contact us (learn@vtec.org or 207-775-0244). Course is subject to minimum enrollment. Course may run as a live distance learning course if minimum is not met.

COURSE TOPICS:


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

Module 2: Data Visualizations
Data Visualization Fundamentals
The Microsoft Toolsets for Visualizations
Lab : Data Visualizations

Module 3: Dashboard Design Principles
Successful dashboards
Quantitative relationships
Summary numbers
Tables or graphs?
Types of graphs
Key performance indicators
Dashboard taxonomies
Pitfalls in dashboard design
Lab : Group Review of Design Problems

Module 4: Microsoft Business Intelligence Stack
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 : Tour of the Microsoft Business Intelligence Stack

Module 5: Report Builder 3.0
Introduction to Report Builder 3.0
Report Builder 3.0 Wizards
Report Builder 3.0 Graphics
Intermediate Reports
Lab : Report Builder 3.0

Module 6: PowerPivot and PowerView
PowerPivot
DAX
PowerView
Lab : PowerPivot and PowerView

Module 7: SharePoint 2014 Excel Services
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 : SharePoint 2014 Excel Services

Module 8: SharePoint 2013 PerformancePoint Services
New 2013 Overview of PerformancePoint Services
Dashboard Designer
Data Sources
Indicators
KPIs
Visual Reports
Filters
Scorecards
Dashboards
Lab : PerformancePoint 2013