It is an honor and I am excited to be speaking at the January 16th, 2016 installment of SQL Saturday Nashville (#SQLSatNash). I will be doing a ‘spotlight’ 90-minute session covering the keys to being a successful SharePoint administrator, with a focus on database administrators who might have inherited a SharePoint farm or have been tasked with implementing it. We will cover common SharePoint misconceptions & use live demos to show frequently performed tasks. Lastly we will cover the training options and other resources available to make your job easier and more automated.
With the extended time I plan on diving a little deeper than I could with a regular 60-minute session – highlighting automation tools/methods, how to document your farm and troubleshooting common issues. My session is right before lunch, so it will be easy enough to carry the conversation over into lunch if attendees want to continue.
The event was a great success and I really enjoyed spending time with the attendees. We were able to have a great conversation about SharePoint as it relates to a DBA, even with a small projector problem 🙂
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.
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).
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!” 🙂
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!