{"id":266,"date":"2013-05-25T15:18:50","date_gmt":"2013-05-25T14:18:50","guid":{"rendered":"https:\/\/blog.bham.ac.uk\/itinnovation\/?p=266"},"modified":"2018-05-25T15:19:36","modified_gmt":"2018-05-25T14:19:36","slug":"data-analysis-and-reporting-features-in-ms-sharepoint","status":"publish","type":"post","link":"https:\/\/blog.bham.ac.uk\/itinnovation\/2013\/05\/25\/data-analysis-and-reporting-features-in-ms-sharepoint\/","title":{"rendered":"Data analysis and reporting features in MS SharePoint"},"content":{"rendered":"<p>The purpose of this experiment is to explore the data analysis features of SharePoint 2013 and how\u00a0it can be used to visualise information in the university and give trustworthy insights to the data.<\/p>\n<p>There are two major business intelligence tools currently used in the university including BOXI and\u00a0Tableau. However, BOXI tends to be more specialists targeted and is not great at data visualisation;\u00a0whereas Tableau is good at data visualisation but we don\u2019t have a tableau server which is quite\u00a0expensive for license.<\/p>\n<p>Based on SharePoint 2013, SQL server 2012, and end user tools including PowerPivot, Power View, Dashboard Builder, Microsoft SharePoint 2013 potentially provides a new solution for self-service\u00a0Business Intelligence.<\/p>\n<p><a href=\"https:\/\/intranet.birmingham.ac.uk\/it\/innovation\/documents\/public\/Data-Analysis-in-SharePoint-Pilot-Report.pdf\" target=\"_blank\" rel=\"noopener\">Read the full report.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The purpose of this experiment is to explore the data analysis features of SharePoint 2013 and how\u00a0it can be used to visualise information in the university and give trustworthy insights to the data. There are two major business intelligence tools currently used in the university including BOXI and\u00a0Tableau. However, BOXI tends to be more specialists &hellip; <a href=\"https:\/\/blog.bham.ac.uk\/itinnovation\/2013\/05\/25\/data-analysis-and-reporting-features-in-ms-sharepoint\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Data analysis and reporting features in MS SharePoint&#8221;<\/span><\/a><\/p>\n","protected":false},"author":96,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,6],"tags":[],"class_list":["post-266","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-projects"],"_links":{"self":[{"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/posts\/266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/users\/96"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/comments?post=266"}],"version-history":[{"count":1,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/posts\/266\/revisions"}],"predecessor-version":[{"id":267,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/posts\/266\/revisions\/267"}],"wp:attachment":[{"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/media?parent=266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/categories?post=266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bham.ac.uk\/itinnovation\/wp-json\/wp\/v2\/tags?post=266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}