Ep 78 – Interview with the SPFest BI Speakers

This is episode 78 recorded on December 5th, 2018 live from SPFest Chicago where Jason talks with the other speakers on the BI track Treb Gatte, Liz Sundet, and Daniel Glenn about their perspectives on BI in the SharePoint space & their predictions for 2019.

Show notes:

Treb Gatte

Treb is Managing Partner, of TumbleRoad.com, a Power BI consultancy. Tumble Road works with many companies worldwide, like Pandora Media, Microsoft, and Kaiser Permanente, to achieve business intelligence success.

Treb is a five year Business Solutions MVP and a one year Data Platform MVP for Power BI. He has authored three books on Project and SharePoint. He is also a professional public speaker and a CIO Magazine Contributor for the Effective Enterprise blog. Treb is a former Project Engineering Team BI PM at Microsoft.

You can follow Treb on Twitter @tgatte.

Liz Sundet

Liz is a Microsoft Premier Field Engineer for SharePoint and former Office Apps and Services MVP. She loves a challenge, so everything from a business problem to troubleshooting an error in a system is just another learning opportunity. As a trainer and international speaker, she hopes to inspire others to learn something they can apply to their own work immediately. When she is not working in SharePoint or traveling, you may find her in a variety of activities as diverse as she is: playing music, riding motorcycles, training her dog and even a craft or two.

You can follow Liz on twitter @percusn.

Daniel Glenn

Daniel is a Microsoft Office Apps and Services MVP with 15 years’ experience building technology solutions, intranets and extranets. As a Practice Lead for InfoWorks Inc., He helps organizations of all sizes solve complex data challenges by implementing Office 365 and SharePoint without the need of customization and costly investments. 

He is a sought-after trainer, providing customized Power BI and Microsoft Flow training for companies around the world. He’s also passionate about giving back and building the Microsoft technical community. Daniel holds leadership roles in various local user groups, serves as an organizer for SharePoint Saturday Nashville, and is a co-host for the popular REgarding 365 Message Center show on MessageCenter.Show. You can follow Daniel online at https://DanielGlenn.com and @DanielGlenn on Twitter.

Helpful Links

MessageCenter.Show

Tumble Road

Episode 47 – Excel Update with Olaf Hubel

This is episode 47 recorded on April 30th 2018… where John & Jason interview Olaf Hubel, Senior Program Manager at Microsoft on the Excel Engineering team.

Excel User Voice
https://excel.uservoice.com/

Excel Blog
https://techcommunity.microsoft.com/t5/Excel-Blog/bg-p/ExcelBlog

Excel Community
https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat

Episode 46 – Community News and Updates

This is episode 46 recorded on April 17th 2018… where John & Jason talk about a whole bunch of miscellaneous items including GDPR, OneNote, Moving from SSRS SharePoint Integrated Mode, and SharePoint lists in Microsoft Teams.

GDPR White Paper
https://powerbi.microsoft.com/en-us/blog/power-bi-gdpr-whitepaper-is-now-available/
OneNote 2016 being deprecated
https://techcommunity.microsoft.com/t5/Office-365-Blog/The-best-version-of-OneNote-on-Windows/ba-p/183974
Eric Shupps post on issues converting from SSRS Integrated mode to Native mode
https://www.ericshupps.com/sharepoint-2016-ssrs-and-the-native-mode-report-viewer-web-part/
John’s blog series on working with complex SharePoint types in Power BI
https://whitepages.unlimitedviz.com

Jason’s 1 blog in the past couple of months… Viewing SharePoint lists in Microsoft Teams
http://www.sharepointlonghorn.com/using-sharepoint-lists-microsoft-teams/

Shameless self-promotion

SharePoint Conference North America
May 21-23, 2018
Use discount code WHITE for $50 off

European Collaboration Summit in Mainz, Germany
Use discount code ECS18-Trebinje for a 20 Euro discount
May 28-30, 2018

Episode 23 – Interview with Dave Feldman

This is episode 23 recorded on November 7th, 2017… where John & Jason talk to about the new single-sign on methods for the Power BI service and an interview with Dave Feldman, Microsoft MVP from Shire Pharmaceuticals.

News:
Blog post by Miguel Llopis: Announcing Single Sign-On Support when connecting to data sources from the Power BI Service
https://powerbi.microsoft.com/en-us/blog/announcing-single-sign-on-support-when-connecting-to-data-sources-from-the-power-bi-service/


“… it is now possible to use Single Sign-On, leveraging Kerberos, when connecting to certain data sources using DirectQuery mode from Power BI.”

Config link: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-kerberos-for-sso-pbi-to-on-premises-data/

Support for Single Sign-On is available for the following data sources as of today:

    • SQL Server
    • Teradata
    • SAP HANA

Additional data sources will be added:

EOY 2017

    • Impala
    • Oracle
    • SAP BW

H1 2018

    • Spark
    • And others…

Interview notes:
“Using BI to make intelligent business decisions”TyGraph, HyperFish & onPrem IIS Logs to do proper analysis around what was being used during the planning phases of the integration between Shire & BaxaltaThe analysis fueled Dave’s migration decisionsLooking into the future to multi-geo decision planning for SharePoint Online

Links:
Shire’s Hub and Link Web Parts: https://github.com/SharePoint/sp-dev-solutions/tree/master/solutions/LinksAndHandlebarsTemplate
Dave’s blog: http://bostonmusicdave.com/
Hyperfish: https://www.hyperfish.com/
tyGraph: https://www.tygraph.com/

Episode 20 – Ignite recap and Office 365 Reporting with the tyGraph Team

This is episode 20 recorded on October 3rd, 2017 where John & Jason talk to John’s colleagues, Ed Senez & Dean Swann from tyGraph to debrief on Microsoft Ignite from a real world Business Intelligence perspective. We discuss tyGraph, which allows organizations to take Office 365 reporting to a whole new level, and finally about their new podcast, tyGraph Moneyball, which focuses in on the why of using reporting and analytics.

Show Notes:

tyGraph

tyGraph YouTube channel

tyGraph Moneyball podcast

Dean’s Ignite session – “Mining Yammer Data for Gold with Power BI”