• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
11/08/2018 11/09/2018
  • VLT
Live Online
12/06/2018 12/07/2018
  • VLT
Live Online

About the Course 

This two-day educator drove course focuses on PowerPivot and Power View in Excel 2013. The participants will figure out how to surface the exercise manuals and perceptions utilizing the Business Intelligence Center in SharePoint 2013. 

Beyond what many would consider possible each of the modules remains solitary taking into consideration the customization of the course for those groups of onlookers that might not have an enthusiasm for a specific administration. 

Audience Profile

This course is expected for examiners, business knowledge (BI) engineers and IT experts that will be included with the outline, advancement, and upkeep of Excel exercise manuals using PowerPivot and Power View 2013 to be surfaced on SharePoint. 

At Course Completion

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

  • Utilize PowerPivot 2013 in Excel. 
  • Work with DAX. 
  • Make Power View perceptions. 
  • Comprehend information models. 
  • Spare to SharePoint. 
  • A surface on SharePoint. 
  • Work with the SharePoint Business Intelligence Center. 
  • Make devoted applications in SharePoint for PowerPivot and Power View. 
  • Utilize PowerPivot inside Excel to import a table from SQL Server. 
  • Utilize PowerPivot inside Excel to import a table from SQL Server Analysis Services. 
  • Shroud sections they don't need to be reflected in the subsequent PivotTable. 
  • View the connections existing inside the transported in tables from SQL Server and afterward import an extra table and arrange a connection amongst it and the current. 
  • Make a PivotTable inside a current worksheet. 
  • Explore and effectively utilize Power View. 
  • Make a table. 
  • Make an outline. 
  • Spare and offer their work. 
  • Make a BI semantic model. 
  • Investigate the alternatives and settings accessible inside the new SharePoint 2013 Central Administration and Excel Services. 
  • Get to and survey the Secure Store. 
  • Make another web application and business insight webpage while investigating the elements of both. 

Module 1: Course Overview 

55049: PowerPivot Power View and SharePoint 2013 Business Intelligence Center for Analysts module clarifies how the class will be organized and presents course materials and extra authoritative data. 

Lessons 

  • 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: PowerPivot 

In 55049: PowerPivot Power View and SharePoint 2013 Business Intelligence Center for Analysts module we will investigate PowerPivot and its logical abilities. PowerPivot is an information investigation add-on for Microsoft Excel that enables a lot of information to be gathered, collected, and broke down in one exercise manual. Sound capable? It is! We'll cover all that you have to know to get you up, running, and breaking down. 

Lessons 

  • What is an information display? 
  • PowerPivot and Excel 
  • New 2013 PowerPivot Features 
  • PowerPivot and SharePoint 
  • Venture Business Intelligence and PowerPivot 
  • Advancing Data 
  • Bringing in Data 
  • Reviving Data 
  • Organizing Data 
  • Arranging and Filtering 
  • Making Relationships 
  • Counts 
  • SharePoint Sharing 

Lab : PowerPivot 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Utilize PowerPivot inside Excel to import a table from SQL Server. 
  • Utilize PowerPivot inside Excel to import a table from SQL Server Analysis Services. 
  • Conceal segments they don't need to be reflected in the subsequent PivotTable. 
  • View the connections existing inside the foreign tables from SQL Server and after that import an extra table and arrange a connection amongst it and the current. 
  • Make a PivotTable inside a current worksheet. 

Module 3: Power View 

In this module, we will cover Power View and the revealing that can be made. From tables to outlines and sharing on SharePoint, this module will have you prepared to imagine your information in an assortment of ways. 

Lessons 

  • New 2013 Power View Features 
  • Microsoft Power View User Interface 
  • Tables 
  • Graphs 
  • Sparing and Sharing 
  • BI Semantic Models 

Lab : Power View 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Explore and effectively utilize Power View. 
  • Make a table. 
  • Make a graph. 
  • Spare and offer their work. 
  • Make a BI semantic model. 

Module 4: SharePoint 2013 Business Intelligence Center

In this module, we will investigate the as good as ever 2013 SharePoint Central Administration site. We will cover particularly the new 2013 Business Intelligence Center format inside SharePoint. Authorizations and parts will be tended to and the included library and rundown applications will be clarified. 

Lessons 

  • New 2013 SharePoint Central Administration 
  • New 2013 Business Intelligence Center 
  • Authorizations and Roles 
  • Included Document Library and List Apps 
  • Make Custom Apps (Libraries) for Visualizations or Workbooks 
  • Make Custom Connection Apps (Libraries) 
  • SharePoint 2013 Business Intelligence Center 

Lab : SharePoint 2013 Business Intelligence Center 

Subsequent to finishing this module, understudies will have the capacity to: 

  • Investigate the choices and settings accessible inside the new SharePoint 2013 Central Administration and Excel Services. 
  • Get to and audit the Secure Store. 
  • Make another web application and business insight website while investigating the components of both. 
  • Make custom applications to store perceptions or potentially exercise manuals in SharePoint 2013 Business Intelligence Center.

Before going to this course, understudies must have: 

  • Involvement with Excel 2007 or higher. 
  • A comprehension of PivotTables.

Awards