1 / 12

Simple Business Intelligence on List Data

Learn to interpret and create interactive dashboards with SharePoint list data using Excel and SharePoint tools. No extensive training needed!

rharter
Download Presentation

Simple Business Intelligence on List Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Dave Morrison Simple Business Intelligence on List Data 3 October 2015 Johannesburg, SA

  2. Sponsors Platinum Gold Silver @sps_events #SPSPlus, #SPSJHB, #SPSCPT, #SPSDBN

  3. http Davegopher.wordpress.com About Me IT Trainer for 20 Years, specialising in MS SQL, Business Intelligence and SharePoint Currently Technical Lead for GTConsult Johannesburg Dave Morrison www.gtconsult.com

  4. Session Overview Data that is sitting in a SharePoint List is not all that easy for most users to interpret. We can use OOTB functionality in Microsoft Excel and Microsoft SharePoint to create interactive Dashboards for users Very little training is required in order to achieve this.

  5. Session Index Overview Connecting Excel To SharePoint Power Query Pivoting the Data Presenting the Dashboard

  6. Overview What was the total value of the road bike sales in 2005 vs 2006? What were our total sales in June 2005? Did we do better in June 2006?

  7. Connecting Excel to SharePoint We need to get the data into Excel so we can manipulate it. Yes we can export but what if we want it to update automatically?

  8. Power Query Excel 2013 – Add In Excel 2016 – Built In Connect to List Pivot the Data Present the Dashboard

  9. Demo

  10. Questions

  11. SharePint – Have a Drink on Us Platinum Gold Silver @sps_events #SPSPlus, #SPSJHB, #SPSCPT, #SPSDBN

  12. Questions Thank You

More Related