• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
12/20/2018 12/21/2018
  • VLT
Live Online
10/25/2018 10/26/2018
  • VLT
Live Online
11/19/2018 11/20/2018
  • VLT
Live Online

About the Course 

In this course understudies will figure out how to make and offer intuitive dashboards utilizing Excel PowerPivot, Power View and SharePoint. Understudies will stroll through the advancement of a dashboard extend with the means, ideas, equations, and capacities that are utilized clarified in detail. 

Audience Profile

This course is focused at Business Intelligence designers and Power Users that are as of now, or are in procedure of, creating Excel dashboards. 

At Course Completion

In the wake of finishing this course, understudies will have the capacity to: 

  • See how to build up numerous dashboards. 
  • See how to change sent dashboards. 
  • See how to give intelligent help to dashboards. 
  • See how to screen dashboard use. 
  • See how to control dashboard refreshes. 
  • See how to import information. 
  • See how to relate information. 
  • See how to improve information. 
  • See how to utilize time figurings. 
  • Source information. 
  • Comprehend forbidden information. 
  • Comprehend visual information. 
  • Comprehend connected tables. 
  • Make a dashboard. 
  • See how to include drillthrough. 
  • Comprehend representations in Power View. 
  • Include intelligence. 
  • See how to send to SharePoint. 
  • Comprehend programmed information invigorate. 
  • Offer utilizing SharePoint Excel Services. 

55103: Creating And Sharing Interactive Dashboards with PowerPivot, Power View And  SharePoint Server Course Outline 

Module 1: Course OverviewLessons 

  • Presentation 
  • Course Materials 
  • Offices 
  • Requirements 
  • What We'll Be Discussing 
  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Effectively sign into their virtual machine. 
  • Have a full comprehension of what the course expects to cover. 

Module 2: Dashboard PrinciplesLessons 

  • Build up Multiple Dashboards 
  • Change Deployed Dashboards 
  • Give Interactive Help To Your Dashboards 
  • Screen Dashboard Utilization 
  • Control Dashboard Updates 
  • In the wake of finishing this module, understudies will have the capacity to: 
  • See how to build up various dashboards. 
  • See how to change sent dashboards. 
  • See how to give intelligent help to dashboards. 
  • See how to screen dashboard usage. 
  • See how to control dashboard refreshes. 

Module 3: Sourcing the DataLessons 

  • Bringing in Data 
  • Relating Data 
  • Enhancing Data 
  • Time Calculations 

Lab : Sourcing the Data 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • See how to import information. 
  • See how to relate information. 
  • See how to enhance information. 
  • See how to utilize time estimations. 
  • Source information. 

Module 4: Creating the Excel DashboardLessons 

  • Unthinkable Data 
  • Visual Data 
  • Connected Tables 

Lab : Creating the Excel Dashboard 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Comprehend unthinkable information. 
  • Comprehend visual information. 
  • Comprehend connected tables. 
  • Make a dashboard. 

Module 5: Adding InteractivityLessons 

  • Including Drillthrough 
  • Perceptions with Power View 

Lab : Adding Interactivity 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • See how to include drillthrough. 
  • Comprehend perceptions in Power View. 
  • Include intuitiveness. 

Module 6: Sharing with SharePoint Excel ServicesLessons 

  • Convey to SharePoint 
  • Programmed Data Refresh 

Lab : Sharing with SharePoint Excel Services 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • See how to convey to SharePoint. 
  • Comprehend programmed information revive. 
  • Offer utilizing SharePoint Excel Services.

Before going to this course, understudies must have: 

  • Experience introducing PC equipment and gadgets. 
  • Essential comprehension of TCP/IP and systems administration ideas. 
  • Essential Windows and Active Directory information. 
  • The abilities to outline record shares. 
  • Experience working from an order incite. 
  • Essential learning of the basics of uses. For instance, how customer PC applications speak with the server. 
  • Essential comprehension of security ideas, for example, validation and approval. 
  • A comprehension of the crucial standards of utilizing printers.

Awards