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

Category

SharePoint

Rating
5
(5)
Price

$2595
Per Participant

Course Description

The goal of this course is to give participants an opportunity to learn about and experiment with Microsoft's data visualization tools while also developing their awareness of what is possible without the use of code. PowerView, PowerPivot, Report Builder, PerformancePoint, Excel Services, and SharePoint 2013 are all covered and merged into dashboards. Of course, this is a better version of 50561AC.

What does "no code" mean? It depends on your point of view. The successful software seller of today must create software that is simple for non-technical users to customize. In the context of business intelligence, this entails providing various tools to various user types so that, depending on their level of skill, they can use them to quickly produce the data visualization that best matches their needs. Microsoft has created a wide range of such products that cater to various users. These tools include different Wizards, Forms, Dialog Boxes, Web Page Designers, and other things. We use the built-in tools in this course and don't create a single line of code!

No Code visualization refers to leveraging pre-existing data structures to do the task. You need solutions but lack the time or even the desire to learn how to code. If you haven't already observed, IT is constantly trying to clear a backlog, but your company's condition is dynamic and changing quickly, so it won't wait for any backlog. You will discover how to receive those answers in this course without making a request and waiting.

Who should attend this course?

This course is intended for business analysts, team leads, SharePoint administrators, report designers, project managers, and business intelligence developers who will be responsible for implementing, supporting, managing, or training users so they can quickly benefit from the rapidly expanding world of Data V.

microsoft logoMicrosoft Certified Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

GTR
  • Virtual Live Training
  • Guaranteed to Run

Jun 26, 2023

9:00 am - 5:00 pm EST
Online
  • Virtual Live Training

Jul 10, 2023

9:00 am - 5:00 pm EST
Online
GTR
  • Virtual Live Training
  • Guaranteed to Run

Jul 24, 2023

9:00 am - 5:00 pm EST
Online
  • Virtual Live Training

Aug 07, 2023

9:00 am - 5:00 pm EST
Online
GTR
  • Virtual Live Training
  • Guaranteed to Run

Aug 21, 2023

9:00 am - 5:00 pm EST
Online
  • Virtual Live Training

Sep 04, 2023

9:00 am - 5:00 pm EST
Online
GTR
  • Virtual Live Training
  • Guaranteed to Run

Sep 18, 2023

8:30 am - 5:00 pm EST
Online
Request Batch

What you will learn

  • Despite the fact that you have the infrastructure, it takes too long for reports to be generated by IT.
  • Your ability to go forward is being hampered by a lack of understanding of what transpired.
  • To make the knowledge as accessible as the internet, you need or wish to use a web browser as your informational tool.
  • To handle the data connections, report objects, dashboards, KPIs, etc., you wish to make use of the SharePoint deployment.
  • For ever-changing circumstances, you must quickly prototype reports.
  • You want to switch from writing text-based reports to drawing them.
  • Utilizing Visio Data Driven objects, your objective is to implement Six Sigma-style reports.
  • Your business wishes to use automatic updating data for analysis.
  • A "Single Source of The Truth" structure must be used.
  • You must comprehend how effective the reports and dashboards are.
  • You must be aware of the tools that are available and know how to identify who their intended users are.
  • Implementing actionable dashboards will enable line managers to act quickly.

Curriculum

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?
  • This module explains concepts of data visualizations.

    Lessons

  • Data Visualization Fundamentals
  • The Microsoft Toolsets for Visualizations
  • Lab 1: Data Visualizations

  • Explore the Microsoft Toolsets
  • 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 1: 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.

    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 1: 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.

    Lessons

  • Introduction to Report Builder 3.0
  • Report Builder 3.0 Wizards
  • Report Builder 3.0 Graphics
  • Intermediate Reports
  • Lab 1: 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 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.

    Lessons

  • PowerPivot
  • DAX
  • PowerView
  • Lab 1: 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 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 1: 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.

    Lessons

  • New 2013 Overview of PerformancePoint Services
  • Dashboard Designer
  • Data Sources
  • Indicators
  • KPIs
  • Visual Reports
  • Filters
  • Scorecards
  • Dashboards
  • Lab 1: 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
  • 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 expert
    • For Government and Private pricing*

    * For more details call: +1-800-961-0337 or Email: info@microteklearning.com

    Request Call

    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
    Accredited By
    img-.jpg

    Course Details

    • Start Date: Jun 26, 2023
    • Duration: 5 Days
    • Skill Level: Intermediate
    • Enrolled: 1373
    • Price: $2595
    • Course PDF: Click Here
    side post side mode

    Talk to Learning Advisor