How to create Dashboard using BI in SharePoint 2013

Advertisement

         For this Dashboard, first we have to configure PPS ,In my previous post I have explained about Configuration of PPS in SharePoint 2013.

Facing issues while Configuration PerformancePoint Services we can check below.

Cannot complete this action as the Secure Store Shared Service is not responding. Please contact your administrator

Cannot connect to performance point services contact the administrator for details
facing issues while Configuration PerformancePoint Services we can check below.

- See more at: http://www.dotnetsharepoint.com/2013/06/sharepoint-2013-performancepoint.html#.UwHpMrRrm-U

       The PerformancePoint Service is a SharePoint Server 2013 service application. It enables users to create business intelligence (BI) dashboards that provide insight into an organization's performance. By providing flexible, easy-to-use tools for rich dashboards, scorecards, and key performance indicators (KPIs) in web browsers, that can aggregate their content from multiple sources and help companies make important decisions.

For this demonstration ,I am using

Windows Server 2012.
Microsoft SharePoint Server 2013.
Microsoft SQL Server Analysis Services 2012.



First, we have to create site using SharePoint template “Business Intelligence Center” as shown in below



Once the site gets created, go to Site Contents on “Site Contents”



















You can make a design as per your requirement, for designing a dashboard, click on the “Dashboards” library 










Go to ribbon “PERFORMANCE POINT” and click on “Dashboard Designer” as shown below




  


   It shows window like this, click “open”

Launch the Dashboard Designer as shown below



For this demonstration ,I am using  Analysis Service database . So first step “create a Data Conncetion”. Right click Data Conncetion and click on “New Data Source” context menu.





It will show different types of data sources. choose “Multidimensional” and “Analysis Services” . Click the OK button as shown in figure below

Create a connection string by specifying  Server Name ,Database Name and Cube name as shown below


Note: Some times 'Database' remainder empty. please check my Article for that .
Rename the data source to “pps” save the data source. Right click “PerformancePoint Contents”, New and select Report as shown below
      It shows some different templates as shown below

   choose Data Source you would like to use .choose “pps” .click finish button. Rename the report as “PPS Chart” .

From the Details pane which is on our right hand side, drag and drop measures and dimensions depends on Your requirement ,I drag  “ Student SDAPH“ into our “Bottom Axis” section and drag and drop “Total English, Total Hindi, Total Maths”  from Measures as shown below
Add one more report which is the “Analytic Grid” report with name “PPS Grid”.same like as Report ,as shown in below

Create Dashboard and deploy it:

Create a dashboard and deploy the same to our SharePoint site. To create a Dashboard, right click on “PerformancePoint Contents” and click on “Dashboard” Choose the “2 rows” dashboard page template. Rename your dashboard to “PPS Dashboard”.
In Details pane, expand “Reports” and then PerformancePoint Contents. Drag and drop the “PPS Chart” into our first row and “PPS Grid” into our second row.


Save the Dashboard and Deploy the SharePoint site, Right click the “PPS Dashboard” and click on “Deploy to SharePoint”.
Use the “Default Site Master Page” and click “Ok” button.

Final report will look like this


In my next post i explain about how to create Filters and KPI's.

Advertisements
SHARE

Unknown

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

16 comments:

  1. Thanks,for sharing this post.

    ReplyDelete
  2. Its very use full for me..........

    ReplyDelete
  3. Great Article... Thank you

    ReplyDelete
  4. Hi,

    How would one setup a connection btw a scorecard and an excel services report?

    ReplyDelete
  5. hi
    I have made sure that I have started the Service and created Service application. But, whenever I try to create a data source from PerformancePoint Designer, I get the error:
    Cannot connect to PerformancePoint Services.Contact the adminstrator for more details.

    ReplyDelete
    Replies
    1. Hello,

      Plese check my article,
      http://www.dotnetsharepoint.com/2014/01/cannot-connect-to-performance-point.html#.UwHng7Rrm-U

      Delete
    2. thanks its work

      Delete
  6. hi !
    I want to create reports from a data model power pivot, what you need to know is that my model refers to external data (various sources)! how can i do?

    Thank's

    ReplyDelete
    Replies
    1. excuse me, I forgot to said that everything is done in sharepoint 2013

      Delete
  7. While making this step: "Go to ribbon “PERFORMANCE POINT” and click on “Dashboard Designer”" I got this error :
    Request FAiled unexpected response from server. The status coe of response is 500, The status text of response is 'System.ServiceModel.ServiceActivationException'. null

    ReplyDelete
  8. The UFC is back in Las Vegas this weekend for a big UFC 209 event, and the promotion has rolled out its “Embedded” treatment for a preview.
    UFC 209
    UFC 209 Live Stream , UFC 209 Live
    UFC 209 Fight , UFC 209 Fight Card
    LAS VEGAS – The outrage was noticeable when it was announced that UFC welterweight contender Demian Maia would be required to accept

    It's finally here, namely, UFC 209. But more than that, it feels like the first big fight week week of the year. That's a little bizarre because this.
    Jeremy Stephens and Renato Moicano square off at the UFC Fight Night card on April 15. The bout was announced Wednesday on UFC
    UFC 209
    UFC 209 Live , UFC 209 Fight Card
    UFC 209 Live Stream , UFC 209 Fight

    ReplyDelete
  9. Following having a few days and nights with mid-major March Madness championship video games claiming the schoolMarch Madness Live hockey spotlight, the Power 5 March Madness Live Stream conference tournaments commence to take center stage today. These types of are the games that will help define the way the bubble and the rear end of the NCAA March Madness Bracket Tournament bracket shakes away.
    March Madness 2017
    On Wednesday, Syracuse, Arkansas, March Madness 2017 Live California, TCU, Ohio Express, Wake Forest, 2017 March Madness Virginia Technology, Texas Tech, Xavier and The south all play video games NCAA March Madness that will either help solidify their at-large berth/seed or make Selection On the more of an troubled day. march madness schedule

    One other quick note: I moved Gonzaga back up to the top seed line after a third thoroughly impressive win over a very good Saint Mary's team in the WCC name game. That's not overall, though. The Pac-12 competition champion march madness schedule 2017 could easily find yourself there by the end of the week, particularly if the winner of the Arizona/UCLA semifinal beats Or in it game.

    ReplyDelete
  10. I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. download UC mini

    ReplyDelete
  11. Great job for publishing such a beneficial web site. Your web log isn’t only useful but it is additionally really creative too. There tend to be not many people who can certainly write not so simple posts that artistically. Continue the nice writing UC mini download

    ReplyDelete

Labels

.Net Interview Questions add custom button in sharepoint using javascript Add custom column property into a PageLayout in SharePoint Add Page Title on their browser's title bar in SharePoint Customly add zip files in blogger Add-SPOSiteCollectionAppCatalog : Must have Manage Web Site permissions or be a tenant admin in order to add or remove sites from the site collection app catalog allow list Advance SmartObject An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL. Angular 2 Angular JS Angularjs Angularjs 1 anonymous users accessing lists and libraries App Permissions for SharePoint 2013 asp.net membership unique email Asp.net TreeView Control asp.net. Attendees in SharePoint Auto refresh list using Content Editor WebPart in SharePoint 2013. Auto Refresh SharePoint list using JavaScript Block and unblock of attachment types in SharePoint Blogger C# Callouts in SharePoint 2013 Cascading Dropdown list in SharePoint change onenote to another location. change SuiteBarLeft in SharePoint 2013 check if userid exists in database c# click node text to expand/collapse in Treeview client object model Close webpart CQWP crate chart using BI site in PPS Create a modern team site collection in SharePoint online Create BI chart in PPS SharePoint 2013 create filter in dashboard designer. create kpi's in dashboard designer create kpi's in SharePoint 2013 dashboard designer Create List Create List In SharePoint Create List using Power Shell Script Create Lookup Field in List using Power Shell Script Create lookup field in List create SharePoint List custom view. create SharePoint List views in List Schema create site collection in site collection in SharePoint using powershell created Date Time calculated field in SharePoint Cross site Collection in SharePoint 2013 Crud Operation in Asp.net Using Stored Procedure Custom MasterPage Approval in SharePoint custom view for survey list Customly add SharePoint List view in Page. delete items in sharepoint using powershell Difference between Angular 1.x & Angular 2 difference between Office 365 and Windows Azure difference between Windows Azure and Office 365 in sharepoint? DifferenceBetween discussion board Display Data in Grid View display radio buttons and choice fields horizontally in SharePoint 2013 Document library DotNet Drag and drop documents in document library in SharePoint dynamically populating values from one list to another list using jquery in sharepoint edit and delete buttons in datagridview Edit Links email notification using Nintex enable anonymous access in SharePoint 2013 enable app catalog sharepoint online site collection powershell Enable appcatalog site collection level using PowerShell based on Input file Enable versions for list and library except the hidden lists using PowerShell Script Error occurred in deployment step 'Recycle IIS Application Pool': Cannot resolve model for the project package Errors&Solutions Export document library in sharepoint using powershell Export particular Group in Term Store Management in SharePoint 2013 Export to Excel first release Flow Flow features free disk space on servers using powershell Friendly URLs and Managed Navigation in SharePoint 2013 get a list of site collection with template in web application using PowerShell Script in SharePoint Get attachments in SharePoint custom list using c# get current list item id sharepoint programmatically Get current url using jquery Get data from SharePoint list using Rest api & Angular JS Get Random Get Random SharePoint items using PowerShell Get Random values from SharePoint list using PowerShell Get url of the last value using jquery Get-SPOSite : The managed path sites/yoursitename is not a managed path in this tenant. Getting Email From User Hide “Edit Links” in left navigation SharePoint 2013 hide button in sharepoint based on permissions Hide column in SharePoint List view hide fields using client side object model Hide list in Quick Launch in SharePoint using PowerShell How to add Custom Tiles to SharePoint site Page. How to add extension files in Search Navigation in SharePoint 2013 How to Add Multiple users Using SharePoint People Picker How to add SharePoint list view in Page using C# How to Approve MasterPage using PowerShell in SharePoint How to bind Multiple users Using SharePoint People Picker how to change indicators on kpi performance how to check if an email address already exists in the database in asp.net how to configure workflow manager platform for SharePoint 2013 how to create calculated value using powershell how to create certificate in SharePoint How to create flow. how to create gantt chart webpart in sharepoint how to create KPI indicators in Dashboard designer How to create moden communication site in SharePoint online How to create Multi selected filter in Dashboard How to create nintex workflow in sharepoint how to create rdlc reports in asp.net How to Display Data Grid View in ASP.net How to enable anonymous access in SharePoint How to find data in datagridview in c# How to get image names from the folder using C# how to get particular list content type id in SharePoint 2013 How to get QueryString value in SharePoint WebPart Programatically how to get the current item id for newly created item using REST API and JQuery how to hide list in sharepoint how to know who created list in sharepoint How to make a Site Collection Read-Only in SharePoint 2010 How to overlay Office 365 shared calendar on SharePoint Site how to pass jquery value to asp.net textbox control How to pass pagename as a browser's title bar in the page how to remove unused Application Pool in SharePoint how to remove zone using powershell script How to send mail to particular group of people using PowerShell how to update modified by and created by using powershell how to uplaod RAR files in blogger import csv data into sharepoint import data using powershell Import group to term store management using SharePoint 2013. InfoPath InfoPath Cascading Dropdown list Insert update delete in datagridview in C# winforms Integration from SharePoint to k2. K2 Smart Forms for SharePoint JavaScript Injection jquery K2 blackpearl K2 Designer K2 Designer Workflow. K2 smartform cascading dropdown list k2 Workflow K2 workflow to send a mail with PDF left navigation Local Term Set in managed meta data Managed meta data navigation in SharePoint 2013 Managed metadata service in SharePoint 2013. Managed Navigation in SharePoint 2013. Managed Promoted Sites. meta data navigation Microsoft Flow New Features New-SPConfigurationDatabase The user does not exist or is not unique NintexWorkFlow Office 365 OneNote overwrite existing document in sharepoint using javascript PDF Converter PDF Method in K2 Performance Point Service in SharePoint 2013 PerformancePoint Services Configurtion PerformancePoint Services Configurtion for SharePoint 2013 PerformancePoint Services in SharePoint Server 2013 Popularity trends in SharePoint 2013 Pages populate dropdown list dynamicallyusing jquery Power Shell Power shell script to get SharePoint site size. powershell read xml PowerShell Script PowerShell script to get list of users from SharePoint groups PowerShell Scripts in SharePoint 2013 Powershell to set the masterpage in SharePoint Promoted Links Promoted Sites psconfig.exe quick launch Rdlc reports Readonly Column in SharePoint Editview Realtime DotNet Interview Questions Recent Dotnet interview questions Recent SharePoint interview questions recover deleted OneNote page. OneNote content is missing Regional Settings in SharePoint 2013 Replace New Item text in SharePoint Rest API Schedule PowerShell Script Search in SharePoint 2013 Search navigation in SharePoint 2013 Secure store service SecureStore Services SecureStore Services configuration for SharePoint 2013 self-signed certificate on IIS Server Send email to members of SharePoint Group using PowerShell sharepint2010 sharepoin2010 SharePoint 2013 SharePoint 2010 SharePoint 2013 SharePoint 2013 Dashboard Designer SharePoint 2013 features SharePoint 2013 Interview Questions SharePoint 2013. SharePoint 2013.disable views from user to create SharePoint 2013.Power shell SharePoint 2013.SharePoint 2010 SharePoint 2016 SharePoint Administration SharePoint Alerts and Reminders SharePoint App Configuration SharePoint Apps SharePoint Bulk upload SharePoint Calculated field SharePoint Calendar View sharepoint interview questions SharePoint online training SharePoint Onprem vs Online SharePoint RealTime Online Training SharePoint2010 SharePoint2013 SharePoint2016 SharePointInterview SharePointOnline SharePointOnline;Restore deleted site;SharePoint 2013 show data in datagridview in C# Simple Insert update Delete Retrieve Clear in asp.net. Site Collection Operations in SharePoint 2013 Site Collection Read-Only in SharePoint 2013 site contents Sorting & Filtering SPSite Site Collection Operation parameters in SharePoint 2013 Step by step to create rdlc report in .Net Store names in text files in C# Sub site Subsite Term store management. The server was unable to save the form at this time. please try again UI New look update created by using client side object model update field values in SharePoint using powershell update items in SharePoint list using client object model update modified by field using client side object model upload zip files in blog use IsNullOrEmpty in PowerShell VirtoSoftware VirtoSofware vitrosoftware WebParts what is Document Set in SharePoint 2010 What is Filter in SharePoint Dashboard what is Limited-access user permission lock down mode feature What is Modern Team site What is Target Audience in SharePoint Who Created Site Using PowerShell Workflow in SharePoint 2013 Workflow management platform in SharePoint 2013 Workflow manager for SharePoint 2013 XSL-Template.