Building Business Intelligence Dashboards with SharePoint Data – December 1st 2015

I will be co-presenting at the Nashville Business Intelligence User Group meeting this month. We will be walking attendees through creating dashboards using Power BI and I will be focusing on using SharePoint data.

I will show how to use Excel to create dashboards within SharePoint web part pages – first with an export of a SharePoint list and then an import of a SharePoint list into Excel. We will discuss the benefits and drawbacks of each method.

I will then show linking to the same SharePoint list data using the Power BI Desktop application and then publishing it to Power BI.

[UPDATE]
The meeting went really well – Tammy Clark started off showing how easily Power BI could connect to Facebook data.

I went second and used a SharePoint list I created with Helpdesk data to create dashboards using Excel and SharePoint web part pages. I then moved onto Power BI and ended with showing the cool iOS Power BI app (although it took some time to get it to project from my phone onto the screen).

Power BI iOS App
Helpdesk sample data within Power BI iOS app

Dan Evans then made a couple of announcements about Cortana and Power BI integration. Kerry Tyler finished off the night rocking our Power BI world with a demo that had us saying “wow!” 🙂

Nash BI December 2015 Meeting
Business Intelligence User Group Meeting Attendees

We finished the night at a new restaurant around the corner called Tupelo – fried green tomatoes, pork egg rolls (they were fantastic!!), and chicken and biscuits were enjoyed by all!

Tupelo Honey Cafe
SQLFamily Night at Tupelo Honey Cafe

Leave a Reply