I will be presenting at #SPSNashville on May 14th on the topic Business Intelligence with SharePoint & Power BI. I will show how to create BI solutions using SharePoint, Excel, Power BI, and a new Microsoft tool Flow.
I had a great time presenting at SharePoint Saturday Nashville. I had a great group of attendees and we discussed SharePoint list interaction with Excel, Power BI, and Microsoft Flow. I am not posting my slides because I didn’t really show content on slides – I used demonstrations the majority of the time to show the power of the tools.
We walked through creating a BI solution that included a SharePoint helpdesk site – one solution used Excel and Power Pivot to build dashboards, the second used Power BI to display and manipulate the helpdesk data, and lastly we used Microsoft Flow to improve the functionality of the solution by pulling in even more content.
There were a lot of great questions and Jeff was genuinely excited to see all the SharePoint professionals giving up their Saturday to learn and build community. A few bits of information I noted that Jeff shared:
There will not be another SharePoint-branded conference put on by Microsoft anytime soon. Microsoft’s Ignite conference will be the focus and they are attempting to put more focus on SharePoint at the conference.
Approximately 300,000 Android users start using OneDrive every day
Jeff acknowledged some missteps and wants to fix them – the first being that navigation will be coming back to the new document library look in SharePoint
Microsoft knows it did not handle correctly the delivery of the message around how the newly announced SharePoint Framework effects existing developed add-ins. This will be fixed in the weeks ahead.
The day ended with a lot of giveaways – we counted over 20! We also announced that attendance was up 79% over last year!
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 had a little fun with the promotion of my session at the event, given that #SPSTC was only a few days after #BackToTheFutureDay (October 21st, 2015).
The speaker dinner was excellent; great location, food, and a relaxed atmosphere. I had the opportunity to catch up with organizers and other speakers, some of which I hadn’t seen since the Microsoft Ignite conference in May. The organizing committee was awesome and we all had a great time enjoying the fun items in our speaker bags.
Saturday morning arrived and with over 500 people in attendance, I knew the day was going to be fun!
I had a room full of people eager to hear about Tuning SQL Server for SharePoint. The group had a lot of questions and was very interactive…and fun?
As is the norm at SPS events, there were some fabulous speakers delivering world-class content. After the giveaways, some of the organizers and speakers went to dinner to wrap-up a fun day. Thank you to all the organizers, volunteers, sponsors, and other speakers – I am sure to return for the announced Spring 2016 edition of #SPSTC!
I was honored to speak at this year’s installment of SharePoint Saturday (SPS) Cincinnati – is was a spooktacular event!
Every year the organizers of #SPSCincy do a Halloween theme and this year, all the speakers were given football jerseys to help them with their costume. Others, well, they brought there own:
When I arrived at the event, the theme was in full swing – decorations and people dressed as their favorite gorilla, princess, or Star Wars character.
I attended several great sessions during the day – if you aren’t attending SPS events, you are really missing out on high-quality, free content! As I prepared for my session, I grabbed a quick pick with those initially in the room:
The organizers and volunteers did an excellent job – SPSCincy was a huge success!
As it turns out, my last scheduled SQL Saturday event for 2015 was one of the closest – #SQLSat403 was my first time at the event held in Louisville, but I hope it won’t be the last!
The speaker dinner was held at a great restaurant that was known for is delicious food – even featured on one of the TV cooking shows! We all gathered around tables and talked shop, family, work, and stuffed our faces with a lot of pizza.
My session, Keys to Successful SharePoint Administration for the DBA, was slated later in the day, so I was able to attend several sessions throughout the day.
I had a smaller group of attendees, so the session was even more interactive than normal and I really enjoyed it. This is was the first time I attempted to use Microsoft Sway as a presentation method. The week prior I spent a lot of effort taking my existing slide deck into a ‘Sway’. I was getting Sway advice and tips from Mark Kashman and Chris Pratley, Microsoft GM (and founder of Sway and OneNote) and gave presenting with it a shot.
@DanielGlenn@mkashman nice. BTW use group to get several things on screen at once. Also get some interactivity (it's quite "powerpointy")
I started my presentation off and everything was going well, but Sway started advancing twice for every time I clicked once, so I had to abandon it 15 minutes into the session – I reverted back to using PowerPoint and I had no issues moving forward.
My session went well, except for the demo. I performed a SharePoint 2013 install using PowerShell but the installation didn’t finish. The most likely reason is that the virtual server host was busy (disk I/O). Oh well, the process had completed some steps and I was able to show databases without the GUID – which is kinda the point.
I also attended Mike Lawell’s Execution Plans for Mere Mortals session. A lot of the information was new for me, but that is why I love going to SQL Saturdays – I stretch my knowledge.
Right after Mike’s session, Robert Verell gave his second session of the day, Know Your Role(s)! One of the things Robert talked about was not giving db_owner rights to accounts. Which came up in my session when Robert asked if SharePoint service accounts, namely the Farm account, can have the db_owner rights removed from databases.
Special thank you to Hope Foley and the rest of the #SQLSatIndy team – it was a great event! I hope to be able to make the event next year.