18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
country flagUnited States
share button

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

Category

SharePoint

Rating
4
(4)
Price

$2799

Course Description

This SharePoint 2013 training is for the professionals who want to explore the Microsoft data visualizations and learn what can be achieved without the use of code. SharePoint 2013 PerformancePoint, Excel Services, PowerView, PowerPivot, and Report Builder and covered and fused into dashboards.

This course is an updated version of 50561AC.

This training is designed based on the objectives of the course variant 55072A.

Prerequisites for this training

An ideal candidate will have at least one year of experience within a SharePoint environment.

Who should attend this course?

The target audience of this course is 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.

Schedules


Aug 16, 2021
9:00 am - 5:30 pm EST
Online

Aug 23, 2021
9:00 am - 5:30 pm EST
Online

Aug 30, 2021
9:00 am - 5:30 pm EST
Online
question-markCan't find the batch you're looking for?

What you will learn

  • Why this course may be for you:
  • You have the infrastructure, but getting reports generated out of I.T. takes too long.
  • Lack of insight into what has happened is hampering your ability to move forward.
  • You need or want to use the web browser as your source of information to be as accessible as the internet.
  • You want to take advantage of the SharePoint deployment to manage the data connections, report objects, dashboards KPI’s, etc.
  • You need to prototype reports for changing conditions rapidly
  • You want to move from textual messages to graphical reporting.
  • You are tasked with implementing Six Sigma-type reports using Visio Data Driven objects.
  • Your organization wants to implement analysis based on automatically updating data.
  • You need to implement a “Single Source of The Truth” structure.
  • You need to understand the effectiveness of the reports and dashboards.
  • It would help if you understood the available tools and how to determine which is the target audience for those tools.
  • It would help if you implemented actionable dashboards to allow line managers to take action rapidly.

With Microtek Learning, you’ll receive:

  • Certified Instructor-led training
  • Industry Best Trainers
  • Official Training Course Student Handbook
  • Pre and Post assessments/evaluations
  • Collaboration with classmates (not available for a self-paced course)
  • Real-world knowledge activities and scenarios
  • Exam scheduling support*
  • Learn and earn program*
  • Practice Tests
  • Knowledge acquisition and exam-oriented
  • Interactive online course.
  • Support from an approved ITIL expert
  • For Government and Private pricing*
*For more details call: +1-800-961-0337 or email: info@microteklearning.com

Our Clients

For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.

  • 300+ enterprise clients
  • 100,000+ professionals trained
  • Service 70 of the Fortune 100
  • 96% of our clients would recommend us
our clients

Our Awards

our awards

Why Choose Us?

Best price

Best Price in the Industry

You give better value in the marketplace. We will beat it.

trusted-approved

Trusted & Approved

Our courses are accredited by the authorized vendor.

delivery-methods

Many Delivery Methods

Flexible delivery methods are available here.

high-quality-resources

High-Quality Resources

Resources are included for a comprehensive learning experience.

Curriculum

This module explains how the class will be structured and introduces course materials and additional administrative information.

  • What does NO Code mean?
  • How to get the most out of this course
  • The course setup
  • What is not covered?
  • This module explains the concepts of data visualizations.

  • Data Visualization Fundamentals
  • The Microsoft Toolsets for Visualizations
  • Lab: Data 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
  • Lab: Group Review of Design Problems

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

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

  • Introduction to Report Builder 3.0
  • Report Builder 3.0 Wizards
  • Report Builder 3.0 Graphics
  • Intermediate Reports
  • Lab: Report Builder 3.0

  • 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
  • Lab: PowerPivot and 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 the 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
  • Lab: SharePoint 2014 Excel Services

  • 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
  • Lab: PerformancePoint 2013

  • 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
  • REVIEWS ON OUR POPULAR COURSES

    male

    I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.

    MARTIN

    TORONTO, CANADA

    • (5)
    male

    I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.

    Prince N.

    Texas

    • (5)
    male

    I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.

    Marsh George

    Texas

    • (5)
    Accredited By

    Course Details

    • Start Date: Aug 16, 2021
    • Duration: 5 Days
    • Skill Level: Intermediate
    • Certification: NO
    • Enrolled: 1373
    • Price: $2799
    side post

    Talk to Learning Advisor

    Get In Touch

    * I authorize Microtek Learning to contact me via Phone/Email