Course Code: 1161

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

Class Dates:
5 Days
Class Time:
Instructor-Led Training, Virtual Instructor-Led Training


  • 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
  • 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.


Course Details

  • 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